Troubleshooting the Question Bank Import

Use the following as a guide when troubleshooting a Question Bank import.

CSV file fails to upload

If the CSV file fails to upload, check the file for the following:

• Column A (qPoolID)

  • For creating a new question bank, this field must be left blank.
  • For editing an existing question bank, this field must match the qPoolID retrieved from TopClass.

• Column D (questionID)

  • For creating a new question bank, this field must be left blank.
  • For editing an existing question in a question bank, this field must match the questionID retrieved from TopClass.
  • For adding a new question to an existing question bank, this field must be left blank.

CSV file uploads but not all questions are created

If the CSV file uploads but not all questions are created, review the following:

• Import Question Result notification in your TopClass message center.

  Depending on the failure reason, details may be given on the failure row(s) and the failure reason ( e.g., Column B (qPoolTitle) left blank).

• Review the CSV file to ensure all mandatory fields have been completed.

• Review the fields for any Unicode characters(e.g., £$%^&*/ é).

  If Unicode characters have been used, the CSV file must be UTF-8 encoded.

Converting a CSV file to a UTF-8 encoded file

To convert a CSV file to a UTF-8 encoded file, do the following:

1. Open the CSV file in Notepad++ or a similar editor.
2. Click Encoding.
3. Select Convert to UTF-8.
4. Click Save.

📘

Note

If the CSV file has been downloaded and subsequently edited or it has been received via email, Notepad++ may not allow the file to be converted.

If Notepad++ will not convert the CSV file to a UTF-8 encoded file, do the following:

1. Create a new CSV file.
2. Copy all data into the new file.
3. Repeat the conversion steps above.

See Question Bank Import Overview for full details. For further assistance, enter a Support Ticket.