Page 1 of 1

Database

Posted: Thursday 23 February 2017 8:17
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?

Re: Database

Posted: Thursday 23 February 2017 8:21
by Egregius
You could update the database directly.

Re: Database

Posted: Thursday 23 February 2017 8:27
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.......

Re: Database

Posted: Thursday 23 February 2017 8:33
by Egregius
Probably in tables meter and meter_calendar

Re: Database

Posted: Thursday 23 February 2017 8:39
by Noppie
I will give it a try......

Re: Database

Posted: Thursday 23 February 2017 12:33
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 :)

Re: Database

Posted: Thursday 23 February 2017 14:33
by Noppie
Thanks Nautilus,

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