Domoticz is running in a docker on my Synology NAS I have version 2021.1 (build 13628) installed.
I have been using a P1 cable to read out my smart meter and store the data in Domoticz. However, a month ago I switched hardware and now have a gateway to monitor and log the smart meter data. Unfortunately, this is a new device and thus it's logging started the day it was installed.
I still have all the old devise from the old P1 meter in Domoticz; it's stopped logging the day the new devise was installed.
Would it be possible to transfer data from the old to the new device (so, manipulate the database)? I would love to compare gas usage over the years, but now I have two separate devices and two sets of data.
Merge two databases /append data from old database to new database
Moderators: leecollings, remb0
-
- Posts: 63
- Joined: Saturday 06 December 2014 16:26
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Contact:
Merge two databases /append data from old database to new database
Synology DS218+
Homey controller
Z-Wave stuff (Fibaro / Aeotec / NEO Coolcam)
Zigbee stuff (Aqara)
HUE lights
Logitech Harmony Ultimate + Hub
IP camera's
Homey controller
Z-Wave stuff (Fibaro / Aeotec / NEO Coolcam)
Zigbee stuff (Aqara)
HUE lights
Logitech Harmony Ultimate + Hub
IP camera's
Re: Merge two databases /append data from old database to new database
On a device there is a replace button. I know for sure that that works for Temp/hum devices, used it several times.
So save you database and try it with energy devices. My guess is that it will work.
So save you database and try it with energy devices. My guess is that it will work.
-
- Posts: 63
- Joined: Saturday 06 December 2014 16:26
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Contact:
Re: Merge two databases /append data from old database to new database
Thanks! I did not know of that option 
Will give it a go!

Will give it a go!
Synology DS218+
Homey controller
Z-Wave stuff (Fibaro / Aeotec / NEO Coolcam)
Zigbee stuff (Aqara)
HUE lights
Logitech Harmony Ultimate + Hub
IP camera's
Homey controller
Z-Wave stuff (Fibaro / Aeotec / NEO Coolcam)
Zigbee stuff (Aqara)
HUE lights
Logitech Harmony Ultimate + Hub
IP camera's
Who is online
Users browsing this forum: No registered users and 1 guest