Related
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

Download page for lap data

Jannie
over 1 year ago

I used the following web-location 'connect.garmin.com/.../4549671491' to download the lap times and other data of my run activities (activity 4549671491 in the example). Since today it doesn't work any more, giving a message 'This page doesn't work'. Anybody an idea what happened?

  • 0 over 1 year ago in reply to Jannie

    Garminbadges Updater.

    Note that I wrote to

  • 0 over 1 year ago in reply to trux

    That's no solution.  A lap of 10'12"8 and a lap of 5'12"8 will be in the CSV as 10:12 and 5:12,8 and  if copied to excel it will read as 10 hours 12'.  Moreover I don't understand why the laptimes in the app (read on the small screen of your smartphone) show 10th of a second while on your laptop or desktop (read your big screen where you have so much ore space then on your smartphone) you don't.

  • 0 over 1 year ago in reply to Ivanhoe007
    Ivanhoe007 said:
    A lap of 10'12"8 and a lap of 5'12"8 will be in the CSV as 10:12 and 5:12,8 and  if copied to excel it will read as 10 hours 12'.

    Use the free OpenOffice / LibreOffice Calc instead of Excel, and you get rid of the wannabe-intelligent Excel formatting Wink You can also use any fields separator you want, with Calc, and not having to use the one Excel thinks is the best for you.

    There are also a few other options:

    1. You can simply copy and paste the Laps table from Garmin Connect Web to Calc.
    2. Use the DevTools of your browser to get the Split data from the XHR data streams (it can be automated with a script). See below on the screenshot how to get to the data
    3. Export the FIT file, convert it to CSV with the FitCSVTool and extract the lap data from it (can be automated with a script too)

  • 0 over 1 year ago in reply to trux

    Yes, but what about the 10th of second when the lap is longer then 10'?  Will they be back with those methods?

  • 0 over 1 year ago in reply to Ivanhoe007
    Ivanhoe007 said:
    Yes, but what about the 10th of second when the lap is longer then 10'?  Will they be back with those methods?

    Yup, up to the milisecond:

  • 0 over 1 year ago in reply to BunBun!

    I'm using excel VBA and I don;t know how use the F12 DevTools. I need more help on how use the download service.

  • 0 over 1 year ago in reply to DanH44

    You cannot use DevTools with a VBA script, but you can find there which HTTP request you have to make, and which headers the request needs to have. You can get to the DevTools with most of modern browsers by pressing the key F12. Press F1 when in the DevTools, to obtain help on its usage. There are also plenty of online resources, including YouTube tutorials, explaining how to use DevTools, so I recommend checking some of them.

  • 0 over 1 year ago in reply to trux

    I don't know what a header is or the relationship between headers and requests. All I know is the form of the URL to use to access the download service. I've been accessing the DL service programmatically via Excel vba

  • 0 over 1 year ago in reply to trux

    Does the header vary with the file to be DL'd or can I find out what it should be once and then use that?

  • 0 over 1 year ago in reply to DanH44
    DanH44 said:
    I don't know what a header

    What is HTTP Header? - Definition from Techopedia

    DanH44 said:
    Does the header vary with the file to be DL'd or can I find out what it should be once and then use that?

    It depends on the URL you need to use. At some of them, it will be enough to add the request header name/value pair Nk:NT, at others you may need to add more than that.