Bulk export of WKO data

Discussion in 'Power Training' started by liversedge, Aug 15, 2009.

  1. liversedge

    liversedge New Member

    Joined:
    Jun 28, 2004
    Messages:
    32
    Likes Received:
    1
    Hi Everyone,

    After a couple of months of intense activity and testing I am now releasing my wko to csv converter to the world. Pre-compiled binaries for Windows, Linux and OS X are available and the program has been tested on over 1,200 files from users of Powertap, SRM, Garmin, iBike, Ergomo, Polar, Computrainer and Velotrons and it succesfully extracted all graph data from all files parsed.

    It is an open-source command line tool and available from https://sourceforge.net/projects/wko2csv

    I do hope you find it useful, and if you find it doesn't work for your files then pm me and I'll take a look.

    Thanks,
    Mark
     
    Tags:


  2. SolarEnergy

    SolarEnergy New Member

    Joined:
    Aug 15, 2005
    Messages:
    1,503
    Likes Received:
    0
    Wow great. Thanks a lot for sharing this as an open source project.

    What does it do?
     
  3. liversedge

    liversedge New Member

    Joined:
    Jun 28, 2004
    Messages:
    32
    Likes Received:
    1
    Because WKO stores data in a proprietary format you need to export it to an open format to use in other programs. The WKO+ export function will only let you do one file at a time. In addition, the output files it creates are less than ideal since they reduce completeness, accuracy or fidelity in one way or another.

    My program allows you to convert WKO binary files in bulk (i.e. lots of files at a time) to a text based Comma Separated Variable format. It exports ALL data and does not lose fidelity or accuracy during the export.

    If you have a large amount of historic data or you coach athletes who use WKO this tool may be very useful. Its also useful to have a backup of data in a format you know will be readable by any program.
     
  4. SolarEnergy

    SolarEnergy New Member

    Joined:
    Aug 15, 2005
    Messages:
    1,503
    Likes Received:
    0
    I am very glad. I will give it a try soon and reply back.

    Congratulations for the new baby boy !
     
  5. marc66thomas

    marc66thomas New Member

    Joined:
    Sep 13, 2009
    Messages:
    4
    Likes Received:
    0
    Mark

    I'm trying your wko 2 csv and i wonder if I'm asking too much.
    I want to take the directory and the 255 WKO files to get 255 csv's
    will you tool do that?

    I'm using Ubuntu Linux and it appears that I dont have the syntax correct for the app.
    do you have a "terminal command" line for me to try? does the app also out put a log when done? (if errors occur.)

    Thank you for your hard work on this It's exactly what I was looking for!
    Marc :)
     
  6. marc66thomas

    marc66thomas New Member

    Joined:
    Sep 13, 2009
    Messages:
    4
    Likes Received:
    0
    Mark

    I'm trying your wko 2 csv and I wonder if I'm asking too much.
    I want to take the directory and the 255 WKO files to get 255 csv's
    will you tool do that?

    I'm using Ubuntu Linux and it appears that I dont have the syntax correct for the app.
    do you have a "terminal command" line for me to try? does the app also out put a log when done? (if errors occur.)

    Thank you for your hard work on this It's exactly what I was looking for!
    Marc :)
     
  7. liversedge

    liversedge New Member

    Joined:
    Jun 28, 2004
    Messages:
    32
    Likes Received:
    1
    For sure.

    I would create a new directory and copy all the wko files you want to convert into it, cd to it and then

    wko2csv *.wko

    should run through each wko and create a .csv file. You might want to download the latest stable binary distribution since I recently fixed support for more device types.

    Regards,
    Mark
     
  8. marc66thomas

    marc66thomas New Member

    Joined:
    Sep 13, 2009
    Messages:
    4
    Likes Received:
    0
    So here is where I admit I'm over my head with Linux (Ubuntu).
    I created a directory named "csv" used your suggested commands (next line)
    " [email protected]:~/csv$ wko2csv *.wko "
    " bash: wko2csv: command not found "

    I must have not installed the application correctly as it's not a recognised command.

    I tried to put the app in the same directory too. no luck.
    I'm back to the "read me.txt" for another read through.
     
  9. liversedge

    liversedge New Member

    Joined:
    Jun 28, 2004
    Messages:
    32
    Likes Received:
    1
    You were sooooooo close. If you put the program in the same directory then when you ran it you just needed to use "./wko2csv *.wko" (the PATH environment variable does not include the current directory, use "echo $PATH" to see where it does look for programs. If there is a /usr/local/bin or similar then copy wko2csv into that directory and the "./" will not be required.

    Let me know how you get on?

    Cheers,
    Mark
     
  10. marc66thomas

    marc66thomas New Member

    Joined:
    Sep 13, 2009
    Messages:
    4
    Likes Received:
    0
    That hand holding was what I needed. Thank you it worked. Saying good bye to vista hello to Ubuntu. Nice. Might you comment on this error? I got a few files with errors. "ERROR: T_marc_11_20_2008a.wko contains no GRAPHS"
     
  11. liversedge

    liversedge New Member

    Joined:
    Jun 28, 2004
    Messages:
    32
    Likes Received:
    1
    The file in question is almost certainly a manual entry and contains no data to export. Glad you got it working in the end.
     
  12. dberger

    dberger New Member

    Joined:
    Jan 27, 2010
    Messages:
    1
    Likes Received:
    0
    Hello - I'm trying to use your software and I have a couple questions. #1 - I can get the program to load. I'm using Windows XP v.5.1. I browse from the command line (Run) and the program just 'blips' up for a fraction of a second the disappears. Any ideas?

    #2 - I'm hoping that when I export to excel I will get these data fields: Date / Distance / Time / Energey (kj) / Avg Pwr / Comments. Will I get these fields?

    Thanks!
    David
     
  13. radicalvelo

    radicalvelo New Member

    Joined:
    Aug 11, 2011
    Messages:
    1
    Likes Received:
    0
    Hey,

    Thanks for this, I notice you are also a contributor to GoldenCheetah. I ran your wko2csv program and then realized GoldenCheetah has this same program built in.

    My issue is that a vast majority of my .wko files are being Skipped when I run wko2csv in command prompt. So far the only way for me to covert each file is to individually export each file from TrainingPeaks WKO+ as a .csv file.

    Any help on this situation would be greatly appreciated.

    Thanks!!!!!!
    Gavi
     
  14. ironrob

    ironrob New Member

    Joined:
    Feb 20, 2012
    Messages:
    1
    Likes Received:
    0
    Thanks, this sounds incredibly useful. One quick question, does it also export the workout notes and workout goals fields?

    Thanks,
    rob
     
Loading...
Loading...