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
Noppie
Posts: 7
Joined: Friday 19 February 2016 15:50
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Database

Post by Noppie »

Hi,

Due to a re-installation I've added a new sensor (with a new IDX) for my Solar panels. Is it possible to link the old data to the new sensor based on the IDX?
User avatar
Egregius
Posts: 2582
Joined: Thursday 09 April 2015 12:19
Target OS: Linux
Domoticz version: v2024.7
Location: Beitem, BE
Contact:

Re: Database

Post by Egregius »

You could update the database directly.
Noppie
Posts: 7
Joined: Friday 19 February 2016 15:50
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Re: Database

Post by Noppie »

Yes I know, but where is the history stored? I queried the database but I can't find the history of my solar panels.......
User avatar
Egregius
Posts: 2582
Joined: Thursday 09 April 2015 12:19
Target OS: Linux
Domoticz version: v2024.7
Location: Beitem, BE
Contact:

Re: Database

Post by Egregius »

Probably in tables meter and meter_calendar
Noppie
Posts: 7
Joined: Friday 19 February 2016 15:50
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Re: Database

Post by Noppie »

I will give it a try......
Nautilus
Posts: 722
Joined: Friday 02 October 2015 12:12
Target OS: Raspberry Pi / ODroid
Domoticz version: beta
Location: Finland
Contact:

Re: Database

Post by Nautilus »

Noppie wrote:Hi,

Due to a re-installation I've added a new sensor (with a new IDX) for my Solar panels. Is it possible to link the old data to the new sensor based on the IDX?
When you have both new and old in Domoticz open the edit window of the old and select "Replace...", then select the new as the replacement and your old data will be moved to the new sensor.

But yes, you can do the same directly by editing the database, just a lot easier via the UI :)
Noppie
Posts: 7
Joined: Friday 19 February 2016 15:50
Target OS: Raspberry Pi / ODroid
Domoticz version:
Contact:

Re: Database

Post by Noppie »

Thanks Nautilus,

unfortunately I deleted the old one so, Replacing isn't an option anymore.....
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests