Forums >General Running>A tool to generate your weekly table based on your Strava activities from the last week
Intl. correspondent
Hi everyone,
Some people on this forum used to use a tool to generate their weeklies table by pulling the last 7 days of activities from Strava.
A couple months ago I heard that it stopped working.
It's been a while but today I was bored and assembled something together that might be able to help people do just that.
It's a very early draft, but I control the source code so we are able to iterate on it to make it better.
Those of you who are Java/web developers can send a Pull Request to https://github.com/flaviopezzini/stravaweekly
Your technical feedback is much appreciated as well
So how does it work?
1 - Go to https://strava-weekly.herokuapp.com/
2 - Click on "click here" next to With Strava.
3 - It will redirect you to the Strava login page. Enter your credentials and click login.
PS: If you are already logged in to Strava it will skip this step.
4 - It will show a page so you can authorize the app to fetch your activities from the last 7 days.
The message will be : Authorize forum_weekly_app to connect to Strava
You just have to click on the big orange "Authorize" button.
5 - It will automatically compute the last week and load activities for it.
If you live elsewhere in the world and you use the logic, metric system, then tick the check box "Show Metric?" and then click the Activities button.
6 - A table with your activities from the last 7 days will be displayed (name, distance, duration and elevation gain).
7 - There are also buttons to show "Previous week" and "Next week" so you can navigate through your weeks.
This can be useful if you need to generate the last 2 weeks.
You can reply here to this thread if you find any issue or if you have a recommendation of how we could make it better (other bits of information that you'd like displayed, colors, better way to lay out the buttons, etc).
PS: This has been deployed on a free account on Heroku, I'm not sure exactly what is the limit but it's possible that one of you will eventually hit a limit and it will error out. If that happens, wait half an hour and try again.
Thanks all in advance for the feedback
Edit: 2020-03-29 - I've updated the instructions to reflect the current state of the app.
PRs: 1500 4:54.1 2019 - 5K 17:53 2023 - 10K 37:55 2023 - HM 1:21:59 2021
Up next: Base building till August
Oct 1st - World Half Marathon Champs in Riga - Latvia - sub 1:21:59 PR
Dec 3rd - Valencia Marathon - sub 2:59
April 2024 - Porto Eco Trail - Finish the damn thing.
Tool to generate Strava weekly
RIP Milkman
Thank you for putting this together! Here are my suggestions:
1) It would be helpful if you can pull last week, not the last 7 days. The problem I see is some folks want to post their weeklies on Tuesday for example, but this will only pull the previous Tuesday to Monday.
2) I would include the date next to each activity.
3) Average pace should be included as well.
4) Can you include a link to the activity like the old version of this had?
5) It pastes a little funky on this site, here's what mine looks like. not sure how you can fix that though:
Name
Distance
Duration
Elevation Gain
Evening Run
11.0
01:25:15
159.4
Afternoon Run
7.0
00:55:07
87.2
Lunch Run
16.0
01:55:55
60.4
10.9
01:25:08
158.6
When is a niggle actually an injury?
01:28:03
61.2
Morning Run
7.1
00:59:14
91.2
17.3
02:13:57
150.3
5K: 16:37 (11/20) | 10K: 34:49 (10/19) | HM: 1:14:57 (5/22) | FM: 2:36:31 (12/19)
Next Race: NYC Half (3/19)
thanks Jmac for the great feedback. I have updated the tool according to your suggestions.
Here's how the table looks now. Let me know for more feedback you have and I'll adjust accordingly.
Here's how it looks when not using metric (default).
I've also added a couple more improvements.
It loads the previous week. If today is a Sunday it will look up the last 7 days (mon-Sun).
If it's not a Sunday it computes the previous Sunday and 7 days before that.
Also it's using the user timezone to compute the dates so it should finally help out our fellow Kiwi friends.
Overtime I'll adjust it so you don't have to authorize it on Strava every time.
JMac - you can also copy/paste from your RA log.
Dave
I have added a little blurb explaining how start and end dates for the period being displayed are calculated, as well as the start and end dates computed from that.
I've also changed the table to display the activities in ascending order by date.
Another change was to use the user time zone when computing said dates.
Problem Child
Seems to work for me. Looks a lot like the previous version we'd used.
Many of us aren't sure what the hell point you are trying to make and no matter how we guess, it always seems to be something else. Which usually means a person is doing it on purpose.
VDOT 55.2
5k18:xx | Marathon 2:55:22
I have done a few changes recently to the tool.
It now will load the week automatically, we no longer need to click "Generate table".
There are now also buttons to view the previous and the next weeks which can be useful if you need to generate the last 2 weeks.
Thanks Piwi and Darkwave for reporting the issue with the duration formatting.
It was not displaying the hour bit, so 01:00:00 was being displayed as 00:00.
That has been fixed now.
Nice tool. One thing I noticed right away is that you are losing on precision of the mileage - Strava reports precision of two digits after dot and you are only taking into account one digit. As a result, I had 100.7 miles last week but your tool reports 100.5 due to that rounding. Is it possible to fix? Thank you!
paces PRs - 5K - 5:48 / 10K - 6:05 / HM - 6:14 / FM - 6:26 per mile
Thanks call for the feedback. I've just applied your recommendation.
Could you please try again and see if it shows correctly now?
Thanks call for the feedback. I've just applied your recommendation. Could you please try again and see if it shows correctly now?
Looks good flavio - thanks! Now I have to figure out why Strava gave me 100.7 miles and your tool and RunningAhead log gave me 100.8
Oh, that was a rounding choice. I was rounding every day to 2 digits after the decimal point and accumulating that value.
I've just adjusted it to accumulate in meters instead and then compute km/miles at the end.
Thanks for the feedback!
Flavio- the last couple of weeks, I've not been able to use this as the output is not capturing all my runs (I've tried it on Sunday, Monday and Tuesday). The issues seem to be:
I changed my profile to private a couple of weeks ago, but I tried re-running the summary with it set to public and have the same issues, so I don't think it's that.
I've seen others seem to have successfully posted the last week training using this so I'm not quite sure whether it's just some sort of issue/setting I'm having.
3,000m: 9:07.7 (Nov-21) | 5,000m: 15:39 (Dec-19) | 10,000m: 32:34 (Mar-20)
10km: 33:15 (Sep-19) | HM: 1:09:41 (May-21)* | FM: 2:41:41 (Oct-20)
* Net downhill course
Last race: Xterra Waitawa, 21 May, didn't die
Up next: Xterra Hunua, 11 June, also aiming to not die
"CONSISTENCY IS KING"