Peter Gamma (Physiologist & Director) Meditation Research Institute Switzerland (MRIS)

Can we import .csv files into InfluxDB with a timestamp from tomorrow, and other questions

Last Updated on December 20, 2022 by pg@petergamma.org

  • Yes, we can, as the following example shows:

https://www.youtube.com/watch?v=O0i2N4VMcR4

  • but the timestamps have to be Unix time. We can do it directly in Home Assistant, where we can download the InfluxDB plugin.
  • we looked at several examples how to import .csv files into InfluxDB, and after we did that, we have let it be. But the above example looks easy. The result can immediately be visualized.
  • We have data from Data Scientist Max Max Candocia .fit to .csv script, we have .csv data from the the Android app a Training Tracker of Dr. Ing. Rainer Blind, we have .csv data from the Polar Sensor Logger by Jukka Happonen from Polar Electro Research Center, we have .csv data from the Mind Monitor app of Computer Scientist James Clutterbock, with these apps, we have a lot of data we are interested in.
  • the more we are looking at Apple watches, we can see, that more and more options which are available for Garmin watches are also available for Apple watches, and if we got it right, if the sensor data are stored in Apple Health, they can be synchronized to Home Assistant and exported to InfluxDB by using the Apple Health Auto Export App by Lybron Sobers.
  • Do we just synchronize data from one InfluxDB on the Apple watch to another InfluxDB in Home Assistant?
  • And if we export data from Garmin Connect over the .fit file path, to we export data from one InfluxDB over the .fit file format to the other over the .csv format to our own InfluxDB? If that is true, what a Sisyphus work is that?
  • We don t need Microsoft Access, we don t need SQLite, we can directly inject .csv files into InfluxDB in Home Assistant.
  • But what is required is to know a lot about Home Assistant, InfluxDB, Grafana and Python. These are contemporary tools
  • The GoldenCheetah software for athletes, which can be downloaded from a GITHUB page, had many contributors:

https://www.goldencheetah.org/#section-contributor

  • but if we look on YouTube about Golden Cheetah, we can find a Real Life Video which was recoded one year ago:
  • and a Golden Cheetah Ride Analyze seven years ago:
  • if we look the YouTube channel Everything Smart Home, which was started on 16.05.2020, then we can see, that is has more than 10 million views, countless videos and 122.000 subscriptions:

https://www.youtube.com/@EverythingSmartHome/videos

Why can t we use InfluxDB & Grafana so easily with sports sensors and physiological sensor as we can use it with smart home sensors?