Page 1 of 1

Import historical data

Posted: Friday 25 March 2022 11:09
by friso82
Hi,

I installed Domoticz and have a lot of pre-domoticz historical data. E.g. daily utility counter values. I was thinking of importing those into the MultiMeter_Calendar table in the correct format to have this historical data in Domoticz as well.

How to approach this? I already created the required records in a csv file in the correct format. Is updating the MultiMeter_Calendar table with the additional rows sufficient or do I need to take other dependencies into account?

Thanks!

Cheers, Friso

Re: Import historical data

Posted: Friday 25 March 2022 11:47
by waltervl
Yes, this would be the easiest way to do so. You can use "DB Browser for SQLite" https://sqlitebrowser.org
Always make a backup of domoticz.db first!