Bulk export of WKO data

View Full Version : Bulk export of WKO data

liversedge

SolarEnergy

Wow great. Thanks a lot for sharing this as an open source project.

What does it do?

liversedge

Wow great. Thanks a lot for sharing this as an open source project.

What does it do?

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.

SolarEnergy

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.

I am very glad. I will give it a try soon and reply back.

Congratulations for the new baby boy !

marc66thomas

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

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 :)

marc66thomas

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

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 :)

liversedge

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 :)
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

marc66thomas

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

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)
" marc@ubuntu:~/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.

liversedge

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)
" marc@ubuntu:~/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.

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

marc66thomas

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

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"

liversedge

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"

The file in question is almost certainly a manual entry and contains no data to export. Glad you got it working in the end.

Automatic Translations (Powered by

Translations made by vBET 3.2.2