SRVQUESTION - Question import

This import template allows inserting:

• Questions.

To insert each question, the standard documented below must be followed.

Insert

Column	Required	Type	Precision	Description
OIDINTERFACE	X	TEXT	32	Primary key - Identifies an item to be imported into SoftExpert Suite.
FGIMPORT	X	NUMERIC	2	Import status: 1 - New; 2 - In progress; 3 - Finished; 4 - Error.
CDISOSYSTEM	X	NUMERIC	10	Code of the system for which the integration will be performed: 214 - Code of the SoftExpert Survey component.
FGOPTION	X	NUMERIC	2	Code of the operation to be performed: 2 - Insert question.
NMFIELD01	X	TEXT	255	Question type: 1 – Single selection - Vertical; 2 – Single selection - Horizontal; 3 – Single selection - Vertical matrix; 4 – Single selection - Horizontal matrix; 5 – Single selection - In list; 6 – Single selection - NPS; 7 – Multiple selection - Vertical; 8 – Multiple selection - Horizontal; 9 – Multiple selection - Vertical matrix; 10 – Multiple selection - Horizontal matrix; 11 – Long description; 12 – Short description; 13 – Date/time; 14 – Date; 15 – Time; 16 – Classification.
NMFIELD02		TEXT	255	Question group ID #
NMFIELD03		TEXT	255	Degree of difficulty ID #
NMFIELD04		TEXT	255	Required: 1 - Yes; 2 or empty – No.
NMFIELD05		TEXT	255	Evaluative question [test mode]: 1 – Yes; 2 or empty – No.
NMFIELD06		TEXT	255	Allow attachment when answering question: 1 - Yes; 2 or empty – No.
NMFIELD07		TEXT	255	Require an attachment to be added when answering the question: 1 - Yes; 2 or empty – No.
NMFIELD08		TEXT	255	Allow selecting the same response for all questions: 1 - Yes; 2 or empty – No.
DSFIELD01	X	TEXT	4000	Question
DSFIELD02		TEXT	4000	Help text
DSFIELD03		TEXT	4000	Matrix questions (separated by "|")
NRFIELD01		NUMERIC	10	Weight (1 to 999) If it is not entered, it will be considered as 1.