All energy history disappeared

[lorerave85]

finally I found this post

Custom Integration to import long term statistics from a file like csv or tsv

After a lot of research, I managed to implement an integration to import long term statistics from a file like csv or tsv (I did not find any existing integration doing this). This custom integration offers a service with some parameters, the most important one being the file name containing the historical data. In this way, you can easily import historical statistic data into a running HA instance, without the need to be familiar with SQL. You can find it here: GitHub - klausj1/homeassistant…

that allows you to load metrics from a custom service on the DB.
if you look in the latest answers I also put a python script that extracts a metric and prepares it for loading. obviously only those of type energy.