Jon00 DataScraper/JSON Parser Script For Homeseer 3 and Homeseer 4

[Freddan101]

Difficult to assist without looking at the actual web data.

In the ini file, set Textfile=1 and then run the script. In your Homeseer HS3\Data\Jon00\datascraper, please send me the grabX.txt file where X is the grab number you have used.

Thank you. File sent.

[jon00]

This was resolved with the following pattern:

Pattern1=(?s)elspot-content">(.*?) .*?kWh

[Freddan101]

Thanks a lot, Jon. Great support as always.

[Martin75a]

Read out electricity consumption?

Hi,

I Have an EMC that reads the electricity consumption and now I want to read the fourth value from this page (http://192.168.1.135:81/emcData.xml) and set it as a status on a virtual device. I also want to remove all the zeros in the beginning if possible?.
The page looks like this

<emcData>
<emcRecord>
2017-08-27 11:20:27 0006802072 00001396 000252 000101 000003 000003
</emcRecord>
</emcData>

The value I want is 1396 And that's the watt consumption in real time.
Is this possible with Jon00 DataScraper Script?

Best Regards
Martin

[jon00]

Try it with the following pattern:

Pattern1=(?s)<emcRecord>.*? .*? .*? 0000(.*?) .*?< 

[Martin75a]

Try it with the following pattern:

Pattern1=(?s)<emcRecord>.*? .*? .*? 0000(.*?) .*?< 

Excellent, Works great!!
Thank you so much for your help and script Jon. Much appreciated.

best regards
Martin

[SilentWolf]

Where To Download?

Where can I download this script? I keep seeing everyone asking for config help and saying what a great script this is but I do not see a download link

I am trying to pull the Air Quality Index from the below webpage:
https://airnow.gov/index.cfm?action=...0007&submit=Go

[randy]

Where can I download this script? I keep seeing everyone asking for config help and saying what a great script this is but I do not see a download link

I am trying to pull the Air Quality Index from the below webpage:
https://airnow.gov/index.cfm?action=...0007&submit=Go

Click on Jon00's signature in the first post of this thread. It will take you to his website. You can download the scripts and make a donation if you feel they are helpful.

[jon00]

Where can I download this script? I keep seeing everyone asking for config help and saying what a great script this is but I do not see a download link

I am trying to pull the Air Quality Index from the below webpage:
https://airnow.gov/index.cfm?action=...0007&submit=Go

Try this pattern:

Pattern1=(?s)TblInvisible.*?"middle">(.*?)</td>

[SilentWolf]

Try this pattern:

Pattern1=(?s)TblInvisible.*?"middle">(.*?)</td>

Jon,

It worked first try! Thank You!!!!!!!!!

[SilentWolf]

Jon,

It appears what we were filtering on changed...

<td class="AQDataSectionTitle">
Air Quality Index (AQI)<br>
<small>observed at 12:00 MDT</small>
</td>
</tr>
<tr>
<td align="center">
<table class="TblInvisible" cellpadding="0" cellspacing="0"><tr><td>
<table class="TblInvisible" cellpadding="0" cellspacing="0" width="50">
<tr style="color:black;text-align:center;font-weight:200">
<td background="/images/aqi_mod_lg.gif" style="text-align:center" height="38" width="50" >
75
</td>
</tr>
</table></td>
<td class="AQDataLg">Moderate</td>
</tr></table>

</td>
</tr>



Is it possible to look for "AQDataLg" and grab that 75 number above it? I have not found another unique identifier that wouldn't change.

[OliP]

Hi All,
Jon - Thanks for another great plugin.

Im trying to extract the "in house temp"22.3 into homeseer, but im getting no where with regex.

Can anyone shed some light?

{"user mode":"clock","clock program":"auto","in house status":"ok","in house temp":22.3,"hot water active":true,"boiler indicator":"off","control":"weather","temp override duration":0,"current switchpoint":32,"ps active":false,"powersave mode":false,"fp active":false,"fireplace mode":false,"temp override":false,"holiday mode":false,"boiler block":null,"boiler lock":null,"boiler maintenance":null,"temp setpoint":20,"temp override temp setpoint":22,"temp manual setpoint":24,"hed enabled":null,"hed device at home":null,"outdoor temp":13,"outdoor source type":"virtual"}

[jon00]

Jon,

It appears what we were filtering on changed...

<td class="AQDataSectionTitle">
Air Quality Index (AQI)<br>
<small>observed at 12:00 MDT</small>
</td>
</tr>
<tr>
<td align="center">
<table class="TblInvisible" cellpadding="0" cellspacing="0"><tr><td>
<table class="TblInvisible" cellpadding="0" cellspacing="0" width="50">
<tr style="color:black;text-align:center;font-weight:200">
<td background="/images/aqi_mod_lg.gif" style="text-align:center" height="38" width="50" >
75
</td>
</tr>
</table></td>
<td class="AQDataLg">Moderate</td>
</tr></table>

</td>
</tr>



Is it possible to look for "AQDataLg" and grab that 75 number above it? I have not found another unique identifier that wouldn't change.

Try this pattern:

Pattern1=(?s)TblInvisible.*?td background.*?>(.*?)</td>

[jon00]

Hi All,
Jon - Thanks for another great plugin.

Im trying to extract the "in house temp"22.3 into homeseer, but im getting no where with regex.

Can anyone shed some light?

{"user mode":"clock","clock program":"auto","in house status":"ok","in house temp":22.3,"hot water active":true,"boiler indicator":"off","control":"weather","temp override duration":0,"current switchpoint":32,"ps active":false,"powersave mode":false,"fp active":false,"fireplace mode":false,"temp override":false,"holiday mode":false,"boiler block":null,"boiler lock":null,"boiler maintenance":null,"temp setpoint":20,"temp override temp setpoint":22,"temp manual setpoint":24,"hed enabled":null,"hed device at home":null,"outdoor temp":13,"outdoor source type":"virtual"}

Try this:

Pattern1=(?s)"in house temp":(.*?),"hot water active"

[OliP]

Awesome, many thanks!