Bulk Upload Questions

...

1. When a contributor logs into contribution portal and opens a target collection page of a project to which she can contribute (i.e. her nomination is accepted), currently against each target collection there is a “Create New” action using which user can create a question set.

2. Given user has access to a sourcing project where she can contribute, When she creates a question set within the sourcing project, Then she can upload questions to the question set

3. User will see an option to “Bulk Upload Question” in the question set similar to “QR codes” in the collection asset editor

4. Clicking “Bulk Upload Question” option, Bulk Upload Question screen should open up. The screen should have following options

   1. Option to select a Bulk Upload Question (metadata) file from local folder (of user’s system)
      Assumption: the metadata file will have publicly accessible URLs to the question related files

   2. There is a link to sample metadata file: “Sample Bulk Upload Question metadata file”

   3. User selects metadata file, user clicks “Upload”. System provides a message “Validating file”

   4. The system should first validate metadata file against the selected files. Following are the validations:

      1. All the columns are available

      2. All the mandatory columns have values filled in

      3. There are no duplicate URLs in file path column

5. In case there are errors in the metadata file validation, display relevant error message on the Upload dialog

   1. Some columns are not available:
      “Metadata file validation failed. Following columns are not found in the file. Please check and upload again: <list the missing column names>”

   2. Some mandatory columns have values missing:
      “Metadata file validation failed. Following rows have missing values. Please check and upload again: <list the row numbers (starting from 1) with missing values>“

   3. Some duplicate URLs in File path column:
      ”Metadata file validation failed. Following rows have duplicate file links. Please check and upload again: <list the row numbers (starting from 1) with duplicate links>“

6. In case of metadata file validation errors, “Upload” button is disabled unless user re-selects a metadata file again.

7. In case metadata file doesn’t have any validation errors, the dialog shows
   “Bulk Upload is in progress.
   Number of content uploaded successfully: <no.>
   Number of content failed: <no.>
   Number of content pending: <no.>”

8. There is an option to download status report as a csv. The status report should include identifier of the question (as generated by the system i.e. API response) and status (Success, Failure, Error, Invalid, etc)

9. There is a “Close” button to close the dialog. When user clicks it, it is returned to Textbook page of the project.

10. In the Question Set page, whenever user clicks “Bulk Upload Questions”, in case a bulk upload is in progress, it shows the status dialog as described in point 8.

Limits on number of content, size: Number of contents per textbook for one bulk upload job: 300 Maximum size of each content is same as max size supported by system.

Reference material

1. Bulk Upload Question Guidelines (current manual script driven process) https://docs.google.com/document/d/1PW5b-Mdie6--wsFhGzC-fxVcPbvax4cA-hJyajr8Xew/edit#heading=h.we2s93hce9f4

2. Bulk Upload Content related /wiki/spaces/DO/pages/1581350917

   1. https://project-sunbird.atlassian.net/browse/DP-18

   2. https://project-sunbird.atlassian.net/browse/DP-947

   3. https://project-sunbird.atlassian.net/browse/DP-967

   4. https://project-sunbird.atlassian.net/browse/DP-1480

...