Importing data
Posted: Sunday 15 November 2015 11:27
Hi all,
I have been using Domotiga for several years now but noticed Domoticz, firstly because of the MySensors but very soon after that the whole look and feel.
Now I have decided that I will make the step to Domoticz and come to the point where I would really like to keep my historic data that I have in Domotiga. The switching data is not that important (nice to have) but mainly my electric and gas usage data and solar panel data I would like to keep and make use of the graphics that Domoticz generates.
Besides the Domotiga database I have a separate database where I have this data available, on daily base but also every xx minutes. The data starts in the middle of 2012, so there is more then three years. Loads of data.
Can someone give me some pointers on how to do this conversion from MySQL and what is the best way to use the data. I have some experience in php and MySQL, so the basics are there.
The second thing I have is the order of doing things to get the correct data to the correct devices. Domotiga is my main system at the moment and I have Domoticz running on a separate esxi server. The things that are accessible from shared sources are available in Domoticz already, but the power meters and Rfxcom can not be shared atm. I think I need the devices first before I can import any data, is this correct ?
I have been using Domotiga for several years now but noticed Domoticz, firstly because of the MySensors but very soon after that the whole look and feel.
Now I have decided that I will make the step to Domoticz and come to the point where I would really like to keep my historic data that I have in Domotiga. The switching data is not that important (nice to have) but mainly my electric and gas usage data and solar panel data I would like to keep and make use of the graphics that Domoticz generates.
Besides the Domotiga database I have a separate database where I have this data available, on daily base but also every xx minutes. The data starts in the middle of 2012, so there is more then three years. Loads of data.
Can someone give me some pointers on how to do this conversion from MySQL and what is the best way to use the data. I have some experience in php and MySQL, so the basics are there.
The second thing I have is the order of doing things to get the correct data to the correct devices. Domotiga is my main system at the moment and I have Domoticz running on a separate esxi server. The things that are accessible from shared sources are available in Domoticz already, but the power meters and Rfxcom can not be shared atm. I think I need the devices first before I can import any data, is this correct ?