XML to XSLT conversion??

Hannibal · November 23rd, 2006, 08:27 AM

Hi..

  I have a xml document. Document is as follows:

<?xml version="1.0" encoding="ISO-8859-1" ?>

<Resource>
      <Catalog>
              <TableName>Mine</TableName>
              <Column1>Blue</Column1>
              <Column2>Red</Column2>
              <Column3>Green</Column3>
              <Query>Select </Query>
              <Condition>all</Condition>
              <Association_rule>1</Association_rule>
      </Catalog>

      <Catalog>
              <TableName>Others</TableName>
             <Column1>white</Column1>
             <Column2>orange</Column2>
             <Query>Insert</Query>
             <Condition>= </Condition>
             <Association_rule>2</Association_rule>
      </Catalog>

</Resource>

I need to create a XSLT for this page. The problem is that the first table has 3 colums and second table has 2 columns.. How to create the xslt for the above?

eg: XSLT should be in this table format:

Table Columns Query Condition Association Rule

Mine Blue select all 1

          Red insert = 2

          Green

Others White

          Orange

please help with the XSLT..

mhkay · November 23rd, 2006, 08:38 AM

Sorry, I don't understand the relationship of the input to the output. Why does the row for "Red", which appears to be part of table "Mine", fetch data from Table "Others", and why are the rows for "Others" blank?

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Hannibal · November 23rd, 2006, 09:05 AM

I needed to group the datas in the way i had provided, although there is no relationship between the 2 tables,

mhkay · November 23rd, 2006, 09:21 AM

Unless you can provide a clear specification of your requirements, there's no point starting to write code.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Hannibal · November 23rd, 2006, 09:26 AM

The xslt output format should have the tables and their respective columns. However the next element, ie., the query,condition and the Association rule should be sequentially following. This xslt conversion is provided as a Report, so there is no need for the relationships. Hope you can help me now.

Hannibal · November 23rd, 2006, 11:06 PM

can anyone please help

Hannibal · November 24th, 2006, 12:26 AM

I need the xslt for providing a report only. So there is no need for the relationships to check. Can anybody please help

Hannibal · November 24th, 2006, 02:08 AM

I have created a xslt, but its not providing the output i required. This is the XSLT that i have created:
<?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">

<html>
<body>

   <table border="1">
     <tr bgcolor="#9acd32">
       <th align="left">Table</th>
       <th align="left">Columns</th>
       <th align="left">Query</th>
       <th align="left">Condition</th>
       <th align="left">Association Rule</th>
     </tr>

<xsl:for-each select="Resource/Catalog">

<tr>
      <td><xsl:value-of select="TableName"/></td>
      <td><xsl:value-of select="Column1"/></td>
      <td><xsl:value-of select="Query"/></td>
      <td><xsl:value-of select="Condition"/></td>
      <td><xsl:value-of select="Association_rule"/></td>

</tr>

<tr>
      <td></td>
      <td><xsl:value-of select="Column2"/></td>

</tr>

<tr>
      <td></td>
      <td><xsl:value-of select="Column3"/></td>
</tr>

</xsl:for-each>

   </table>
</body>
</html>

</xsl:template>
</xsl:stylesheet>

I need the output as, i had shown in my first post. please do help

joefawcett · November 24th, 2006, 03:55 AM

It's still very difficult to see how the data maps from your input to the output. Why does the red row have insert and = and the green row have neither?

--

Joe (Microsoft MVP - XML)

mhkay · November 24th, 2006, 04:24 AM

No-one can write code for you unless you make the specification clear. You have not yet responded to the questions that Joe and I have asked.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference