Load Questions - Template and Validations

The Questions template contains all of the fields that can be loaded via the Data Load Wizard. Each Reference Number must be unique.

The Questions template contains the following data fields:

System Field Type Limit Comments/Rules
Question Reference Number String 50 This field is required. This is the unique identifier for the question.
Question Text String 2000 This field is required. This is the question text. This field can be localized. If a value is not available for user's language, the field is displayed in the default language of the question, which is the display language for the administrator who created the question.
Response Type String   This field is required. This specifies the type of response that is required for the question. This affects the question options that are available for the question. Each response type has an ID. The value that is entered must be a valid response type ID. Please refer to the Data Mapping Report by selecting the Data Mapping Report link on the Upload page for a list of valid response types and their associated IDs. Note: The Click On Image response type is not supported by the Data Load Wizard.
Correct Answer Boolean or String 1000

This field is required. This specifies the correct answer for the question.

  • When the response type is True/False or Yes/No, this value must be one of the following: True, False, T, F, Yes, No, Y, N, Active, or Inactive.
  • When the response type is Text, this value must be Null. Responses must be loaded in the Question Responses template.
  • When the response type is Free Form, this value must be Null. Correct answers cannot be provided for this question type.
  • When the response type is Multiple Choice/Single Answer or Multiple Choice/Multiple Answer, this value must be Null. Responses must be loaded in the Question Responses template.
Answer Explanation String 300 This field is optional. This provides an explanation for correct answers.
Category String   This field is required. This is the category for the question. This must be a valid Category ID within the system. Active and inactive categories are supported. Test and evaluation questions have unique categories. Please refer to the Data Mapping Report by selecting the Data Mapping Report link on the Upload page for a list of valid categories and their associated IDs.
Active Boolean 50 This field is optional. This sets the status of the question to Active or Inactive. Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive. If this field is blank, then it defaults to False.
Author ID   This field is optional. This specifies the author of the question. This must be a valid User ID within the system. Active and inactive users are supported.
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 for a list of valid Culture IDs.
Default Language String   This field is optional. This must be one of the known active languages in the Culture table. This is only used if multiple languages are enabled for the portal. When this field is blank, then it defaults to the display language of the administrator who is loading the data.
Multiple Choice Random Answer Selection Boolean   This field is optional. When this is set as True, the system randomly selects a subset of the provided responses to display to the user. Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive. If this field is blank, then it defaults to False. This must be set to False when Response Type does not equal Multiple Choice/Multiple Response or Multiple Choice/Single Response.
Multiple Choice Answers to Always Display Integer 6 When Multiple Choice Random Answer Selection is set to True, then this is the number of responses that are displayed to the user. This field is required when Multiple Choice Random Answer Selection is set as True. Otherwise, this field must be blank. The value must be greater than or equal to the number of Correct multiple choice responses.
Delete Boolean   This field is optional. When this field is set to True, then the question will be deleted from the system. Questions cannot always be deleted. See Load Question Data - Considerations. Values must be either True, False, T, F, Yes, No, Y, N, Active, or Inactive.
Question Type Numeric   This field is required. This determines whether the loaded questions are for tests or evaluations. This must be a valid Question Type ID. Please refer to the Data Mapping Report for a list of valid response types and their associated IDs.
Evaluation Type String   This field is required for evaluation questions, and must be Null for test questions. Each evaluation type in the system contains its own question bank. This determines the evaluation type for the evaluation question so that the question is loaded to the appropriate question bank. This must be a valid Evaluation Type ID. Please refer to the Data Mapping Report by selecting the Data Mapping Report link on the Upload page for a list of valid response types and their associated IDs.