Notification
Newbie
1 posts
Adobe Captivate (2019 release) supports importing of questions from a CSV file. The CSV file contains questions in a pre-defined format can be imported in Captivate to create question slides or question pools. Managing questions made simpler in Captivate 2019 as many of us uses CSV to create question banks.
The question types supported in CSV import :
- True/False
- Multiple choices
- Matching
- Fill in the Blank
- Short answer
How to create a CSV file with questions?
The CSV can be created in two ways.
- Manually entering questions in a CSV file in a pre-defined format
- Using an excel macro to generate the CSV file
Manually creating the CSV file
Snapshot of the CSV file with questions is shown below.
Instructions on how to add the questions in the CSV file can be found in https://helpx.adobe.com/captivate/using/import-questions-csv-files.html
There is a sample CSV file packaged with Captivate and it is can be found in the installed directory at the location “Adobe Captivate 2019 x64/Gallery/Quiz/SampleQuestions.csv”.
Using an excel macro to generate the CSV file
There is an Excel macro file (CSVQuestionsCreationMacro.xlsm) available in the captivate installed directory at the location “Adobe Captivate 2019 x64/Gallery/Quiz/CSVQuestionsCreationMacro.xlsm”. The instructions on how to use the macro to generate the CSV file is provided within the macro. The generated CSV file can be then imported to Captivate. All the validations will be taken care of by the macro.
How to import?
- Adding questions as slides
- In Captivate, Click Import CSV Format File from Quiz
- Select the CSV file which contains the question in the pre-defined format.
- Adding questions to question pool
- Select Questions Pools Manager from Quiz
- Select Import CSV File option
- Select the CSV file which contains the question in the pre-defined format.
An error dialog pops up if the questions imported has syntax errors.
Clicking on “Show import status” shows the status of each question in the CSV file in a tabular form.
Once the errors are corrected, the CSV file can be imported again. When importing the same CSV file again, a dialog will be shown prompting to add or overwrite the questions imported from the same file.
If “Add” option is selected, it will add the questions to the existing slides. If “Overwrite” option is selected, it will delete all the question slides imported from the same file and then add the questions.
Adobe Captivate (2019 release) supports importing of questions from a CSV file. The CSV file contains questions in a pre-defined format can be imported in Captivate to create question slides or question pools. Managing questions made simpler in Captivate 2019 as many of us uses CSV to create question banks.
The question types supported in CSV import :
- True/False
- Multiple choices
- Matching
- Fill in the Blank
- Short answer
How to create a CSV file with questions?
The CSV can be created in two ways.
- Manually entering questions in a CSV file in a pre-defined format
- Using an excel macro to generate the CSV file
Manually creating the CSV file
Snapshot of the CSV file with questions is shown below.
Instructions on how to add the questions in the CSV file can be found in https://helpx.adobe.com/captivate/using/import-questions-csv-files.html
There is a sample CSV file packaged with Captivate and it is can be found in the installed directory at the location “Adobe Captivate 2019 x64/Gallery/Quiz/SampleQuestions.csv”.
Using an excel macro to generate the CSV file
There is an Excel macro file (CSVQuestionsCreationMacro.xlsm) available in the captivate installed directory at the location “Adobe Captivate 2019 x64/Gallery/Quiz/CSVQuestionsCreationMacro.xlsm”. The instructions on how to use the macro to generate the CSV file is provided within the macro. The generated CSV file can be then imported to Captivate. All the validations will be taken care of by the macro.
How to import?
- Adding questions as slides
- In Captivate, Click Import CSV Format File from Quiz
- Select the CSV file which contains the question in the pre-defined format.
- Adding questions to question pool
- Select Questions Pools Manager from Quiz
- Select Import CSV File option
- Select the CSV file which contains the question in the pre-defined format.
An error dialog pops up if the questions imported has syntax errors.
Clicking on “Show import status” shows the status of each question in the CSV file in a tabular form.
Once the errors are corrected, the CSV file can be imported again. When importing the same CSV file again, a dialog will be shown prompting to add or overwrite the questions imported from the same file.
If “Add” option is selected, it will add the questions to the existing slides. If “Overwrite” option is selected, it will delete all the question slides imported from the same file and then add the questions.
You must be logged in to post a comment.
- Most Recent
- Most Relevant
I’ve tried to upload a CSV file but I constantly have loading errors. I have saved the file as CSV with Unicode (UTF -8) but I can’t upload the file to the Question Pool or to the project. What am I doing wrong?
Did you use the included excel template to create the CSV file?Nederlandstalig?
Yes, I used the included excel file. I saw that if I type the question it works, but if I copy paste, I get upload errors.
The limitation at this moment, compared with GIFT import, is that you cannot define partial points for a MCQ with multiple correct answers, which is possible with the original GIFT files.
I also regret that you cannot edit the third sheet from which the CSV file is exported, which I often need for localisation purposes. When editing the exported CSV file, there is an error in the last field of each question, which I logged. All has been explained in a recent blog post on this portal:
https://elearning.adobe.com/2018/09/csv-import-localisation/
