AnsweredAssumed Answered

Output XML

Question asked by prolog_1 on Jan 16, 2010

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>
  

 

 




























Outcomes