Swim File CSV Upload

258 views
Skip to first unread message

ABE79

unread,
Sep 25, 2019, 4:11:19 PM9/25/19
to golden-cheetah-users
I have a CSV file I have exported from a Moov Now which I use for pool swims (a shorter example file is attahced).
I am looking for the easiest way of uploading this file, whilst preserving as much of the data as possible. 
I know I can create a manual entry and use the lap editor but this is timeconsuming for a 3000m + swim in a 25m pool. 
I've also tried playing around with the editor but can't seem to get it to work.
So is there any way I can edit the headers in the attached file or edit it in some other way so that I can simply import it, as I'm sure this will be quicker than manually entering each lap?
Thanks


Swim_Sep 23 2019 at 6 33 am.csv

Ale Martinez - No direct email please

unread,
Sep 26, 2019, 1:10:14 PM9/26/19
to golden-cheetah-users
The existent CSV importer works with periodic samples not with lengths of variable duration.
Probably would be interesting to allow the import of XData from CSV files but it is not currently available.
Without changing GC code the alternative would be to convert the CSV file to a JSON file, I attached a sample swim file including only length data, the initial boilerplate is mostly fix and the length data is easy to transform: the main difference is we don't have a pause after each length but an additional "length" with type=0 meaning pause marking the pause after a series of lengths which also triggers a lap/interval.
Once this file is imported you need to use Edit > Fix Lap Swim to generate the second by second samples and intervals, this step can be automated.
sample_swim.json

Ale Martinez - No direct email please

unread,
Oct 10, 2019, 10:24:53 PM10/10/19
to golden-cheetah-users
In the next build you could import this file after some transformation, here is how it looks your file modified for import: https://github.com/GoldenCheetah/GoldenCheetah/blob/master/test/swims/2019_09_23_06_33_00.csv, after import it is necessary to set Sport=“Swim” and to run Edit > Fix Lap Swim specifying the pool length to generate second-by-second data and laps.


El miércoles, 25 de septiembre de 2019, 17:11:19 (UTC-3), ABE79 escribió:

ABE79

unread,
Oct 11, 2019, 9:23:31 AM10/11/19
to golden-cheetah-users
Thanks for this, that's fantastic.
Reply all
Reply to author
Forward
0 new messages