How to edit data Topic is solved

Please use template to report bugs and problems. Post here your questions when not sure where else to post
Only for bugs in the Domoticz application! other problems go in different subforums!
Forum rules
Before posting here, make sure you are on the latest Beta or Stable version.
If you have problems related to the web gui, clear your browser cache + appcache first.

Use the following template when posting here:

Version: xxxx
Platform: xxxx
Plugin/Hardware: xxxx
Description:
.....

If you are having problems with scripts/blockly, always post the script (in a spoiler or code tag) or screenshots of your blockly

If you are replying, please do not quote images/code from the first post

Please mark your topic as Solved when the problem is solved.
Post Reply
HenkHavelaar
Posts: 7
Joined: Saturday 30 September 2017 17:13
Target OS: Windows
Domoticz version: V4.9700
Contact:

How to edit data

Post by HenkHavelaar » Friday 14 September 2018 16:38

Version:4.9700
Platform: Windows 10
Hardware: RFXcom USB tranceiver, Open Zwave USB Aeotec, Davis Vantage Weather station
I'm using a RFX powermeter but sometimes there are strange values measured or recorded (see attachement), were can I find the database with the measured values and how can I edit these values?
Attachments
KWh use.jpg
KWh use.jpg (54.19 KiB) Viewed 222 times
Domoticz on Synology NAS and Windows 10
Interfaces: zWave and RFXcom
Locations: Netherlands and Portugal

zicht
Posts: 219
Joined: Sunday 11 May 2014 11:09
Target OS: Windows
Domoticz version: 3.8xxx
Location: NL
Contact:

Re: How to edit data

Post by zicht » Friday 14 September 2018 21:08

Database is the file domoticz.db in the domoticz dir (see normal programs dir, in windows)
Sql edit is possible with several tools, the tables are very logical. I would not recommend to alter directly, but if you do make a backup. All sensors and settings are stored there so if you corrupt something you can start from scratch.
Rpi & Win x64. Using : cam's,Nest,RFXCom,Kaku,LaCrosse,RFY,IsAlive,Dummy,Wether Underground, standard Lua, Curl on windows,Domoticz Android App & Tasker,

"The only source of knowledge is experience (A.Einstein)"

tun0
Posts: 11
Joined: Saturday 28 July 2018 9:30
Target OS: -
Domoticz version:
Contact:

Re: How to edit data

Post by tun0 » Friday 14 September 2018 21:15

If you want to delete a datapoint rather than alter it, just click it while holding shift. Otherwise you'll have to dive into the database indeed.

HenkHavelaar
Posts: 7
Joined: Saturday 30 September 2017 17:13
Target OS: Windows
Domoticz version: V4.9700
Contact:

Re: How to edit data

Post by HenkHavelaar » Wednesday 24 October 2018 12:41

Thanks for the tip, this works perfect. Sorry for the late reaction, I was on vacation.
Domoticz on Synology NAS and Windows 10
Interfaces: zWave and RFXcom
Locations: Netherlands and Portugal

HenkHavelaar
Posts: 7
Joined: Saturday 30 September 2017 17:13
Target OS: Windows
Domoticz version: V4.9700
Contact:

Re: How to edit data

Post by HenkHavelaar » Wednesday 24 October 2018 12:43

Topic solved, can be closed
Domoticz on Synology NAS and Windows 10
Interfaces: zWave and RFXcom
Locations: Netherlands and Portugal

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest