AnsweredAssumed Answered

Can anyone help with a XSLT not working?

Question asked by ferkinx on Jun 19, 2016
Latest reply on Jun 20, 2016 by 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

Outcomes