9 Replies Latest reply on Jun 20, 2016 11:43 AM by ferkinx

    Can anyone help with a XSLT not working?

    ferkinx

      Hello,

      I 've no experience with importing XML into Filemaker, but have tried to make my first XSLT to import person-information from this URL: http://data.stortinget.no/eksport/dagensrepresentanter

      I 'm only interested in some of the fields. When I run the import, the Filemaker file is created correctly with the defined fields, but the table is not filled with data. What 's wrong? My XSLT looks like this:

       

      <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="doedsdato" TYPE="DATE"/>

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

        <FIELD NAME="foedselsdato" TYPE="DATE"/>

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

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

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

        </METADATA>

        <RESULTSET>

        <xsl:for-each select="/dagensrepresentant">

        <ROW>

        <COL>

        <DATA><xsl:value-of select="dagensrepresentant/versjon/></DATA>

        </COL>

        <COL>

        <DATA><xsl:value-of select="dagensrepresentant/doedsdato/></DATA>

        </COL>

        <COL>

        <DATA><xsl:value-of select="dagensrepresentant/etternavn/></DATA>

        </COL>

        <COL>

        <DATA><xsl:value-of select="dagensrepresentant/foedselsdato/></DATA>

        </COL>

        <COL>

        <DATA><xsl:value-of select="dagensrepresentant/fornavn/></DATA>

        </COL>

        <COL>

        <DATA><xsl:value-of select="dagensrepresentant/id/></DATA>

        </COL>

        <COL>

        <DATA><xsl:value-of select="dagensrepresentant/kjoenn/></DATA>

        </COL>

        </ROW>

        </xsl:for-each>

        </RESULTSET>

        </FMPXMLRESULT>

        </xsl:template>

      </xsl:stylesheet>

       

       

      Jørgen Ferkingstad

      Norway