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 <[EMAIL PROTECTED]> 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 >
