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_size>
<outbound_queue_size>82</outbound_queue_size>
<latency_seconds>6</latency_seconds>
<last_message_minutes_ago>1</last_message_minutes_ago>
<unique_recipients>4936</unique_recipients>
<firmware_storage_percent_used>35</firmware_storage_percent_used>
<mail_storage_percent_used>7</mail_storage_percent_used>
<sys_fan_speed_rpm>3668</sys_fan_speed_rpm>
<sys_temp_celsius>55</sys_temp_celsius>
<cpu_fan_speed_rpm>6750</cpu_fan_speed_rpm>
<cpu_temp_celsius>52</cpu_temp_celsius>
</performance>
- <statistics>
- <total>
<blocked>30209038</blocked>
<viruses>35422</viruses>
<quarantined>16800</quarantined>
<tagged>1359970</tagged>
<allowed>1617605</allowed>
<total>33238835</total>
</total>
- <today>
<blocked>241322</blocked>
<viruses>192</viruses>
<quarantined>156</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>92</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>14</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>496</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>11</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>22</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>69</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>132</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>322</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>19</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>395</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>123</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>49</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_10042006>
<rate_control>1268</rate_control>
<bad_recipients>40501</bad_recipients>
<spams>486576</spams>
<viruses>284</viruses>
<quarantined>626</quarantined>
<tagged>34197</tagged>
<allowed>19401</allowed>
</date_10042006>
- <date_10052006>
<rate_control>12764</rate_control>
<bad_recipients>33962</bad_recipients>
<spams>433973</spams>
<viruses>285</viruses>
<quarantined>674</quarantined>
<tagged>33814</tagged>
<allowed>19143</allowed>
</date_10052006>
- <date_10062006>
<rate_control>9645</rate_control>
<bad_recipients>29521</bad_recipients>
<spams>408478</spams>
<viruses>252</viruses>
<quarantined>440</quarantined>
<tagged>35169</tagged>
<allowed>23102</allowed>
</date_10062006>
- <date_10072006>
<rate_control>9117</rate_control>
<bad_recipients>22463</bad_recipients>
<spams>424655</spams>
<viruses>373</viruses>
<quarantined>301</quarantined>
<tagged>35932</tagged>
<allowed>15901</allowed>
</date_10072006>
- <date_10082006>
<rate_control>8080</rate_control>
<bad_recipients>21848</bad_recipients>
<spams>464576</spams>
<viruses>386</viruses>
<quarantined>407</quarantined>
<tagged>16635</tagged>
<allowed>5847</allowed>
</date_10082006>
- <date_10092006>
<rate_control>8635</rate_control>
<bad_recipients>33113</bad_recipients>
<spams>465628</spams>
<viruses>1092</viruses>
<quarantined>648</quarantined>
<tagged>27355</tagged>
<allowed>13545</allowed>
</date_10092006>
- <date_10102006>
<rate_control>3950</rate_control>
<bad_recipients>27200</bad_recipients>
<spams>445595</spams>
<viruses>940</viruses>
<quarantined>600</quarantined>
<tagged>26585</tagged>
<allowed>15861</allowed>
</date_10102006>
- <date_10112006>
<rate_control>1730</rate_control>
<bad_recipients>33202</bad_recipients>
<spams>469967</spams>
<viruses>313</viruses>
<quarantined>585</quarantined>
<tagged>30686</tagged>
<allowed>21622</allowed>
</date_10112006>
- <date_10122006>
<rate_control>5939</rate_control>
<bad_recipients>31092</bad_recipients>
<spams>474337</spams>
<viruses>374</viruses>
<quarantined>667</quarantined>
<tagged>26457</tagged>
<allowed>14958</allowed>
</date_10122006>
- <date_10132006>
<rate_control>7089</rate_control>
<bad_recipients>25936</bad_recipients>
<spams>494163</spams>
<viruses>299</viruses>
<quarantined>671</quarantined>
<tagged>24412</tagged>
<allowed>13241</allowed>
</date_10132006>
- <date_10142006>
<rate_control>7658</rate_control>
<bad_recipients>20821</bad_recipients>
<spams>463208</spams>
<viruses>294</viruses>
<quarantined>396</quarantined>
<tagged>28683</tagged>
<allowed>16139</allowed>
</date_10142006>
- <date_10152006>
<rate_control>8307</rate_control>
<bad_recipients>22277</bad_recipients>
<spams>456403</spams>
<viruses>359</viruses>
<quarantined>377</quarantined>
<tagged>36869</tagged>
<allowed>19673</allowed>
</date_10152006>
- <date_10162006>
<rate_control>4890</rate_control>
<bad_recipients>23535</bad_recipients>
<spams>481393</spams>
<viruses>533</viruses>
<quarantined>571</quarantined>
<tagged>31594</tagged>
<allowed>21880</allowed>
</date_10162006>
- <date_10172006>
<rate_control>9105</rate_control>
<bad_recipients>24827</bad_recipients>
<spams>501449</spams>
<viruses>524</viruses>
<quarantined>673</quarantined>
<tagged>29484</tagged>
<allowed>18000</allowed>
</date_10172006>
- <date_10182006>
<rate_control>4749</rate_control>
<bad_recipients>27466</bad_recipients>
<spams>527561</spams>
<viruses>318</viruses>
<quarantined>481</quarantined>
<tagged>22691</tagged>
<allowed>16127</allowed>
</date_10182006>
- <date_10192006>
<rate_control>3834</rate_control>
<bad_recipients>28646</bad_recipients>
<spams>526190</spams>
<viruses>734</viruses>
<quarantined>540</quarantined>
<tagged>26021</tagged>
<allowed>17005</allowed>
</date_10192006>
- <date_10202006>
<rate_control>2956</rate_control>
<bad_recipients>23183</bad_recipients>
<spams>535327</spams>
<viruses>519</viruses>
<quarantined>410</quarantined>
<tagged>26625</tagged>
<allowed>19158</allowed>
</date_10202006>
- <date_10212006>
<rate_control>4285</rate_control>
<bad_recipients>20526</bad_recipients>
<spams>506429</spams>
<viruses>396</viruses>
<quarantined>313</quarantined>
<tagged>32226</tagged>
<allowed>12772</allowed>
</date_10212006>
- <date_10222006>
<rate_control>1685</rate_control>
<bad_recipients>19917</bad_recipients>
<spams>484741</spams>
<viruses>482</viruses>
<quarantined>307</quarantined>
<tagged>37800</tagged>
<allowed>18622</allowed>
</date_10222006>
- <date_10232006>
<rate_control>4925</rate_control>
<bad_recipients>23379</bad_recipients>
<spams>507168</spams>
<viruses>704</viruses>
<quarantined>396</quarantined>
<tagged>30744</tagged>
<allowed>25048</allowed>
</date_10232006>
- <date_10242006>
<rate_control>3832</rate_control>
<bad_recipients>23410</bad_recipients>
<spams>511776</spams>
<viruses>537</viruses>
<quarantined>624</quarantined>
<tagged>26644</tagged>
<allowed>19393</allowed>
</date_10242006>
- <date_10252006>
<rate_control>7327</rate_control>
<bad_recipients>25599</bad_recipients>
<spams>535249</spams>
<viruses>503</viruses>
<quarantined>443</quarantined>
<tagged>20746</tagged>
<allowed>21545</allowed>
</date_10252006>
- <date_10262006>
<rate_control>4100</rate_control>
<bad_recipients>26054</bad_recipients>
<spams>517442</spams>
<viruses>498</viruses>
<quarantined>240</quarantined>
<tagged>16238</tagged>
<allowed>17058</allowed>
</date_10262006>
- <date_10272006>
<rate_control>1325</rate_control>
<bad_recipients>17309</bad_recipients>
<spams>371235</spams>
<viruses>706</viruses>
<quarantined>217</quarantined>
<tagged>14776</tagged>
<allowed>17117</allowed>
</date_10272006>
- <date_10282006>
<rate_control>2471</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_10292006>
<rate_control>1387</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_10302006>
<rate_control>4097</rate_control>
<bad_recipients>11254</bad_recipients>
<spams>236963</spams>
<viruses>263</viruses>
<quarantined>188</quarantined>
<tagged>9099</tagged>
<allowed>9861</allowed>
</date_10302006>
- <date_10312006>
<rate_control>5149</rate_control>
<bad_recipients>13728</bad_recipients>
<spams>242786</spams>
<viruses>383</viruses>
<quarantined>187</quarantined>
<tagged>9611</tagged>
<allowed>8993</allowed>
</date_10312006>
- <date_11012006>
<rate_control>2119</rate_control>
<bad_recipients>14311</bad_recipients>
<spams>240065</spams>
<viruses>292</viruses>
<quarantined>194</quarantined>
<tagged>9342</tagged>
<allowed>9715</allowed>
</date_11012006>
- <date_11022006>
<rate_control>1146</rate_control>
<bad_recipients>16011</bad_recipients>
<spams>245873</spams>
<viruses>332</viruses>
<quarantined>128</quarantined>
<tagged>8898</tagged>
<allowed>8869</allowed>
</date_11022006>
- <date_11032006>
<rate_control>1652</rate_control>
<bad_recipients>10755</bad_recipients>
<spams>228915</spams>
<viruses>192</viruses>
<quarantined>156</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.XPath
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As
System.EventArgs) Handles Me.Load
Dim xslSetting As New Xsl.XsltSettings(False, True)
Dim xmldoc As XmlDocument = New XmlDocument()
Dim xsldoc As XslCompiledTransform = New Xsl.XslCompiledTransform()
Dim outString As String = ""
Dim cudaServer1 = "http://xxx.xxx.xxx.xxx:8000/cgi-bin/stats.cgi?"
Dim xslServer As String = "cstats.xslt"
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.WebRequest.Create(cudaServer1)
'_webRequest.Timeout = 500 * 1000 'Default 5 minutes
_webResponse = _webRequest.GetResponse
_streamReceived = _webResponse.GetResponseStream
_streamEncoding = System.Text.Encoding.GetEncoding("utf-8")
_streamRead = New System.IO.StreamReader(_streamReceived,
_streamEncoding)
_pageResponse = _streamRead.ReadToEnd()
If _pageResponse.Length 0 Then
outString = _pageResponse
xmldoc.LoadXml(_pageResponse)
xsldoc.Load(Server.MapPath(xslServer)) ', xslSetting, New
XmlUrlResolver)
Xml1.DocumentContent = xmldoc.InnerXml
Xml1.TransformSource = Server.MapPath(xslServer)
End If
If Not _webResponse Is Nothing Then
_webResponse.Close()
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
http://cuda2.megavision.com:8000/cgi-bin/stats.cgi
Any help anyone can give me would be greatly appreciated.
Jeff