How to import multiple values (checkbox) with FMPXMLRESULT? -
11-09-2006
, 08:03 AM
Hi,
In FileMaker Pro 8 I'm trying to import data to a table from an XML file
following the FMPXMLResult grammar. It works fine for single text
fields, but now I'm trying to populate a checkbox control, which can
have multiple values on.
Let's suppose the checkbox control in FileMaker has options A B C D E
and that the XML record I'm trying to import has B C D checked.
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="5"/>
</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 in advance your help. |