Hi All,
my electricity company replaced a power meter in my house. So, Domoticz at once shows huge usage and return since all counters are suddenly dropped to 0. How to fix this situation and retain the old data and start collecting the new one?
In SQL DB the moment of switching looks like this:
1|15334577|2038952|0|1804|15353123|4155992|2023-06-20 11:20:00
1|14|53|0|719|0|0|2023-06-20 11:55:00
What can I modify to fix the issue ?
Replacing Power meter - how to fix Domoticz
Moderators: leecollings, remb0
-
- Posts: 7
- Joined: Wednesday 23 February 2022 18:13
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2022.1
- Contact:
Replacing Power meter - how to fix Domoticz
Last edited by voroniys on Tuesday 20 June 2023 15:13, edited 1 time in total.
- psubiaco
- Posts: 222
- Joined: Monday 20 August 2018 9:38
- Target OS: Raspberry Pi / ODroid
- Domoticz version: Beta
- Location: Italy
- Contact:
Re: Replacing Power meter - how to fix Domoticz
Maybe you can fix the problem by using some SQL queries on domoticz.db database (sqlite3 command to access it), but you have to specify:
* what device you're using to read energy/meter
* how the device is configure in domoticz: go to utility panel, click on the meter device -> edit, and let us know if it's a kWh meter (or other type) and if it's configured in Computed or From Device mode.
* what device you're using to read energy/meter
* how the device is configure in domoticz: go to utility panel, click on the meter device -> edit, and let us know if it's a kWh meter (or other type) and if it's configured in Computed or From Device mode.
Paolo
--
I use DomBus modules to charge EV car, get a full alarm system, control heat pump, fire alarm detection, lights and much more. Video
Facebook page - Youtube channel
--
I use DomBus modules to charge EV car, get a full alarm system, control heat pump, fire alarm detection, lights and much more. Video
Facebook page - Youtube channel
-
- Posts: 7
- Joined: Wednesday 23 February 2022 18:13
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2022.1
- Contact:
Re: Replacing Power meter - how to fix Domoticz
I'm using standard ' P1 Smart Meter USB' of type Energy and it is a kWh meter with 4 tellers Usage High, Usage Low, Return High, Return Low
In Utility/Edit there is no setting like you've mentioned. There I have only name and icon.
In Utility/Edit there is no setting like you've mentioned. There I have only name and icon.
- gizmocuz
- Posts: 2552
- Joined: Thursday 11 July 2013 18:59
- Target OS: Raspberry Pi / ODroid
- Domoticz version: beta
- Location: Top of the world
- Contact:
Re: Replacing Power meter - how to fix Domoticz
That will happen on 1 day, you can shift-click the value in the day/month chart to remove it
Quality outlives Quantity!
-
- Posts: 7
- Joined: Wednesday 23 February 2022 18:13
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2022.1
- Contact:
Re: Replacing Power meter - how to fix Domoticz
I've solved my issue.
Just for other people facing the similar issue - I've waited till next day, so a new record in the table MultiMeter_Calendar was created. And than I've updated the record of yesterday by putting into the usage and return calculated numbers as a sum of usage/return registered by old and new meter and to the counters I've copied counters values from the new meter at midnight taken from MultiMeter table.
All graphs are looking good now.
Just for other people facing the similar issue - I've waited till next day, so a new record in the table MultiMeter_Calendar was created. And than I've updated the record of yesterday by putting into the usage and return calculated numbers as a sum of usage/return registered by old and new meter and to the counters I've copied counters values from the new meter at midnight taken from MultiMeter table.
All graphs are looking good now.
Who is online
Users browsing this forum: No registered users and 1 guest