1 Reply Latest reply on Feb 7, 2014 3:42 AM by beverly

    Import xml data source

    aanshi

      I have one xml file.I want to import it in filemaker.I try to import ->XML datasource in that its ask about xslt file.I know about it but dnt knw how to convert it in FMXMLRESULT grammer .

      <?xml version="1.0"?>

      <data>

      <records>

      <id>1</id>

      <job_no>"E7845"</job_no>

      <item1>"Pen"</item1>

      <price>2</price>

      <item2>

      <item1>att1</item1>

      <price>5</price>

      </item2>

      </records>

      <records>

      <id>2</id>

      <job_no>"E7400"</job_no>

      <item1>"book"</item1>

      <price>3</price>

      <item2>

      <item1>att2</item1>

      <price>5</price>

      </item2>

      </records>

      </data>

        • 1. Re: Import xml data source
          beverly

          Three are some example XSLTs with your install. Take a look in the "<<your language here>> Extras/Examples/XML Examples/Import" folder. These may or may not work for your source xml, but they may give you an idea of what the XSLT are like for IMPORT. The "T" in xslt means to transform (from one xml schema into another xml schema, text or html. The import is mostly a "mapping" of xml elements with the FM fields. If there are repeated elements in your source, these are handled by "loops" in the XSLT and each loop would import a record.

           

          You can find the DTD for FMPXMLRESULT grammar in the ../Examples/XML Documentation folder. Don't worry about the FMPDSORESULT grammar as it is deprecated and cannot be used IMPORT.

           

          Without knowing your database (tables and fields), a sample xslt for your particular needs cannot be posted here. Try the examples first.

           

          HTH,

          Beverly