Problems with XML transformation with XSLT

[scripts08]

Hi,

I am new to XSLT. Having problems creating an HTML table (specifically the headers) from an XML file like the following:

<group>
<categorylist>
<category>car</category>
<description>bently</description>
</categorylist>

<categorylist>
<category>car</category>
<description>bmw</description>
</categorylist>

<categorylist>
<category>computer</category>
<description>dell</description>
</categorylist>
</group>

So, I need to create a table where the first header (TH) should be 'car' with 2 TRs for 'bently' and 'bmw'. The next header should be 'computer' with only one TR for 'dell'. So, for each categorylist, I need to create a header for all categories with the same value and TRs for their corresponding 'description'.

Any help would be greatly appreciated.

Thanks.

[saran3b2]

hi declare the variable for category and description
like this

<xsl:key name="keyCategory" match="categorylist" use="category"/>
<xsl:key name="keyDescription" match="categorylist" use="description"/>


and apply ur xslt coding like these


<xsl:for-each select="$group">
<xsl:variable name="category" select="category"/>
<xsl:variable name="description" select="description"/>
<xsl:if test="generate-id(.)=generate-id($group[category=$category])">
<tr>
<th><xsl:value-of select="category"/></th>
</tr>
<tr>
<td><xsl:value-of select="description"/></td>
</tr>

</xsl:if>

</xsl:for-each>


ok
-------------------------------------------------------------------------------------------------------

Hi,

I am new to XSLT. Having problems creating an HTML table (specifically the headers) from an XML file like the following:

<group>
<categorylist>
<category>car</category>
<description>bently</description>
</categorylist>

<categorylist>
<category>car</category>
<description>bmw</description>
</categorylist>

<categorylist>
<category>computer</category>
<description>dell</description>
</categorylist>
</group>

So, I need to create a table where the first header (TH) should be 'car' with 2 TRs for 'bently' and 'bmw'. The next header should be 'computer' with only one TR for 'dell'. So, for each categorylist, I need to create a header for all categories with the same value and TRs for their corresponding 'description'.

Any help would be greatly appreciated.

Thanks.

[scripts08]

Thank you very much for your response. For some reason, its not working for me. I am not sure why. Any idea? I checked several times to make sure I don't have any typo or anything but still no luck.

hi declare the variable for category and description
like this

<xsl:key name="keyCategory" match="categorylist" use="category"/>
<xsl:key name="keyDescription" match="categorylist" use="description"/>


and apply ur xslt coding like these


<xsl:for-each select="$group">
<xsl:variable name="category" select="category"/>
<xsl:variable name="description" select="description"/>
<xsl:if test="generate-id(.)=generate-id($group[category=$category])">
<tr>
<th><xsl:value-of select="category"/></th>
</tr>
<tr>
<td><xsl:value-of select="description"/></td>
</tr>

</xsl:if>

</xsl:for-each>


ok
-------------------------------------------------------------------------------------------------------

[saran3b2]

hi,

here ouput is the clear. Please verify in ur xml and xsl coding.


<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="group.xsl"?>
<group>
<categorylist>
<category>car</category>
<description>bently</description>
</categorylist>

<categorylist>
<category>car</category>
<description>bmw</description>
</categorylist>

<categorylist>
<category>computer</category>
<description>dell</description>
</categorylist>
</group>

Simply copy and paste this coding for out put
------------------------------------------------------

group.xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" encoding="ISO-8859-1" doctype-public="-//W3C//DTD HTML 4.0 Transitional//EN"/>
<xsl:variable name="group" select="//categorylist"/>
<!-- Define keys used to group elements -->
<xsl:key name="keyCategory" match="categorylist" use="category"/>
<xsl:key name="keyDescription" match="categorylist" use="description"/>
<xsl:template match="/">
<html>
<head>
<title>Cengage Production Report</title>
</head>
<body>
<center>**************************************** </center>
<center>
<font size="6" color="brown">PreMedia Global P. Ltd.</font>
</center>
<center>**************************************** </center>
<center>
<font size="4" color="blue">Cengage Production Report</font>
</center>
<br/>
<table width="100%" frame="box" border="2" align="center">
<tbody>
<xsl:apply-templates/>
</tbody>
</table>
</body>
</html>
</xsl:template>



<xsl:template match="group" name="ShowproductionsInTeam">

<xsl:for-each select="$group">
<xsl:variable name="category" select="category"/>
<xsl:variable name="description" select="description"/>
<xsl:if test="generate-id(.)=generate-id($group[category=$category])">
<tr>
<th><xsl:value-of select="category"/></th>
</tr>
</xsl:if>
<tr>
<td><xsl:value-of select="description"/></td>
</tr>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

Reply me if ouput clear

Regards
vinoth K

Thank you very much for your response. For some reason, its not working for me. I am not sure why. Any idea? I checked several times to make sure I don't have any typo or anything but still no luck.

[saran3b2]

hi,

Please ignore the previous mail.

here is ur xml

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="group.xsl"?>
<group>
<categorylist>
<category>car</category>
<description>bently</description>
</categorylist>

<categorylist>
<category>car</category>
<description>bmw</description>
</categorylist>

<categorylist>
<category>computer</category>
<description>dell</description>
</categorylist>
</group>


Simply copy and paste this coding for out put
------------------------------------------------------

group.xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html" encoding="ISO-8859-1" doctype-public="-//W3C//DTD HTML 4.0 Transitional//EN"/>
<xsl:variable name="group" select="//categorylist"/>
<!-- Define keys used to group elements -->
<xsl:key name="keyCategory" match="categorylist" use="category"/>
<xsl:key name="keyDescription" match="categorylist" use="description"/>
<xsl:template match="/">
<html>
<head>
<title>Report</title>
</head>
<body>
<table width="100%" frame="box" border="2" align="center">
<tbody>
<xsl:apply-templates/>
</tbody>
</table>
</body>
</html>
</xsl:template>



<xsl:template match="group" name="ShowproductionsInTeam">

<xsl:for-each select="$group">
<xsl:variable name="category" select="category"/>
<xsl:variable name="description" select="description"/>
<xsl:if test="generate-id(.)=generate-id($group[category=$category])">
<tr>
<th><xsl:value-of select="category"/></th>
</tr>
</xsl:if>
<tr>
<td><xsl:value-of select="description"/></td>
</tr>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>