Importing multiple values with FMPXMLRESULT -
12-14-2005
, 10:00 AM
Hi,
In FileMaker Pro 8 I'm trying to import data to a table from an XML file
following the FMPXMLResult grammar. So far it works rather well for
single text fields, but now I'm trying to populate a checkbox control,
i.e. which can have multiple values set.
Supposing my checkbox control in FM has the following options:
A B C D E
The XML file I'm trying to import is :
<?xml version="1.0" encoding="UTF-8" ?>
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
<ERRORCODE>0</ERRORCODE>
<PRODUCT BUILD="08-11-2005" NAME="FileMaker Pro" VERSION="8.0v1" />
<DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="" NAME="cc2006.fp7" RECORDS="1"
TIMEFORMAT="k:mm:ss" />
<METADATA>
<FIELD NAME="Choose" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT="10" />
</METADATA>
<RESULTSET FOUND="1">
<ROW MODID="0" RECORDID="1">
<COL>
<DATA>B/DATA>
<DATA>C</DATA>
<DATA>D</DATA>
</COL>
</ROW>
</RESULTSET>
</FMPXMLRESULT>
I do the import process, everything OK, but instead of having the 3
boxes B,C,D checked as expected, only the first one, B, is properly
checked (all the rest is unchecked).
Where did I make a mistake ?
Thanks a lot for your help.
Albin |