Script was updated to solve this error.

Got some nice readings today but then the counter stopped at 13:05 for no immediate reason. No idea what the issue is.
Manually ran the script and get only the following feedback in domoticz log.

2020-10-28 15:07:49.701 Status: --->> Cookie File: /var/tmp ...

@sincze Thanks! Loved the way you support this!
Next steps are calculating actual power usage, solar power percentage, and Return on Investment.

Here is the last full code, as it works in my setup. Thanks @waaren for all your contributions - the credits fully go to you!

--[[ -- sqliteDump.lua

Dumps daily data as csv file

requires sqlite3
install command on linux: sudo apt install sqlite3
install command on openwrt: opkg install ...

@waaren. Thanks, yes I feared that from what I have already read about domoticz. Thanks for the confirmation.

Thanks @waaren.

As the file will be containing the past 24 hours and overwrite the previous file, I changed the filename to contain yesterday's date and run the timer at 00:04.


local path = "/home/pi/domoticz/" -- full qualified path to your domoticz directory
local database = 'domoticz.db ...

@waaren thanks. With a few small modifications (paths and smart meter idx) this works and i get a CSV dump of the P1 meter per day.

How can I change the code so that I get the values for each day (so every measurement)? These are needed to calculate the actual usage per counter (high / normal ...

Very interested in this script. I tried it and it runs but the csv file remains empty. The data i am trying to export is my P1 power meter (idx 17) and p1 gas meter (idx 21).

That way I can use excel to calculate the actual power usage when combined with the solar inverter download (until i can get ...

Script to read Delta solar power inverter data into domoticz.

So called "smart" energy meters are pretty dumb: as soon as you install solar panels they cannot show your actual power usage. P1 meters only show energy consumption from the grid, or delivery to the grid. They do not show the energy ...

This looks nice but I get wrong values. My power usage today is positive, and at the same time the cost is negative. Which would be nice but the power company does not work this way.

I leave it to the OP to explain the code but you might want to look at line
local costElectricityFixedDay = (0 ...

This looks nice but I get wrong values. My power usage today is positive, and at the same time the cost is negative. Which would be nice but the power company does not work this way.

So I have been breaking my head over the cose, but i do not know enough about dzvents scripting and cannot find ...