Delete false data?

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
Deranged
Posts: 6
Joined: Monday 31 March 2014 16:47
Target OS: Linux
Domoticz version:
Contact:

Delete false data?

Post by Deranged »

Hi,

I have a question about false data that somehow got into the database.
If I check the graph for energy used in the past year:
Image

If I drill deeper:
Image

Quickest fix (I think) would be to delete the captured data for October 5th 2016?
Or maybe a way to fix the readings into the correct fields?

Thanks for reading!
User avatar
emme
Posts: 909
Joined: Monday 27 June 2016 11:02
Target OS: Raspberry Pi / ODroid
Domoticz version: latest
Location: Milano, Italy
Contact:

Re: Delete false data?

Post by emme »

shift-leftclick on the value ;)
The most dangerous phrase in any language is:
"We always done this way"
Deranged
Posts: 6
Joined: Monday 31 March 2014 16:47
Target OS: Linux
Domoticz version:
Contact:

Re: Delete false data?

Post by Deranged »

Hmm, sure? I tried that in Edge, IE and FireFox, and that doesn't work for me.
Is that a feature or setting I need to enable first?

Thanks for your reply!
User avatar
Egregius
Posts: 2592
Joined: Thursday 09 April 2015 12:19
Target OS: Linux
Domoticz version: v2024.7
Location: Beitem, BE
Contact:

Re: Delete false data?

Post by Egregius »

Or use a sqlite browser to adjust the value.
Deranged
Posts: 6
Joined: Monday 31 March 2014 16:47
Target OS: Linux
Domoticz version:
Contact:

Re: Delete false data?

Post by Deranged »

@Egregius:
Thanks, I downloaded a browser, opened the .db file and managed to edit the data in the MULTIMETER_CALENDAR table.
You'll find 2 entries for the specified date. I simply copied the values from the previous day.

All is fixed, thanks for the help (to the both of you).

Cheers
careless2000
Posts: 2
Joined: Monday 03 September 2018 18:22
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Re: Delete false data?

Post by careless2000 »

Cool, this worked for me on Safari! Finally got rid of the -124ºC value in my Outdoor meter :lol:
emme wrote: Wednesday 30 November 2016 9:52 shift-leftclick on the value ;)
simon_rb
Posts: 612
Joined: Wednesday 07 August 2013 19:09
Target OS: -
Domoticz version:
Location: UK
Contact:

Re: Delete false data?

Post by simon_rb »

The left click to delete still doesn't work for me. I can't find the data in the DB to delete either :(
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest