Loading historical data to HA

[sanchosk (Robert Klauco)]

I would like to create a tracker for my car that will monitor battery state, range, odometer, etc. during the drive.

The car does not have internet connectivity, but the device can store the data on the microSD.

Once at home, I’d like to upload the data (including historical values) to HA somehow.

Any ideas how I can post historical data to HA? So far, I only know how to report current data using MQTT…

Thanks for the hints.

[koying (Chris B)]

Nothing out of the box, but that thread might help you

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…

[sanchosk (Robert Klauco)]

Thanks, this is close to what I need Will test it.