Parsing a Filemaker XML Resultset

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
rgilchrist
Forum Newbie
Posts: 4
Joined: Mon Jul 30, 2007 3:47 pm

Parsing a Filemaker XML Resultset

Post 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>
 
Mark Baker
Forum Regular
Posts: 710
Joined: Thu Oct 30, 2008 6:24 pm

Re: Parsing a Filemaker XML Resultset

Post by Mark Baker »

Have a look at PHPs simpleXML
User avatar
rgilchrist
Forum Newbie
Posts: 4
Joined: Mon Jul 30, 2007 3:47 pm

Re: Parsing a Filemaker XML Resultset

Post 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
Post Reply