[Golden-Cheetah-Users] Merging rides???

844 views
Skip to first unread message

Jamie Kimberley

unread,
Apr 22, 2010, 9:37:24 PM4/22/10
to golden-che...@googlegroups.com
All, I had my garmin display lock up on me today and I was able to
powerdown and maintain all of my data, but the ride ended up getting
split in two. I have imported the fit files and exported to .gc,
and am wonding if there is an easy way to merge the data into one
continuous ride. I'm not good with XML, but it seems that all i
need to do is add an offset time in seconds to each datapoint. I
could probably cobble something together in AWK but I figure that
I'd ask here to see if anyone had an easy way to handle this.

Thanks,
Jamie

"You don't use science to show that you're right, you use science to
become right."--xkcd
__________________
Jamie Kimberley
Postdoctoral Fellow
Department of Mechanical Engineering
The Johns Hopkins University
Office: 410.516.5162
Mobile: 217.621.8272
Fax: 410.516.4316
E-Mail:jamie.k...@jhu.edu

--
_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en

Brendan

unread,
Feb 7, 2011, 4:21:40 PM2/7/11
to golden-che...@googlegroups.com
Did you ever find a solution to this?  I tried this path:  Garmin connect > export TCX > import into GC > export to CSV > import into EXCEL ...  with hopes of getting it BACK into GC with power adn torqu computed in Excel manually (power was not recording during the ride) but there seem to be issues with excel reading the numbers in properly.

i.e. it will take cadence values and forget the decimal point for a few records (85.43, 86.10, 874534, 887654, 86.38 ...)

Mark Liversedge

unread,
Feb 7, 2011, 4:30:56 PM2/7/11
to golden-cheetah-users
The ride editor will let you cut and paste columns and rows ... if you
paste special you can choose 'overwrite' and select columns to ignore
or reassign them to other data series. I did this as a poor man's
merge, basically copying what I was doing with excel myself.

A more sophisticated merge would try and align with a common data
series like time, distance or even better gps... Robert Carlsen posted
something along these lines recently.

Damien Grauser

unread,
Feb 7, 2011, 4:58:27 PM2/7/11
to Mark Liversedge, golden-cheetah-users
I have a patch with a special menu to merge 2 files.
You can choose for each "canal/column" what you keep in the final ride file.

In this screen shot I have 2 files from the same ride, one with GPS and one without.screen2011-02-07.png
I can keep all datas from my Joule file and add GPS from my GPS unit.

But I have to choose how to manage with different recording rates and propose different options to "synchronise" time of the 2 files (started at the same time, same clock time or choose a delay) 

I hope to found time to finish this patch soon.

Damien


2011/2/7 Mark Liversedge <liver...@gmail.com>
screen2011-02-07.png
screen2011-02-07.png
Reply all
Reply to author
Forward
0 new messages