Import workout from .csv

Please add feature and function requests for PM3 firmware, DLL/API's, and documentation here.
Post Reply
slowButSure
Paddler
Posts: 2
Joined: May 22nd, 2015, 5:10 am

Import workout from .csv

Post by slowButSure » May 22nd, 2015, 5:32 am

I would like to synchronize the Concept2 logbook with Garmin Connect so that I can use the reporting tools on the logbook, and have all rowing related activities logged in one place.

I use a logcard so all my indoor rowing sessions are uploaded. I only need to import water training.

Ideally this would all be automatic, but perhaps the simplest lowest cost solution is to take the .csv export from the Garmin activities page and load all activities where "Activity Type" is "Rowing", and create corresponding new activities in the log book. The additional data on speeds, HRs, calories etc. could be added into the comment box after the activity name. This could also be easily extended to allow other formats to support synchronisation with other services.

The .csv file looks like this (the upload in this forum doesn't accept .csv files):
Activities by garminUserName

Favorite,Activity Name,Activity Type,Event Type,Course,Start,Time,Distance,Elevation Gain,Avg Speed(Avg Pace),Max Speed(Best Pace),Avg HR,Max HR,Avg Power,Calories,
false,Thu 8+ boat name,Rowing,Training,Boat club to mile stoop,"Thu, 21 May 2015 5:56 AM",1:13:15,18.02,26,15,25,140,180,200,850,

User avatar
Citroen
SpamTeam
Posts: 6727
Joined: March 16th, 2006, 3:28 pm
Location: A small cave in deepest darkest Basingstoke, UK

Re: Import workout from .csv

Post by Citroen » May 22nd, 2015, 8:51 am

You may be able to write a program to log in and screen scrape http://log.concept2.com/log.asp but there is NO API for doing it any other way.

Manual entry is probably your easiest option.

slowButSure
Paddler
Posts: 2
Joined: May 22nd, 2015, 5:10 am

Re: Import workout from .csv

Post by slowButSure » May 22nd, 2015, 1:39 pm

I've been doing that for a couple of years now, and making mistakes.

Do you mean no published API - the Concept2 Utility uploads somehow?

User avatar
Citroen
SpamTeam
Posts: 6727
Joined: March 16th, 2006, 3:28 pm
Location: A small cave in deepest darkest Basingstoke, UK

Re: Import workout from .csv

Post by Citroen » May 22nd, 2015, 1:49 pm

slowButSure wrote: Do you mean no published API - the Concept2 Utility uploads somehow?
Correct, there's no public API, the C2 utility uses a hidden proprietary API.

Post Reply