Lemond Revolution Power Pilot - Convert csv files to tcx (2 methods for Windows users)

[Rick Simi]

Convert Lemond Revolution csv data files to tcx (strava.com and connect.garmin.com compatible)

 

Below are two methods to convert Lemond Revolution csv data files to tcx (compatible with strava and connect.garmin.com, among others).

Method A is via an excellent Python script written by Thomas O’Dowd (requires the installation of Python program) and Method B is a multistep procedure via  available free utilities (also requires some installation such as training peaks device agent and goldencheetah, but Python is not needed). Method A is the superior and much easier method. Method B is useful to see how traininpeaks and goldencheetah can crunch and summarize your ride data.

 

1. With Python (Instructions). This method will display speed, power, cadence, HR, and Time data correctly.

    

   Mac instructions provided via following link: https://groups.google.com/forum/#!msg/lemondrevolution/L0tFZ9yUINc/yVVuMPFHAXYJ

    

   Windows Instructions:

   Requires Lemond Revolution firmware version 63): 

1. Install python 3.4.3 (Compatible with Python 2.6, 2.7, 3.2, 3.3 or 3.4.3). It will not work on Python 2.5

   https://www.python.org/downloads/

    

2. Download lemondcsv.py from https://github.com/tpodowd/lemondcsv (if you don’t want to sync the files to your desktop then left click the lemondcsv.py file, click Raw, and then copy and paste the contents to notepad and save the file with the name lemondcsv.py. To verify, the beginning of the file should be as follows:

 

#!/usr/bin/env python

# Copyright (c) 2013 Thomas O'Dowd

     

Copy (or save) the lemondcsv file to c:\python34 and also your Lemond Revolution csv data files to same folder.

 

1. Open command prompt window (click start and type cmd, then press Enter key)

2. In the cmd prompt window, change to c:\python34 folder (i.e. type cd c:\python34 and press Enter key)

3. Now execute the conversion script, below example assumes your Lemond data file is named warmup.csv – I changed the original csv file name)

   1. C:\Python34\python lemondcsv.py warmup.csv (a tcx will be created in this same folder to upload to strava, or connect.garmin.com, to name a few)

------------------------------------------------------------------------------------------------------------------------------------

B. Overall steps without python program: (This method will not display speed data in Strave, but correctly displays, HR, Cadence, Power, and Time data. connect.garmin.com displays all the data correctly)

1. Import LeMond Revolution .csv file into trainingpeaks.com via their Device Agent utility (must be installed (save the installation file before running it) prior to creating a trainingpeaks account),

2. export the .gz file from trainingpeaks.com and extract it (.pwx) via a 3^rd party program or free online utility (www.wobzip.org).

3. Import the .pwx file into goldencheetah and export to a tcx where it then can be imported into a number of programs (including connect.garmin.com and strava.com)

 

Detailed 1^st time steps without python program (same as B. above, but more detail):

1. Install free version of golden cheetah at http://www.goldencheetah.org/. This is a program that needs to be installed (PC or MAC).
2.  Create a free account at trainingpeaks.com
3. Install TrainingPeaks Device Agent (be sure to save the file before running it): http://help.trainingpeaks.com/hc/en-us/articles/204073144-Installing-Device-Agent
4. Via trainingpeaks Device Agent, drag csv lemond file to Device Agent. Then export the file (compressed gz file).
5. Run Device Agent

1. Drag Lemond Revolution file to Device Agent window

2. Click Save, when finished click login

3. From the calendar view, click on the workout that was uploaded, click files, click download and save to disk (note that the file is a compressed gz file and must be uncompressed (extracted)

6. Extract training peaks gz files (follow instruction at this link – this is an online utility, no need to install anything):

http://www.wobzip.org/

7. Import the extracted training peaks pwz files and export to tcx for strava via link below:

http://goldencheetah.org

1. Launch goldencheetah program

2. After creating your profile, click Activity, Import from File and browse to the pwx file that was extracted in step 3.

3. Confirm date and time from prompt (e.g. last tue – optionally change the time to when you did the activity)

4. Click Save, then finish

5. Click Activity then Export and change the file type to Garmin Training Center TCX and type in a name for the file to be save

6. You can now import this .tcx file into connect.garmin.com or www.strava.com. Note that connect.garmin.com will display speed, cadence, hr, time and power data but strava only shows hr and power. Even if you export a new tcx file from connect.garmin.com, strava still does not display speed correctly.