Import Rowing workouts to Strava from the Concept2 log

For those of us who split their time between rowing running and cycling it would be great to have all this on strava.

97

Comments

119 comments
  • This is my second Premium trial, and I see this is still not working. I'll try Premium for 30 days, and I'll be out again. I do both rowing and cycling, and want pay for the service before Concept2 logs are synced with Strava.

    Also, how do you edit an existing row? I don't find out how to edit metres.

    Otto

    1
    Comment actions Permalink
  • Yes please STRAVA. Can't believe you don't support Concept2 considering how many of us use them. Surely a lost opportunity.

    1
    Comment actions Permalink
  • bump - seriously... a tremendous oversight. this would bigly be appreciated. 

    0
    Comment actions Permalink
  • I just don't think strava care at all. Two years!!

    0
    Comment actions Permalink
  • +1 for this

    0
    Comment actions Permalink
  • A generous community member has created and shared a site to sync Concept2 data with Strava: https://rowsandall.com/ 

    We are looking into this, but as is normal with the beginning stages of any investigation, I can't say where we'll land in terms of implementing features to support Concept2 indoor rowing data on Strava. To be determined. 

    Here is what I've learned from a little research so far - please chime in and add any information that might help us move forward with this project. 

    The Concept2 Logbook uses the file format CSV. Can anyone attach such a file to this discussion? 

    If using one of the Performance Monitors (PM) to record data from the Concept2 machine, you can upload the files to the Logbook using a USB drive. 

    If using the ErgData mobile app (iOS/Android), certain recent models of the PM (3, 4, 5) can upload the data via Bluetooth to the app, which then can upload the data to the Concept2 Logbook via the app. 

    There is an API for the Logbook, but after a quick look there doesn't appear to be any API calls to export Concept2 Logbook data, which would be needed to send data to Strava. 

    If there is a way to send Logbook data to Strava via the API, there would need to be extra development to then display the Concept2 data in Strava in a meaningful way. What data, metrics, or graphs are most important to you? Can anyone attach screenshots that illustrate how Concept2 or ErgData display such data? 

    Tarun Shome seems to have found a workaround to upload Concept2 data to Strava, but I'm curious to know more about the step described after exporting a CSV from Concept2, where the file is then uploaded to Runkeeper via the ErgData app? 

    Thanks for the help! 

     
    0
    Comment actions Permalink
  •  HI Elle,

    Great that you are looking at this.

    Re your questions:-

    1. see below a screenshot of how the Concept2 Log data is displayed for an individual workout

    2. I can send you CSV files for a season summary (one line per workout), and an individual workout (looks like one line per stroke), but can't immediately see how to attach a file to this page? I have emailed them to you via Strava Support.

    3. I would be most interested in seeing the following metrics:

    * Distance

    * Time

    * Pace - ideally per 500m as concept2 display it, but any other format would be fine

    * Heart rate (average and ideally a graph)

    * Power (average and ideally a graph)

    Secondary level of priority for me would be:

    * Strokes per minute (SPM) - analagous to cadence for cycling so might fit with your existing model?

    * Splits info

    Happy to help with any other info if you need anything else

    Paul

     

     

     

    2
    Comment actions Permalink
  • P.S. Elle - I have had a quick look at the API documentation.

    It appears to support get commands for

    1. An individual result : GET /api/users/{user}/results/{result_id}

    2. A date range: GET /api/users/me/results?from=2015-05-01&to=2015-05-31&type=rower

    3. All results for current user : GET /api/users/{user}/results

    So perhaps no need to go via CSV?

    Paul

    1
    Comment actions Permalink
  • Thanks Paul, I got the files and the screenshot and will add them to the information I'm compiling for the development team. 

    As for the API calls, I also saw those calls for results, but to me that means the results from a leaderboard or a challenge, as Concept2 seems to host, and not for the data of a single rowing activity with the metrics you listed as #3 above. However, that's just my assumption. 

    1
    Comment actions Permalink
  • Hi Elle,

    The API refers to ability to get & post "workouts", which looks to me to be a single rowing activity. See this screenshot which shows my workouts (uploaded from ergdata) - it also has a manual 'Add workout' form which is for an ordinary rowing activity. The 'Post' documentation has a list of fields which also matches what i would expect to see for a single rowing activity.

    Btw, the leaderboards are determined in concept2 by manually choosing your best effort - this is the 'Rank' / 'Unrank' button. So like strava PRs/KOMs but for some reason they you have to manually decide which workouts to rank (maybe to make the data processing of the leaderboards simpler for them?).

    The challenges look similar to strava challenges, i.e. how much you can row between two pre-defined dates, etc. There is a separate GET call to get a list of challenges from the API.

    For strava integration I would say that leaderboard / challenges are not relevant, it is the individual workouts that matter, and if you can take it this far there is also a 'Stroke data' GET command which I am guessing is the equivalent of the CSV result detail file I sent you.

    Also I notice they use result_id as the unique identifier in the documentation - which matches the name of the CSV result detail file I sent you - I would guess the number in the filename is the result_id for that particular workout.

    Paul

     

     

     

     

    1
    Comment actions Permalink
  • Elie, you could also use the BT API for iOS and Android and directly include it in the Strava App. So, you could display data from the PM5 and directly send the data session to Strava.

    2
    Comment actions Permalink
  • * Distance

    * Time

    * Pace - ideally per 500m as concept2 display it, but any other format would be fine

    * Heart rate (average and ideally a graph)

    * Strokes per minute (SPM) - analagous to cadence for cycling so might fit with your existing model?

    Thanks for looking into it!

    Huub

     

    1
    Comment actions Permalink
  • While a lot of these ideas are good, I would vote for (initially) just being able to see the workouts.  I would hate to see it get shelved again for lack of ability to implement advanced features.

    For me, it's a bit of a gamification thing.   I want my strava friends to see my efforts, but what I really want is for them to know that they will not see them if I haven't worked out.  it's motivation to get the data on board to as an incentive to keep working.

    it's also a log of what I've done and if I'm improving.   being able to look back of average pace, heart rate spm, time and distance over time is a nice to to have.

    I hope we can get this worked out.

    3
    Comment actions Permalink
  • I'd put a plug in for wattage given that Strava is probably not going to be able to show speed in the conventional 500m split manner.

    Thanks for picking this up!

    Justin

    1
    Comment actions Permalink
  • Here my comments for your indoor rowing requirement document:

    • Make sure that you define indoor rowing independent of the outdoor rowing (separation of statistics and slightly different requirements in metrics.) 
    • Assume two basic use cases: A) Row fixed time and measure reached distance. B) Row fixed distance and measure needed time. Both are common for indoor rowing (outdoor rowing is dominated by fixed distance as you are more likely to use land marks for training row and fixed course for regattas)
    • Use meter as unit for distance (for outdoor row I would expect x.x km as unit)
    • Measure speed / effort in time / 500 m (for outdoor row I would expect time / km). Other units like watt and calories are secondary and less important, 500 m times is what really counts.
    • Allow a split of an indoor row into sperate time / distance intervals  with individual statistics
    • Virtual regatta: Allow a competition which overlays workouts of individuals and also competitions of crews (sum the workouts of 2, 4 or eight rowers and let them compete against another team)
    • Standard distances: 2000 m, 5000 m, 8000 m, 10000 m, 12000 m, 15000 m
    • Standard times: 20 min, 30 min, 40 min, 45 min, 50 min 60 min, 90 min
    • Make sure that manual input is possible. We may erg in gyms with outdated hardware.
    0
    Comment actions Permalink
  • I just found this thread. I have actually put up an independent site rowsandall.com which can import to and from Concept2 logbook and Strava. 

    The basic functionality of the site is free to use and you can use it to shuttle your workouts from Concept2 logbook to Strava. 

    However, take a few moments to explore some of the other options of the site. It is compatible with most of the  apps that work with the Concept2 PM and caters for "On the water" (OTW) rowers as well. 

    The site is still in beta but already very usable. 

    2
    Comment actions Permalink
  • Thanks Sander R. 

    Have any of you on this thread managed to try https://rowsandall.com/?

    What do the activities look like when they reach Strava? I'm assuming they are still missing a lot of data like strokes that is available on Concept2 Logbook. 

    0
    Comment actions Permalink
  • I tried it, but my logbook records apparently don't have stroke information so rowsandall ignores them completely (they were uploaded to the logbook using the concept2 logbook tool from my PM5 USB card).  Since many of use the PM5 and upload using the standard tools, we only have workout information (distance, time, row/m, pace time/500m, etc.) but don't have detailed stroke information.

    0
    Comment actions Permalink
  • In response to Bjoern:

    Both on the water and on the erg, pace is measured as time/500m. Apart from the use cases you mention, we do intervals (mixed, time based, distance based). Outdoor rowing is NOT dominated by distance. Actually, a lot of workouts are time based because of the lack of landmarks (on lakes). 

    Units like watts are starting to be introduced to Outdoor rowing, and are very important for Indoor rowing.

    Finally, I have experimented with defining "segments" on lakes and rivers, but very often the segment is not recognized. We rowers tend to drift a bit further from the ideal line (we are facing the direction we come from, not where we are going). 

    Ideally, an outdoor segment should be defined by a start line, finish line, and optionally a few buoys that need to be rounded/passed. For example, some of my regular benchmark rows involve a start and finish line on the same part of the lake. From the start I row 3km in a more or less straight line, rounding a buoy and then returning to the start line.

    0
    Comment actions Permalink
  • Elle - 

    Rowsandall.com works great! Everybody in this discussion should take a look. There are tons of useful data visualization features on the site which you should definitely check out (you won't believe what he can do with your data!) but, for purposes of this discussion, the ability to move data between apps/devices to Strava will be of special interest. One can import TCX, CSV, FIT files directly from apps such as ErgData, BoatCoach, RowPro, Painsled and NK GPS2 to rowsandall.com and then export to Strava. Alternatively, one can import C2 Logbook data (files originally uploaded to C2 from ErgData, RowPro, etc.) to rowsandall and then export to Strava. 

    It would be great to have a direct link from apps/devices, even the PM5 itself, to Strava but this is a terrific work-around with many additional capabilities. 

    MM (an enthusiastic user of rowsandall for several months now; not financially involved) 

    0
    Comment actions Permalink
  • Here's a snip of today's workout recorded on BoatCoach, imported to rowsandall.com and exported to Strava. 

    0
    Comment actions Permalink
  • Yes, it only works if you have stroke data. Use ErgData, BoatCoach, RowPro or (I believe) newer version of the C2 utility

    0
    Comment actions Permalink
  • Would it be possible to have the Strava App talk to PM5 (Bluetooth Smart) directly?

    http://www.concept2.com/files/pdf/us/monitors/PM5_BluetoothSmartInterfaceDefinition.pdf

    1
    Comment actions Permalink
  • I am the "generous community member" who created rowsandall.com. 

    The Concept2 logbook has an API. You can get stroke data from the API. I use it to import data to my site, then use the Strava API to get data to Strava (Power, Pace, Cadence, Distance, Time, Heart Rate, etc). 

    There is an app Painsled (www.painsled.com) for iOS, which captures data directly from the PM5, just as ErgData does. It has Strava sync out of the box. 

    ErgData syncs to the Concept2 logbook. You can download a CSV file for an individual workout. Here's an example:

     

    1
    Comment actions Permalink
  • Thanks everyone (and especially Sander R. for the additional insights in your last comment).

    The Strava Product team is tuned in to this discussion, and will assess the potential for a future project. I'll share any updates as they become available. 

    3
    Comment actions Permalink
  • For Garmin users: there is something exiting going on: an IQ app (BETA) for Garmin watches to connect to the PM5

    https://forums.garmin.com/showthread.php?366510-Erg-IQ

    So finally people are working on it from several fronts (watch, Garmin Connect and Strava ) :))

    Great!

     

     

    2
    Comment actions Permalink
  • Strava.... listen the the tortured masses - we need this. make it work.... 

    1
    Comment actions Permalink
  • If any developers want a hand with any of this stuff, I row and write api's. So I'm a pretty good resource if needed.

    2
    Comment actions Permalink
  • Again frustrated by looking at my training log and not seeing a single mile rowed.  Bad enough that you have to manually input Concept2 activities, but then the manually added activities aren't even included in the training log?!  

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post