Page 1 of 1
How to edit database
Posted: Thursday 27 October 2016 10:23
by Docc
Hi
I am measuring power on an outlet with a Greenwave zwave plug and had a couple of power outages this Tuesday which seems to have corrupted the data. How can I edit this and remove the false values?
The 7 day graph is correct but the Last week graph is obviously wrong

- 2016-10-27_1012.png (95.18 KiB) Viewed 5736 times
Re: How to edit database
Posted: Thursday 27 October 2016 11:15
by StanHD
Hi, try holding Shift and Left Mouse Click on the point you wish to remove.
Edit:- Oops sorry, just tried that on my power graph (Week) and it doesn't work.
Re: How to edit database
Posted: Thursday 27 October 2016 11:16
by borgkitty
you could try what these guys are suggesting here
viewtopic.php?t=4128
I haven't done it myself but even before I found this I was goung to say something along the lines of phpadmin
Re: How to edit database
Posted: Thursday 27 October 2016 16:22
by Docc
Shift and Left Mouse Click worked, but only for the whole day in the month graph.
Re: How to edit database
Posted: Tuesday 13 December 2016 9:07
by Yustmenl
I have done this and this works.
But because of the previous high values the total amount of energy greated by my solar pannels is still to high.
is there a way to recalculate this?
I already tryed to restart Domoticz but without the desired result.
Any ideas on how to do this?
Re: How to edit database
Posted: Tuesday 13 December 2016 13:09
by Egregius
Use a sql3lite explorer/editor to change the value.