Import workout from .csv
Posted: 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,
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,