This import template enables to insert/edit:
▪Data of a user; ▪Relationship between User, Department, and Position; ▪Relationship between User and Access group.
To insert each of these items, it is necessary to follow the standard documented below.
Insert/edit user
|
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:
1 - Insert user. If it exists, edits it;
2 - Insert user. If it exists, returns an error;
3 - Edit user. If it does not exist, returns an error.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Name used by the user to log into the system.
|
NMFIELD02
|
X
|
TEXT
|
255
|
User's reg. code #.
|
NMFIELD03
|
X
|
TEXT
|
255
|
User name.
|
NMFIELD04
|
X
|
TEXT
|
255
|
Enter the user language code, in accordance with the "Database Encoding" column of the Localization section, in the System Requirements document.
|
NMFIELD05
|
X
|
TEXT
|
255
|
User password.
|
NMFIELD06
|
|
TEXT
|
255
|
User countersign.
|
NMFIELD07
|
|
TEXT
|
255
|
Maximum number of simultaneous user connections.
|
NMFIELD08
|
|
TEXT
|
255
|
User phone #.
|
NMFIELD09
|
|
TEXT
|
255
|
Leader ID #.
|
NMFIELD10
|
|
TEXT
|
255
|
User unique ID # in the domain controller.
|
NMFIELD11
|
|
TEXT
|
255
|
Enabled user (1 - Enabled, 0 - Disabled).
|
NMFIELD13
|
|
TEXT
|
255
|
Receive news from SoftExpert:
1 - Yes;
0 - No.
|
NMFIELD15
|
|
TEXT
|
255
|
ID # of the connection with the domain controller where the user was imported from (Used in the user data synchronization with the Domain controller).
|
DSFIELD01
|
X
|
TEXT
|
4000
|
User e-mail address.
|
DSFIELD02
|
|
TEXT
|
4000
|
User description.
|
Insert/delete relationship between user, department, and position
|
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:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
4 - Insert relationship between user, department, and position;
6 - Delete relationship between user, department, and position.
|
NMFIELD01
|
X
|
TEXT
|
255
|
User's reg. code #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Department ID #.
|
NMFIELD03
|
X
|
TEXT
|
255
|
Position ID #.
|
NMFIELD04
|
X
|
NUMERIC
|
2
|
Default department:
1 - Yes;
2 - No.
|
Insert/delete relationship between user and access group
|
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:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
13 - Insert relationship between user and access group;
14 - Delete relationship between user and access group.
|
NMFIELD01
|
X
|
TEXT
|
255
|
User's reg. code #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Access group ID #.
|
Disable user
|
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:
153 - Code of component SoftExpert Administration.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
5 - Disable user.
|
NMFIELD01
|
X
|
TEXT
|
255
|
User's reg. code #.
|
|