how to parse xml data ?

[Malosa]

Got it , SOLVED



Hello all,

i don;t know where to start at all..
i did found a lot of scripts for parsing the xml data but i can't get it to work..

here is the url where the data is coming from and how its formatted.

the url is http://192.168.x.x/core/modules

<modules><module id="cccd9a140dxxxx599e066afca56"><vendor_name>Ene5\XS21 0ESMR5.0</vendor_name><vendor_model>Ene5\XSxxxSMR5.0</vendor_model><hardware_version/><firmware_version/><created_date>2019-02-21T16:22:43.123+01:00</created_date><modified_date>2019-04-07T12:28:00.275+02:00</modified_date><deleted_date/><services><electricity_interval_meter id="bd521e53xxx9a662023c5"><measurement log_date="2019-04-07T12:00:00+02:00" unit="Wh" interval="PT300S" directionality="produced" tariff_indicator="nl_offpeak">956.000</measurement><measurement log_date="2019-04-07T12:00:00+02:00" unit="Wh" interval="PT300S" directionality="produced" tariff_indicator="nl_peak">0.000</measurement><measurement log_date="2019-04-07T12:00:00+02:00" unit="Wh" interval="PT300S" directionality="consumed" tariff_indicator="nl_offpeak">0.000</measurement><measurement log_date="2019-04-07T12:00:00+02:00" unit="Wh" interval="PT300S" directionality="consumed" tariff_indicator="nl_peak">0.000</measurement></electricity_interval_meter><electricity_cumulative_meter id="317687xxxx9xx838cba3c92c9"><measurement log_date="2019-04-07T12:25:00+02:00" unit="Wh" directionality="produced" tariff_indicator="nl_offpeak">92572.000</measurement><measurement log_date="2019-04-07T12:25:00+02:00" unit="Wh" directionality="produced" tariff_indicator="nl_peak">186981.000</measurement><measurement log_date="2019-04-07T12:25:00+02:00" unit="Wh" directionality="consumed" tariff_indicator="nl_offpeak">131788.000</measurement><measurement log_date="2019-04-07T12:25:00+02:00" unit="Wh" directionality="consumed" tariff_indicator="nl_peak">96659.000</measurement></electricity_cumulative_meter><electricity_point_meter id="064fd82e2xxxx90c0f26e2c75104"><measurement log_date="2019-04-07T12:27:53+02:00" unit="W" directionality="produced">2422.000</measurement><measurement log_date="2019-04-07T12:27:53+02:00" unit="W" directionality="consumed">0.000</measurement></electricity_point_meter></services><protocols><dsmrmain id="516833c0bb2840bdxxxxx59d8365295b3"><serial>E0047xxxxx47 4 22 718</serial><dsmrmbuses>
</dsmrmbuses></dsmrmain></protocols></module></modules>


this is what i need, only the value's ofcourse.:
like to return in hs.writelog.

"nl_offpeak">956.000</measurement>
nl_peak">0.000</measurement>
"nl_offpeak">0.000</measurement>
nl_peak">0.000</measurement>
tariff_indicator="nl_offpeak">92572.000<
tariff_indicator="nl_peak">186981.000<
tariff_indicator="nl_offpeak">131788.000
tariff_indicator="nl_peak">96659.000
directionality="produced">2422.000<
directionality="consumed">0.000


right now i have this code ;

Sub Main(ByVal Parms As String)
Dim xmlDoc As New XmlDocument()
Dim strdata as String
Dim PageXML as String
Dim XML_Feed as integer = 1
Dim url = "http://usernm:pass@192.168.1.13"
Dim page = hs.GetURL(url,"/core/modules",FALSE,80)
hs.WriteLog ("test", page)

End Sub

and returns like this :

Apr-07 12:55:51           Test     Ene5\XS210ESMR5.0 Ene5\XS210ESMR5.0 2019-02-21T16:22:43.123+01:00 2019-04-07T12:55:51.824+02:00 1967.000 0.000 0.000 0.000 93583.000 186981.000 131788.000 96659.000 2495.000 0.000 E0047000047422718

If someone can show me how i can parse this ?
with json its easy but with xml i never done that




regards.

[jon00]

As you have Datascraper installed, why not use that?

[Malosa]

As you have Datascraper installed, why not use that?

hi jon,

i would love t use that.. but it doesnt work at all..
it does not even scrape nothing and i don't know why ...
i did test for a long time.

getting this error for example:
Apr-07 13:26:46 Jon00_DataScrape Cannot obtain data from path: http://smile:*******@192.168.1.13/core/modules
Apr-07 13:26:46 Error Exception in GetURLIE getting retrieved web page's content: Public member 'InnerHTML' on type 'DBNull' not found.


i did test it out with this code just to check if there is indeed a issue :

ECHO
cd C:\Program Files (x86)\GnuWin32\bin
ECHO
wget "http://smile:****@192.168.1.13:80/core/modules" -O C:/PROGRA~2/"HomeSeer HS3"/Data/test55.txt
ECHO

but it gets the full page xmldata correctly like it should.


regards

[jon00]

Do you have to use GetURLIE? (Set UseIE=0)

[Malosa]

Do you have to use GetURLIE? (Set UseIE=0)

yes, nothing shows up in the log when i do that aswell, and no data file created

[jon00]

So is it actually a https site (redirected from http)?

[Malosa]

hi jon,

its normal http, i really dont know why it doesnt work with the data scraper.

but i got the script going.

i really need to see why the scraper doesnt work