Suggestion: Domoticz Database Edit Mode

Use this forum to discuss possible implementation of a new feature before opening a ticket.
A developer shall edit the topic title with "[xxx]" where xxx is the id of the accompanying tracker id.
Duplicate posts about the same id. +1 posts are not allowed.
Post Reply
kimhav
Posts: 109
Joined: Tuesday 01 October 2013 8:31
Target OS: Raspberry Pi
Domoticz version: 4.10215
Location: Malmo, Sweden
Contact:

Suggestion: Domoticz Database Edit Mode

Post by kimhav » Monday 08 October 2018 20:18

Once a while it happens that the sensors or RFXMeters which provides input to a Domoticz instance tends to go bananas when electricity comes back after power outtakes or when replacing batteries in rain gauges, etc. The suggested solution to handle this is often to clone the database make the changes and copy and replace the original database with the changed one to fix what ever values one wants to get ride of or need to change. Just to give an example is that the other day I had to remove the mover for the pulse meters (RFXMeter) which of course gave a bump in the values (Sunday):

Domoticz_ErrorValue.png
Domoticz_ErrorValue.png (41.95 KiB) Viewed 328 times
The suggestion is to add Edit Mode to the View data table function which would solve a lot of pain when these small hiccups happens. Whether it's possible or not based on the database structure or I don't know and whether using a dummy device have any kind of implication. But, just quickly looking, it feels that we're almost there, and so close to be able to edit the values.
Member of Domoticz Sweden Telegram Group

User avatar
Egregius
Posts: 2740
Joined: Thursday 09 April 2015 12:19
Target OS: Linux
Domoticz version: Beta
Location: Beitem, BE
Contact:

Re: Suggestion: Domoticz Database Edit Mode

Post by Egregius » Monday 08 October 2018 22:38

You can use adminer on the live database without stopping domoticz

User avatar
Dnpwwo
Posts: 758
Joined: Sunday 23 March 2014 10:00
Target OS: Raspberry Pi
Domoticz version: Beta
Location: Melbourne, Australia
Contact:

Re: Suggestion: Domoticz Database Edit Mode

Post by Dnpwwo » Tuesday 09 October 2018 11:13

@kimhav,

You can already maintain the logged data without restoring old databases or anything else.

You should be able to click the data point you want to remove on the graph with the shift key held down and you will be asked if you want to delete it, something like:

Code: Select all

Are you sure to remove this value at ?: Date: 2018-07-07 Value: 6.8
select Ok and the data value will be removed.
The reasonable man adapts himself to the world; the unreasonable one persists to adapt the world to himself. Therefore all progress depends on the unreasonable man. George Bernard Shaw

kimhav
Posts: 109
Joined: Tuesday 01 October 2013 8:31
Target OS: Raspberry Pi
Domoticz version: 4.10215
Location: Malmo, Sweden
Contact:

Re: Suggestion: Domoticz Database Edit Mode

Post by kimhav » Tuesday 09 October 2018 16:44

Yes, that is correct that I can remove logged data on the 25h graph but it seems that Domoticz isn't recalculating the Last Week view and the number there can't be removed. Hence the reason why I feel that having a simple edit option directly in Domoticz would make a lot of users happy.
Member of Domoticz Sweden Telegram Group

Toulon7559
Posts: 478
Joined: Sunday 23 February 2014 18:56
Target OS: Raspberry Pi
Domoticz version: latest
Location: Hengelo(Ov)/NL
Contact:

Re: Suggestion: Domoticz Database Edit Mode

Post by Toulon7559 » Tuesday 09 October 2018 17:32

The 'Shift-Method' is not always working.
Like mentioned in the message of kimhav, in the last week of September the Rain Gauge in my Nexus_PWS needed replacement of the batteries.
Requires that after restart of the sensor you 'replace' the fresh sensor popping up by the 'old' sensor.
Unfortunately in the resulting data a cumulative value popped up for that day, which was far beyond reality.

Not knowing a better way for correction, tried to delete the erroneous value with the 'Shift-method', but in vain:
no reaction from Domoticz.
Furthermore, deletion is not always the aim, but correction may be appropriate:
would be nice to have a simple & quick editor directly going to the database to correct 'small & isolated' value-errors, both on recent data and on somewhat older data [ e.g. ;-) when you detect afterwards that a sensor went haywire during your holiday].
Set1 = RPI-B+RFXCom433+S0PCM+Linksprite-shield for BMP180/DS18B20/RS485+DDS238-1ZN
Set2 = RPI-3+RFLinkGTW+ESP8266s+PWS_WS7000
Common = 3*PVLogger+PWS_TFA_Nexus+KAKUs
=> Energy & Data Management based on Time and on PV&Consumption&Meteo

kimhav
Posts: 109
Joined: Tuesday 01 October 2013 8:31
Target OS: Raspberry Pi
Domoticz version: 4.10215
Location: Malmo, Sweden
Contact:

Re: Suggestion: Domoticz Database Edit Mode

Post by kimhav » Sunday 21 October 2018 17:02

Here is an example of typical erroneous value that I would like to be able to set to zero as it's occurs after a power outtake... I guess that most would agree that the value is far from valid for a standard household and no I don't have a flux capacitor in my car. :D

Domoticz_Meter_Day_Spike.png
Domoticz_Meter_Day_Spike.png (35.8 KiB) Viewed 142 times
What also could be nice would be the possibility to add specific rules to meters within what variables one would expect the reported values to be within when it comes to the aggregation of the values which Domoticz performs. And as mentioned, it's not a new issue, and it one of those annoying things which would be nice to find a good solution for.
Member of Domoticz Sweden Telegram Group

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests