ER: Fix dashboard data script (workflow)

[ExperimentsInHonesty]

Emergent Requirement - Problem

The workflow that updates the data on our issue dashboard is not working and has not worked for the last two weeks. I don't know exactly when because I can't find the date on the failed file, it just says 2 weeks.

Edit: It looks like the script is working now but we still need a GHA to notify us (by opening an issue).

Details

• To see the failures you can go here to see all the runs. At the time of this writing, the last good run was on page 4. https://github.com/hackforla/live-dashboard-automation/actions/workflows/schedule_run_to_update_data.yaml
• Live Project Board Issues Dashboard (Current)

Issue you discovered this emergent requirement in

• N/A

Date discovered

2024-01-28

Did you have to do something temporarily

• [ ] YES
• [x] NO

Who was involved

@ExperimentsInHonesty

What happens if this is not addressed

• We won't know when the dashboard data script is not working.

Resources

Recommended Action Items

• [x] Make a new issue
• [ ] Discuss with team
• [ ] Let a Team Lead know

Potential solutions [draft]

In addition to getting the script working again, we need a GHA to notify us (by opening an issue) if it fails more than 2 times in a row and there is not an open issue already for it.

[JessicaLucindaCheng]

I would recommend checking if any of the secrets are expired first to see if this is the reason for the failures: https://github.com/hackforla/live-dashboard-automation/blob/444e9f010fe11e015acac6e9d2b14707398be049/.github/workflows/schedule_run_to_update_data.yaml#L56-L58

[ExperimentsInHonesty]

There is a 1Password vault called website-data-science that kimberly and bonnie have access to.

[JessicaLucindaCheng]

@ExperimentsInHonesty We edited this in Dev/PM meeting on March 11th and we think it is ready for someone to write an issue. Also, it looks like the script is working

• https://github.com/hackforla/live-dashboard-automation/actions
• https://lookerstudio.google.com/u/0/reporting/6410c484-f38f-44ba-b4ed-c29a6b2a081b/page/e1JSB

[ExperimentsInHonesty]

Hi Data Science people. I know someone from DS has been working on helping us get this dashboard script working again. Can you leave a note on this issue explaining what was done to fix it

[github-actions[bot]]

Hi @ExperimentsInHonesty, thank you for taking up this issue! Hfla appreciates you :)

Do let fellow developers know about your:- i. Availability: (When are you available to work on the issue/answer questions other programmers might have about your issue?) ii. ETA: (When do you expect this issue to be completed?)

You're awesome!

P.S. - You may not take up another issue until this issue gets merged (or closed). Thanks again :)

[ExperimentsInHonesty]

• [ ] All the links in this issue will need to be checked to see if we have access
• https://github.com/hackforla/live-dashboard-automation/actions/workflows/schedule_run_to_update_data.yaml
  • [ ] Have access, its located in ____
  • [x] public
• Live Project Board Issues Dashboard (Current)
  • [ ] Have access, its located in ____
  • [ ] public
• https://github.com/hackforla/live-dashboard-automation/blob/444e9f010fe11e015acac6e9d2b14707398be049/.github/workflows/schedule_run_to_update_data.yaml#L56-L58
  • [ ] Have access, its located in ____
  • [ ] public
• https://github.com/hackforla/live-dashboard-automation/actions
  • [ ] Have access, its located in ____
  • [ ] public
• https://lookerstudio.google.com/u/0/reporting/6410c484-f38f-44ba-b4ed-c29a6b2a081b/page/e1JSB
  • [x] Have access, its located in BOP Google Drive (not actually true... just used for an example
  • [x] public