Skip to main content
Question

strava bulk data activity file IDs don't match the activities.csv Activity ID


Forum|alt.badge.img+1

i'm trying to do some analysis, and i'm working with the raw activities.csv, but the field "Activity ID" do not match any of the raw activity files that come with the bulk download (e.g. 3517781504.fit.gz, this number 3517781504 doesn't match any id in the .csv) . this make matching impossible.  how do you match raw .fit files to the activity ids?? 

6 replies

Forum|alt.badge.img+1
  • Author
  • Hub Rookie
  • 1 reply
  • May 5, 2024

nvm, Filename field is what you need. no idea what Activity ID refers to! 


  • Hub Starter
  • 2 replies
  • September 28, 2024

recognize this. Looking at the activityID's in the strava webGUI, thse are different than those in the bulk download. When I use an activityID from the bulk download I get to see an activity from another athlete than myself. So what do the numbers in the bulk download represent?


  • Hub Starter
  • 3 replies
  • October 1, 2024

I understand the frustration with matching the Activity IDs in the activities.csv file to the raw .fit files. It can be tricky when the IDs don’t align. One approach might be to check if a separate mapping file links the IDs. On a different note, I’ve been using SketchUp Crackeado for some design projects, and it’s amazing how important accurate data is in any analysis. Good luck with your work!


  • Hub Starter
  • 2 replies
  • October 1, 2024

O wow, I completely overlooked the activities.csv file in the default download folder. This is it. Big THX to you mate 😀👍


  • Hub Starter
  • 3 replies
  • October 2, 2024

It seems like there's a mismatch between the "Activity ID" in the activities.csv file and the file names of the raw activity files (e.g. .fit.gz files). This could be due to different ID systems used by the platform for referencing activities in the CSV vs. raw file naming. To match them, you might need to look into metadata or timestamps within the raw files and cross-reference them with the corresponding entries in the CSV file. Some platforms store the Activity ID in the metadata of the .fit files, which can be extracted using specialized tools or libraries for .fit file parsing.


Forum|alt.badge.img
  • Hub Starter
  • 1 reply
  • November 21, 2024

Yes, there is a mismatch. I found there is a `Filename` column in activities.csv which can be used to link together.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept, you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings