xml Translation question

lion_bar

Hi,

I'm trying to use an xsl file to pick out some values from one cXML file and generate another xml file. I get the file created but the values are not being populated.

Here's the file that i'm trying to translate.

<cXML>
<Request>
<InvoiceDetailRequest>
<InvoiceDetailRequestHeader invoiceID="123456"/>
</InvoiceDetailRequest>
</Request>
</cXML>

Using this xsl file

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes" encoding="UTF-8"/>
<xsl:template match="/">
<Invoice>
<DocumentNumber>
<xsl:value-of select="cMXL/Request/InvoiceDetailRequest/InvoiceDetailRequestHeader/invoiceID"/>
</DocumentNumber>
</Invoice>
</xsl:template>
</xsl:stylesheet>

My output is this
<?xml version="1.0" encoding="UTF-8"?>
<Invoice>
<DocumentNumber/>
</Invoice>

Does any one have any idea where I'm going wrong? I was hoping to get this output

<?xml version="1.0" encoding="UTF-8"?>
<Invoice>
<DocumentNumber>123456</DocumentNumber>
</Invoice>

Thanks

fasty

The value for invoiceID is an attribute, not the contents of an element so the XPATH is:

<xsl:value-of select="cMXL/Request/InvoiceDetailRequest/InvoiceDetailRequestHeader/@invoiceID"/>

http://www.w3schools.com/xpath/xpath_syntax.asp

lion_bar

thanks.