This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

uploading multiple activities

Former Member
Former Member
After much searching, I've come to the conclusion that there is no method currently available for uploading multiple activities from a spreadsheet (or some other file) to GC. I recently started using a 405 for logging my runs, but I've got many, many runs on the BIMactive website that I'd like to incorporate into my GC activities, at least for 2010. I can create a spreadsheet of the BIM activities, albeit without the GPS routes, but I can't seem to find a way to upload them to GC.

Anyone found a way to do this?

Thanks,
Karl
  • Former Member
    0 Former Member over 14 years ago
    I have an idea that might work. Can you attach a copy of your spreadsheet that shows what kind of data you want to put into GC.
  • Former Member
    0 Former Member over 14 years ago
    Thanks for the response - sorry I've been unable to address this for a few weeks. Right now my data are on the BiM Active site, which I guess is now part of Adidas miCoach. I can download the data from BiM Active and build a spreadsheet having the appropriate fields for import into Garmin. The fields that I can easily download are:

    Activity Type
    Date
    Route (Corresponds to Activity Name on GarminConnect)
    Miles (Distance)
    Time
    Pace (Avg Pace)

    So I can't fill all the fields that show up on the Activities tab in GarminConnect.
  • Former Member
    0 Former Member over 14 years ago
    I have attached a tcx file that will upload manually into Garmin Connect named 2010-09-11_BLANK.tcx

    Before starting I recommend you make a new folder in "My Documents" labeled Training Conversions or something and store the BLANK there. Next you need to know the dates you want to convert. Open the BLANK with "Word Pad" and change the very first date that you see in the document, just below Activity Sport, you can leave the time alone. Then "Save As" with the date you want as year-month-day, remove the word BLANK and be sure to leave the ".tcx" in the new name. You need to have a separate file for each day you want to convert or GC will not upload it.

    After uploading and opening the file with the date you want, click on the pencil icon to the right of the word Summary, not the pencil icon up at the top.

    You will be able to edit everything except the type of gps and coordinate and base elevation. Play with it and see what you think. If you can attach one of your tcx training files I can edit a new BLANK file with info that will match your area and gps. If you only have a gpx file then send it plus the type of gps you have.
  • Former Member
    0 Former Member over 14 years ago
    Thanks for the suggestion. This seems workable although I have about 130 activities that I'd like to upload. It looks like I'll need to write a script to insert the data from my BiM spreadsheet into individual tcx-format files, then upload them individually to GC. Batch upload would be a nice feature!

    Karl
  • Former Member
    0 Former Member over 14 years ago
    Ya, batch loading would be nice. I do not think you can write a script that will work inside Garmin Connect. You could write one for each tcx file but then you still have to load each one separately. A PITA either way.
  • Former Member
    0 Former Member over 14 years ago
    Yeah, that's what I meant. I'll download the data from BiM Active, generate a spreadsheet (or flat text file) locally containing these activities, and then write a perl script to convert each activity to an individual tcx file. Uploading the tcx files to GC will be drudgery, but oh well...