BobaBoard / issues

BobaBoard issue tracking
2 stars 0 forks source link

Allow creating a new bobadex from a gSheet #126

Open essential-randomness opened 1 year ago

essential-randomness commented 1 year ago

Currently we don't want to support complex bobadex management from within the UI, but instead allow realm admins to upload new bobadexes as CSV files.

We're going to suggest google sheets as an easy way to create this CSV. However, the google sheets CSV export doesn't support images, so we're going to explore whether we can get the pictures through API and upload it ourselves.

To support edits to the bobadex, we will ask realm managers to redownload an updated CSV with the external ids of each identity prefilled in. This way we can know whether they mean to update a pre-existing identity or create new ones. This feature is not considered part of an MVP.

- [x] Check whether the google sheets API can fetch images from a sheet
- [ ] Write the SQL query to create the new identity in the bobadex and assign them to the correct Realm [`boba-backend`]
- [ ] Add a permission for a role to be able to create the bobadex [`boba-backend`]
- [ ] https://github.com/BobaBoard/boba-backend/issues/144
- [ ] Define how the bobadex creation admin screen is going to look like
- [ ] Implement the bobadex creation admin screen [`boba-frontend`/`boba-components`]
enigmalea commented 1 year ago

I'll start research on the gSheets stuff this week and come back with an update. Someone please feel free to help with the rest of this!

ETA: This Stack Overflow has information on how to get images form the google sheets api.

enigmalea commented 1 year ago

Updated the name of the issue. Due to CSV limitations, we can't use them to import images to the bobadex, we'll have to use gSheets for setting up BobaDexes.