Skip to content

Add mass upload section in Admin Portal #655

@christina-luong

Description

@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 accept this information to the system from the client side.

In Scope

  1. Create a mass upload section/button in the Admin Portal.
  2. Display a blank example template with the correct layout for client reference. (see Mockups)
  3. Facilitate an upload of a csv file using a Dropzone component
  4. Once inputted (in the server handler), validate that the csv has the correct headers.

Out of Scope

  1. Processing the csv past the headers; see Process mass upload #629

Open Questions

Mockups

Draft Template
https://docs.google.com/spreadsheets/d/1UD4cuP2LJ160PHak3wpRTLuBgSPg7RI_QTMpcNOUud4/edit?usp=sharing
Visual Mockup
https://www.figma.com/design/3XcaCKS0xC3U0mo98B8eTV/Features-Complaint-Manager?node-id=971-3861&t=AcLrpZUzwJNA43NU-0

Acceptance Criteria

  1. Scenario:
    Given that I am in the Admin Portal
    When I look at the page
    Then I see a Mass Upload section where I can input my csv file

  2. Scenario:
    Given that I have entered a csv with incorrect or missing headers
    When I click Upload
    Then an error is generated stating that I need to fix errors and resubmit

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

Metadata

Metadata

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions