Extract data points from garmin into .xml?
04-02-09, 05:50 PM
#1
Banned.
Thread Starter
Join Date: May 2005
Location: Woodstock
Posts: 5,761
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
Extract data points from garmin into .xml?
I'd like to extract every data point from my 305 and put it in a spredsheet. I can't seem to figure out how to do this...is it possible?
I want to run some stuff through SPSS, because i'm bored and nerdy like that.
I want to run some stuff through SPSS, because i'm bored and nerdy like that.
04-02-09, 05:55 PM
#2
Member
Join Date: Mar 2009
Location: Mississauga, Ontario
Posts: 26
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
You can export your workouts from Garmin Training Center to a TCX file which is just an XML file. Open it up with excel and bingo bango.
04-02-09, 05:57 PM
#3
Banned.
Thread Starter
Join Date: May 2005
Location: Woodstock
Posts: 5,761
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
04-02-09, 10:44 PM
#5
Banned
Join Date: Sep 2005
Location: Santa Barbara, CA
Posts: 28,387
Bikes: Specialized Tarmac SL2, Specialized Tarmac SL, Giant TCR Composite, Specialized StumpJumper Expert HT
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 2 Times
in
2 Posts
The TCX file format isn't horrible except for the way it stores power data. XML is general is a pain in the ass to work with, it's hard to store a lot of data without a ridiculous amount of overhead.
04-03-09, 06:33 AM
#6
NYC
Join Date: Sep 2006
Posts: 3,714
Mentioned: 18 Post(s)
Tagged: 0 Thread(s)
Quoted: 1169 Post(s)
Liked 107 Times
in
62 Posts
XML CAN be quite simple, though it will never be space efficient.
Garmin, however, has done some very ugly things in it's XML use.
Try editing a defined workout file directly and you'll see what I mean.
Why would anyone do such a thing? Well in my case because the 705 interface is painful to use, and the training center software crashed and won't sync because it doesn't understand power zones.
Garmin, however, has done some very ugly things in it's XML use.
Try editing a defined workout file directly and you'll see what I mean.
Why would anyone do such a thing? Well in my case because the 705 interface is painful to use, and the training center software crashed and won't sync because it doesn't understand power zones.
04-03-09, 06:59 AM
#7
Senior Member
Join Date: Sep 2008
Location: Just this side of insanity.
Posts: 575
Bikes: Too many
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 1 Post(s)
Likes: 0
Liked 0 Times
in
0 Posts
The TCX is at least fully defined, so you can write a quick DTD to extract out the salient parts. There's a lot of redundent data in the file though, so it is pretty ugly to look at raw.
