Page 1 of 1

Parsing a Filemaker XML Resultset

Posted: Thu Sep 17, 2009 6:59 am
by rgilchrist
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



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>
 

Re: Parsing a Filemaker XML Resultset

Posted: Thu Sep 17, 2009 7:38 am
by Mark Baker
Have a look at PHPs simpleXML

Re: Parsing a Filemaker XML Resultset

Posted: Thu Sep 17, 2009 7:44 am
by rgilchrist
Hi
I had a look at SimpleXML and it imports the XML in as an object but I couldn't see a way to match the FIELDS up with the DATA. Do you know how to do this?

Cheers
Rob