#Import historic time series sensor data from CSV

7 messages · Page 1 of 1 (latest)

autumn pasture
#

Dear all,
I have a CSV file that contains time series sensor data of the bast year of a temperature probe. I would like to import this data into HA so i can visualize it in graphs and contextualize it with other sensors wich are natively integrated in HA.

Any easy way to do that? The only thing i found was the file based sensor but that only reads the last row of a CSV

timid hinge
#

Not easily. There are ways to hack around it and insert data into the "past" in the database, but it is a lot of work and not supported by ha

autumn pasture
#

hmm ok i see, thanks for the info though, then I will habe to extract the data in HA to CSV and find another means of visualization

bleak tide
#

There are custom integrations that will help you load CSV into statistics.

autumn pasture
#

oh cool, thanks, will check it out

waxen mural
#

another way that doesn't really fix it in ha could be to set up the influxdb integration to mirror ha out to influxdb, then load your historical data into influxdb and visualize in grafana. it really depends on what you want to do. grafana is pretty powerful for visualizations