redirect:write printing xml header in output csv

jon.london · October 1st, 2007, 02:48 AM

Hi,

I need to write to an csv file,via xsl, which I have successfully done using the following code.

Code:

    <redirect:write select="$file_name">MONTH,SERVICE ORDER TYPE,SUCCESS RATE %
    <xsl:variable name="reconciledStats" select="@month"/>
    <xsl:for-each select="$reconciledStats">
        <xsl:if test="@StartRawDateAndTime=$month">
            <xsl:value-of select="concat(@StartRawDateAndTime,',',@ID, ',',@Total)" />
        </xsl:if>

    </xsl:for-each>

The problem is that at the top of my csv file, the following header is printed, which I need to remove. How can I remove this header:?

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

many thanks,

Jon

samjudson · October 1st, 2007, 03:13 AM

You could try adding <xsl:output method="text"/> as a top level declaration.

/- Sam Judson : Wrox Technical Editor -/

jon.london · October 1st, 2007, 05:05 AM

I am currently calling the template that makes the csv file from a page that renders as html. If I call <xsl:output method="text"/> as a top level declaration i get the whole page rendering as text.

Is there a way i can just get the one template to render as text?

Many thanks,

Jon

samjudson · October 1st, 2007, 05:35 AM

Ah yes, my mistake.

I've just confirmed in the rewrite docs that rewrite does no coordinate with the XSLT serialization, therefore is going to take no notice of the xsl:output element.

http://xml.apache.org/xalan-j/apidoc.../Redirect.html

It seems to be a 'feature' of the rewrite element so I don't think there is anything you can do about it.

/- Sam Judson : Wrox Technical Editor -/

mhkay · October 1st, 2007, 05:47 AM

Time to look at XSLT 2.0, perhaps? The <xsl:result-document> element gives you full control of the way in which secondary output files are serialized.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference