0 Replies Latest reply on Jan 16, 2010 6:58 AM by prolog_1

    Output XML

    prolog_1

      Title

      Output XML

      Post

      Hello again

      Filemaker pro 9 adv 

      New problem

      I am working with an XLS file to output an XML who looks like this

       

      text

      text

      text

      and so on

      On the computer screen it looks perfect.

      But when I write it out on the printer it looks like this

       

      text

       

      text

       

      text

       

      Who shall I fix it ?

       

       This is the XSL File.

       

       

       <?xml version="1.0" encoding="UTF-8"?>
      <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 method="xml" version="1.0" encoding="iso-8859-1" omit-xml-declaration="no" indent="yes"/>
          <xsl:strip-space elements="*"/>

          <xsl:template match="/">
              <GBAOX10>
           <xsl:for-each select="/fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW">

        
           <ORDERLIST>
      <ORDER>
                 <!-- START-ENTRIES -->
                          <xsl:comment>START-ENTRIES</xsl:comment>
       
                          <ORDERID><xsl:value-of select="./fmp:COL[4]/fmp:DATA"/></ORDERID>

                          <CONTID><xsl:value-of select="./fmp:COL[5]/fmp:DATA"/></CONTID>
          <CONTNAME><xsl:value-of select="./fmp:COL[6]/fmp:DATA"/></CONTNAME>
          <ADRINVO><xsl:value-of select="./fmp:COL[7]/fmp:DATA"/></ADRINVO>
      <ADRDELIV><xsl:value-of select="./fmp:COL[8]/fmp:DATA"/></ADRDELIV>
      <REF><xsl:value-of select="./fmp:COL[9]/fmp:DATA"/></REF>
      <YOURREF><xsl:value-of select="./fmp:COL[10]/fmp:DATA"/></YOURREF>
      <EMPID><xsl:value-of select="./fmp:COL[11]/fmp:DATA"/></EMPID>
      <TEXT><xsl:value-of select="./fmp:COL[12]/fmp:DATA"/></TEXT>
      <SHIPTEXT><xsl:value-of select="./fmp:COL[13]/fmp:DATA"/></SHIPTEXT>
        <DATA4><xsl:value-of select="./fmp:COL[14]/fmp:DATA"/></DATA4>
      <DATA9><xsl:value-of select="./fmp:COL[15]/fmp:DATA"/></DATA9>
          <DATA15><xsl:value-of select="./fmp:COL[16]/fmp:DATA"/></DATA15>
        <DATA14><xsl:value-of select="./fmp:COL[17]/fmp:DATA"/></DATA14>
        <DATA2><xsl:value-of select="./fmp:COL[18]/fmp:DATA"/></DATA2>
         <FREIGHT><xsl:value-of select="./fmp:COL[19]/fmp:DATA"/></FREIGHT>
         <SUMORDER><xsl:value-of select="./fmp:COL[20]/fmp:DATA"/></SUMORDER>
        <SUMORDERDISCOUNT><xsl:value-of select="./fmp:COL[21]/fmp:DATA"/></SUMORDERDISCOUNT>
      <SUMORDERVAT><xsl:value-of select="./fmp:COL[22]/fmp:DATA"/></SUMORDERVAT>
      <SUMORDERTOTAL><xsl:value-of select="./fmp:COL[23]/fmp:DATA"/></SUMORDERTOTAL>
      <EXTERNALID><xsl:value-of select="./fmp:COL[24]/fmp:DATA"/></EXTERNALID>
      <KID><xsl:value-of select="./fmp:COL[25]/fmp:DATA"/></KID>
      <CURRENCYID><xsl:value-of select="./fmp:COL[26]/fmp:DATA"/></CURRENCYID>
        <ORDERLINES>
       <xsl:for-each select="./fmp:COL[27]/fmp:DATA">
                               <xsl:variable name="theRow" select="position()"/>
      <ORDERLINE>
        
      <PRODID><xsl:value-of select="../../fmp:COL[28]/fmp:DATA[position()=$theRow]"/></PRODID>
      <DESCRIPTION><xsl:value-of select="../../fmp:COL[29]/fmp:DATA[position()=$theRow]"/></DESCRIPTION>
      <QUANTITY><xsl:value-of select="../../fmp:COL[30]/fmp:DATA[position()=$theRow]"/></QUANTITY>
      <PRICE><xsl:value-of select="../../fmp:COL[31]/fmp:DATA[position()=$theRow]"/></PRICE>
      <DISCOUNT><xsl:value-of select="../../fmp:COL[32]/fmp:DATA[position()=$theRow]"/></DISCOUNT>
      <VATCODE><xsl:value-of select="../../fmp:COL[33]/fmp:DATA[position()=$theRow]"/></VATCODE>
      <STOREID><xsl:value-of select="../../fmp:COL[34]/fmp:DATA[position()=$theRow]"/></STOREID>
      <DELIVERYDATE><xsl:value-of select="../../fmp:COL[35]/fmp:DATA[position()=$theRow]"/></DELIVERYDATE>
       </ORDERLINE>
       </xsl:for-each>
      </ORDERLINES>   
       
      </ORDER>
                    </ORDERLIST>
               </xsl:for-each>
            
             </GBAOX10>
       
              
            
          </xsl:template>
      </xsl:stylesheet>