AnsweredAssumed Answered

Importing an XML File

Question asked by JoeCampo on Nov 17, 2010

Title

Importing an XML File

Post

Hello!

I'm trying to import this XML file into Filemaker:

<?xml version="1.0" ?>
<orders>
<order>
    <invoice>0000000031</invoice>
    <date>2009-07-09 10:52:45</date>
    <ip>212.173.191.33</ip>
    <transid>0M042998XL200874G</transid>
    <paytype>PayPal Standard</paytype>
    <authcode></authcode>
    <bfname>Steve</bfname>
    <blname>Jones</blname>
    <bcompany></bcompany>
    <baddress1>2 North Main Street</baddress1>
    <baddress2></baddress2>
    <bcity>Beverly Hills</bcity>
    <bstate>CA</bstate>
    <bcountry>United States</bcountry>
    <bzip>90210</bzip>
    <email>stevejonesabc123@somedomain.com</email>
    <phone>1234567890</phone>
    <sfname>Steve</sfname>
    <slname>Jones</slname>
    <scompany></scompany>
    <saddress1>123 ABC Street</saddress1>
    <saddress2></saddress2>
    <scity>Beverly Hills</scity>
    <sstate>CA</sstate>
    <scountry>United States</scountry>
    <szip>90210</szip>
    <comments></comments>
    <note></note>
    <items>
        <item>
            <id>0000003265</id>
            <title>T-shirt( Colored T-shirt )</title>
            <options>Size:small</options>
            <quantity>1</quantity>
            <price>13.95</price>
        </item>
    </items>
</order>
<order>
    <invoice>0000000032</invoice>
    <date>2009-07-14 10:20:40</date>
    <ip>226.122.191.43</ip>
    <transid>2ND50767S3852845Y</transid>
    <paytype>PayPal Standard</paytype>
    <authcode></authcode>
    <bfname>Joe</bfname>
    <blname>Smith</blname>
    <bcompany>SmithCo</bcompany>
    <baddress1>222 Some St</baddress1>
    <baddress2>Suite 33</baddress2>
    <bcity>Cartersville</bcity>
    <bstate>GA</bstate>
    <bcountry>United States</bcountry>
    <bzip>30120</bzip>
    <email>joe@smithco.com</email>
    <phone>1234567890</phone>
    <sfname>Joe</sfname>
    <slname>Smith</slname>
    <scompany></scompany>
    <saddress1>222 Some St</saddress1>
    <saddress2>Suite 33</saddress2>
    <scity>Cartersville</scity>
    <sstate>GA</sstate>
    <scountry>United States</scountry>
    <szip>30120</szip>
    <comments></comments>
    <note>Please ship right away.</note>
    <items>
        <item>
            <id>0000003352</id>
            <title>T-shirt( White T-shirt )</title>
            <options>Size:small</options>
            <quantity>1</quantity>
            <price>12.95</price>
        </item>
        <item>
            <id>0000003353</id>
            <title>Shareware Product</title>
            <options>Platform:Mac OS 9</options>
            <quantity>1</quantity>
            <price>10.00</price>
        </item>
    </items>
</order>
<order>
    <invoice>0000000046</invoice>
    <date>2009-07-14 10:32:52</date>
    <ip>236.44.32.77</ip>
    <transid>9RS32512TA664993B</transid>
    <paytype>PayPal Standard</paytype>
    <authcode></authcode>
    <bfname>Bobby Joe</bfname>
    <blname>Green</blname>
    <bcompany></bcompany>
    <baddress1>88 Outback Way</baddress1>
    <baddress2>Trailer #44</baddress2>
    <bcity>Swampland</bcity>
    <bstate>GA</bstate>
    <bcountry>United States</bcountry>
    <bzip>30144</bzip>
    <email>bobbyjoe@swampland.com</email>
    <phone>1234567890</phone>
    <sfname>Bobby Joe</sfname>
    <slname>Green</slname>
    <scompany></scompany>
    <saddress1>88 Outback Way</saddress1>
    <saddress2>Trailer #44</saddress2>
    <scity>Swampland</scity>
    <sstate>GA</sstate>
    <scountry>United States</scountry>
    <szip>30144</szip>
    <comments></comments>
    <note></note>
    <items>
        <item>
            <id>0000003354</id>
            <title>Shareware Product</title>
            <options>Platform:Mac OS 9</options>
            <quantity>1</quantity>
            <price>7.00</price>
        </item>
        <item>
            <id>0000003355</id>
            <title>Shareware Product</title>
            <options></options>
            <quantity>1</quantity>
            <price>10.00</price>
        </item>
        <item>
            <id>0000003356</id>
            <title>T-shirt</title>
            <options></options>
            <quantity>1</quantity>
            <price>12.95</price>
        </item>
        <item>
            <id>0000003357</id>
            <title>Shareware Product</title>
            <options>Platform: Mac OS X</options>
            <quantity>1</quantity>
            <price>8.00</price>
        </item>
    </items>
</order>
</orders>

However, Filemaker tells me there's not enough information to import it. I'm guessing I'm going to have to create a XSL file, and I was wondering how I would go about doing that? Is there a template I can manipulate? basically, I'm trying to create a database within filemaker to store this type of information...

Thanks!

Outcomes