Some python code for extracting OS X Garmin Training Center data
Turns out that Garmin Training Center schema wasn't all that difficult to figure out. I still don't know how they have the timestamps encoded - doing a conversion results in a date that is ~30 years off and, if post-February, ~30 years and 1 day offf. Also, I don't know how the longitude/latitude is encoded either. Any pointers would be most appreciated.
If you've got python and it's sqlite library installed, then this script will be a half-decent example of how to pull data from ".gtc" database for each entry in the stored history. If not, have no fear, I hope to release a small app to let you extract the data on your own and I'm still thinking about that widget.
Pretty source after the jump.
Open in new window
If you've got python and it's sqlite library installed, then this script will be a half-decent example of how to pull data from ".gtc" database for each entry in the stored history. If not, have no fear, I hope to release a small app to let you extract the data on your own and I'm still thinking about that widget.
Pretty source after the jump.
Open in new window
- 2874 reads
Comments
Cool script
I was really surprised to find out that Garmin is using SQLite to store the Training Center data. That certainly makes it easy to work with! Looks like it wouldn't be to hard to build a portable, cross-platform "Training Center" class.
Thanks for the example script!
- JPM