Navigation:  Integration via database > Published interfaces > Survey >

SRVRESP - Survey respondent import

Previous  Top  Next

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.

 

X¹: Required when importing a guest user.