Import Questions

Questions can be imported, allowing them to be reviewed, approved rejected or retired offline instead of in the question editor. This can be useful for adding questions and making updates in bulk. It is also helpful for allowing subject matter experts who do not have access to the LMS to review the questions.

To import questions your role must have unrestricted access to the Exam Manager Data Loader feature.

Create the Import File

There are two options for creating the import file.

Use the CSV Template

Used primarily when you are simply adding new questions.

Go to Manage Center > Learning > Exam Utilities > Question CSV Loader. CSV download and import actions are located on the right side of the screen.

Click Download CSV file template.
Prepare the file for import.

Export Existing Questions to a CSV file

This option is useful if you are making updates to existing questions. The file is exported in the same format as the CSV template.

You can add new questions in this template as well. This is a great option if you want to update and add within the same import.

On the Questions page, filter the list of questions to select only those that you need to export. This step is optional, but recommended to allow you to focus on only the questions that need to be updated.
Click Export to CSV. The Questions.csv is downloaded to your browser's default downloads location.
Prepare the file for import.

Click the CSV Formatting Help link for important guidelines around preparing the file for import.

CSV files are likely to be opened by Microsoft Excel if it is installed on your system. If you encounter any problems with importing a CSV file into the LMS, it could be caused by Microsoft Excel applying extra formatting to the file.
As an alternative, you can edit CSV files in a text editor. The data should conform to the formatting required by the template as specified in the corresponding CSV Formatting Help.
If the values for text area fields include punctuation, these fields must be enclosed in double quotation marks (" "). Do not include commas or semicolons in other fields as they could be interpreted as a field delimiter (depending on your choice of delimiter at import).

Import the File

Go to Manage Center > Learning > Exam Utilities > Question CSV Loader.
Click + Import CSV file.
Click Choose File to select the CSV file to upload.
Configure the import fields:

Encoding - If the CSV file was saved with a specific file encoding the LMS can automatically detect it, otherwise you can select it from the list.
Delimiter - Select the delimiter used to separate the values in the file.
Permissions - If you are importing new questions, select the permissions to assign to all new questions. Select Public to give unrestricted access to users in all organizations in the LMS, or Private to give unrestricted access only to the question owner specified in the CSV file.
Status - If you are importing new questions, select the default question status.

Click Preview. The contents of the CSV file are shown in the Data Loader page so that you can review the data before importing the file.
Click Upload to import the CSV file. The Summary Report shows how many records in the file were imported successfully and how many failed.
If any records fail to import, you can return to the CSV Loader page and click the CSV Error Report link for the failed import. The report downloads to your desktop as a copy of the original file, with error messages included for each record that couldn't be imported.

Are you a PeopleFluent administrator?
Check out our Help Center or Contact Support.