Replacing Power meter - how to fix Domoticz

Topics (not sure which fora)
when not sure where to post, post here and mods will move it to right forum.

Moderators: leecollings, remb0

Post Reply
voroniys
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

Post 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 ?
Last edited by voroniys on Tuesday 20 June 2023 15:13, edited 1 time in total.
User avatar
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

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

Post 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.
User avatar
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

Post by gizmocuz »

That will happen on 1 day, you can shift-click the value in the day/month chart to remove it
Quality outlives Quantity!
voroniys
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

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

Who is online

Users browsing this forum: No registered users and 1 guest