AnsweredAssumed Answered

SAXParseException using XSL stylesheet

Question asked by rremde on Nov 15, 2018
Latest reply on Nov 15, 2018 by steve_ssh

I'm on FMP17 standalone on a Mac, and am trying to export a set of records to use in an xml file using an xsl stylesheet. Output needs to look like this:

 

<channel>

<item>

<irctitle>Bad Movie Police Case 1: Galaxy of the Dinosaurs</irctitle>

<ircposter>http://10467-2.b.cdn13.com/bad_movie_police_case_1.jpg</ircposter>

<ircurl>http://10467-2.b.cdn13.com/bad_movie_police_case_1.mp4</ircurl>

<ircstreamformat>mp4</ircstreamformat>

<ircdescription>Follow the adventures of Sgt. Elke Mantooth, Lt. Drucilla Dread and The BMP Task Force as they seek out the worst cine-terrorists in movie history and bring their crimes to justice for your entertainment! </ircdescription>

<ircactors>Ariauna Albright, Lilith Stabs, Jesse Bean</ircactors>

<ircdirector>John Treacy</ircdirector>

<irclength>01:10:57</irclength>

<ircreleasedate>2003</ircreleasedate>

<ircrating>R</ircrating>

<irchdbranded>false</irchdbranded>

</item>

<item>

<irctitle>Bad Movie Police Case 2: Chickboxer</irctitle>

<ircposter>http://10467-2.b.cdn13.com/bad_movie_police_case_2.jpg</ircposter>

<ircurl>http://10467-2.b.cdn13.com/bad_movie_police_case_2.mp4</ircurl>

<ircstreamformat>mp4</ircstreamformat>

<ircdescription>The sexy Bad Movie Police Force hunts down a notorious distributor of cheapo movies and then try to locate his accomplice, Yolonda Squatpump, the creator of the horrible 1992 action movie CHICKBOXER (1992).</ircdescription>

<ircactors>Ariauna Albright, Lilith Stabs, Jesse Bean</ircactors>

<ircdirector>John Treacy</ircdirector>

<irclength>01:10:04</irclength>

<ircreleasedate>2003</ircreleasedate>

<ircrating>R</ircrating>

<irchdbranded>false</irchdbranded>

</item>

</channel>

 

I'm trying to use the following xsl to format the results:

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

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

xmlns:fmp="http://www.filemaker.com/fmpxmlresult" version="1.0" exclude-result-prefixes="fmp"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:noNamespaceSchemaLocation="anyfile.xsd">

<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

<xsl:strip-space elements="*"/>

<xsl:template match="fmp:FMPXMLRESULT">

<channel>

   <xsl:for-each select="fmp:RESULTSET/fmp:ROW">

    <item>

      <irctitle>

         <xsl:value-of select="fmp:COL[1]/fmp:DATA"/>

      </irctitle>

      <ircposter>

        <xsl:value-of select="fmp:COL[2]/fmp:DATA"/>

      </ircposter>

      <ircurl>

       <xsl:value-of select="fmp:COL[3]/fmp:DATA"/>

      </ircurl>

      <ircstreamformat>

       <xsl:value-of select="fmp:COL[4]/fmp:DATA"/>

      </ircstreamformat>

      <ircdescription>

        <xsl:value-of select="fmp:COL[5]/fmp:DATA"/>

       </ircdescription>

       <ircactors>

        <xsl:value-of select="fmp:COL[6]/fmp:DATA"/>

       </ircactors>

       <ircdirector>

        <xsl:value-of select="fmp:COL[7]/fmp:DATA"/>

       </ircdirector>

       <irclength>

        <xsl:value-of select="fmp:COL[8]/fmp:DATA"/>

       </irclength>

       <ircreleasedate>

        <xsl:value-of select="fmp:COL[9]/fmp:DATA"/>

       </ircreleasedate>

       <ircrating>

        <xsl:value-of select="fmp:COL[10]/fmp:DATA"/>

       </ircrating>

       <irchdbranded>

        <xsl:value-of select="fmp:COL[11]/fmp:DATA"/>

       </irchdbranded>

     </item>

   </xsl:for-each>

</channel>

</xsl:template>

</xsl:stylesheet>

 

When I try to run the export, I get the following error:

SAXParseException Argument expected line 2, col 16

 

This is a first try for me, and I've been away from FMP for a long time, so any assistance would be appreciated.

 

 

 

Thanks in advance!

Outcomes