XML Import

Discussion created by anna.antonioli on Sep 23, 2016
Latest reply on Sep 23, 2016 by anna.antonioli

Hi all,

I need to import into filemaker table an XML file as this:


<?xml version="1.0" encoding="utf-8"?>
  <Field APIName="WrntyID">6029065</Field>
  <Field APIName="ExternalID">1761A</Field>
  <Field APIName="Name">sayIT SA</Field>


now I'am trying to create the xls file.

This is my xls file....


<?xml version='1.0' encoding='UTF-8'?>
<xsl:stylesheet version="1.0" xmlns:xsl="">
    <xsl:template match="/">
        <FMPXMLRESULT xmlns="">
                <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="WrntyID" TYPE="TEXT"/>
                <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ExternalID" TYPE="TEXT"/>
                <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Name" TYPE="TEXT"/>           
                        <DATA><xsl:value-of select=“Account/Field[1]" /></DATA>
                        <DATA><xsl:value-of select=“Account/Field[2]” /></DATA>
                        <DATA><xsl:value-of select=“Account/Field[3]” /></DATA>


This instruction <xsl:value-of select=“Account/Field[1]"/> doesn't work.


What is the right syntax to retrive the value of the first TAG FIELD? Then the second end so on...?

Many thanks