WeeklyChallenge Downloader

[#1]

Small app that automatically downloads all weekly challenges (everything, from the URLs to the attachments) and arranges them in folders (you can find all the challenge details in the folder's name, i.e. "Challenge_1_Parse, Preparation, Join, Data Preparation, Transform_Intermediate")

2023/10/26 - Temporary fix for missing records info (challenge 394 doesn't have the "Certification Level" populated)

2023/07/20 - I fixed a few bugs...now it should download all the Challenges correctly  

If you spot any issues with it, feel free to reach me out

[cairstinedk28]

Good day, I just downloaded your app and it is giving me an error when I input First = 1 and Last = 5.

The error reads :

"Challenge Range Error: 'First' has to be less or euqual to the 'Last'"

Any ideas why this might be happening?

Thank you 

Cairstine

[aiahwieder]

@cairstinedk28 Same issue here! I don't have time to troubleshoot it at the moment but maybe that's the Bonus Weekly Challenge?

[LucaCesario]

Hi guys!! 

Try to download it again, it should work now.

In a nutshell, since I built that macro super quickly, I haven't created a robust logic to handle missing information (in this case it was failing because challenge 394 doesn't have a "certification level")

If you open the workflow there is a section where I'm using select record tools to slice the dataset and empty text input tools to inject empty cells; I didn't have the time to think about how to automate the checking process

Until the next challenge with missing info, it should work correctly 

Thanks

Luca

[aiahwieder]

Still getting the same error, unfortunately . . . if I have time today I can take a look!

 

[Naomi_I]

Seeing a different error on mine