Edit database records

[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 (75.99 KiB) Viewed 3275 times

Any ideas?

Greeting from Berlin
Frank

[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.

[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.

[McFranky]

OK. I try to click on the bad value with Shift Key in the Graph on 13.Feb. but nothing happens...

DatabaseEdit.JPG (107.58 KiB) Viewed 3230 times

[McFranky]

OK, it works. I take the chart for the last month...

Thanks for support