Adobe Captivate allows you to import questions from a CSV file into your projects. This feature offers several benefits, including efficiency, convenience, and error reduction. You can create, edit, and manage questions using spreadsheets, and then import them into Adobe Captivate, saving time and effort.
The CSV file must follow a specific format, including columns for question type, points, question stem, answer options, and slide type. Different question types, such as multiple choice, true/false, matching, sequence, and short answer, can be imported. If there are any errors or issues with the CSV file, Captivate provides you with guidance on the further steps.
Captivate offers a sample CSV file containing all the necessary fields to facilitate your tasks.
You can download the sample CSV file here:
Download
If you are using Captivate Classic, refer to this article for more information on importing questions to your project.
These are the types of questions that can be imported from a CSV file in Adobe Captivate:
Use the sample CSV provided by Captivate to add the question data. Follow these steps:
Open a new spreadsheet or the sample CSV provided by Captivate. The sample CSV file is shipped with Captivate and is available here:
Make sure to adhere to the syntax and rules provided in the documentation to avoid errors during the import process. Input the data for each question as a row in the following format, keeping the same columns as headings.
For KC (Knowledge check) slides, points can be disregarded as they are not part of the grading criteria.
|
Column name |
What is to be filled? |
|---|---|
|
//Question type |
MC – for multiple choice questions. TF – for true/false questions. MAT – for match the following questions. SEQ – for sequence questions. SA – for short answer questions. |
|
//Points |
Points assigned to the question. Must be numeric and cannot have negative values. |
|
//Question Stem |
Text for each question. |
|
// Answer Option 1,2,3… |
Different answer options are based on the type of question. True/False questions require TRUE and FALSE as answer Options. Prefix the correct answer with an asterisk(*). |
|
//Slide Type |
G – for graded question slide. KC – for knowledge check question slide. |
Save the file as a .CSV file. This file is now ready to be imported to Adobe Captivate for use in your projects.
Once you are ready with your questions CSV file, you can import it, either from the file menu or from the slide navigator.
Select File menu > Import> Import CSV or from the slide navigator, select New slide > Import CSV.
If the CSV does not contain any errors, the import is successful. You will observe that the project is populated with all the question slides according to the format specified in the CSV file.
If you encounter errors during CSV import, download the log file to identify and fix the issues. Rectify errors in the CSV and re-import the file. Issues may include syntax errors, unwanted characters, or empty values. Captivate prompts authors about slides that could not be imported successfully.
You can proceed to insert the remaining slides that are error-free and work on the ones that did not import. This helps to simplify and unblock the workflow. You have the option to either address the errors based on the log file and import again or add the remaining slides manually.
The error log file serves as a valuable resource for identifying and addressing erroneous entries. It furnishes details such as the precise location and nature of the errors encountered. The location of an error is specified by denoting the row and column of the cell affected.
By referencing these cell locations within the corresponding CSV file, you can easily pinpoint the problematic cells. Once identified, you have the opportunity to rectify the issues directly within the CSV file. After making the necessary corrections, you can proceed to re-import the file, ensuring a smoother and error-free process.
To troubleshoot issues in importing CSV in Adobe Captivate, you can follow these best practices:
