Page 1 of 1

Replacing Power meter - how to fix Domoticz

Posted: Tuesday 20 June 2023 12:17
by voroniys
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 ?

Re: Replacing Power meter - how to fix Domoticz

Posted: Tuesday 20 June 2023 12:45
by psubiaco
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.

Re: Replacing Power meter - how to fix Domoticz

Posted: Tuesday 20 June 2023 13:04
by voroniys
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.

Re: Replacing Power meter - how to fix Domoticz

Posted: Wednesday 21 June 2023 7:49
by gizmocuz
That will happen on 1 day, you can shift-click the value in the day/month chart to remove it

Re: Replacing Power meter - how to fix Domoticz

Posted: Wednesday 21 June 2023 10:41
by voroniys
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.