Need help on xsl and xpath

emeakashah

Hi all,
I'm having problem with my xsl project.I want to display all the xml data in a table using xsl.
My problem is why all my table display the same data(only the first data displayed and being repeated in other table).it seems that the program does not iterate even if i'm using for each.Can somebody help me????
XML file contains:

<tpeg_document generation_time="2006-11-28T02:44:56+0" >
<tpeg_message >
<originator country="UK" originator_name="BBC Travel News" />
<summary lang="en" > A8014 West Dunbartonshire - Traffic light failure on Kilbowie Road both ways at the A82 Great Western Road junction.
</summary>
.....
.....
.....

</tpeg_message>
<tpeg_message>.........</tpeg_message>

My XSL file:

<xsl:template match="tpeg_document" >
<xsl:apply-templates />
</xsl:template>
<xsl:template match="tpeg_message" >
<table border="1">
<xsl:for-each select="." >
<th colspan="2">Traffic Incidents</th>
<tr>
<td><b>Time of Incidents</b></td>
<td><xsl:value-of select="//@message_generation_time" /></td>
</tr>
<tr>
<td><b>Severity Factor</b></td>
<td><xsl:value-of select="//@severity_factor" /></td>
</tr>
<tr>
<td><b>Latitude</b></td>
<td><xsl:value-of select="//@latitude" /></td>
</tr>
<tr>
<td><b>Longitude</b></td>
<td><xsl:value-of select="//@longitude" /></td>
</tr>
<tr>
<td><b>Summary</b></td>
<td><xsl:value-of select="//summary" /></td></tr>
</xsl:for-each>
</table>
</xsl:template>

snow

The problem is the '//'s you are using before every selection. They select the first matching thing in the document that they come accross, which is why you're getting the first values repeated.

You need to define your xpath specifically for where you are in the document. Most of them shouldn't need the '//'s at all.


Post more on the problem if you're having trouble getting the XPath values.

Snow

P.S. I'm not really seeing the point in the 'originator' node, it seems to be just attributes - unless you allow values in some circumstances? If not I'd add it's attributes to the 'tpeg_message' attributes as it would be a lot cleaner. Just an idea...

emeakashah

Snow,thanks for your suggestion.I try to remove the "//" but it did not work out.The data is not diplayed at all.I'm new to XSL.This is my first project using XSL.Thanks..Hope you can help !!!

snow

Could you post up your DTD?

emeakashah

i am given only the xml file.i need to create xsl to display the xml data.is it possible to work out without the dtd file?

snow

Oh, before you think XPath stuff, then the XSLT needs sorted as you're using apply-template & a for-each; which I'm pretty sure will not work together in this context - you're drilling in a level too deep.

I'd advice you to take out the 'for-each' and stick with the apply-template.

Snow

emeakashah

thanks snow..i have remove the for each and i put <td><xsl:value-of select="./summary" /></td>..it show me all the different data in each table.the problem now is all the attributes do not display.I put it in the same format..<td><xsl:value-of select="./@latitude" /></td> but it didnt work..thanks

snow

could I see how your DTD and XSLT look now please?

emeakashah

XML file contains:

<tpeg_document generation_time="2006-11-28T02:44:56+0" >
<tpeg_message >
<originator country="UK" originator_name="BBC Travel News" />
<summary lang="en" > A8014 West Dunbartonshire - Traffic light failure on Kilbowie Road both ways at the A82 Great Western Road junction.
</summary>
.....
.....
.....

</tpeg_message>
<tpeg_message>.........</tpeg_message>

My XSL file:

<xsl:template match="tpeg_document" >
<xsl:apply-templates />
</xsl:template>
<xsl:template match="tpeg_message" >
<table border="1">

<th colspan="2">Traffic Incidents</th>
<tr>
<td><b>Time of Incidents</b></td>
<td><xsl:value-of select="./@message_generation_time" /></td>
</tr>
<tr>
<td><b>Severity Factor</b></td>
<td><xsl:value-of select="./@severity_factor" /></td>
</tr>
<tr>
<td><b>Latitude</b></td>
<td><xsl:value-of select="./@latitude" /></td>
</tr>
<tr>
<td><b>Longitude</b></td>
<td><xsl:value-of select="./@longitude" /></td>
</tr>
<tr>
<td><b>Summary</b></td>
<td><xsl:value-of select="./summary" /></td></tr>
</table>
</xsl:template>

snow

Oh, sorry, didn't see your post above...

Where in your XML do you enter values for those attributes you're trying to recover? Have you skipped some of the XML document on here?

emeakashah

<tpeg_document generation_time="2006-11-28T02:44:56+0" >
<tpeg_message >
<originator country="UK" originator_name="BBC Travel News" />
<summary lang="en" > A8014 West Dunbartonshire - Traffic light failure on Kilbowie Road both ways at the A82 Great Western Road junction.
</summary>
<road_traffic_message message_id="1333854" message_generation_time="2006-11-28T02:34:30+0" version_number="2" start_time="2006-11-28T02:04:28+0" stop_time="2006-11-28T03:34:30+0" severity_factor="severe" >
<facilities_performance >
<traffic_control traffic_control_type="traffic lights" traffic_control_status="not working" >
<position position="all driving lanes" />
</traffic_control>
</facilities_performance>
<location_container language="English" >
<location_coordinates location_type="route" >
<WGS84 latitude="55.91857" longitude="-4.405708" />
<location_descriptor descriptor_type="road number" descriptor="A8014;Kilbowie Road" />
<location_descriptor descriptor_type="town name" descriptor="West Dunbartonshire" />
<location_descriptor descriptor_type="Junction with" descriptor="A82;Great Western Road" />
<location_descriptor descriptor_type="and " descriptor="B814;Duntocher Road" />
<direction direction_type="both ways" />
</location_coordinates>
</location_container>
</road_traffic_message>
</tpeg_message>
<tpeg_message >

I only post one section of tpeg_message

snow

does plain:
<td><xsl:value-of select="@latitude" /></td>

not work?

emeakashah

ok snow...now it works...thanks for your help..thanks a lot

snow

No problem! Glad it's sorted