any serious "connect" experts here?
Results 1 to 24 of 24
  1. #1
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240

    any serious "connect" experts here?

    I just imported over 1200 ride files into Garmin connect (exported from SportTracks) and while it worked really well, they are classified generically as activities. I was wondering if anyone knew how I could possibly change the "activity type" preferably as a batch, but i am not even seeing how to do it individually.
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  2. #2
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    ok I see how to do it individually, but for 1200 ride that is just too much work!
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  3. #3
    RoadBikeReview Member
    Reputation:
    Join Date
    Dec 2014
    Posts
    2,597
    After importing from whatever format sporttracks provided, export it from the activities page in CSV, Edit the first field to match the activity you want, then delete everything from the connect page, and reimport the CSV file you just edited.

    That might work, I am guessing here, as I have not done it.

  4. #4
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    Quote Originally Posted by ljvb View Post
    After importing from whatever format sporttracks provided, export it from the activities page in CSV, Edit the first field to match the activity you want, then delete everything from the connect page, and reimport the CSV file you just edited.

    That might work, I am guessing here, as I have not done it.
    for 1200 files? uh....I don't want it that bad!!!!!!!
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  5. #5
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    Quote Originally Posted by ljvb View Post
    After importing from whatever format sporttracks provided, export it from the activities page in CSV, Edit the first field to match the activity you want, then delete everything from the connect page, and reimport the CSV file you just edited.

    That might work, I am guessing here, as I have not done it.
    Editing in connect works too but if it took 30 seconds each, it would take 10 hours.
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  6. #6
    RoadBikeReview Member
    Reputation: velodog's Avatar
    Join Date
    Sep 2007
    Posts
    7,784
    Quote Originally Posted by Touch0Gray View Post
    Editing in connect works too but if it took 30 seconds each, it would take 10 hours.
    Do a few every time you enter new ride data and it would be a little less painful.
    Too old to ride plastic

  7. #7
    RoadBikeReview Member
    Reputation:
    Join Date
    Dec 2005
    Posts
    870
    If you can find someone with strong Excel/Visual Basic skills they could probably write a macro in about twenty minutes to do what you want

  8. #8
    Master debator.
    Reputation: nOOky's Avatar
    Join Date
    Mar 2009
    Posts
    8,523
    Can you export all of the activities into Excel using the Garmin reports? That should give you the data to re-upload after you edit it. Maybe...
    "I felt bad because I couldn't wheelie; until I met a man with no bicycle"

  9. #9
    RoadBikeReview Member
    Reputation:
    Join Date
    Dec 2014
    Posts
    2,597
    Quote Originally Posted by nOOky View Post
    Can you export all of the activities into Excel using the Garmin reports? That should give you the data to re-upload after you edit it. Maybe...
    Yes, that is what I told him to do.

    Not sure where he is getting 1200 files, he said 1200 rides. That would just be 1200 lines in a single file. The first field is the activity.

    Change the first ride in connect to the activity you want, export everything into a single file, highlight the first rides activity field, copy it, select the first cell for the remaining rides, and copy the activity over them. Should take like 2 min, then import the rides back into connect (I would suggest you delete everything in connect first to avoid duplicates)

  10. #10
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    Quote Originally Posted by nOOky View Post
    Can you export all of the activities into Excel using the Garmin reports? That should give you the data to re-upload after you edit it. Maybe...
    Again.... 1200 activities!
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  11. #11
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    Quote Originally Posted by velodog View Post
    Do a few every time you enter new ride data and it would be a little less painful.
    It takes a couple of minutes just to scroll back to 2015......and the files date back to 2006
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  12. #12
    Master debator.
    Reputation: nOOky's Avatar
    Join Date
    Mar 2009
    Posts
    8,523
    My intention was slightly different. I don't see it now, but you used to be able to run a report for selected dates and activities etc., looks like that is no longer an option? I noticed that in the activities you have to basically scroll down through all of your activities to "select" them to export all of the files in your history. The result is the same, it looks like it can be done.



    Quote Originally Posted by ljvb View Post
    Yes, that is what I told him to do.

    Not sure where he is getting 1200 files, he said 1200 rides. That would just be 1200 lines in a single file. The first field is the activity.

    Change the first ride in connect to the activity you want, export everything into a single file, highlight the first rides activity field, copy it, select the first cell for the remaining rides, and copy the activity over them. Should take like 2 min, then import the rides back into connect (I would suggest you delete everything in connect first to avoid duplicates)
    "I felt bad because I couldn't wheelie; until I met a man with no bicycle"

  13. #13
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    Quote Originally Posted by nOOky View Post
    My intention was slightly different. I don't see it now, but you used to be able to run a report for selected dates and activities etc., looks like that is no longer an option? I noticed that in the activities you have to basically scroll down through all of your activities to "select" them to export all of the files in your history. The result is the same, it looks like it can be done.
    Keeping in mind, I am NOT a computer expert or excel expert. I found a relatively easy way to change them from the app on my tablet. It will still take time but I don't risk breaking anything!
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  14. #14
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    ok, so I d/l the csv file, edited it (replace with is my new best friend) NOW, if I upload it to Connect will it overwrite the old stuff or append it? To avoid all risk, am I better off creating NEW connect account and starting clean??????


    edit:
    Nope, started with new account, upload error, changed it to a .xls, still upload error
    Last edited by Touch0Gray; 4 Weeks Ago at 06:09 AM.
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  15. #15
    RoadBikeReview Member
    Reputation:
    Join Date
    Dec 2014
    Posts
    2,597
    Quote Originally Posted by Touch0Gray View Post
    ok, so I d/l the csv file, edited it (replace with is my new best friend) NOW, if I upload it to Connect will it overwrite the old stuff or append it? To avoid all risk, am I better off creating NEW connect account and starting clean??????
    Try saving the file in Excel 1997 - 2003 format (under save as under the "Save type as") Just changing the file name will not change the type, as the newer v

    edit:
    Nope, started with new account, upload error, changed it to a .xls, still upload error
    You need to save the file as CSV UTF-8 format, not excel. When you open the CSV, excel converts it to the excel format. You cannot just save it, you have to save it as CSV. Connect won't import excel formats.

  16. #16
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    Quote Originally Posted by ljvb View Post
    You need to save the file as CSV UTF-8 format, not excel. When you open the CSV, excel converts it to the excel format. You cannot just save it, you have to save it as CSV. Connect won't import excel formats.
    All I have is office 2000, I saved as CSV.. Can I do it with open office?
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  17. #17
    RoadBikeReview Member
    Reputation: velodog's Avatar
    Join Date
    Sep 2007
    Posts
    7,784
    I back up most of my data with ink and paper. I've got weekly planners back to 2002.
    Too old to ride plastic

  18. #18
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    Quote Originally Posted by velodog View Post
    I back up most of my data with ink and paper. I've got weekly planners back to 2002.
    apparently your desk doesn't look like mine!
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  19. #19
    RoadBikeReview Member
    Reputation: velodog's Avatar
    Join Date
    Sep 2007
    Posts
    7,784
    Quote Originally Posted by Touch0Gray View Post
    apparently your desk doesn't look like mine!
    Cluttered?
    Too old to ride plastic

  20. #20
    RoadBikeReview Member
    Reputation:
    Join Date
    Dec 2014
    Posts
    2,597
    Quote Originally Posted by Touch0Gray View Post
    All I have is office 2000, I saved as CSV.. Can I do it with open office?
    Probably.. you could do it with notepad too, CSV is just a plane text file with fields separated by a comma (Comma Separated Values), any text editor from notepad, VI, emac to Openoffice/MS Office of any version can create them.

    I'm curious why it is getting an error.. It should work... in theory... I'll have to try it out when I get the chance.. I'm not too attached to my activities, so if I screw something up I'll just delete them heh.

  21. #21
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    Quote Originally Posted by ljvb View Post
    Probably.. you could do it with notepad too, CSV is just a plane text file with fields separated by a comma (Comma Separated Values), any text editor from notepad, VI, emac to Openoffice/MS Office of any version can create them.

    I'm curious why it is getting an error.. It should work... in theory... I'll have to try it out when I get the chance.. I'm not too attached to my activities, so if I screw something up I'll just delete them heh.
    it specifies that the cvs or xls files are for fitbit data, there may be a specific "signature" within the file to show that?

    edit: I tried to save as in notepad which allowed me to specify UT-8 (or whatever that was) still no go
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  22. #22
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    desk is too small or life is too big......not sure which!
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  23. #23
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    ljvb....I appreciate the assistance but I did figure out a fairly painless way to do it via the android app, I can do a year in about 15 minutes. so I am done all the way back to 2011 now. 5 more years

    actually, it wont let me upload the file I downloaded without error!
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

  24. #24
    Frog Whisperer
    Reputation: Touch0Gray's Avatar
    Join Date
    May 2003
    Posts
    40,240
    I got all my files edited, but I would still love to know why I can't upload the file I downloaded from them!
    Of course I'm sure...that doesn't mean I'm right.....

    "There's no sense being stupid unless you show it."

    "that was like trying to teach a goldfish how to play basketball over the phone."

Similar Threads

  1. Garmin Connect "Goals"?
    By Switchblade906 in forum Beginner's Corner
    Replies: 9
    Last Post: 03-22-2012, 09:10 AM
  2. NNC: Why not tap the "experts" here too..
    By Sylint in forum The Lounge
    Replies: 36
    Last Post: 09-07-2011, 08:07 AM
  3. Replies: 5
    Last Post: 11-29-2010, 05:14 AM
  4. any drywall "experts" here?
    By rmp in forum The Lounge
    Replies: 40
    Last Post: 01-08-2009, 11:43 AM
  5. Replies: 34
    Last Post: 10-07-2005, 08:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

THE SITE

ABOUT ROADBIKEREVIEW

VISIT US AT

© Copyright 2019 VerticalScope Inc. All rights reserved.