Process mass upload

[christina-luong]

User Story

As a user of either NO or Hawaii I want to be able to mass upload information about officers or inmates (respectively) So that the database is kept up to date

Business Context:

Occasionally, we are provided by either organization a spreadsheet containing the updated roster of officers or inmates. The uploads have been a manual process (see #592) with some research previously done on mass uploading (see #529). This story will build the functionality needed to process this information on the backend.

In Scope

1. Flag errors (see Open Questions for guidance).
2. Update and run the script from an uploaded file received via server handler

Out of Scope

1. Implement a scheduled upload.

Open Questions

• What should the system do if a required field is missing? Ignore that line and display it as an error in Admin Portal.
• If officer does not exist? Create a new officer.
• If a row is rejected because supervisorEmployeeId doesn't match an employeeId, set supervisorEmployeeId to null and re-insert
• Do we need to cross reference anything other than ID? No.

Mockups

Acceptance Criteria

1. Scenario: Given that the user is on the Admin Portal When they input a csv with the correct headers Then our database is updated with information from the csv

2. Scenario: Given When Then

Notes

Checklist

Kickoff

• [ ] We have we indicated which organizations and user permissions require this
• [ ] We have indicated whether we have any dependencies to other cards/work
• [ ] We have indicated which environment this can be tested in
• [ ] We have included a mockup if this is design related
• [ ] We have included clear ACs to test it
• [ ] We have estimated the story

Deskcheck

• [ ] This work has been demoed in CI (or higher) and led by the dev pair who worked on this card
• [ ] We have run through and passed all the ACs
• [ ] Our documentation has been updated
• [ ] Our onboarding checklist has been updated

[andrew-rist-tw]

Officers' script: src/server/seeder_jobs/createSeedOfficerDataFromS3.js Inmates' script: src/server/seeder_jobs/createSeedInmateDataFromS3.js

[andrew-rist-tw]

Only the ids are required (employeeId, inmateId)

[claireholt-tw]

Here is the link to the how-to docs regarding the mass upload: https://docs.google.com/document/d/1mdOOv5pzH682rabBEG56Rq2OQ-4Fh0e4lASzkVlTWNw/edit?usp=sharing