Load Question Responses - Template and Validations

Learning Loads Deprecation: Ability to perform learning data loads using Data Load Wizard will be deprecated with and end-of-life in the February '21 Release. Edge Import replaces this functionality. For more information on learning loads deprecation, See Learning Data Load Overview. For information about Edge Import, See Edge Import Homepage.

The Question Responses template contains all of the fields that can be loaded via the Data Load Wizard.

Multiple Choice Responses Validation: When loading response choices for a multiple choice question, the total number of responses that are available for the question (available within the system and being loaded) must be greater than or equal to the Multiple Choice Answers to Always Display value for the question, which is set at the question level.

Multiple Choice Responses Validation: When loading response choices for a multiple choice question, the total number of responses that are set to always display for a question must be less than or equal to the Multiple Choice Answers to Always Display value for the question, which is set at the question level.

The Question Responses template contains the following data fields:

System Field Type Limit Comments/Rules
Question Reference Number String 50 This field is required. This is the reference number for the question for which the multiple choice responses are being loaded. The corresponding question must have a response type of Multiple Choice/Multiple Response or Multiple Choice/Single Response.
Response Order Integer 6 This field is required. This specifies the order of the responses for multiple choice questions. This order serves as the identifier for each response. If a response or correct answer for a question is updated, the Response Order value must be referenced. The Response Order must be unique per response choice within a question. Also, the Response Order must be a sequence of numbers (e.g., 1, 2, 3), and the sequence can have gaps (e.g., 1, 3, 8). Duplicate Response Order numbers are not supported within the same question.
MC Response Choice/Text Correct Answer String 500 This field is required. When the question type is Multiple Choice, these values are the multiple choice options that are displayed to the user. When the question type is Text Only, then this is the correct answer for the question. Values can be localized. This must be set to Null when the Response Type is not Multiple Choice or Text Only.
Multiple Choice Correct Response Boolean or Text 1000

This indicates whether the response choice is the correct answer for a multiple choice question.

  • When the Response Type is Multiple Choice/Single Answer, only one correct answer is supported for each question.
  • When the Response Type is Multiple Choice/Multiple Answer, at least one correct answer must be selected for each question.
  • When the Response Type is Text Only, this must be set to Null.

Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive.

Always Display Response Boolean   Select this option to always display the option as a response choice. This only applies if Random Answer Selection is set to True for the question and not all choices are displayed. Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive. This must be set to Null when the Response Type does not equal Multiple Choice/Single Answer or Multiple Choice/Multiple Answer.
Culture ID String   This field is optional. This is the language for which the question is localized (translated). This must be a valid Culture ID. Please refer to the Data Mapping Report by selecting the Data Mapping Report link on the Upload page for a list of valid Culture IDs.
Delete Boolean   This field is optional. When this field is set to True, then the response choice will be deleted from the system. Responses cannot always be deleted. See Load Question Data - Considerations. Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive.