This import template enables to insert/delete:
▪Association between a team and a department, position, or user
To insert each of these items, it is necessary to follow the standard documented below:
Insert
|
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:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
34 – Associate (department, user, position) with a team;
35 – Remove existing association.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Team ID # (required field for deletion).
|
NMFIELD02
|
X
|
TEXT
|
255
|
Create team with:
1 – Departments;
2 – Users;
3 – Positions.
(required field for deletion)
|
NMFIELD03
|
X
|
TEXT
|
255
|
ID # of the (departments, users, positions) that will be associated (separated by “,”). Example: “User1”, “User2”, “User3”.
(required field for deletion)
|
|