Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[VPS-170] (5) (3) Connecting the CSV upload file to the Upload CSV Button #170

Open
JordanBlenn opened this issue Apr 29, 2024 · 0 comments
Assignees

Comments

@JordanBlenn
Copy link
Contributor

JordanBlenn commented Apr 29, 2024

Description:

AS A: staff member using VPS
I WANT: the upload CSV button to work
SO THAT: I can upload groups, allowing groups to play the same scenario together

AC's:

  1. When the "Upload CSV" button is clicked, it opens a file navigator and allows you to upload a file.
  2. When a file of the correct format is uploaded, its data is displayed appropriately in the manage groups table.
  3. This group data linking emails with groups, roles, and scenarios is stored in the database.
  4. As part of this, any previous group data linked with this scenario is deleted
  5. Only .csv files and files of the correct format (defined via [VPS-154](2)(0.5) Uploading a CSV file creates appropriate groups and assigns roles (No UI) #154 ) can currently be uploaded

Technical Discussion:

  • error handling for this CSV will come in the future (low priority)
  • Being able to dynamically manage the data in the groups table will also come in a future story ([VPS-172](5) Edit functionality to the Manage Groups table within the website #172)
  • Database storing (I believe, but double check with Jin if needed) is done as follows: A massive table containing all groups is in the database, with each group having a ScenarioId that links it to the scenario it relates to. Each user also has a UserId which can reference a role.
  • VC 4 likely requires some very good error handling to ensure that if a group is deleted. From my personal understanding, I would imagine if a group is deleted it can never be played again. However, you'd have to ensure the deleted group Ids are not used again or that could lead to old and new groups accessing the same scenario (edge case but important to keep in mind). Talk with Jin or Jordan about this if you need clarification. References to the scenario from the group and references to the group from the scenario will both need to be updated (I believe it's 2 way but I could be wrong, check with Jin).
@JordanBlenn JordanBlenn changed the title [VPS-169] Connecting the CSV upload file to the Upload CSV Button [VPS-170] Connecting the CSV upload file to the Upload CSV Button Apr 29, 2024
@JordanBlenn JordanBlenn changed the title [VPS-170] Connecting the CSV upload file to the Upload CSV Button [VPS-170] (5) Connecting the CSV upload file to the Upload CSV Button May 13, 2024
@JordanBlenn JordanBlenn changed the title [VPS-170] (5) Connecting the CSV upload file to the Upload CSV Button [VPS-170] (5) (3) Connecting the CSV upload file to the Upload CSV Button May 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants