AnsweredAssumed Answered

Something wrong with my xls but I don't know where

Question asked by OkcunSahin on Oct 10, 2013

Title

Something wrong with my xls but I don't know where

Post

     The web site http://www.tcmb.gov.tr/kurlar/today.xml is publishing the latest currencies in Turkey. To get them I have created the xls file as:

      

     <?xml version="1.0" encoding="UTF-8"?>
     <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
     <xsl:template match="/*">
     <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
     <ERRORCODE>0</ERRORCODE>
     <PRODUCT BUILD="" NAME="" VERSION=""/>
     <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="" RECORDS="{count(/*/*)}" TIMEFORMAT="h:mm:ss a"/>
     <METADATA>
     <xsl:for-each select="/*/*[position()=1]/*">
     <FIELD>
     <xsl:attribute name="EMPTYOK">YES</xsl:attribute>
     <xsl:attribute name="MAXREPEAT">1</xsl:attribute>
     <xsl:attribute name="NAME"><xsl:value-of select="name()"/></xsl:attribute>
     <xsl:attribute name="TYPE">TEXT</xsl:attribute>
     </FIELD>
     </xsl:for-each>
     </METADATA>
     <RESULTSET>
     <xsl:attribute name="FOUND"><xsl:value-of select="count(child::*)"/></xsl:attribute>
     <xsl:for-each select="child::*">
     <ROW>
     <xsl:attribute name="MODID">0</xsl:attribute>
     <xsl:attribute name="RECORDID">0</xsl:attribute>
     <xsl:for-each select="child::*">
     <COL>
     <DATA>
     <xsl:value-of select="."/>
     </DATA>
     </COL>
     </xsl:for-each>
     </ROW>
     </xsl:for-each>
     </RESULTSET>
     </FMPXMLRESULT>
     </xsl:template>
     </xsl:stylesheet>
      
     But it is giving an error as it is at the attachment.
      
     I can not find where I am doing the mistake can you help me.
      
     Thanks,
      
     Okcun

Ekran_Resmi_2013-10-10_14.20.35.png

Outcomes