Parsing a Filemaker XML Resultset
Posted: Thu Sep 17, 2009 6:59 am
Hi
Can anyone tell me how to parse a Filemaker XML Resultset in PHP?
A client is providing us with a feed of data from their Filemaker system in XML format (below is an example).
Thanks in advance
Rob
Can anyone tell me how to parse a Filemaker XML Resultset in PHP?
A client is providing us with a feed of data from their Filemaker system in XML format (below is an example).
Thanks in advance
Rob
Code: Select all
<?xml version="1.0" encoding="UTF-8" ?>
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
<ERRORCODE>0</ERRORCODE>
<PRODUCT BUILD="06-18-2009" NAME="FileMaker" VERSION="ProAdvanced 10.0v3"/>
<DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="" NAME="XX" RECORDS="71" TIMEFORMAT="k:mm:ss "/>
<METADATA>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Group_ID_pk" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Display_Name" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Timestamp_t" TYPE="TEXT"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Filtering" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Sort_Order" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Delete" TYPE="NUMBER"/>
<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Info" TYPE="TEXT"/>
</METADATA>
<RESULTSET FOUND="24">
<ROW MODID="21" RECORDID="3">
<COL>
<DATA>1</DATA>
</COL>
<COL>
<DATA>Author</DATA>
</COL>
<COL>
<DATA>2009-09-16 16:55:40</DATA>
</COL>
<COL>
<DATA>1</DATA>
</COL>
<COL>
<DATA></DATA>
</COL>
<COL>
<DATA>0</DATA>
</COL>
<COL>
<DATA>The person</DATA>
</COL>
</ROW>
</RESULTSET>
</FMPXMLRESULT>