Search found 10 matches

by fzoet
Wednesday 28 October 2020 15:06
Forum: Utility
Topic: solar panel readout for delta inverters (my delta solar cloud)
Replies: 13
Views: 2983

Re: solar panel readout for delta inverters (my delta solar cloud)

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 ...
by fzoet
Tuesday 27 October 2020 17:50
Forum: Utility
Topic: solar panel readout for delta inverters (my delta solar cloud)
Replies: 13
Views: 2983

Re: solar panel readout for delta inverters (my delta solar cloud)

@sincze Thanks! Loved the way you support this!
Next steps are calculating actual power usage, solar power percentage, and Return on Investment.
by fzoet
Tuesday 27 October 2020 13:41
Forum: Examples & Solutions
Topic: Export data from DB to Excel [SOLVED]
Replies: 40
Views: 18095

Re: Export data from DB to Excel [SOLVED]

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 sqlite3-cli ...
by fzoet
Tuesday 27 October 2020 13:31
Forum: Examples & Solutions
Topic: Export data from DB to Excel [SOLVED]
Replies: 40
Views: 18095

Re: Export data from DB to Excel [SOLVED]

@waaren. Thanks, yes I feared that from what I have already read about domoticz. Thanks for the confirmation.
by fzoet
Monday 26 October 2020 17:22
Forum: Examples & Solutions
Topic: Export data from DB to Excel [SOLVED]
Replies: 40
Views: 18095

Re: Export data from DB to Excel [SOLVED]

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 ...
by fzoet
Monday 26 October 2020 12:33
Forum: Examples & Solutions
Topic: Export data from DB to Excel [SOLVED]
Replies: 40
Views: 18095

Re: Export data from DB to Excel [SOLVED]

@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), and ...
by fzoet
Friday 23 October 2020 14:29
Forum: Examples & Solutions
Topic: Export data from DB to Excel [SOLVED]
Replies: 40
Views: 18095

Re: Export data from DB to Excel [SOLVED]

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 ...
by fzoet
Wednesday 21 October 2020 10:22
Forum: Utility
Topic: solar panel readout for delta inverters (my delta solar cloud)
Replies: 13
Views: 2983

solar panel readout for delta inverters (my delta solar cloud)

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 ...
by fzoet
Friday 16 October 2020 15:00
Forum: dzVents
Topic: Electricity consumption & cost per day, month and year [Solved]
Replies: 23
Views: 10129

Re: Electricity consumption & cost per day, month and year [Solved]

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.08765 ...
by fzoet
Tuesday 13 October 2020 10:56
Forum: dzVents
Topic: Electricity consumption & cost per day, month and year [Solved]
Replies: 23
Views: 10129

Re: Electricity consumption & cost per day, month and year [Solved]

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 ...