Fix score dataclip(s) by late April [5,3,1.67]

[stenington]

Dataclips referencing old score columns will be broken, e.g.

• https://data.heroku.com/dataclips/bjbpcmaurdxgdscmxtrkqwjyudkw

Are there others?

[stenington]

From #2264

[rsgonzal]

Looking at Amy's data archive here: https://docs.google.com/document/d/1AJJH9Hq7s7HRQ726w3MkK0fgYbM2_1RxdQx1kpwqIHM/edit

I think the dataclip above is the only one used and the rest is pulled from the site. Is this correct, @amyiridescent and should I check with anyone else?

[amyiridescent]

Yes I believe that is true but I can't get the data clip to run right now. I am getting an error.

[rsgonzal]

Thanks, @amyiridescent ! This ticket is to fix that ^^ :)

[stenington]

This fits roughly under the theme of #2392 in that I believe if it isn't fixed, monitoring scores will become more of a developer problem.

[shaun-technovation]

The new/updated dataclip is here: https://data.heroku.com/dataclips/daqfepdhedhrlripdngbdskqiihj

A couple of notes:

• I created a new dataclip from the existing one
• There doesn't seem to be an easy way to copy an existing dataclip 🤕 😳
• There isn't a PR
• I ran the dataclip against QA/staging data and was able to get some results
• The year in the dataclip is still set to 2019
• This might be nice to have in the app for admins to view

[stenington]

Dataclips used to be versioned so each time you edited it a new version was created, but it looks like the new dataclips don't do that which is a bummer.

I agree this would be nicer in the app, but for context I think the reason it's in a dataclip is because Amy likes to have data in spreadsheets to work with, and the platform's CSV export is much flakier than dataclips are. So until we can address that flakiness, dataclips are the more reliable solution.

[amyiridescent]

Yeah sorry Shaun. I like to manipulate the date on a spreadsheet. It helps that I already know how to write functions on google spreadsheet. :) And I try not to do the CSV exports too often since it tends to get stuck or crashes. Sorry for being old school.

[shaun-technovation]

Yeah sorry Shaun. I like to manipulate the date on a spreadsheet. It helps that I already know how to write functions on google spreadsheet. :) And I try not to do the CSV exports too often since it tends to get stuck or crashes. Sorry for being old school.

Ah, no worries! 😃 Anywho, when you get a moment, can you check out the new dataclip, and see if it's working as expected?

https://data.heroku.com/dataclips/daqfepdhedhrlripdngbdskqiihj

Right now it's pointing at staging for the 2019 season, if it's working as expected I'll updated it to 2020, and point it production, and it should be good to go for the 2020 season. 😃

[amyiridescent]

Data clip looks good. :)

Thanks Shaun for helping me the the dataclip share settings. :)

[shaun-technovation]

Thanks @amyiridescent! 👍 🙌 🎉

I updated the year in the dataclip to 2020 and also pointed it to production.

[shaun-technovation]

I'll move this one to Done, since there's nothing to deploy for this. 👍 😃