This import template makes it possible to insert:
▪Guest, internal and external respondents who will be recorded in the survey. The survey must be previously created.
To insert each one of these respondents, it is necessary to follow the standard documented below.
Insert
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
TEXT
|
32
|
Sequential code - Identifies a respondent 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
|
System code where the integration will be performed to:
214 – Code of SE Survey component
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
1 – Insert respondent
|
NMFIELD01
|
X
|
TEXT
|
255
|
Survey ID #
|
NMFIELD02
|
X
|
TEXT
|
255
|
Respondent e-mail. When the user type is internal, the field must be filled out with the internal user ID.
|
NMFIELD03
|
X1
|
TEXT
|
255
|
Respondent name.
|
NMFIELD04
|
X
|
NUMERIC
|
2
|
User type for the import:
1 – Internal user;
2 – Guest user;
3 – External user;
4 – Customer;
5 – Supplier.
|
|