Trouble excluding select xml out to HTML using xsl

Discussion in 'XML' started by kmunderwood@charter.net, Mar 17, 2005.

  1. Guest

    I am having trouble excluding select xml out to HTML using xsl

    I want to ignore some xml and turn others red

    I can not find the right way to both:

    1. Only show the <tag> that want to, and
    2. Turn an attribute a color when it falls below a certain level.


    This is the way I want the html to display:

    Tank Level Temperature
    B05 535.91 22.22

    But, the way it pulls in all "Tag"
    It looks like:

    Tank Level Temperature
    B05 535.91 22.22
    _4..20mA-2 -0.01 <no data>

    I want to ignore the _4..20mA-2, among others.
    When the tank level falls below 600, I want the background or text to
    turn red.



    This is the way I get the xml.
    (its abreviated. It is very long and shows 17 "Tag", or devices, but I
    only
    want to show 12 of them)

    <?xml version="1.0" encoding="iso-8859-1" ?>
    <fieldgate ser="6C000D010A0" tag="TTL Bulk Storage Farm" type="full"
    devices="all">
    <timezone>0</timezone>
    <os_version>3.18</os_version>
    <conf>FXA520-AA1A</conf>
    <device id="11183312ee" tag="B05" type="HART">
    <u4>°C</u4>
    <v4>22.22</v4>
    <dev>Cerabar S</dev>
    <man>Endress+Hauser</man>
    <u1>lb</u1>
    <v1>535.91</v1>
    <type>HART</type>
    <unid>11183312ee</unid>
    </device>
    <device id="_4..20mA-2" tag="_4..20mA-2" type="INTRN">
    <u>mA</u>
    <tag>_4..20mA-2</tag>
    <hlsts1>OK</hlsts1>
    <v1>-0.01</v1>
    <man>Endress+Hauser</man>
    <unid>_4..20mA-2</unid>
    </device>
    </fieldgate>




    This is the xsl:

    <?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>
    <h2>Bulk Storage Tanks</h2>
    <table border="1">
    <tr bgcolor="#9acd32">
    <th>Tank</th>
    <th>Level</th>
    <th>Temperature</th>
    </tr>
    <xsl:for-each select="fieldgate/device">
    <tr>
    <td><xsl:value-of select="tag"/></td>
    <xsl:choose>
    <xsl:when test="v1 &lt; 600">
    <td bgcolor="#ff00ff">
    <xsl:value-of select="v1"/></td>
    </xsl:when>
    <xsl:eek:therwise>
    <td><xsl:value-of select="v1"/></td>
    </xsl:eek:therwise>
    </xsl:choose>
    <td><xsl:value-of select="v4"/></td>
    </tr>
    </xsl:for-each>
    </table>
    </body>
    </html>
    </xsl:template></xsl:stylesheet>

    This works fine, but includes all "tag", and I want to ignore some.


    Tank Level Temperature
    B05 535.91 22.22
    B04 42567.36 22.81
    _4..20mA-2 -0.01 Blank


    The 535.91 background turns red, which is what I am looking for, but I
    want to ignore <tag> _4..20mA-2

    I had success displaying only the ones I wanted, using an "if match".
    <xsl:if match=".[tag='B05']">, but I cant "test" on it.


    This is the HTML:

    <html>

    <head>
    <style type="text/css">
    th, td { font-size: 200%; }
    </style>
    </head>

    <body>

    <script language="javascript">
    // Load XML
    var xml = new ActiveXObject("Microsoft.XMLDOM")
    xml.async = false
    xml.load("index.xml")

    // Load the XSL
    var xsl = new ActiveXObject("Microsoft.XMLDOM")
    xsl.async = false
    xsl.load("index.xsl")

    // Transform
    document.write(xml.transformNode(xsl))
    </script>

    </body>
    </html>

    Can anyone give me an idea on how to do this, I am stuck, and a newbie
    at xml/xsl

    Thank You, Ken
     
    , Mar 17, 2005
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Eric Weiss
    Replies:
    1
    Views:
    1,070
    Eric Weiss
    Jul 6, 2003
  2. Terry Chilvers
    Replies:
    1
    Views:
    587
    Mats Kindahl
    Sep 1, 2003
  3. 5tein
    Replies:
    1
    Views:
    475
    Patrick TJ McPhee
    Apr 30, 2004
  4. Replies:
    1
    Views:
    3,636
    A. Bolmarcich
    May 27, 2005
  5. Replies:
    1
    Views:
    1,162
    Martin Honnen
    Feb 6, 2009
Loading...

Share This Page