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 store the data into a file or database? I am looking for a solution without manually exporting and saving data into a file. I would like the files/db to be update on set times and dates.
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.