This article defines the three-step process to create a Question Based Assessment’s (QBA’s) for bulk importing questions through a JSON template.
3 step process to publish an assessment using JSON templates:
- Create a Question Based Assessment (QBA) with one sample question on 6clicks.
- Convert an excel sheet with questions to JSON template.
- Import JSON and publish the assessment.
1. Create a Question Based Assessment (QBA) on 6clicks.
i. Follow this step-by-step guide to create a QBA.
ii. To add a question, follow this article.
Note: You just need to add one question to build a sample template. For this approach to work, all questions are needed to be of same type only (like Multiple Choice, Checkbox, Dropdown etc). If a question is of a different type, you may need to add it manually.
iii. Export the sample template (sample assessment 12), More > Export (JSON)
iv. Open the exported template and you will see the different sections of an Assessment like Assessment name, Question name, Domain name, Answer options, linked provisions etc.
We will utilize the provided JSON template to transform the CSV file containing questions into a JSON format suitable for import into 6clicks.
2. Convert an excel sheet with questions to JSON template.
The next step involves aligning different sections from the CSV file with the structure of the imported JSON template.
i. From the provided JSON template, cut the section under "Questions": [. This will serve as the template to import all questions from the given CSV file.
ii. Update the fields within the JSON file to correspond with the column positions in the CSV file.
For example, the "Domain Name" is situated in the initial column of the CSV file. Therefore, align the "DomainName" field with the primary column in the JSON file, similarly for other fields by adding “{f1}”, “{f2}”, "{f3}" and so on. This signifies the position of field in the csv.
iii. Go to https://www.convertcsv.com/csv-to-json.htm
iv. Upload assessment (CSV file) to "step 1".
v. Copy and paste the JSON template created in "step 4" (remove all the existing tags) and click on “Convert CSV to JSON via Template”.
vi. Copy the output from “step 5” and paste it into the area under "Questions": [ part of step i.
Our final JSON is ready with all the questions present in the csv file.
3. Import JSON and publish the assessment.
i. Go to the 6clicks account where you created the sample assessment (sample assessment 12 – step 1.iii in this case.)
ii. Import the JSON created in step 2.vi.
All the questions are now imported into the sample assessment.
Video Tutorial: