Hey folks, Yesterday I installed InfluxDB on my HA. Now I want to transfer all existig data from my HA to the InfluxDB How can I do this?

Wait 10 days? Which is a flippant way of saying: you cant. Sorry (for being flippant and that there is no easy way to do this). But your state data only goes back 10 days by default so you’re not losing that much.

Bad news Unfortunately I have some long term data collectors utility-meter for energy measurement.

The solution will be exporting and importing the data in a CSV format. https://docs.influxdata.com/influxdb/cloud/write-data/developer-tools/csv/

this sounds good how can I export the HA data to a CSV file that is readable by InfluxDB?

The utility meter state history only goes back 10 days as well.

utility_meter: burntime_weekly: name: "tägliche Brenndauer" source: sensor.brenndauer_tag cycle: weekly burntime_yearly: name: "jährliche Brenndauer" source: sensor.brenndauer_tag cycle: yearly what about the cycle: yearly ? [image] type: custom:mini-graph-card name: B…

The utility meter yearly cycle will count up for a year then reset. The state history of that count only goes back 10 days by default. So let’s say it increases by 1 a day and is currently 24, you can only see a history back to 14. There’s no scale on that graph. It does not go back a year. Hover …

hi but how become the CSV file from HA addon ?

This addon is great to get data on CSV [image] New interactive history explorer custom card Share your Projects! Update Jan 16 2024: This custom card is end-of-life and not developed anymore. Please see this post for more information. Hey all I created a new custom his…

Transfer existing data form HA to InfluxDB

Configuration

Tomascrespo (Tomás Crespo) November 1, 2023, 11:26am 10

This addon is great to get data on CSV