I know there are allready a lot of questions on the old forum about exporting all sorts of data. Some solutions are more difficult then others. It is hard for me to find a good and easy solution to eport the data and do some usefull analytics with it. What is the best solution to export data and sto…

Did you ever found out how to do this? I would like to export some data to a MySQL database and then have some graphs showing via Grafana.

Have you tried the Export Insights app?

I looked at it, but then I would still need to import a CSV in to the database. For example: export the value of a temperature sensor every 5 minutes. I didn’t test it, but from the description from that app it exports all data, not only the data since the last backup.

Exports can be easily scheduled by using the trigger card in a flow. You can schedule a full export, or an export per app.

Try InfluxDB [image] Logging temp and humidity Questions & Help As simple as it is with InfluxDB. All insight measurements are exported, even if you have multiple sensors. You can get something like this [image]

Export data

Questions & Help

Arnold_vd_Linden January 11, 2022, 9:49am 6

Try InfluxDB

Topic		Replies	Views
Export insights to sql db Questions & Help tools	3	799	April 23, 2019
[FeatureRequest] WebApp - Inzichten Grafieken Bewaren Ideeën & Suggesties app , featurerequest	6	1222	July 8, 2022
Create flow to export charts from insigts? Questions & Help insights	2	736	September 16, 2021
Logging für spätere Auswertung Fragen & Hilfe	0	494	April 2, 2022
Storing energy data Energy	15	851	March 8, 2025

Export data

Related topics