Merge two databases /append data from old database to new database

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
Eternity
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

Post by Eternity »

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.
Synology DS218+
Homey controller
Z-Wave stuff (Fibaro / Aeotec / NEO Coolcam)
Zigbee stuff (Aqara)
HUE lights
Logitech Harmony Ultimate + Hub
IP camera's
EddyG
Posts: 1042
Joined: Monday 02 November 2015 5:54
Target OS: -
Domoticz version:

Re: Merge two databases /append data from old database to new database

Post by EddyG »

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

Post by Eternity »

Thanks! I did not know of that option :-)
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
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest