Page 1 of 1
Software to export to .csv
Posted: Sat Mar 14, 2009 2:33 pm
by cjonbike
I now use a wired mount so can not use a heart rate monitor, but do have a Garmin Edge 705. does anyone know a software I can get that would import from thhe 705 or import the .tcx file, then export to a .csv file in 1 second increments like the iBike .csv so I can transpose the HR date over to the ibike .csv file?
I do thank you for your help and time
Chris
Re: Software to export to .csv
Posted: Sat Mar 14, 2009 5:04 pm
by lorduintah
If you have a Mac computer there is a software program called Ascent (
http://www.montebellosoftware.com/index.html) - reads the 705 directly and will export a .csv file.
I think I ran across a PeeCee version of some software that will oblige - cannot remember where, sorry. Somebody else on the forum will have to help you out.
Tom
Re: Software to export to .csv
Posted: Sun Mar 15, 2009 1:13 am
by racerfern
cjonbike wrote:I now use a wired mount so can not use a heart rate monitor, but do have a Garmin Edge 705. does anyone know a software I can get that would import from thhe 705 or import the .tcx file, then export to a .csv file in 1 second increments like the iBike .csv so I can transpose the HR date over to the ibike .csv file?
Chris
Try using the "Merge signals from another ride file" function.
First, Open the tcx file in any xml editor. I use foxe from
www.firstobject.com . Search and replace all "</Track><Track>" the stuff inside the quotes with nothing. Save the file with a new file name.
Now use the Merge signals function and select the HR box to merge the data into the csv file. That's it.
If you need more detailed instructions just ask.
Re: Software to export to .csv
Posted: Sun Mar 15, 2009 10:27 am
by cjonbike
Thank you gentlemen for the replies
I have Windows so the Ascent will not work yet, Oh well
Will play with the XML editor and merg signals option, tried once but it played with my power data to so I have to find what I did wrong, but will get it.
Thanks so much
Chris
Re: Software to export to .csv
Posted: Sun Mar 15, 2009 12:50 pm
by cjonbike
Fernando
I do have a question or 2 if I could impose I am using Foxe to get into the xml file, here are my questions, you said to search for </track><Track> and replace everything in between these with nothing
<Track> is the beginning and </Track> is the end of the group so I want nothing in between the groups or in between these 2 tags? For example
<Track
<TrackPoint>
Whatever
</TrackPoint>
</Track>
<Track>
<Trackpoint>
whatever
</TrackPoint>
</Track>
So I make sure there is nothing between the </Track><Track> or do I delete everything between the <Track></Track>?
I do Thank you for your help and patience I am a bit slow
Chris
Re: Software to export to .csv
Posted: Sun Mar 15, 2009 4:10 pm
by cjonbike
I went for another ride today and ran the steps you wrote and it worked like a charm, I must have corrupted one of the files I was using earlier.
I Thank you a bunch
Chris
Re: Software to export to .csv
Posted: Sun Mar 15, 2009 4:27 pm
by racerfern
You actually delete </Track><Track>
There is nothing between those two tags. You actually delete the tags.
Re: Software to export to .csv
Posted: Mon Mar 16, 2009 7:14 am
by cjonbike
Thanks a bunch Fernando I completely read your first post wrong, it does make sense and works perfectly
Chris