AnsweredAssumed Answered

Importing XML file using XSLT - Not working but no error message

Question asked by Gingernut on Nov 15, 2017
Latest reply on Nov 15, 2017 by Gingernut

Using Filemaker 14 on Windows.

 

I am missing something and I cannot see what. there is no error but nothing is imported either.

This is my XML file

 

 

<?xml version="1.0" encoding="utf-8"?>

<root>

  <header />

  <orderacknowledgements>

    <order>

      <ordernumber>23695</ordernumber>

      <name>Clarity Copiers Ltd</name>

      <addressline1>Conitor House</addressline1>

      <addressline2>Denbury Road</addressline2>

      <towncity>Newton Abbot</towncity>

      <county>Devon  </county>

      <postcode>UK</postcode>

      <country></country>

      <contactname></contactname>

      <contactphone></contactphone>

      <jobnumber />

      <serialno />

      <machinelocation />

      <instructions />

      <customerref></customerref>

      <acknowledgeref>0000216829</acknowledgeref>

      <orderline>

        <orderlinenumber>23695</orderlinenumber>

        <sku>50310335</sku>

        <qty>2.000000</qty>

        <price>16.400000</price>

        <allocatedqty />

        <backorderqty />

        <productcode></productcode>

        <description>BOX ARSC3 STAPLES (6,000)</description>

      </orderline>

      <orderline>

        <orderlinenumber>23695</orderlinenumber>

        <sku>00141030</sku>

        <qty>4.000000</qty>

        <price>6.850000</price>

        <allocatedqty />

        <backorderqty />

        <productcode></productcode>

        <description>BLUE CLOTHS</description>

      </orderline>

    </order>

  </orderacknowledgements>

</root>

 

AND this is my XSLT file -I am not getting an error but not importing any records either.

<?xml version='1.0' encoding='UTF-8'?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">

<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">

   <METADATA>

    <FIELD NAME="orderlinenumber" TYPE="TEXT"/>

    <FIELD NAME="sku" TYPE="TEXT"/>

    <FIELD NAME="qty" TYPE="NUMBER"/>

    <FIELD NAME="price" TYPE="NUMBER"/>

    <FIELD NAME="allocatedqty" TYPE="NUMBER"/>

    <FIELD NAME="backorderqty" TYPE="NUMBER"/>

    <FIELD NAME="productcode" TYPE="TEXT"/>

     <FIELD NAME="description" TYPE="TEXT"/>

   </METADATA>

   <RESULTSET>

            <xsl:for-each select="/orderacknowledgements/order/orderline">

    <ROW>

     <COL><DATA><xsl:value-of select="orderlinenumber"/></DATA></COL>

     <COL><DATA><xsl:value-of select="sku"/> </DATA></COL>

     <COL><DATA><xsl:value-of select="qty"/> </DATA></COL>

     <COL><DATA><xsl:value-of select="price"/></DATA></COL>

     <COL><DATA><xsl:value-of select="allocatedqty"/></DATA></COL>

     <COL><DATA><xsl:value-of select="backorderqty"/></DATA></COL>

                    <COL><DATA><xsl:value-of select="productcode"/></DATA></COL>

                    <COL><DATA><xsl:value-of select="description"/></DATA></COL>

    </ROW>

                </xsl:for-each>

   </RESULTSET>

  </FMPXMLRESULT>

Outcomes