Import historical data

[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

[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!