On Jul 8, 7:20 am, Martin Honnen <mahotr...@yaho o.dewrote:
mike.luss...@gm ail.com wrote:
I have written some simple XSL pages to extract the data I need but
each device here has a total of 6 keys and within this 6 values a time
stamp and how long until the next data extraction ( 300 seconds ) 5
minutes.
The page starts off with WebBox
Then goes to MeanPublic
How can I extract the "<Firstdata from the 6 Keys for that device ?
My coding so far has only revealled the first key and nothing more.
It is not clear to me what you want to achieve. Do you want to simply
process all those MeanPublic elements and output the First values? Then
use a tempate for those elements e.g.
<xsl:template match="WebBox">
<table>
<thead>
<tr>
<th>Key</th>
<th>First</th>
</tr>
</thead>
<tbody>
<xsl:apply-templates select="MeanPub lic"/>
</tbody>
</table>
</xsl:template>
<xsl:template match="MeanPubl ic">
<tr>
<td><xsl:valu e-of select="Key"/></td>
<td><xsl:valu e-of select="First"/></td>
</tr>
</xsl:template>
--
Martin Honnen
http://JavaScript.FAQTs.com/
Martin,
I tried what you sent me and it is a very close replication to a
senario I tried. It gives me no outyput at all. here is the xml file I
am working with if this helps any. Yes, I am trying to extract all the
keys and all of the first lines of data from the file. Honestly I
think we are both in the right ball park its just missing something.
<?xml version="1.0" encoding="utf-8"?><!DOCTYP E WebBox []>
<?xml-stylesheet href="mean200.x sl" type="text/xsl" ?><WebBox
xmlns:msdata="u rn:schemas-microsoft-com:xml-msdata" xmlns:xsi="http ://
www.w3.org/2001/XMLSchema-instance"
xsi:noNamespace SchemaLocation= "MEAN_200.x sd">
<Info>
<Created>2007-07-05T18:45:19</Created>
<Culture>en-US</Culture>
</Info>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Error </Key>
<First>0</First>
<Last>0</Last>
<Min>0</Min>
<Max>0</Max>
<Mean>0</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Error-Cnt</Key>
<First>214</First>
<Last>214</Last>
<Min>214</Min>
<Max>214</Max>
<Mean>214</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:E-Total</Key>
<First>6574.237 04818048</First>
<Last>6574.2461 1484896</Last>
<Min>6574.23704 818048</Min>
<Max>6574.24611 484896</Max>
<Mean>6574.2410 75</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Fac</Key>
<First>59.98</First>
<Last>59.99</Last>
<Min>59.96</Min>
<Max>59.99</Max>
<Mean>59.976667 </Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:h-Total</Key>
<First>11505.82 1753799</First>
<Last>11505.903 69825</Last>
<Min>11505.8217 53799</Min>
<Max>11505.9036 9825</Max>
<Mean>11505.863 675</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Iac</Key>
<First>886</First>
<Last>1150</Last>
<Min>869</Min>
<Max>1150</Max>
<Mean>972.46666 7</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Ipv</Key>
<First>538</First>
<Last>657</Last>
<Min>524</Min>
<Max>657</Max>
<Mean>580.55</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Mode</Key>
<First>7</First>
<Last>7</Last>
<Min>7</Min>
<Max>7</Max>
<Mean>7</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Pac</Key>
<First>104</First>
<Last>135</Last>
<Min>102</Min>
<Max>135</Max>
<Mean>114.31666 7</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Power On</Key>
<First>1387</First>
<Last>1387</Last>
<Min>1387</Min>
<Max>1387</Max>
<Mean>1387</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Seria l Number</Key>
<First>15644036 41</First>
<Last>156440364 1</Last>
<Min>1564403641 </Min>
<Max>1564403641 </Max>
<Mean>156440364 1</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Vac</Key>
<First>118</First>
<Last>118</Last>
<Min>117</Min>
<Max>118</Max>
<Mean>117.98333 3</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Vpv</Key>
<First>224</First>
<Last>233</Last>
<Min>218</Min>
<Max>236</Max>
<Mean>225.96666 7</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Vpv-_PE</Key>
<First>1</First>
<Last>1</Last>
<Min>1</Min>
<Max>1</Max>
<Mean>1</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Vpv-Setpoint</Key>
<First>225</First>
<Last>234</Last>
<Min>219</Min>
<Max>236</Max>
<Mean>226.5</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR18UW4E:1 564403641:Zac</Key>
<First>0</First>
<Last>0</Last>
<Min>0</Min>
<Max>0</Max>
<Mean>0</Mean>
<Base>60</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Error </Key>
<First>0</First>
<Last>0</Last>
<Min>0</Min>
<Max>0</Max>
<Mean>0</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Error-Cnt</Key>
<First>82</First>
<Last>82</Last>
<Min>82</Min>
<Max>82</Max>
<Mean>82</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:E-Total</Key>
<First>8276.322 72193088</First>
<Last>8276.3365 8860032</Last>
<Min>8276.32272 193088</Min>
<Max>8276.33658 860032</Max>
<Mean>8276.3306 43</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Fac</Key>
<First>59.98</First>
<Last>59.98</Last>
<Min>59.96</Min>
<Max>59.99</Max>
<Mean>59.974098 </Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Fac-Srr</Key>
<First>59.98</First>
<Last>59.98</Last>
<Min>59.96</Min>
<Max>59.99</Max>
<Mean>59.974098 </Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:h-Total</Key>
<First>6825.364 1571402</First>
<Last>6825.4486 015914</Last>
<Min>6825.36415 71402</Min>
<Max>6825.44860 15914</Max>
<Mean>6825.4074 36</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Iac</Key>
<First>692</First>
<Last>848</Last>
<Min>648</Min>
<Max>848</Max>
<Mean>717.47541 </Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:I-dif</Key>
<First>97</First>
<Last>97</Last>
<Min>97</Min>
<Max>97</Max>
<Mean>97</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:I-dif-Srr</Key>
<First>78</First>
<Last>78</Last>
<Min>78</Min>
<Max>78</Max>
<Mean>78</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Ipv</Key>
<First>640</First>
<Last>801</Last>
<Min>612</Min>
<Max>801</Max>
<Mean>692.13114 8</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Max Temperature</Key>
<First>66.5</First>
<Last>66.5</Last>
<Min>66.5</Min>
<Max>66.5</Max>
<Mean>66.5</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Max Vpv</Key>
<First>515</First>
<Last>515</Last>
<Min>515</Min>
<Max>515</Max>
<Mean>515</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Mode</Key>
<First>7</First>
<Last>7</Last>
<Min>7</Min>
<Max>7</Max>
<Mean>7</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Pac</Key>
<First>166</First>
<Last>204</Last>
<Min>156</Min>
<Max>204</Max>
<Mean>172.32786 9</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Power On</Key>
<First>762</First>
<Last>762</Last>
<Min>762</Min>
<Max>762</Max>
<Mean>762</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Seria l Number</Key>
<First>13741252 80</First>
<Last>137412528 0</Last>
<Min>1374125280 </Min>
<Max>1374125280 </Max>
<Mean>137412528 0</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Tempe rature</Key>
<First>42.5</First>
<Last>41.4</Last>
<Min>41.4</Min>
<Max>42.5</Max>
<Mean>41.827869 </Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Vac</Key>
<First>241</First>
<Last>241</Last>
<Min>240</Min>
<Max>241</Max>
<Mean>240.75409 8</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Vac-Srr</Key>
<First>241</First>
<Last>241</Last>
<Min>240</Min>
<Max>241</Max>
<Mean>240.93442 6</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Vpv</Key>
<First>320</First>
<Last>301</Last>
<Min>287</Min>
<Max>320</Max>
<Mean>304.90163 9</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Vpv-_PE</Key>
<First>0</First>
<Last>0</Last>
<Min>0</Min>
<Max>0</Max>
<Mean>0</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Vpv-Setpoint</Key>
<First>321</First>
<Last>302</Last>
<Min>288</Min>
<Max>321</Max>
<Mean>305.52459 </Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
<MeanPublic>
<Key>WR25UW8E:1 374125280:Zac</Key>
<First>0</First>
<Last>0</Last>
<Min>0</Min>
<Max>0</Max>
<Mean>0</Mean>
<Base>61</Base>
<Period>300</Period>
<TimeStamp>20 07-07-05T18:45:18</TimeStamp>
</MeanPublic>
</WebBox>