help with xsl templates

arazok · June 16th, 2004, 03:11 PM

hello,
I have a problem. I have an xml file that I am trying to display.

the xml is similar as follows. (The <Zone>'s can come in any order/quantity, and come in 2 types: Those with child <Table>'s, and those without. Zones with Tables always have 'Name="Table"')

<Page>
<Zone Name="Address">
   <Field Name="Address">123 4th st.></Field>
</Zone>
<Zone Name="Table">
   <Table LineNo="1">
      <Field Name="Item">12345</Field>
   </Table>
   <Table LineNo="1">
      <Field Name="Desc">Candy</Field>
   </Table>
   <Table LineNo="2">
      <Field Name="Desc">Cane</Field>
   </Table>
</Zone>
</Page>

I want the output to look something like this:
Address
123 4th St

Item Desc
12345 Candy
         Cane

I have been able to create a template that works for the first address <Zone>, but I do not understand how to create a template that can handle the Table <Zone>. Any help is appreciated.

Birger · June 16th, 2004, 06:40 PM

To use this you MUST add a line to 'pair' your table:

---> <Table LineNo="2"/>
      <Table LineNo="2">
         <Field Name="Desc">Cane</Field>
      </Table>

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

   <xsl:template match="/">
      <html>
         <head>
            <title></title>
            </head>
            <body>
               <xsl:apply-templates select="Page"/>
           </body>
      </html>
   </xsl:template>

   <xsl:template match="Page"><br/>
      <table border="1">
         <tr><th colspan="2">Address:</th></tr>
            <xsl:for-each select="Zone">
               <tr>
                  <td colspan="2">
                     <xsl:value-of select="Field"/>
                 </td>
              </tr>
           </xsl:for-each>
            <tr><th>Item</th><th>Desc</th></tr>
            <tr>
               <xsl:for-each select="Zone/Table[@LineNo='1']">
                  <td>
                     <xsl:value-of select="Field[@Name='Item']"/><xsl:value-of select="Field[@Name='Desc']"/>
                  </td>
               </xsl:for-each>
            </tr>
            <tr>
               <xsl:for-each select="Zone/Table[@LineNo='2']">
                  <td>
                     <xsl:value-of select="Field[@Name='Item']"/><xsl:value-of select="Field[@Name='Desc']"/>
                  </td>
               </xsl:for-each>
            </tr>
         </table>
   </xsl:template>
</xsl:stylesheet>

However, Im sure it can be done without adding the extra line. I just dont know howto yet ;)

arazok · June 16th, 2004, 08:57 PM

I can't thank you enough for your help. Today is my first day working with XSL, and your code helped me a lot. I'm finaly grasping how this works. THANK YOU!!!!

Birger · June 17th, 2004, 04:47 AM

Well, I should be happy if you're happy. Im not so happy, though. There's a table error when processing additional elements. I just can't figure out how to rearrange/change the code to have the line2 items show below each other. If you find out (if you're going further with your example) please let me know!

arazok · June 17th, 2004, 09:30 AM

You got me on the right track, and opend some doors for me. Considering I spent 6 hours trying to get to that point, I'm thrilled with what you gave me. I am also still having trouble getting line two items to show under the previous lines. I'll be spending the rest of the day trying to get that problem (and some others) licked. I'll post my code if/when I find a solution.

Ninjazx9r · June 23rd, 2004, 07:33 AM

Hi,

This may be slightly irrelevant, but it opens up a wider issue.

Looking at your source document it seems to me that the structure doesn't look very well designed/thought out.

I think a good point to start from is to consider your data and apply some relational database normalisation rules to the production of the xml itself.

This means you completely understand the data and can get the structure firmly fixed.

I am a newcomer to the whole html/xml/xslt thing so maybe this is way off line...................

Cheers.