Dear all, I've just create a script to export my records in multiple xml file (one xml for each record) applying also an XSL stylesheet.

So, if I use the style.xsl taking from my computer ("source" button when filemaker ask me to select the file) it works. If I put the same file online, it doesn't work giving me a SAXParseException error: internal error in NetAccess (occurred in an unknown entity, at line 0, column 0).

In the same folder where I have the style.xsl there are other xsl files that works, but they are used to "import" process (from XML to FILEMAKER, while in this case I'm working to an export process, from FILEMAKER to XML, I don't know if this could be the problem)

Someone could help me to understand the error? Thank you

<xsl:stylesheet 
  version="1.0" 
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:fmp="http://www.filemaker.com/fmpxmlresult"
  exclude-result-prefixes="fmp"
>
<xsl:output omit-xml-declaration="yes" indent="yes"/>
     <xsl:strip-space elements="*"/>
      <xsl:template match="fmp:FMPXMLRESULT">

                <xsl:for-each select="fmp:RESULTSET/fmp:ROW">
<xsl:text>&#xA;</xsl:text>
<xsl:text disable-output-escaping="yes">&lt;!--</xsl:text> <xsl:value-of select="fmp:COL[1]/fmp:DATA"/>.<xsl:value-of select="fmp:COL[2]/fmp:DATA"/>.<xsl:value-of select="fmp:COL[3]/fmp:DATA"/><xsl:text disable-output-escaping="yes">--&gt;</xsl:text>

                     <problem display_name="Checkboxes" >
                         <choiceresponse>
                          <label><xsl:value-of select="fmp:COL[4]/fmp:DATA"/></label>
                           <checkboxgroup>
                               
                               <choice correct="{fmp:COL[6]/fmp:DATA}">
                               <xsl:value-of select="fmp:COL[5]/fmp:DATA"/>
                               <choicehint selected="true"><xsl:value-of select="fmp:COL[7]/fmp:DATA"/> </choicehint>                             
                               </choice>
								
								<choice correct="{fmp:COL[9]/fmp:DATA}">
								<xsl:value-of select="fmp:COL[8]/fmp:DATA"/>                             
								 <choicehint selected="true"><xsl:value-of select="fmp:COL[10]/fmp:DATA"/></choicehint>               
</choice>
                               <choice correct="{fmp:COL[12]/fmp:DATA}">
                               <xsl:value-of select="fmp:COL[11]/fmp:DATA"/>                               
                               <choicehint selected="true"><xsl:value-of select="fmp:COL[13]/fmp:DATA"/></choicehint>               
</choice>
                           </checkboxgroup>
                           </choiceresponse>
                     </problem>
<xsl:text>&#xA;</xsl:text>

                </xsl:for-each>


      </xsl:template>
</xsl:stylesheet>

 

Edited September 3, 20187 yr by DarioDN

9 minutes ago, DarioDN said:

I've just create a script to export my records in multiple xml file (one xml for each record) applying also an XSL stylesheet.

Where do you split the export into separate files? And why do you use for-each?

The error you are asking about is sometimes due to async sources and FileMaker being sync.

 

It's hard to help you without any hands-on.

Edited September 3, 20187 yr by ggt667

I'm triyng to export on a local folder. The "local" saving is ok.

Why doesn't it work if I use the xsl file online? Is really strange

I'm trying to search a workaround.

The first: is there a way to define the xsl path in a script? Using "export record" I can define the XML path (destination) but not the XSL path, asked me by dialog window.

So, how can I disable the Dialog and store the xsl path w/o it asks me every time?

tnx