Sorry, I feel really stupid, but I cannot get this tool to work for me.
I’m trying to import my domoticz power data.
The Domoticz database is read correctly, and I get the following output (59 is the daily kWh consumption in Home Assistant):
update statistics set sum = sum + 845.982 where metadata_id = 59 and start_ts > unixepoch("2023-03-28 02:00:00.000000")
update statistics_short_term set sum = sum + 845.982 where metadata_id = 59 and start_ts > unixepoch("2023-03-28 02:00:00.000000")
insert into statistics (created_ts, start_ts, state, sum, metadata_id) values
(unixepoch("2022-08-25 02:00:00.000000"), unixepoch("2022-08-25 02:00:00.000000"), 1360.979, 0.000, 59),
(unixepoch("2022-08-26 02:00:00.000000"), unixepoch("2022-08-26 02:00:00.000000"), 1361.223, 0.244, 59),
I get the error: Error importing file: list index out of range.
No matter how I change the settings, I keep getting this error. Also when I try to import a single data point.
delete from statistics where metadata_id = 59
delete from statistics_short_term where metadata_id = 59
insert into statistics (created, start, state, sum, metadata_id) values
("2022-08-25 02:00:00.000000", "2022-08-25 02:00:00.000000", 1360979.000, 0.000, 59)
Also does not work.