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

Notes to an activity are not exported

dgg4 over 5 years ago

On Garmin Connect Web, Notes you enter on an Activity are not exported when you select All Activities > Export CSV.

Is there a way to get notes included in the CSV export? Or is there another way to get Notes exported?

Thanks in advance!

dgg

Top Replies

trux over 5 years ago +2 suggested

dgg4 said:
Is there a way to get notes included in the CSV export? Or is there another way to get Notes exported?

Yes, you can export a very detailed data report of all activities in JSON file format. It…
trux over 5 years ago in reply to dgg4 +2

Yes, the data you posted is the beginning of the list of your activities, with all details, including comments. It is in JSON format. As I wrote, you can view and edit it with a number of tools, including…
BunBun! over 1 year ago in reply to zlatko +2

That error is when you run it with the Web closed. You need to log-in and open Console there. But with latest change, proxy was replaced by header, so you would get next error anyway.

Now new headers are…

All Replies

0 trux over 5 years ago

dgg4 said:
Is there a way to get notes included in the CSV export? Or is there another way to get Notes exported?

Yes, you can export a very detailed data report of all activities in JSON file format. It includes the comments too. JSON can be then handled with plenty of tools, including such software like Excel, to extract the data you need from it, Use the following link, and adjust the limit and start values as needed. Limit - is the number of activites to load, and start is the first activitity to load:

https://connect.garmin.com/modern/proxy/activitylist-service/activities/search/activities?limit=20&start=0

0 dgg4 over 5 years ago in reply to trux

Thanks for the encouraging response, but (a) I don't know anything about JSON, and (b) the link provided unfortunately did not work.

Could you try to post the link again? This is the link I see when I look at this message thread..

https://connect.garmin.com/modern/proxy/activitylist-service/activities/search/activities?limit=20&start=0

And I get this message when I try to use the link...

{"message":"HTTP 403 Forbidden","error":"WebApplicationException"}

Thx!

dgg

0 trux over 5 years ago in reply to dgg4

Try logging into your Garmin Connect Web account first, and acessing the Activity page. The session must be opened first, of course, and it must be saved in the cookie (so make sure you checked the option Stay connected, when logging in, and that cookies are not forbidden in your browser).

As for JSON - it is an easily readable format, and as I wrote, you can process it with a big number of tools, Excel, or Open Office / Libre Office including. In doubts, you'll find plenty of info about the format on the web.

0 dgg4 over 5 years ago in reply to trux

Thank you for helping!

I hate to be dense, but I opened the Activities page in one Chrome tag and clicked on the link above in another tab and got this result...

[{"activityId":4630027556,"activityName":"Newport News Running","description":null,"startTimeLocal":"2020-03-07 10:34:24","startTimeGMT":"2020-03-07 15:34:24","activityType":{"typeId":1,"typeKey":"running","parentTypeId":17,"sortOrder":3},"eventType":{"typeId":9,"typeKey":"uncategorized","sortOrder":10},"comments":null,"parentId":null,"distance":11796.7900390625,"duration":6245.54296875,"elapsedDuration":6289772.94921875,"movingDuration":6243.190002441406,"elevationGain":35.0,"elevationLoss":41.0,"averageSpeed":1.8890000581741333,"maxSpeed":2.407000

I am logged in to Garmin connect and I both have cookies enabled and whitelisted 3rd party cookies from Garmin.com (one of my computers has 3rd party cookies blocked by work restrictions).

I tried this on two Win10 computers -- one work and one personal -- tried Chrome and the new chromium based Edge browser -- no joy :-(

Hopefully there's an easy answer!

Thx again,

dgg

0 trux over 5 years ago in reply to dgg4

Yes, the data you posted is the beginning of the list of your activities, with all details, including comments. It is in JSON format. As I wrote, you can view and edit it with a number of tools, including Excel. But if you do not feel like searching how to do it, and insist on a CSV file, I just googled a JSON to CSV online conversion tool for you. Copy and paste the text there: http://convertcsv.com/json-to-csv.htm

0 trux over 5 years ago in reply to trux

BTW, I'd advise you to rather edit and trim your post with the data, since it includes some sensitive details you do not want to be seen publicly, if you do not wish someone hacking into your account.

0 dgg4 over 5 years ago in reply to trux

I see....many thanks!

dgg

0 dgg4 over 5 years ago in reply to trux

Thank you, again! (for advising that I correct my previous post, that is)

dgg

0 Former Member over 4 years ago in reply to trux

thanks for posting this! Can't believe comments aren't being exported by default!

0 pacolini over 4 years ago in reply to trux

@ trux - Thanks for the post, helpful. Is there a way to define the date parameters like i want to export all the Notes going back years? Thanks much!...Luc