Search found 10 matches
- 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 ...
- 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.
Next steps are calculating actual power usage, solar power percentage, and Return on Investment.
- 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 ...
- 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.
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...