Page 1 of 1

Edit database records

Posted: Thursday 10 March 2016 6:32
by McFranky
Is it possible to modify existing database records?
My kw/h counter has an incorrect value is entered and this corrupted me all the statistics. :?
DatabaseRecord.JPG
DatabaseRecord.JPG (75.99 KiB) Viewed 3277 times
Any ideas?

Greeting from Berlin
Frank

Re: Edit database records

Posted: Thursday 10 March 2016 7:24
by Egregius
I use sqladminer, a php page.
For windows there's Sqlite explorer I think.
Advantage of sqladminer is that it can be used without stopping domoticz.

Re: Edit database records

Posted: Thursday 10 March 2016 9:18
by Dnpwwo
A better way is to go to the device log within Domoticz itself and find the part of the graph with the bad value and click on the value while holding the shift key down. For many device types you will be asked if you want to delete the clicked data point.

Re: Edit database records

Posted: Thursday 10 March 2016 12:39
by McFranky
OK. I try to click on the bad value with Shift Key in the Graph on 13.Feb. but nothing happens...
DatabaseEdit.JPG
DatabaseEdit.JPG (107.58 KiB) Viewed 3232 times

Re: Edit database records

Posted: Thursday 10 March 2016 12:50
by McFranky
OK, it works. I take the chart for the last month...

Thanks for support