Room Slot CSV Upload

[JacquelineMai]

User Story

As an instructor I can upload a CSV of room slot entries so that I can quickly populate the database with room slots from a spreadsheet. A CSV is a "comma-separated values" file that represents the contents of a spreadsheet in text format.

Acceptance Criteria

• [ ] There should be a file upload button on the Room Slots page that takes a CSV file of tutor information
• [ ] If it is a valid CSV file, an entry is created in the database for each tutor in the file
• [ ] This feature is visible on the page only to instructors and admins ...

Implementation Todos

Front end:

• [ ] On the Room Slots page, add a file chooser component (you might consider this one: https://www.npmjs.com/package/react-csv-importer) where a user can drag and drop their CSV file
• [ ] Validation errors are displayed on the screen if the file is invalid
• [ ] A success message is displayed if the file is successfully processed at all tutors have been added to the database ...

Back end:

• [ ] Validate the file - it is invalid if the CSV doesn't contain all the required columns for the room slot information
• [ ] If the file is valid, a new Room Slot entry is created and saved for every row ...

Testing:

• [ ] There is a frontend test checking that the CSV file upload is visible on the Room Slots page if the user is logged in as an admin
• [ ] There is a frontend test checking that the CSV file upload is not visible on the Room Slots page if the user is not an admin or instructor
• [ ] There is a test checking that no new room slots are saved if an invalid CSV file is uploaded
• [ ] There is a test checking that all the room slots specified in the CSV are saved to the database if the CSV file is valid

[JacquelineMai]

You might use this PR as a reference: https://github.com/ucsb-cs156-s21/proj-ucsb-cs-las/pull/168 Remember that you're not required to do it in this way, so feel free to bring your own ideas or approaches.