Data Administrator makes bulk edits by uploading a CSV file in Tangerine web interface

[esurface]

This feature will allow data administrators to make bulk edits to form responses. Typically the steps will be:

1. Download CSV
2. Edit the CSV
3. Upload the CSV

It will be very important to have guardrails in place before this goes into the field:

• uploads must have _id
• check for ","
• checks for non standard characters
• duplicate input names and item names

Components:

• Add a sub-tab button called "Bulk Uploads" in the "Uploads"
• "Bulk Uploads" has a list of previously uploaded bulk upload transactions in a table and a "New Bulk Upload" button
• The workflow for a new Bulk upload:
  • Name and select Form (copy component from Manage Spreadsheet Templates)
  • Select the file for upload
  • Map column names from CSV to variable names of selected form (copy component from Location List)
  • Do guardrail checks
  • Submit to complete the upload

[esurface]

Bulk Edit Status Document Schema:

When starting the bulk edit process the user will select the form name associated with the upload and MUST provide a version tag which will be used to track each process.

{
  "id": "<generatedId>",
  "groupId": "group-<id>",
  "formId": "grade-1-english",
  "versionTag": "v1",
  "startTime": "2019-01-01T00:00:00Z",
  "endTime": "2019-01-01T23:59:59Z",
  "status": "active"
}