2 XML nodes, 1 xslt

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Dimitre Novatchev

    #16
    Re: 2 XML nodes, 1 xslt

    Now for the $64000.00 question. If I can draw from two xml documents into
    my vb, export them for my XSLT to read, how do I mark them so I can tell
    the XMLT document what to read? Maybe I am going about this all wrong. I
    have only done a small amount of XML before.
    The way to pass arguments to an XSLT transformation (XslCompiledTra nsform)
    is by using the XsltArgumentLis t class.

    Read more about it in your VS2005 documentation:

    ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.NETDEVFX.v20 .en/CPref19/html/T_System_Xml_Xs l_XsltArgumentL ist.htm


    In particular, one of the allowed argument types is XPathNodeIterat or, which
    means that you can pass the two parsed xml documents as separate arguments.

    For details see also:
    ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio .v80.en/WD_XML/html/fe60aaa0-ae43-4b1c-9be1-426af66ba757.ht m

    Cheers,
    Dimitre Novatchev

    "Jeff Uchtman" <uchtman@megavi sion.comwrote in message
    news:OtGcqg9$GH A.1012@TK2MSFTN GP04.phx.gbl...
    OK, here go's: Both XML documents are as follows. I have no ability to
    do anything whit them except read them
    <?xml version="1.0" encoding="UTF-8" ?>
    + <stats>
    - <performance>
    <inbound_queue_ size>0</inbound_queue_s ize>
    <outbound_queue _size>82</outbound_queue_ size>
    <latency_second s>6</latency_seconds >
    <last_message_m inutes_ago>1</last_message_mi nutes_ago>
    <unique_recipie nts>4936</unique_recipien ts>
    <firmware_stora ge_percent_used >35</firmware_storag e_percent_used>
    <mail_storage_p ercent_used>7</mail_storage_pe rcent_used>
    <sys_fan_speed_ rpm>3668</sys_fan_speed_r pm>
    <sys_temp_celsi us>55</sys_temp_celsiu s>
    <cpu_fan_speed_ rpm>6750</cpu_fan_speed_r pm>
    <cpu_temp_celsi us>52</cpu_temp_celsiu s>
    </performance>
    - <statistics>
    - <total>
    <blocked>302090 38</blocked>
    <viruses>3542 2</viruses>
    <quarantined>16 800</quarantined>
    <tagged>1359970 </tagged>
    <allowed>161760 5</allowed>
    <total>33238835 </total>
    </total>
    - <today>
    <blocked>241322 </blocked>
    <viruses>192</viruses>
    <quarantined>15 6</quarantined>
    <tagged>8292</tagged>
    <allowed>8472 </allowed>
    <total>258434 </total>
    </today>
    - <thishour>
    <blocked>3571 </blocked>
    <viruses>4</viruses>
    <quarantined> 3</quarantined>
    <tagged>184</tagged>
    <allowed>160</allowed>
    <total>3922</total>
    </thishour>
    </statistics>
    - <hourly>
    - <hour_2300>
    <rate_control>9 2</rate_control>
    <bad_recipients >687</bad_recipients>
    <spams>9576</spams>
    <viruses>19</viruses>
    <quarantined> 5</quarantined>
    <tagged>210</tagged>
    <allowed>188</allowed>
    </hour_2300>
    - <hour_0000>
    <rate_control>0 </rate_control>
    <bad_recipients >802</bad_recipients>
    <spams>9330</spams>
    <viruses>21</viruses>
    <quarantined> 4</quarantined>
    <tagged>310</tagged>
    <allowed>235</allowed>
    </hour_0000>
    - <hour_0100>
    <rate_control>0 </rate_control>
    <bad_recipients >413</bad_recipients>
    <spams>9085</spams>
    <viruses>4</viruses>
    <quarantined> 4</quarantined>
    <tagged>163</tagged>
    <allowed>205</allowed>
    </hour_0100>
    - <hour_0200>
    <rate_control>0 </rate_control>
    <bad_recipients >530</bad_recipients>
    <spams>7571</spams>
    <viruses>6</viruses>
    <quarantined> 9</quarantined>
    <tagged>399</tagged>
    <allowed>147</allowed>
    </hour_0200>
    - <hour_0300>
    <rate_control>1 4</rate_control>
    <bad_recipients >728</bad_recipients>
    <spams>7940</spams>
    <viruses>7</viruses>
    <quarantined>10 </quarantined>
    <tagged>305</tagged>
    <allowed>143</allowed>
    </hour_0300>
    - <hour_0400>
    <rate_control>4 96</rate_control>
    <bad_recipients >546</bad_recipients>
    <spams>12580</spams>
    <viruses>7</viruses>
    <quarantined> 3</quarantined>
    <tagged>659</tagged>
    <allowed>139</allowed>
    </hour_0400>
    - <hour_0500>
    <rate_control>1 1</rate_control>
    <bad_recipients >422</bad_recipients>
    <spams>9283</spams>
    <viruses>7</viruses>
    <quarantined> 4</quarantined>
    <tagged>215</tagged>
    <allowed>179</allowed>
    </hour_0500>
    - <hour_0600>
    <rate_control>2 2</rate_control>
    <bad_recipients >590</bad_recipients>
    <spams>11974</spams>
    <viruses>11</viruses>
    <quarantined> 2</quarantined>
    <tagged>448</tagged>
    <allowed>259</allowed>
    </hour_0600>
    - <hour_0700>
    <rate_control>6 9</rate_control>
    <bad_recipients >431</bad_recipients>
    <spams>12685</spams>
    <viruses>15</viruses>
    <quarantined>11 </quarantined>
    <tagged>391</tagged>
    <allowed>375</allowed>
    </hour_0700>
    - <hour_0800>
    <rate_control>1 32</rate_control>
    <bad_recipients >446</bad_recipients>
    <spams>14084</spams>
    <viruses>8</viruses>
    <quarantined> 3</quarantined>
    <tagged>786</tagged>
    <allowed>594</allowed>
    </hour_0800>
    - <hour_0900>
    <rate_control>3 22</rate_control>
    <bad_recipients >500</bad_recipients>
    <spams>12071</spams>
    <viruses>6</viruses>
    <quarantined> 4</quarantined>
    <tagged>430</tagged>
    <allowed>617</allowed>
    </hour_0900>
    - <hour_1000>
    <rate_control>1 9</rate_control>
    <bad_recipients >406</bad_recipients>
    <spams>10288</spams>
    <viruses>16</viruses>
    <quarantined>15 </quarantined>
    <tagged>399</tagged>
    <allowed>653</allowed>
    </hour_1000>
    - <hour_1100>
    <rate_control>3 95</rate_control>
    <bad_recipients >806</bad_recipients>
    <spams>11243</spams>
    <viruses>10</viruses>
    <quarantined>14 </quarantined>
    <tagged>381</tagged>
    <allowed>592</allowed>
    </hour_1100>
    - <hour_1200>
    <rate_control>1 23</rate_control>
    <bad_recipients >433</bad_recipients>
    <spams>11472</spams>
    <viruses>13</viruses>
    <quarantined>12 </quarantined>
    <tagged>461</tagged>
    <allowed>561</allowed>
    </hour_1200>
    - <hour_1300>
    <rate_control>0 </rate_control>
    <bad_recipients >453</bad_recipients>
    <spams>11490</spams>
    <viruses>21</viruses>
    <quarantined>14 </quarantined>
    <tagged>502</tagged>
    <allowed>547</allowed>
    </hour_1300>
    - <hour_1400>
    <rate_control>0 </rate_control>
    <bad_recipients >408</bad_recipients>
    <spams>9738</spams>
    <viruses>7</viruses>
    <quarantined>12 </quarantined>
    <tagged>387</tagged>
    <allowed>535</allowed>
    </hour_1400>
    - <hour_1500>
    <rate_control>0 </rate_control>
    <bad_recipients >479</bad_recipients>
    <spams>9934</spams>
    <viruses>4</viruses>
    <quarantined> 7</quarantined>
    <tagged>321</tagged>
    <allowed>540</allowed>
    </hour_1500>
    - <hour_1600>
    <rate_control>0 </rate_control>
    <bad_recipients >392</bad_recipients>
    <spams>10477</spams>
    <viruses>3</viruses>
    <quarantined> 7</quarantined>
    <tagged>372</tagged>
    <allowed>511</allowed>
    </hour_1600>
    - <hour_1700>
    <rate_control>0 </rate_control>
    <bad_recipients >389</bad_recipients>
    <spams>10225</spams>
    <viruses>2</viruses>
    <quarantined> 6</quarantined>
    <tagged>211</tagged>
    <allowed>442</allowed>
    </hour_1700>
    - <hour_1800>
    <rate_control>4 9</rate_control>
    <bad_recipients >395</bad_recipients>
    <spams>9228</spams>
    <viruses>7</viruses>
    <quarantined> 5</quarantined>
    <tagged>358</tagged>
    <allowed>309</allowed>
    </hour_1800>
    - <hour_1900>
    <rate_control>0 </rate_control>
    <bad_recipients >350</bad_recipients>
    <spams>8911</spams>
    <viruses>4</viruses>
    <quarantined> 3</quarantined>
    <tagged>249</tagged>
    <allowed>227</allowed>
    </hour_1900>
    - <hour_2000>
    <rate_control>0 </rate_control>
    <bad_recipients >351</bad_recipients>
    <spams>8310</spams>
    <viruses>5</viruses>
    <quarantined> 2</quarantined>
    <tagged>225</tagged>
    <allowed>232</allowed>
    </hour_2000>
    - <hour_2100>
    <rate_control>0 </rate_control>
    <bad_recipients >382</bad_recipients>
    <spams>7528</spams>
    <viruses>4</viruses>
    <quarantined> 2</quarantined>
    <tagged>136</tagged>
    <allowed>270</allowed>
    </hour_2100>
    - <hour_2200>
    <rate_control>0 </rate_control>
    <bad_recipients >103</bad_recipients>
    <spams>3468</spams>
    <viruses>4</viruses>
    <quarantined> 3</quarantined>
    <tagged>184</tagged>
    <allowed>160</allowed>
    </hour_2200>
    </hourly>
    - <daily>
    - <date_1004200 6>
    <rate_control>1 268</rate_control>
    <bad_recipients >40501</bad_recipients>
    <spams>486576 </spams>
    <viruses>284</viruses>
    <quarantined>62 6</quarantined>
    <tagged>34197 </tagged>
    <allowed>1940 1</allowed>
    </date_10042006>
    - <date_1005200 6>
    <rate_control>1 2764</rate_control>
    <bad_recipients >33962</bad_recipients>
    <spams>433973 </spams>
    <viruses>285</viruses>
    <quarantined>67 4</quarantined>
    <tagged>33814 </tagged>
    <allowed>1914 3</allowed>
    </date_10052006>
    - <date_1006200 6>
    <rate_control>9 645</rate_control>
    <bad_recipients >29521</bad_recipients>
    <spams>408478 </spams>
    <viruses>252</viruses>
    <quarantined>44 0</quarantined>
    <tagged>35169 </tagged>
    <allowed>2310 2</allowed>
    </date_10062006>
    - <date_1007200 6>
    <rate_control>9 117</rate_control>
    <bad_recipients >22463</bad_recipients>
    <spams>424655 </spams>
    <viruses>373</viruses>
    <quarantined>30 1</quarantined>
    <tagged>35932 </tagged>
    <allowed>1590 1</allowed>
    </date_10072006>
    - <date_1008200 6>
    <rate_control>8 080</rate_control>
    <bad_recipients >21848</bad_recipients>
    <spams>464576 </spams>
    <viruses>386</viruses>
    <quarantined>40 7</quarantined>
    <tagged>16635 </tagged>
    <allowed>5847 </allowed>
    </date_10082006>
    - <date_1009200 6>
    <rate_control>8 635</rate_control>
    <bad_recipients >33113</bad_recipients>
    <spams>465628 </spams>
    <viruses>1092 </viruses>
    <quarantined>64 8</quarantined>
    <tagged>27355 </tagged>
    <allowed>1354 5</allowed>
    </date_10092006>
    - <date_1010200 6>
    <rate_control>3 950</rate_control>
    <bad_recipients >27200</bad_recipients>
    <spams>445595 </spams>
    <viruses>940</viruses>
    <quarantined>60 0</quarantined>
    <tagged>26585 </tagged>
    <allowed>1586 1</allowed>
    </date_10102006>
    - <date_1011200 6>
    <rate_control>1 730</rate_control>
    <bad_recipients >33202</bad_recipients>
    <spams>469967 </spams>
    <viruses>313</viruses>
    <quarantined>58 5</quarantined>
    <tagged>30686 </tagged>
    <allowed>2162 2</allowed>
    </date_10112006>
    - <date_1012200 6>
    <rate_control>5 939</rate_control>
    <bad_recipients >31092</bad_recipients>
    <spams>474337 </spams>
    <viruses>374</viruses>
    <quarantined>66 7</quarantined>
    <tagged>26457 </tagged>
    <allowed>1495 8</allowed>
    </date_10122006>
    - <date_1013200 6>
    <rate_control>7 089</rate_control>
    <bad_recipients >25936</bad_recipients>
    <spams>494163 </spams>
    <viruses>299</viruses>
    <quarantined>67 1</quarantined>
    <tagged>24412 </tagged>
    <allowed>1324 1</allowed>
    </date_10132006>
    - <date_1014200 6>
    <rate_control>7 658</rate_control>
    <bad_recipients >20821</bad_recipients>
    <spams>463208 </spams>
    <viruses>294</viruses>
    <quarantined>39 6</quarantined>
    <tagged>28683 </tagged>
    <allowed>1613 9</allowed>
    </date_10142006>
    - <date_1015200 6>
    <rate_control>8 307</rate_control>
    <bad_recipients >22277</bad_recipients>
    <spams>456403 </spams>
    <viruses>359</viruses>
    <quarantined>37 7</quarantined>
    <tagged>36869 </tagged>
    <allowed>1967 3</allowed>
    </date_10152006>
    - <date_1016200 6>
    <rate_control>4 890</rate_control>
    <bad_recipients >23535</bad_recipients>
    <spams>481393 </spams>
    <viruses>533</viruses>
    <quarantined>57 1</quarantined>
    <tagged>31594 </tagged>
    <allowed>2188 0</allowed>
    </date_10162006>
    - <date_1017200 6>
    <rate_control>9 105</rate_control>
    <bad_recipients >24827</bad_recipients>
    <spams>501449 </spams>
    <viruses>524</viruses>
    <quarantined>67 3</quarantined>
    <tagged>29484 </tagged>
    <allowed>1800 0</allowed>
    </date_10172006>
    - <date_1018200 6>
    <rate_control>4 749</rate_control>
    <bad_recipients >27466</bad_recipients>
    <spams>527561 </spams>
    <viruses>318</viruses>
    <quarantined>48 1</quarantined>
    <tagged>22691 </tagged>
    <allowed>1612 7</allowed>
    </date_10182006>
    - <date_1019200 6>
    <rate_control>3 834</rate_control>
    <bad_recipients >28646</bad_recipients>
    <spams>526190 </spams>
    <viruses>734</viruses>
    <quarantined>54 0</quarantined>
    <tagged>26021 </tagged>
    <allowed>1700 5</allowed>
    </date_10192006>
    - <date_1020200 6>
    <rate_control>2 956</rate_control>
    <bad_recipients >23183</bad_recipients>
    <spams>535327 </spams>
    <viruses>519</viruses>
    <quarantined>41 0</quarantined>
    <tagged>26625 </tagged>
    <allowed>1915 8</allowed>
    </date_10202006>
    - <date_1021200 6>
    <rate_control>4 285</rate_control>
    <bad_recipients >20526</bad_recipients>
    <spams>506429 </spams>
    <viruses>396</viruses>
    <quarantined>31 3</quarantined>
    <tagged>32226 </tagged>
    <allowed>1277 2</allowed>
    </date_10212006>
    - <date_1022200 6>
    <rate_control>1 685</rate_control>
    <bad_recipients >19917</bad_recipients>
    <spams>484741 </spams>
    <viruses>482</viruses>
    <quarantined>30 7</quarantined>
    <tagged>37800 </tagged>
    <allowed>1862 2</allowed>
    </date_10222006>
    - <date_1023200 6>
    <rate_control>4 925</rate_control>
    <bad_recipients >23379</bad_recipients>
    <spams>507168 </spams>
    <viruses>704</viruses>
    <quarantined>39 6</quarantined>
    <tagged>30744 </tagged>
    <allowed>2504 8</allowed>
    </date_10232006>
    - <date_1024200 6>
    <rate_control>3 832</rate_control>
    <bad_recipients >23410</bad_recipients>
    <spams>511776 </spams>
    <viruses>537</viruses>
    <quarantined>62 4</quarantined>
    <tagged>26644 </tagged>
    <allowed>1939 3</allowed>
    </date_10242006>
    - <date_1025200 6>
    <rate_control>7 327</rate_control>
    <bad_recipients >25599</bad_recipients>
    <spams>535249 </spams>
    <viruses>503</viruses>
    <quarantined>44 3</quarantined>
    <tagged>20746 </tagged>
    <allowed>2154 5</allowed>
    </date_10252006>
    - <date_1026200 6>
    <rate_control>4 100</rate_control>
    <bad_recipients >26054</bad_recipients>
    <spams>517442 </spams>
    <viruses>498</viruses>
    <quarantined>24 0</quarantined>
    <tagged>16238 </tagged>
    <allowed>1705 8</allowed>
    </date_10262006>
    - <date_1027200 6>
    <rate_control>1 325</rate_control>
    <bad_recipients >17309</bad_recipients>
    <spams>371235 </spams>
    <viruses>706</viruses>
    <quarantined>21 7</quarantined>
    <tagged>14776 </tagged>
    <allowed>1711 7</allowed>
    </date_10272006>
    - <date_1028200 6>
    <rate_control>2 471</rate_control>
    <bad_recipients >9717</bad_recipients>
    <spams>222386 </spams>
    <viruses>167</viruses>
    <quarantined>78 </quarantined>
    <tagged>7396</tagged>
    <allowed>5798 </allowed>
    </date_10282006>
    - <date_1029200 6>
    <rate_control>1 387</rate_control>
    <bad_recipients >10912</bad_recipients>
    <spams>232441 </spams>
    <viruses>146</viruses>
    <quarantined>82 </quarantined>
    <tagged>7287</tagged>
    <allowed>4472 </allowed>
    </date_10292006>
    - <date_1030200 6>
    <rate_control>4 097</rate_control>
    <bad_recipients >11254</bad_recipients>
    <spams>236963 </spams>
    <viruses>263</viruses>
    <quarantined>18 8</quarantined>
    <tagged>9099</tagged>
    <allowed>9861 </allowed>
    </date_10302006>
    - <date_1031200 6>
    <rate_control>5 149</rate_control>
    <bad_recipients >13728</bad_recipients>
    <spams>242786 </spams>
    <viruses>383</viruses>
    <quarantined>18 7</quarantined>
    <tagged>9611</tagged>
    <allowed>8993 </allowed>
    </date_10312006>
    - <date_1101200 6>
    <rate_control>2 119</rate_control>
    <bad_recipients >14311</bad_recipients>
    <spams>240065 </spams>
    <viruses>292</viruses>
    <quarantined>19 4</quarantined>
    <tagged>9342</tagged>
    <allowed>9715 </allowed>
    </date_11012006>
    - <date_1102200 6>
    <rate_control>1 146</rate_control>
    <bad_recipients >16011</bad_recipients>
    <spams>245873 </spams>
    <viruses>332</viruses>
    <quarantined>12 8</quarantined>
    <tagged>8898</tagged>
    <allowed>8869 </allowed>
    </date_11022006>
    - <date_1103200 6>
    <rate_control>1 652</rate_control>
    <bad_recipients >10755</bad_recipients>
    <spams>228915 </spams>
    <viruses>192</viruses>
    <quarantined>15 6</quarantined>
    <tagged>8292</tagged>
    <allowed>8472 </allowed>
    </date_11032006>
    </daily>
    </stats>
    My VB pulling is:
    Imports System
    Imports System.IO
    Imports System.Net
    Imports System.Xml
    Imports System.Xml.Xsl
    Imports System.Xml.XPat h
    >
    Partial Class _Default
    Inherits System.Web.UI.P age
    >
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As
    System.EventArg s) Handles Me.Load
    >
    Dim xslSetting As New Xsl.XsltSetting s(False, True)
    Dim xmldoc As XmlDocument = New XmlDocument()
    Dim xsldoc As XslCompiledTran sform = New Xsl.XslCompiled Transform()
    Dim outString As String = ""
    Dim cudaServer1 = "http://xxx.xxx.xxx.xxx :8000/cgi-bin/stats.cgi?"
    Dim xslServer As String = "cstats.xsl t"
    >
    >
    Dim _webRequest As WebRequest
    Dim _webResponse As WebResponse
    Dim _streamRead As StreamReader
    Dim _streamReceived As Stream
    Dim _streamEncoding As Encoding
    Dim _pageResponse As String
    >
    Try
    >
    _pageResponse = ""
    _webRequest = System.Net.WebR equest.Create(c udaServer1)
    '_webRequest.Ti meout = 500 * 1000 'Default 5 minutes
    _webResponse = _webRequest.Get Response
    _streamReceived = _webResponse.Ge tResponseStream
    _streamEncoding = System.Text.Enc oding.GetEncodi ng("utf-8")
    _streamRead = New System.IO.Strea mReader(_stream Received,
    _streamEncoding )
    _pageResponse = _streamRead.Rea dToEnd()
    >
    If _pageResponse.L ength 0 Then
    >
    outString = _pageResponse
    >
    xmldoc.LoadXml( _pageResponse)
    >
    xsldoc.Load(Ser ver.MapPath(xsl Server)) ', xslSetting, New
    XmlUrlResolver)
    Xml1.DocumentCo ntent = xmldoc.InnerXml
    Xml1.TransformS ource = Server.MapPath( xslServer)
    >
    End If
    >
    If Not _webResponse Is Nothing Then
    _webResponse.Cl ose()
    End If
    >
    Catch ex As Exception
    Throw ex
    End Try
    End Sub
    End Class
    >
    Now for the $64000.00 question. If I can draw from two xml documents into
    my vb, export them for my XSLT to read, how do I mark them so I can tell
    the XMLT document what to read? Maybe I am going about this all wrong. I
    have only done a small amount of XML before.
    >
    I have one document pulling at http://barracudastats.megavision.com XSLT
    is at http://barracudastats.megavision.com/cstats.xslt, xml is at
    http://cuda1.megavision.com:8000/cgi-bin/stats.cgi and

    >
    Any help anyone can give me would be greatly appreciated.
    >
    Jeff
    >
    >
    >
    >
    >
    >

    Comment

    Working...