SundayServiceVR / sunday-service-vr

1 stars 1 forks source link

Disaster Recovery: Have mission critical data backed up to an accessible format (google sheets?) #46

Open lebull opened 4 months ago

lebull commented 4 months ago

Problem

If s* hits the fan, we need to be able to fall back on our original processes to run S4. We need to keep an update list of djs and something like our "dj tracking sheet".

Solution

We can have a cloud function that runs once a week (Monday?), pulls all djs and events, and makes a new sheet to upload to google drive. The important thing is that the output is accessible to an organizer who may not be tech-savy.

Dj Roster

We need a list of Djs

Discord Name Dj Name Twitch Username RTMP Stream URL
asdf zxcv bla rtmp://example.com/asdf
qwer qwer asd
tuyy gfds

Event List

We need a list of all events.

Event Date Event Name Slot 1 Slot 2 Slot 3
11-04-2023 Sunday Service Dj Bleats (windyTheDeer) Dj Minecraft (whittyTheMinecraftStreamer) Dj SpinsAlot (Kittz)

Tracking Sheet

This is not a hard requirement (and may be difficult to implement), but it is very nice to have a spreadsheet similar to our current tracking sheet.

https://docs.google.com/spreadsheets/d/1x3o6jmxjimZzlY7kRNVyiCG-A5yQ2XHvQlokeeJd8iI/edit

Image

lebull commented 4 months ago

This is super important, but it doesn't make sense to implement until we can get dj's managed in this tool.

lebull commented 4 months ago

This PR will contain the shapes we're likely going to use.

https://github.com/SundayServiceVR/sunday-service-vr/pull/63