Read data from Smart Meter using P1 USB cable

---

@incmve said:

my brain hurts …

mine also! too much pimatic today

Also the rounding is adding 5 Watt so if you have that every day it wont be accurate anymore

i would say that’s tolerance

but the issue with roundings and units and so on has already been discussed here pimatic/pimatic#387

@leader21 said:

sorry!! there’ a typo!!

change the capital C to a small c in current if you’re using my chosen variables …

Is it always so accurate with capitals and stuff?

yes it is!
does it work now?

@leader21 Yes now it works like a charm!

Great job! Thank you VERY much

you’re welcome!
have fun with pimatic

@leader21 said:

@incmve said:

my brain hurts …

mine also! too much pimatic today

Also the rounding is adding 5 Watt so if you have that every day it wont be accurate anymore

i would say that’s tolerance

but the issue with roundings and units and so on has already been discussed here

I know that topic, but thats about kWh and rounding I am referring to a piece of code that might fix the W issue.
atm the code is

num = Math.round(value * 1e2) / 1e2

This will show 0.615W in GUI as 0.7W
Changing the code to

num = Math.round(value * 1e2) * 1e1

This will show 0.615W in GUI as 700W

I tried to change it but I suck at Coffeescript

Hi all,

I also like to read data of my Smart Meter, not via an USB cable, but via a meter of Enelogic which is connected to P1. This meter is connected to my LAN.
Via my <ipadres>:1000/cgi/electricityMeter/update I get the following xml-format;

<update>
<detected>true</detected>
<reading id=“e_consumed_1” unit=“kWh”>583.782000</reading>
<reading id=“e_consumed_2” unit=“kWh”>668.518000</reading>
<reading id=“e_produced_1” unit=“kWh”>274.548000</reading>
<reading id=“e_produced_2” unit=“kWh”>622.283000</reading>
<reading id=“p_consumed” unit=“kW”>0.251000</reading>
<reading id=“p_produced” unit=“kW”>0.000000</reading>
<text id=“e_switch”>out</text>
</update>

Is it also possible to read out the (xml)-values using the log reader plugin?
For my understanding, the log reader plugin reads a log/db file (SQLite) which is created. So, the question is how to get the xml-data into a db-file. Can I use also sbfspot for this? Or is this to difficult and is a solution with Curl and store a file local better solution? Any experience?

sbfspot is only for SMA solar inverters. This won’t help you much unless you are having one. Then you need to have the inverter connected to the ethernet or bluetooth. And then you are only having the data from your solar inverter and not of any other energy meters at all.

what if you create a cron job e.g. every 10 minutes with the command curl http://<ipadres>:1000/cgi/electricityMeter/update > /home/meter.log
or
curl http://<ipadres>:1000/cgi/electricityMeter/update -o "/home/pi/meter.log"

then parse meters.log with a logreader device.
don’t know if this would work but i hope this will point into the right direction.

@leader21 said:

sbfspot is only for SMA solar inverters. This won’t help you much unless you are having one. Then you need to have the inverter connected to the ethernet or bluetooth. And then you are only having the data from your solar inverter and not of any other energy meters at all.

what if you create a cron job e.g. every 10 minutes with the command curl http://<ipadres>:1000/cgi/electricityMeter/update > /home/meter.log
or
curl http://<ipadres>:1000/cgi/electricityMeter/update -o "/home/pi/meter.log"

then parse meters.log with a logreader device.
don’t know if this would work but i hope this will point into the right direction.

@leader21 absolutely! thx! The only point to found out is getting the text for “match”: quite difficult. Trial and error I quess or is there a tool to help generate this?!

try this here : https://regex101.com/r/oX3kI6/1
you still need to evaluate the match yourself but this helps to check if it works.

I tried to make a match:

"match": "<reading [[:blank:]] id\=\"p_consumed\"[[:blank:]] unit\=\"kW \"\>[0-9]+\.[0-9]+<reading>"

to get the value ‘0.251000’ from ‘p_consumed’ as mentioned in my post 11 hours ago.
But unfortunately, no result. Any idea what is wrong?

isn’t there a possibility to get a “clear text” log file?
have you tried it with a cron job an the curl command?
or with a bash script maybe … this here is confusing but i’ll try it with your match.
keep you informed.

Yes, I created a file using the command:

curl http://<ipadres>:1000/cgi/electricityMeter/update -o "/tmp/meter.log"

Looking into the logfile I see the values in 1 row, one after another, like this:

<update><detected>true</detected><reading id="e_consumed_1" unit="kWh">648.910000</reading><reading id="e_consumed_2" unit="kWh">741.189000</reading>..etc

The “match” I tried was only for the value of p_consumed

ok, i see.

that’s the correct match :
<reading\s*id\=\"p_consumed\"\s* unit\=\"kW\">([0-9]+\.[0-9]+)<\/reading>
lets get this into the json format. i will try to set up a device

got it

the device should look something like that

    {
      "id": "energymeter",
      "name": "Skippers Energy Meter",
      "class": "LogWatcher",
      "file": "/home/pi/meter.log",
      "attributes": [
        {
          "name": "consumed",
          "type": "number",
          "unit": "kW"
        },
      ],
      "lines": [
        {
          "match": "<reading\\s*id=\"p_consumed\"\\s*unit=\"kW\">([0-9]+\\.[0-9]+)<\\/reading>",
          "consumed": "$1"
        }
      ]
    },

logfile meter.log is your above example

<update>
<detected>true</detected>
<reading id="e_consumed_1" unit="kWh">583.782000</reading>
<reading id="e_consumed_2" unit="kWh">668.518000</reading>
<reading id="e_produced_1" unit="kWh">274.548000</reading>
<reading id="e_produced_2" unit="kWh">622.283000</reading>
<reading id="p_consumed" unit="kW">0.251000</reading>
<reading id="p_produced" unit="kW">0.000000</reading>
<text id="e_switch">out</text>
</update>

i guess from here you can set up the other devices or an array for yourself, don’t you?
you just need to get the reading into a logfile. you can try and use the above curl command and try if logreader will parse when all data is in one row.
maybe alter the curl somehow like that to get linefeeds. i’m no curl specialist, so i hope this will work!
curl http://<ipadres>:1000/cgi/electricityMeter/update --data-binary "/home/pi/meter.log"
the --data-binary option will forward the data as is without any change.
usually curl removes linebreaks. just try a little bit, i’m sure it won’t shipwreck now! you will make it!!

@leader21 Thank you so much!! you’ve really helped me!

you’re welcome !
have fun with pimatic and your new smart meter devices

How do I create a log file with the output of the p1 meter?

When i use the command ‘cu -l /dev/ttyUSB10 -s 9600 --parity=none >>stroom.log’

a log file is created with the output but the file grows every few seconds. Is there a possibility to only log 1 output with a cronjob?

You could use a python script with the serial library. This could help: http://raspberrypi.stackexchange.com/questions/15600/reading-from-serial-port-loop

And write it to a log file with python.