![]() |
#1
|
|||
|
|||
![]() Hello,
We have a problem with array fields. I am trying to create a master/detail structure for instance for vcard URL elements. Here is a fragment of my <fieldlist> declaring the array field: --------------------- <!-- organisation --> <field name="ORG_NAME" type="string" compare="slowsync" merge="fillempty"/> <field name="ORG_DIVISION" type="string" compare="conflict" merge="fillempty"/> <!-- web addresses --> <field name="WEBS" array="yes" type="url" compare="never" merge="fillempty"/> --------------------- And the property in <mimeprofile>: --------------------- <property name="URL"> <value field="WEBS"/> <position repeat="array"/> </property> --------------------- Fraction from <fieldmap>: ---------------------- <array sizefrom="WEBS"> <selectarraysql>SELECT %N FROM web WHERE contactid = %k</selectarraysql> <insertelementsql>INSERT INTO web (contactid,%N) VALUES (%k,%v)</insertelementsql> <deletearraysql>DELETE FROM web WHERE contactid = %k</deletearraysql> <maxrepeat>0</maxrepeat> <!-- no limit, we are using dynamic array fields --> <repeatinc>1</repeatinc> <storeempty>no</storeempty> <map name="web" references="WEBS" type="string" mode="rw" size="127"/> </array> --------------------- With this configuration the first URL goes into the DIVISION field. As seen from the log: ---------------------- [2009-10-28 09:50:22] Item_Parse - parsing SyncML item, SyncOp=add, RemoteID=7 [2009-10-28 09:50:22] Created new item of datatype 'vcard21', localID='' remoteID='7' [2009-10-28 09:50:22] Parsing: [2009-10-28 09:50:22] BEGIN:VCARD [2009-10-28 09:50:22] VERSION:2.1 [2009-10-28 09:50:22] REV:20091027T153120Z [2009-10-28 09:50:22] N:Simpson;Homer;;; [2009-10-28 09:50:22] TEL;CELL:+1125551234 [2009-10-28 09:50:22] TEL;VOICE:*1135554321 [2009-10-28 09:50:22] EMAIL;INTERNET;ENCODING=QUOTED-PRINTABLE:homer=40hotmail.com [2009-10-28 09:50:22] URL:http://www.simpsons.com [2009-10-28 09:50:22] URL;WORK:http://www.burns.com [2009-10-28 09:50:22] EMAIL;INTERNET;HOME;ENCODING=QUOTED-PRINTABLE:marge=40simpsons.com [2009-10-28 09:50:22] EMAIL;INTERNET;HOME;ENCODING=QUOTED-PRINTABLE:bart=40simpsons.com [2009-10-28 09:50:22] END:VCARD [2009-10-28 09:50:22] Successfully parsed: [2009-10-28 09:50:22] Item LocalID='', RemoteID='7', operation=add, size: [maxlocal,maxremote,actual] [2009-10-28 09:50:22] - 0 : timestamp REV [ 256, 0, 16] : 20091027T153120Z [2009-10-28 09:50:22] - 1 : integer SYNCLVL [ n/a, 0, 12] : <unassigned> [2009-10-28 09:50:22] - 2 : string N_LAST [ 256, 63, 7] : Simpson [2009-10-28 09:50:22] - 3 : string N_FIRST [ 256, 63, 5] : Homer [2009-10-28 09:50:22] - 4 : string N_PREFIX [ 256, 31, 7] : <empty> [2009-10-28 09:50:22] - 5 : string TITLE [ 256, 31, 7] : <empty> [2009-10-28 09:50:22] - 6 : string CATEGORIES [ n/a, 127, 12] : <unassigned> [2009-10-28 09:50:22] - 7 : string CLASS [ n/a, 63, 12] : <unassigned> [2009-10-28 09:50:22] - 8 : string ORG_NAME [ 256, 63, 7] : <empty> [2009-10-28 09:50:22] - 9 : string ORG_DIVISION [ 256, 63, 23] : http://www.simpsons.com [2009-10-28 09:50:22] - 10 : url WEBS [ n/a, 127, 23] : <array with 1 elements> [2009-10-28 09:50:22] -- element 0 : <empty> -------------------------- It looks like a bug to me. Any ideas how to make this work? Thanks! |
#2
|
|||
|
|||
![]() There was some configuration error. It works now.
|
![]() |
Thread Tools | |
Display Modes | |
|
|