This import template makes it possible to:
▪Insert population data; ▪Delete population data.
To insert each of these items, it is necessary to follow the standard documented below.
Insert population data
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
TEXT
|
32
|
Sequential code - 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
|
System code where the integration will be performed to:
90 – Code of the SoftExpert Audit component.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
22 – Insert population data.
|
NMFIELD01
|
X
|
TEXT
|
50
|
Population ID #.
|
NMFIELD02
|
X
|
TEXT
|
50
|
Population data ID #.
|
To delete all population data, the standard documented below must be followed.
Delete population data
|
Column
|
Required
|
Type
|
Precision
|
Description
|
OIDINTERFACE
|
X
|
NUMERIC
|
10
|
Sequential code - 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
|
System code where the integration will be performed to:
90 – Code of the SoftExpert Audit component.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
23 – Delete all population data.
|
NMFIELD01
|
X
|
TEXT
|
50
|
Population ID #.
|
|