Page 1 of 1

Import historic data from Homewizard into Domoticz

Posted: Monday 05 September 2016 13:18
by iMartien
Hi All,

I'm using Homewizard for a couple of years now, which worked fine but is beginning to get a kind of limited for what I want to do with my domotica. I like to move to domoticz completly and eventually sell my homewizard.

Does anybody know if it is possible to "download" all historic data from Homewizard (Like temprature sensors, rain meter and power usage) from all those years (or the past year) and import them to new sensors in Domoticz?

This way I can keep al my cool graphs etc. and keep analyzing my power usage.

Thanks in advance!

Re: Import historic data from Homewizard into Domoticz

Posted: Monday 05 September 2016 13:29
by Egregius
Must be possible. The Homewizard has a json api wich can be called.
It would require to store all data, maybe in Excel and then alter it to the format Domoticz uses so you can save it there in the sqlite database.
Depending on the format Homewizard kept the data that could be easy, or very hard.

As I don't own a homewizard (sold the stupid thing after some months) I cannot look and test.

Re: Import historic data from Homewizard into Domoticz

Posted: Monday 05 September 2016 15:42
by iMartien
Found this (http://www.bekkema.net/homewizard) powershell script to export all homewizard data I want to a CSV file... gonna give this a try when I get home.

Edit:
Script doesn't do what I what I expected... :(