AnsweredAssumed Answered

importing XML

Question asked by taryn on May 16, 2018
Latest reply on May 21, 2018 by beverly


Hello, I apologize as I am very new to filmmaker and xml, so really I don't really know what I'm doing but I'm trying my best. So I'm having a very hard time importing my xml file, I have read a bunch of tutorials and such, but I think I must be a bit dense as I'm not able to make this work... can any of you tell me all of what I am doing wrong and possibly explain it to me in as simple terms as possible? I've attached the xml file and the xsl file i'm trying to make...

 

<?xml version='1.0' encoding='UTF-8'?>

<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 NANE="dtstamp" TYPE="TEXT"/>

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

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

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

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

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

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

  <FIELD NAME="x-cost-type" TYPE="TEXT"/>

  </METADATA>

  <RESULTSET>

  <ROW>

  <COL><DATA><xsl:value-of select="dtstamp"/></DATA></COL>

  <COL><DATA><xsl:value-of select="categories"/></DATA></COL>

  <COL><DATA><xsl:value-of select="contact"/><DATA></COL>

  <COL><DATA><xsl:value-of select="description"/></DATA></COL>

  <COL><DATA><xsl:value-of select="dtstart"/></DATA></COL>

  <COL><DATA><xsl:value-of select="dtend"/></DATA></COL>

  <COL><DATA><xsl:value-of select="summary"/></DATA></COL>

  <COL><DATA><xsl:value-of select="x-cost-type"/></DATA></COL>

  </ROW>

  </RESULTSET>

  </FMPXMLRESULT>

  </xsl:template>

</xsl:stylesheet>

Attachments

Outcomes