You are viewing a plain text version of this content. The canonical link for it is here.
Posted to j-users@xalan.apache.org by "Ronald R. DiFrango" <ro...@gmail.com> on 2007/08/23 04:56:20 UTC
XML to CSV Help
All,
I have the following XML:
<?xml version="1.0" encoding="UTF-8"?>
<ns0:notificationHeader xmlns:ns0="http://www.circuitcity.com/rtvcrms">
<ns0:id>81</ns0:id>
<ns0:vendorNumber>70229</ns0:vendorNumber>
<ns0:recepientAddress/>
<ns0:notificationDate>2007-06-08T21:01:28.959-04
:00</ns0:notificationDate>
<ns0:subject>CCS RTV Payment Disputes 06/08/2007 21:01:28</ns0:subject>
<ns0:body>N/A</ns0:body>
<ns0:retryCount>1</ns0:retryCount>
<ns0:comment>N/A</ns0:comment>
<ns0:status>Sent</ns0:status>
<ns0:rtvNumber>35508077</ns0:rtvNumber>
<ns0:notificationDetails>
<ns0:notificationDetail>
<ns0:id>19</ns0:id>
<ns0:rtvShipDate>2004-03-22T00:00:00-05:00</ns0:rtvShipDate>
<ns0:qtyDiscrepancy>0</ns0:qtyDiscrepancy>
<ns0:requestedAmount>870</ns0:requestedAmount>
<ns0:paidAmount>500</ns0:paidAmount>
<ns0:rejectedAmount>370</ns0:rejectedAmount>
<ns0:epPrice>0</ns0:epPrice>
<ns0:message>According to our Vendor Contract, this additional
charge is not authorized for repayment OR was overbilled.</ns0:message>
<ns0:repaycode>RS</ns0:repaycode>
<ns0:vendorNumber>70229</ns0:vendorNumber>
<ns0:discrepancyAmount>0</ns0:discrepancyAmount>
<ns0:rtvPrice>0</ns0:rtvPrice>
<ns0:cmPrice>0</ns0:cmPrice>
<ns0:rrPrice>0</ns0:rrPrice>
<ns0:defTag>-</ns0:defTag>
<ns0:apCost>0</ns0:apCost>
<ns0:invoiceCost>0</ns0:invoiceCost>
<ns0:funding>Y</ns0:funding>
<ns0:earned>Y</ns0:earned>
<ns0:cmNumber>35508077CM</ns0:cmNumber>
<ns0:rtvNumber>35508077</ns0:rtvNumber>
</ns0:notificationDetail>
</ns0:notificationDetails>
</ns0:notificationHeader>
and the following XSL file:
<xsl:stylesheet version="1.0" xmlns:xsl="
http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template match="notificationDetail">
<xsl:value-of select="normalize-space(rtvShipDate)"/> , <xsl:value-of
select="normalize-space(brand)"/> , <xsl:value-of
select="normalize-space(model)"/> , <xsl:value-of
select="normalize-space(qtyDiscrepancy)"/> , <xsl:value-of
select="normalize-space(requestedAmount)"/> , <xsl:value-of
select="normalize-space(paidAmount)"/> , <xsl:value-of
select="normalize-space(rejectedAmount)"/> , <xsl:value-of
select="normalize-space(epPrice)"/> , <xsl:value-of
select="normalize-space(ppRec)"/> , <xsl:value-of
select="normalize-space(message)"/> , <xsl:value-of
select="normalize-space(repaycode)"/> , <xsl:value-of
select="normalize-space(vendorNumber)"/> , <xsl:value-of
select="normalize-space(discrepancyAmount)"/> , <xsl:value-of
select="normalize-space(rtvPrice)"/> , <xsl:value-of
select="normalize-space(cmPrice)"/> , <xsl:value-of
select="normalize-space(rrPrice)"/> , <xsl:value-of
select="normalize-space(defTag)"/> , <xsl:value-of
select="normalize-space(apCost)"/> , <xsl:value-of
select="normalize-space(invoiceCost)"/> , <xsl:value-of
select="normalize-space(funding)"/> , <xsl:value-of
select="normalize-space(earned)"/> , <xsl:value-of
select="normalize-space(cmNumber)"/> , <xsl:value-of
select="normalize-space(rtvNumber)"/> , <xsl:value-of
select="normalize-space(keyRecNo)"/><xsl:text> </xsl:text>
</xsl:template>
</xsl:stylesheet>
The intent is for me is to transform the XML into a CSV format. But when I
run this stylesheet I get the following:
81
70229
2007-06-08T21:01:28.959-04:00
CCS RTV Payment Disputes 06/08/2007 21:01:28
N/A
1
N/A
Sent
35508077
19
2004-03-22T00:00:00-05:00
0
870
500
370
0
According to our Vendor Contract, this additional charge is not
authorized for repayment OR was overbilled.
RS
70229
0
0
0
0
-
0
0
Y
Y
35508077CM
35508077
Which is basically a flat dump of the XML minus the tags. My execution code
is as follows:
public static void main(String[] args) throws Exception {
StreamSource xsl = new StreamSource(new InputStreamReader(
NotificationTransform.class.getResourceAsStream("convertToCSV.xsl" )));
Transformer transformer = TransformerFactory.newInstance
().newTransformer(xsl);
StreamSource xml = new StreamSource(new
FileReader("C:/Temp/xmlOutput/notificationDetails.xml"));
StreamResult result = new StreamResult(new
FileWriter("C:/Temp/xmlOutput/notificationDetails.txt"));
transformer.transform(xml, result);
// System.out.println("Done: " + result.getWriter().toString());
}
Any help would be appreciated.
Ron
Re: XML to CSV Help
Posted by "Ronald R. DiFrango" <ro...@gmail.com>.
I figured it out, my XSL now looks like the following:
<?xml version="1.0"?>
<xsl:stylesheet
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:ns0="http://www.circuitcity.com/rtvcrms"
version="1.0">
<xsl:output method="text" />
<xsl:template match="/">
<xsl:apply-templates />
</xsl:template>
<xsl:template match="ns0:notificationHeader">
<xsl:apply-templates select="ns0:notificationDetails" />
</xsl:template>
<xsl:template match="ns0:notificationDetails">
<xsl:apply-templates select="ns0:notificationDetail" />
</xsl:template>
<xsl:template match="ns0:notificationDetail">
<xsl:value-of select="normalize-space(ns0:rtvShipDate)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:brand)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:model)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:qtyDiscrepancy)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:requestedAmount)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:paidAmount)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:rejectedAmount)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:epPrice)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:ppRec)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:message)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:repaycode)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:vendorNumber)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:discrepancyAmount)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:rtvPrice)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:cmPrice)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:rrPrice)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:defTag)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:apCost)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:invoiceCost)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:funding)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:earned)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:cmNumber)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:rtvNumber)" />
<xsl:text>,</xsl:text>
<xsl:value-of select="normalize-space(ns0:keyRecNo)" />
<xsl:text> </xsl:text>
</xsl:template>
</xsl:stylesheet>
And it works like a champ.
On 8/22/07, Ronald R. DiFrango <ro...@gmail.com> wrote:
>
> OK, I figured out part of the problem, it seems I need to force Xalan or
> the parser to recognize namespaces. How do I go about doing that?
>
> On 8/22/07, Ronald R. DiFrango <ro...@gmail.com> wrote:
> >
> > All,
> >
> > I have the following XML:
> >
> > <?xml version="1.0" encoding="UTF-8"?>
> > <ns0:notificationHeader xmlns:ns0=" http://www.circuitcity.com/rtvcrms
> > ">
> > <ns0:id>81</ns0:id>
> > <ns0:vendorNumber>70229</ns0:vendorNumber>
> > <ns0:recepientAddress/>
> > <ns0:notificationDate>2007-06-08T21:01:28.959-04:00</ns0:notificationDate>
> >
> > <ns0:subject>CCS RTV Payment Disputes 06/08/2007
> > 21:01:28</ns0:subject>
> > <ns0:body>N/A</ns0:body>
> > <ns0:retryCount>1</ns0:retryCount>
> > <ns0:comment>N/A</ns0:comment>
> > <ns0:status>Sent</ns0:status>
> > <ns0:rtvNumber>35508077</ns0:rtvNumber>
> > <ns0:notificationDetails>
> > <ns0:notificationDetail>
> > <ns0:id>19</ns0:id>
> > <ns0:rtvShipDate>2004-03-22T00:00:00-05:00</ns0:rtvShipDate>
> > <ns0:qtyDiscrepancy>0</ns0:qtyDiscrepancy>
> > <ns0:requestedAmount>870</ns0:requestedAmount>
> > <ns0:paidAmount>500</ns0:paidAmount>
> > <ns0:rejectedAmount>370</ns0:rejectedAmount>
> > <ns0:epPrice>0</ns0:epPrice>
> > <ns0:message>According to our Vendor Contract, this
> > additional charge is not authorized for repayment OR was
> > overbilled.</ns0:message>
> > <ns0:repaycode>RS</ns0:repaycode>
> > <ns0:vendorNumber>70229</ns0:vendorNumber>
> > <ns0:discrepancyAmount>0</ns0:discrepancyAmount>
> > <ns0:rtvPrice>0</ns0:rtvPrice>
> > <ns0:cmPrice>0</ns0:cmPrice>
> > <ns0:rrPrice>0</ns0:rrPrice>
> > <ns0:defTag>-</ns0:defTag>
> > <ns0:apCost>0</ns0:apCost>
> > <ns0:invoiceCost>0</ns0:invoiceCost>
> > <ns0:funding>Y</ns0:funding>
> > <ns0:earned>Y</ns0:earned>
> > <ns0:cmNumber>35508077CM</ns0:cmNumber>
> > <ns0:rtvNumber>35508077</ns0:rtvNumber>
> > </ns0:notificationDetail>
> > </ns0:notificationDetails>
> > </ns0:notificationHeader>
> >
> > and the following XSL file:
> >
> > <xsl:stylesheet version="1.0" xmlns:xsl="
> > http://www.w3.org/1999/XSL/Transform ">
> > <xsl:output method="text"/>
> > <xsl:template match="notificationDetail">
> > <xsl:value-of select="normalize-space(rtvShipDate)"/> , <xsl:value-of
> > select="normalize-space(brand)"/> , <xsl:value-of
> > select="normalize-space(model)"/> , <xsl:value-of
> > select="normalize-space(qtyDiscrepancy)"/> , <xsl:value-of
> > select="normalize-space(requestedAmount)"/> , <xsl:value-of
> > select="normalize-space(paidAmount)"/> , <xsl:value-of
> > select="normalize-space(rejectedAmount)"/> , <xsl:value-of
> > select="normalize-space(epPrice)"/> , <xsl:value-of
> > select="normalize-space(ppRec)"/> , <xsl:value-of
> > select="normalize-space(message)"/> , <xsl:value-of
> > select="normalize-space(repaycode)"/> , <xsl:value-of
> > select="normalize-space(vendorNumber)"/> , <xsl:value-of
> > select="normalize-space(discrepancyAmount)"/> , <xsl:value-of
> > select="normalize-space(rtvPrice)"/> , <xsl:value-of
> > select="normalize-space(cmPrice)"/> , <xsl:value-of
> > select="normalize-space(rrPrice)"/> , <xsl:value-of
> > select="normalize-space(defTag)"/> , <xsl:value-of
> > select="normalize-space(apCost)"/> , <xsl:value-of
> > select="normalize-space(invoiceCost)"/> , <xsl:value-of
> > select="normalize-space(funding)"/> , <xsl:value-of
> > select="normalize-space(earned)"/> , <xsl:value-of
> > select="normalize-space(cmNumber)"/> , <xsl:value-of
> > select="normalize-space(rtvNumber)"/> , <xsl:value-of
> > select="normalize-space(keyRecNo)"/><xsl:text> </xsl:text>
> > </xsl:template>
> > </xsl:stylesheet>
> >
> >
> > The intent is for me is to transform the XML into a CSV format. But
> > when I run this stylesheet I get the following:
> >
> >
> > 81
> > 70229
> >
> > 2007-06-08T21:01:28.959-04:00
> > CCS RTV Payment Disputes 06/08/2007 21:01:28
> > N/A
> > 1
> > N/A
> > Sent
> > 35508077
> >
> >
> > 19
> > 2004-03-22T00:00:00-05:00
> > 0
> > 870
> > 500
> > 370
> > 0
> > According to our Vendor Contract, this additional charge is
> > not authorized for repayment OR was overbilled.
> > RS
> > 70229
> > 0
> > 0
> > 0
> > 0
> > -
> > 0
> > 0
> > Y
> > Y
> > 35508077CM
> > 35508077
> >
> >
> > Which is basically a flat dump of the XML minus the tags. My execution
> > code is as follows:
> >
> > public static void main(String[] args) throws Exception {
> > StreamSource xsl = new StreamSource(new InputStreamReader(
> > NotificationTransform.class.getResourceAsStream("convertToCSV.xsl" )));
> > Transformer transformer = TransformerFactory.newInstance
> > ().newTransformer(xsl);
> > StreamSource xml = new StreamSource(new
> > FileReader("C:/Temp/xmlOutput/notificationDetails.xml"));
> > StreamResult result = new StreamResult(new
> > FileWriter("C:/Temp/xmlOutput/notificationDetails.txt"));
> > transformer.transform(xml, result);
> > // System.out.println("Done: " + result.getWriter().toString());
> > }
> >
> > Any help would be appreciated.
> >
> > Ron
> >
>
>
Re: XML to CSV Help
Posted by "Ronald R. DiFrango" <ro...@gmail.com>.
OK, I figured out part of the problem, it seems I need to force Xalan or the
parser to recognize namespaces. How do I go about doing that?
On 8/22/07, Ronald R. DiFrango <ro...@gmail.com> wrote:
>
> All,
>
> I have the following XML:
>
> <?xml version="1.0" encoding="UTF-8"?>
> <ns0:notificationHeader xmlns:ns0="http://www.circuitcity.com/rtvcrms ">
> <ns0:id>81</ns0:id>
> <ns0:vendorNumber>70229</ns0:vendorNumber>
> <ns0:recepientAddress/>
> <ns0:notificationDate>2007-06-08T21:01:28.959-04:00</ns0:notificationDate>
>
> <ns0:subject>CCS RTV Payment Disputes 06/08/2007
> 21:01:28</ns0:subject>
> <ns0:body>N/A</ns0:body>
> <ns0:retryCount>1</ns0:retryCount>
> <ns0:comment>N/A</ns0:comment>
> <ns0:status>Sent</ns0:status>
> <ns0:rtvNumber>35508077</ns0:rtvNumber>
> <ns0:notificationDetails>
> <ns0:notificationDetail>
> <ns0:id>19</ns0:id>
> <ns0:rtvShipDate>2004-03-22T00:00:00-05:00</ns0:rtvShipDate>
> <ns0:qtyDiscrepancy>0</ns0:qtyDiscrepancy>
> <ns0:requestedAmount>870</ns0:requestedAmount>
> <ns0:paidAmount>500</ns0:paidAmount>
> <ns0:rejectedAmount>370</ns0:rejectedAmount>
> <ns0:epPrice>0</ns0:epPrice>
> <ns0:message>According to our Vendor Contract, this additional
> charge is not authorized for repayment OR was overbilled.</ns0:message>
> <ns0:repaycode>RS</ns0:repaycode>
> <ns0:vendorNumber>70229</ns0:vendorNumber>
> <ns0:discrepancyAmount>0</ns0:discrepancyAmount>
> <ns0:rtvPrice>0</ns0:rtvPrice>
> <ns0:cmPrice>0</ns0:cmPrice>
> <ns0:rrPrice>0</ns0:rrPrice>
> <ns0:defTag>-</ns0:defTag>
> <ns0:apCost>0</ns0:apCost>
> <ns0:invoiceCost>0</ns0:invoiceCost>
> <ns0:funding>Y</ns0:funding>
> <ns0:earned>Y</ns0:earned>
> <ns0:cmNumber>35508077CM</ns0:cmNumber>
> <ns0:rtvNumber>35508077</ns0:rtvNumber>
> </ns0:notificationDetail>
> </ns0:notificationDetails>
> </ns0:notificationHeader>
>
> and the following XSL file:
>
> <xsl:stylesheet version="1.0" xmlns:xsl="
> http://www.w3.org/1999/XSL/Transform">
> <xsl:output method="text"/>
> <xsl:template match="notificationDetail">
> <xsl:value-of select="normalize-space(rtvShipDate)"/> , <xsl:value-of
> select="normalize-space(brand)"/> , <xsl:value-of
> select="normalize-space(model)"/> , <xsl:value-of
> select="normalize-space(qtyDiscrepancy)"/> , <xsl:value-of
> select="normalize-space(requestedAmount)"/> , <xsl:value-of
> select="normalize-space(paidAmount)"/> , <xsl:value-of
> select="normalize-space(rejectedAmount)"/> , <xsl:value-of
> select="normalize-space(epPrice)"/> , <xsl:value-of
> select="normalize-space(ppRec)"/> , <xsl:value-of
> select="normalize-space(message)"/> , <xsl:value-of
> select="normalize-space(repaycode)"/> , <xsl:value-of
> select="normalize-space(vendorNumber)"/> , <xsl:value-of
> select="normalize-space(discrepancyAmount)"/> , <xsl:value-of
> select="normalize-space(rtvPrice)"/> , <xsl:value-of
> select="normalize-space(cmPrice)"/> , <xsl:value-of
> select="normalize-space(rrPrice)"/> , <xsl:value-of
> select="normalize-space(defTag)"/> , <xsl:value-of
> select="normalize-space(apCost)"/> , <xsl:value-of
> select="normalize-space(invoiceCost)"/> , <xsl:value-of
> select="normalize-space(funding)"/> , <xsl:value-of
> select="normalize-space(earned)"/> , <xsl:value-of
> select="normalize-space(cmNumber)"/> , <xsl:value-of
> select="normalize-space(rtvNumber)"/> , <xsl:value-of
> select="normalize-space(keyRecNo)"/><xsl:text> </xsl:text>
> </xsl:template>
> </xsl:stylesheet>
>
>
> The intent is for me is to transform the XML into a CSV format. But when
> I run this stylesheet I get the following:
>
>
> 81
> 70229
>
> 2007-06-08T21:01:28.959-04:00
> CCS RTV Payment Disputes 06/08/2007 21:01:28
> N/A
> 1
> N/A
> Sent
> 35508077
>
>
> 19
> 2004-03-22T00:00:00-05:00
> 0
> 870
> 500
> 370
> 0
> According to our Vendor Contract, this additional charge is
> not authorized for repayment OR was overbilled.
> RS
> 70229
> 0
> 0
> 0
> 0
> -
> 0
> 0
> Y
> Y
> 35508077CM
> 35508077
>
>
> Which is basically a flat dump of the XML minus the tags. My execution
> code is as follows:
>
> public static void main(String[] args) throws Exception {
> StreamSource xsl = new StreamSource(new InputStreamReader(
> NotificationTransform.class.getResourceAsStream("convertToCSV.xsl" )));
> Transformer transformer = TransformerFactory.newInstance
> ().newTransformer(xsl);
> StreamSource xml = new StreamSource(new
> FileReader("C:/Temp/xmlOutput/notificationDetails.xml"));
> StreamResult result = new StreamResult(new
> FileWriter("C:/Temp/xmlOutput/notificationDetails.txt"));
> transformer.transform(xml, result);
> // System.out.println("Done: " + result.getWriter().toString());
> }
>
> Any help would be appreciated.
>
> Ron
>