I have a New Year’s resolution to rid myself of the MapMyRun (UnderArmor) vendor lock in I’ve created with my workout data. I’ve stored all of my bikes, runs, swims, etc on the site over the past few years and a have a couple thousand workouts on there which I have been able to bulk export into a rather useless CSV file. Has anyone else been able to get one of these files imported into something else?
Also, where’s the best place to store my data these days if it is just to be used by me? (IE I don’t have a coach and use it historically to determine which training approaches were more effective and to aggregate total mileage)
I want to have it all on Strava and usually run the app when I have my phone on me but would I better off using the free version of TrainingPeaks or some other repository? I currently use both my phone and / or my old school Timex Global Trainer to track workouts.
I like to look back by week and month to determine what I was doing in prior weeks / months to see how I’m trending. Should I just abandon the old data and start fresh?
You’re always going to be dependent on someone else as long as you continue to import/rely on third party providers (i.e. Strava, Trianing Peaks, MapMyRun, Garmin Connect, etc.) to keep/organize your data.
I keep the “master” record of all my training in a simple excel spreadsheet file. Over the years I’ve made many tweaks to it to reflect how I like to use the data. I am by no means an excel expert. Other than this file the only other file I use on a regular basis is a monthly budget file. Btw, that csv file you have is easily imported into excel.
To be sure, I use some third party providers such as Garmin and Strava but they are more for entertainment purposes only and I don’t consider them a true refelction of my training history.
I’m using Tapiriik (https://tapiriik.com/) to sync my garmin account with dropbox, that way I’ll always have a .tcx file on my side. I’m not sure if it support MapMyRun though, and I’ve only found how to export from MapMyRun to a standardized file one-by-one (http://www.mikepalumbo.com/MMRConverter/).
Unless you want to use the spreadsheet approach, you’re beholden to some provider who normalizes workout data in a database. Which provider becomes a question of stability - there’s certainly nothing wrong in that regard with MapMyFitness, they’re a robust solution. However, if you’re not getting the view you want to look at historical trends, then it’s not such a good place for it. On your own it sounds like the csv file isn’t going to cut it for you. There is a developers API running behind mapmyfitness that allows you to get your data out programmatically and serialize it however you need it, but I suspect that might not be in your wheelhouse. If you don’t doing it workout by workout you can seed Strava with MapMyFitness data using this: http://www.mikepalumbo.com/MMRConverter/index.php and then cut over to Strava long term. Unfortunately tapiriik doesn’t support MapMyFitness (yet).
I’ve actually been working on a tool that would solve your problem at least part of the way (you’d become dependent on that database though), but it doesn’t support anything but Suunto, Strava, and Garmin as of today.
I keep it on an Exchange server. Past 7 years worth of training data accessible from Office apps, and mobile devices, and through a web service. Obviously this approach is only useful if you are an IT geek.
Unless you want to use the spreadsheet approach, you’re beholden to some provider who normalizes workout data in a database. Which provider becomes a question of stability - there’s certainly nothing wrong in that regard with MapMyFitness, they’re a robust solution. However, if you’re not getting the view you want to look at historical trends, then it’s not such a good place for it. On your own it sounds like the csv file isn’t going to cut it for you. There is a developers API running behind mapmyfitness that allows you to get your data out programmatically and serialize it however you need it, but I suspect that might not be in your wheelhouse. If you don’t doing it workout by workout you can seed Strava with MapMyFitness data using this: http://www.mikepalumbo.com/MMRConverter/index.php and then cut over to Strava long term. Unfortunately tapiriik doesn’t support MapMyFitness (yet).
I’ve actually been working on a tool that would solve your problem at least part of the way (you’d become dependent on that database though), but it doesn’t support anything but Suunto, Strava, and Garmin as of today.
Funny enough this is in my wheelhouse. My question may have been a bit lazy but I wanted to know of anything off the shelf. I suppose I can write something to extract all my data one a workout by workout basis using the ID’s I’ll get by stripping them from the CSV. I just was hoping someone else had already solved that problem for me. I guess I can put this out on github for others when done but that won’t happen today.
I’m using Tapiriik (https://tapiriik.com/) to sync my garmin account with dropbox, that way I’ll always have a .tcx file on my side. I’m not sure if it support MapMyRun though, and I’ve only found how to export from MapMyRun to a standardized file one-by-one (http://www.mikepalumbo.com/MMRConverter/).
Tapiriik looks pretty cool do you know if they are adding MapMyFitness support too?
I use Strava and BeginnerTriathlete’s workout logging tools. It runs some pretty good reports out of it and allows me to compare months, weeks, etc… over many years for comparison.
bike data is stored in WKO+
I back the files up to an external drive, and the cloud
it is a common enough format that you aren’t locked into WKO+
others can import it
Ooof.
WKO+ file format is a proprietary (secret) binary (bit level) file format that can only be read by Raceday and GoldenCheetah.
I wouldn’t advise anyone used that as a long-term format – better to use one that is at least xml or json.
So I’ve got 4 programs that I can use to export WKO+ into other formats that already exist, two of which I own already
and it is only marginally harder for me to write my own program to export it ,if I had to, than XML would be. possibly easier.
I’m good =)
bike data is stored in WKO+
I back the files up to an external drive, and the cloud
it is a common enough format that you aren’t locked into WKO+
others can import it
Ooof.
WKO+ file format is a proprietary (secret) binary (bit level) file format that can only be read by Raceday and GoldenCheetah.
I wouldn’t advise anyone used that as a long-term format – better to use one that is at least xml or json.
and it is only marginally harder for me to write my own program to export it ,if I had to, than XML would be.
I’m sorry Jack but that is just so incredibly wrong … unless you are going to reuse the GoldenCheetah code ?
It is a seriously complicated and difficult to read binary, bit packed file format.
Aww man, if that’s your thing, you should branch off tapiriik and do it for him there. Why roll your own? Probably take you 30 minutes to script the whole thing in python.
Fortunately I have some training and experience in this field.
Of course I am partly exaggerating. The presence of xml parsing libraries makes XML easy to parse.
CSV would be easiest of all =)
It is a seriously complicated and difficult to read binary, bit packed file format.
and it is only marginally harder for me to write my own program to export it ,if I had to, than XML would be.
I’m sorry Jack but that is just so incredibly wrong … unless you are going to reuse the GoldenCheetah code ?
It is a seriously complicated and difficult to read binary, bit packed file format.
I basically decided to use 2 vendors for added redundancy. I use GarminConnect and Strava which now syncs off of GarminConnect. This way if one of them goes tits up, I will still have my data available.
With some basic perl or python, you can crawl either site’s pages and export everything pretty easily as the others pointed out. This will give you the raw data as well via .tcx files.
Aww man, if that’s your thing, you should branch off tapiriik and do it for him there. Why roll your own? Probably take you 30 minutes to script the whole thing in python.
I’ll work on calling their RESTful service and seeing what comes out of it. We’ll see how much they return. I’d like all of the HR data and map stuff too. I’ll contribute it back if I determine what I have is not crap.