0 Replies Latest reply on Nov 17, 2010 7:31 AM by JoeCampo

    Importing an XML File

    JoeCampo

      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!