Software to export to .csv

Post Reply
cjonbike
Posts: 113
Joined: Sat May 03, 2008 1:37 am

Software to export to .csv

Post 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
User avatar
lorduintah
Posts: 668
Joined: Fri Jan 11, 2008 9:37 am
Location: Plymouth, MN

Re: Software to export to .csv

Post 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
User avatar
racerfern
Posts: 1356
Joined: Fri Jan 11, 2008 12:47 am
Location: Baldwin, NY
Contact:

Re: Software to export to .csv

Post 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.
Fernando
cjonbike
Posts: 113
Joined: Sat May 03, 2008 1:37 am

Re: Software to export to .csv

Post 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
cjonbike
Posts: 113
Joined: Sat May 03, 2008 1:37 am

Re: Software to export to .csv

Post 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
cjonbike
Posts: 113
Joined: Sat May 03, 2008 1:37 am

Re: Software to export to .csv

Post 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
User avatar
racerfern
Posts: 1356
Joined: Fri Jan 11, 2008 12:47 am
Location: Baldwin, NY
Contact:

Re: Software to export to .csv

Post by racerfern »

You actually delete </Track><Track>
There is nothing between those two tags. You actually delete the tags.
Fernando
cjonbike
Posts: 113
Joined: Sat May 03, 2008 1:37 am

Re: Software to export to .csv

Post by cjonbike »

Thanks a bunch Fernando I completely read your first post wrong, it does make sense and works perfectly

Chris
Post Reply