XML to XML

daplex · July 28th, 2014, 11:00 AM

I am having trouble getting xml tags to output. I am using this site to process.
http://xslt.online-toolz.com/tools/x...sformation.php

XML:

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited by XMLSpyÂ® -->
<?xml-stylesheet type="text/xsl" href="xsl.xsl"?>
<Root>
	<Row>
		<Number>1</Number>
		<SKU>3225A</SKU>
		<COST>1.98</COST>
	</Row>
	<Row>
		<Number>2</Number>
		<SKU>MN145</SKU>
		<COST>1.82</COST>
	</Row>
	<Row>
		<Number>3</Number>
		<SKU>MN143</SKU>
		<COST>1.82</COST>
	</Row>
</Root>

XSLT:

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited by XMLSpyÂ® -->
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>

<xsl:template match="/">
<xsl:for-each select="Root/Row">
<header>
<xsl:value-of select="SKU"/>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

Output:

Quote:

Error:XSLTProcessor::transformToXml() [<a href='xsltprocessor.transformtoxml'>xsltprocessor. transformtoxml</a>]: No stylesheet associated to this object

Output I want:
<header>
1
3225A
1.98

...etc.

It seems the <header> tag is breaking it saying No stylesheet associated to this object.

I just want to rebuild an xml document changing the SKU on every iteration.

I have tried the disable-output-escaping="yes" to no avail. It seems it doesn't want to output the <header> tag as is that I need.

What am I doing wrong?
thanks

mhkay · July 28th, 2014, 03:54 PM

It's a weird error message, but your stylesheet is wrong. An XSLT stylesheet must be a well-formed XML document, so an unmatched <header> start tag is not allowed.

Your desired output is also not well-formed XML. You can produce that output if you want, but you will need to use the text output method rather than the XML output method.

daplex · July 28th, 2014, 04:09 PM

I figured it out. I see you need opening and closing tags for it to work.

XML...

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited by XMLSpyÂ® -->
<?xml-stylesheet type="text/xsl" href="xsl.xsl"?>
<Root>
	<Row>
		<Number>1</Number>
		<SKU>3225A</SKU>
		<COST>1.98</COST>
	</Row>
	<Row>
		<Number>2</Number>
		<SKU>MN145</SKU>
		<COST>1.82</COST>
	</Row>
	<Row>
		<Number>3</Number>
		<SKU>MN143</SKU>
		<COST>1.82</COST>
	</Row>
</Root>

XSLT...

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- Edited by XMLSpyÂ® -->
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>

<xsl:template match="/">
  
      <xsl:for-each select="Root/Row">
<Message>
<MessageID><xsl:value-of select="Number"/></MessageID><OperationType>Update</OperationType>
<Override><SKU><xsl:value-of select="SKU"/></SKU>
<ShippingOverride><ShipOption>Std Cont US Street Addr</ShipOption><Type>Exclusive</Type><ShipAmount currency="USD"><xsl:value-of select="COST"/></ShipAmount></ShippingOverride>
</Override>
</Message>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

Output...
<?xml version="1.0" encoding="utf-8"?>
<Message>
<MessageID>1</MessageID>
<OperationType>Update</OperationType>
<Override>
<SKU>3225A</SKU>
<ShippingOverride>
<ShipOption>Std Cont US Street Addr</ShipOption>
<Type>Exclusive</Type>
<ShipAmount currency="USD">1.98</ShipAmount>
</ShippingOverride>
</Override>
</Message><Message>
<MessageID>2</MessageID>
<OperationType>Update</OperationType>
<Override>
<SKU>MN145</SKU>
<ShippingOverride>
<ShipOption>Std Cont US Street Addr</ShipOption>
<Type>Exclusive</Type>
<ShipAmount currency="USD">1.82</ShipAmount>
</ShippingOverride>
</Override>
</Message><Message>
<MessageID>3</MessageID>
<OperationType>Update</OperationType>
<Override>
<SKU>MN143</SKU>
<ShippingOverride>
<ShipOption>Std Cont US Street Addr</ShipOption>
<Type>Exclusive</Type>
<ShipAmount currency="USD">1.82</ShipAmount>
</ShippingOverride>
</Override>
</Message>

thanks for your help.
Do you recommend any processors online that may be better than the one I used? http://xslt.online-toolz.com/tools/x...sformation.php

Or is this one okay?

thanks!