AnsweredAssumed Answered

XML import error

Question asked by Jens Teich on Aug 30, 2018
Latest reply on Aug 30, 2018 by Jens Teich

Trying to import this url:  https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml

 

on FM 16 with this XSLT:

 

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
        xmlns:e="http://www.ecb.int/vocabulary/2002-08-01/eurofxref"
        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="1" 
        TIMEFORMAT="h:mm:ss a"/>

      <METADATA>
    
    <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="date" TYPE="TEXT"/>
    <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="currency" TYPE="TEXT"/>
    <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="rate" TYPE="TEXT"/>

      </METADATA>

      <RESULTSET FOUND="1">

    <xsl:apply-templates select="//e:Cube/e:Cube/e:Cube"/>

      </RESULTSET>

    </FMPXMLRESULT>

  </xsl:template>



  <xsl:template match="//e:Cube/e:Cube/e:Cube">

    <ROW MODID="0" RECORDID="0">

      <COL><DATA><xsl:value-of select="../@time"/></DATA></COL>
      <COL><DATA><xsl:value-of select="@currency"/></DATA></COL>
      <COL><DATA><xsl:value-of select="@rate"/></DATA></COL>

    </ROW>

  </xsl:template>

</xsl:stylesheet>

 

I get the error: "Your access privileges do not allow you to perform this action".

 

But I have 'full access' and also tried checking all extended privileges.

 

Any idea?

 

Jens

Outcomes