Bulk Upload Questions

https://project-sunbird.atlassian.net/browse/SB-22801

...

1. Support Multiple Choice Question (MCQ) with validations such as

   1. Minimum 2 options, maximum 4 options

   2. At least and only one correct option

2. Question and Options can have images - provided as Google Drive public link. Google Drive path for image is provided by user which is extracted by system (bulk upload tool).

   1. Images will be placed at the beginning of the text with left align and small size (25%).

3. Question and Options can have either Images only or text only or both.

4. User can download sample bulk upload format. User provides CSV in the prescribed format filled with required details.

5. Mandatory columns (configurable) are coloured in red.

6. Basic validations such as

   1. Text contains only unicode characters

   2. Any cell does not contain any images

   3. All mandatory columns are filled for a particular row in CSV

...

1. Question Category will be Multiple Choice Question for this version.

   1. Mandatory: Yes

   2. Default: MCQ

   3. Validation: If anything other than MCQ, reject the question

   4. Tip: Always fill "MCQ"

2. Additional Category is derived from the question set

   1. Mandatory: No

   2. Default: Primary category of the Question Set (derived value).

   3. Validation:

   4. Tip: Purpose of the question. Should be same as content type of question set.

3. Target Question Set ID to be auto-derived when user is uploading questions within a question set. This will not be shown in the CSV upload format to the contributor.

   1. Mandatory: Yes

   2. Default: Question Set ID where Question Upload file was provided

   3. Validation: Should exist in the platform

   4. Tip: Identifier of the Question Set where questions are to be linked

4. Taxonomy Framework Categories: These will derived from the Question set when questions are being uploaded within a question set. Questions can be uploaded in a question created for any framework - all available categories should be derived and tagged to questions. Below are sample categories for K-12 framework:

   1. Org_FW_Board

   2. Org_FW_Medium

   3. Org_FW_Class

   4. Org_FW_Subject

   5. Org_FW_Topic

   6. Org_FW_LearningOutcome is not supported in bulk upload sheet. User can edit from UI.

   7. Org_FW_Skill is not supported in bulk upload sheet. User can edit from UI.

5. License

   1. Mandatory: No

   2. Default: License of the tenant (derived).

   3. Validation: No special characters. Max 300 characters.

   4. Tip: One of the supported licenses in DIKSHA. If this is empty, default to the default license configured for the tenant.

...

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/question set 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

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>“

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 questions uploaded successfully: <no.>
   Number of questions failed: <no.>
   Number of questions pending: <no.>”

8. After the bulk upload is complete. 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 Question set editor. User cannot close it while User can close it dialog box while a bulk upload is in progress.

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. (This will be in future since we do not have support for background / minimised upload in the first version)

11. User can edit any question after it is uploaded and saved as draft in the question set. Using this user can Learning Outcome or any other detail of the question.

...