Home

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

Technorati Tags:

Posted in

|

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
John (not verified) Says:
Tue, 2007-03-27 22:58

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

»

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.