copying all elements using xsl and renaming specific nodes

[sianmace]

I have a document from Amazon wich is massive and has the same names for elements under different branches of the tree.

ie
<item>
<smallimage>
<height units=""></height>
</smallimage>
<largeimage>
<height units=""></height>
</largeImage>

.net cannot deal with this in a dataset as it needs unique names. so i need to rename the height elements to something like smallheight and largeheight.

as this is only a snippet of the document, i need to copy all of the docuemnt and just rename these specific nodes.

is there any way to say copy everything, but whith these, do this.
??
Please help i have been searching and searchng

 

[JontyMC]

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="[URL unfurl="true"]http://www.w3.org/1999/XSL/Transform">[/URL]
	<xsl:template match="@*|node()">
		<xsl:copy>
			<xsl:apply-templates select="@*|node()"/>
		</xsl:copy>
	</xsl:template>
	<xsl:template match="/item/smallimage/height">
		<smallheight units="{units}">
			<xsl:value-of select="."/>
		</smallheight>
	</xsl:template>
	<xsl:template match="/item/largeimage/height">
		<largeheight units="{units}">
			<xsl:value-of select="."/>
		</largeheight>
	</xsl:template>
</xsl:stylesheet>

 

[flumpy]

I know you can do xsl:copy but this is not what you want...

What you really want to do is create a couple of templates that output the xml with the format you want, using the xml you already have and use apply-templates to structure it.

Something like this (which will not work on its own without development!! I can't just hand you the answer :

<xsl:template select="/">
    <item>
        <xsl:apply-templates select="smallimage"/>
        <xsl:apply-templates select="largeimage"/>
    </items>
</xsl:tempalte>
...

<xsl:template match="smallimage">
<smallimage>
    <small-height>
       <xsl:attribute name="units"><xsl:value-of select="@units"/></xsl:attribute>
    </small-height>
</smallimage>
</xsl:template>

etc..

so basically you are recreating the xml with the stylesheet not copying and replacing nodes.


Hope this helps

Matt

 

[JontyMC]

If item is not the root node, you'll need to put

<xsl:template match="//item/smallimage/height">

and

<xsl:template match="//item/smallimage/height">

 

[flumpy]

yes or what jonty said might actually be better because you do not loose attributes that might potentially be in the items or height tags..

 

[JontyMC]

If you truly need to copy the whole document to dataset, then xsl:copy is what you want. But if you only using some of the nodes, constructing your own cut-down xml would be better.

Jon

 

[sianmace]

no, i need all of the rest of the document exactly the same. and just those nodes renamed.
so what do you collectively think is the best way to go about this

 

[sianmace]

Right i tried the first option and it worked a treat, if i took a xmlns attribute out.
heres what i have

<ItemSearchResponse xmlns:xsd="

http://www.w3.org/2001/XMLSchema"

xmlns:xsi="

http://www.w3.org/2001/XMLSchema-instance">

<Items xmlns="

http://webservices.amazon.com/AWSECommerceService/2005-01-19">

<Item>
<ASIN>0747581088</ASIN>
<DetailPageURL>

http://www.amazon.co.uk/exec/obidos...iptionId=0H62JN5QK8DAQPGRRT82</DetailPageURL>

<SalesRank>1</SalesRank>
<SmallImage>
<URL>

http://images.amazon.com/images/P/0747581088.02._SCTHUMBZZZ_.jpg</URL>

<Height Units="mm">75</Height>
<Width>53</Width>
</SmallImage>
<MediumImage>
<URL>

http://images.amazon.com/images/P/0747581088.02._SCMZZZZZZZ_.jpg</URL>

<Height Units="mm">160</Height>
<Width>113</Width>
</MediumImage>

If i take out the xmlns from items it works, but if its in id doesnt, can you please help, im so near

 

[JontyMC]

See my reply to this thread:

http://www.tek-tips.com/viewthread.cfm?qid=983864

"Basically, the XSLT engine needs a fully qualified name to reference a node. This means to reference any node in XSLT that uses a namespace, you need to have a refence to that namespace in the XSLT and that namespace must use a prefix whether it refers to the default namespace or not.

 

[sianmace]

That was the answer i was looking for.

but i have one more question about it that i dont really understand.

because i have defined it in the stylesheet as
xmlns:amazon="http....."
i now get on those elements that i changed
<LargeHeight xmlns:amazon="http...."

but in the xml its just xmlns="http...." and i would like to keep it that way on the other side.

i understand that the amazon is there because i have said that in the schema, but can i do it without that?

 

[JontyMC]

Never used this myself, but I'm guessing at something along the lines of:

<xsl:namespace-alias stylesheet-prefix="amazon" result-prefix="#default"/>

Let me know if that works.

Jon

 

[sianmace]

that was great.
How do you know what to search for to find the answers on all these xsl questions.
Its all so foreign to me.
Thank you so much for the help.
At last i can get on with my work

 

[JontyMC]

http://www.w3schools.com

is always my first port of call. Other than that, its experience/google/other forums.

Jon