template for child nodes

pushkar_joshi · August 12th, 2010, 03:23 AM

Hi,
This is my first try at xslt. <template> is an entry point for xslt. How can i use it to fetch only child node data without complete root's/document node's data?

Thanks in advance

samjudson · August 12th, 2010, 03:35 AM

Hi

Could you please read this post on how to write a good post here: Hints for a good XSLT post

Then try showing us what your input XML looks like and what you'd like your output XML to look like and what you've tried and we might be able to help you.

pushkar_joshi · August 12th, 2010, 04:49 AM

Sam,
Thanks for replying.

The xml source is,

<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="OrderPrice.xslt"?>
<OrderInfo>
<Customer>
<AccountNumber>7723123</AccountNumber>
</Customer>
<LineItems>
<Item no="1">
<SKU>1234</SKU>
<Quantity>1</Quantity>
<PriceCode>E</PriceCode>
</Item>
<Item no="2">
<SKU>7723</SKU>
<Quantity>2</Quantity>
<PriceCode>C</PriceCode>
</Item>
</LineItems>
</OrderInfo>

The xslt is as follows

<xsl:template match="Item">
<xsl:variable name="letter" select="PriceCode"/>
<Item>
<SKU>
<xsl:value-of select="SKU"></xsl:value-of>
</SKU>
<Quantity>

<xsl:value-of select="Quantity"></xsl:value-of>

</Quantity>
<Price>
<xsl:value-of select="$prices/Code[Letter=$letter]/Price"/>
</Price>
</Item>

</xsl:template>

This gives me the whole data from xml file. How can I extract data only from single node, price, item etc.

pushkar_joshi · August 12th, 2010, 04:52 AM

also this xslt does not define root element for my output. Kindly help

mhkay · August 12th, 2010, 05:00 AM

This instruction looks pretty random

Code:

<xsl:value-of select="$prices/Code[Letter=$letter]/Price"/>

because there are no elements called Code, Letter, or Price in your input, nor do you declare a variable called $prices.

Apart from that, the problem seems to be that you need a template rule to match the root node. Something like

Code:

<xsl:template match="/">
  <output>
     <xsl:apply-templates select="//Item[@no='2']"/>
  </output>
</xsl:template>

pushkar_joshi · August 12th, 2010, 05:48 AM

Thanks for the reply,

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="xml" indent="yes"/>

<xsl:variable name="prices" select=
"document('Price.xml')/PriceCodes"/>

<xsl:template match ="/">
<xsl:apply-templates/>
</xsl:template>

<xsl:template match="OrderInfo/Customer">
<Customer>
<AccountNumber>
<xsl:value-of select="AccountNumber"/>

</AccountNumber>
</Customer>

</xsl:template>

<xsl:template name="lineitems" match="/OrderInfo/LineItems/Item">
<xsl:variable name="letter" select="PriceCode"/>
<Item>
<SKU>
<xsl:value-of select="SKU"></xsl:value-of>
</SKU>
<Quantity>
<xsl:value-of select="Quantity"></xsl:value-of>
</Quantity>
<Price>
<xsl:value-of select="$prices/Code[Letter=$letter]/Price"/>
</Price>
</Item>
</xsl:template>

</xsl:stylesheet>

The output i want is

<root>

<Customer><AccountNumber>7723123</AccountNumber></Customer>

<Item>
<SKU>1234</SKU>
<Quantity>1</Quantity>
<Price>15.50</Price>
</Item>

<PriceCode ItemPrice="15.50" />

<Item>
<SKU>7723</SKU>
<Quantity>2</Quantity>
<Price>6.75</Price>
</Item>

<PriceCode ItemPrice="6.75" />

</root>

The <price> gets proper value from other xml file.
How can i get the root element.
Thanks for helping.

samjudson · August 12th, 2010, 05:59 AM

Simply change:

Code:

<xsl:template match ="/">
<xsl:apply-templates/>
</xsl:template>

to

Code:

<xsl:template match ="/">
<root>
  <xsl:apply-templates/>
</root>
</xsl:template>

pushkar_joshi · August 12th, 2010, 06:02 AM

That solved my problem. Thank you