This import template enables to insert/edit:
▪Data of a user; ▪Relationship between User, Department, and Position; ▪Relationship between User and Access group. ▪Relationship between User and Team.
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:
27 - Inserts user; if existing, edit existing user. Department, position, teams and access groups are substituted;
28 - Inserts user; if existing, edit existing user. Department, position, teams and access groups are added;
|
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
|
X2
|
TEXT
|
255
|
User unique ID # in the domain controller.
|
NMFIELD11
|
|
TEXT
|
255
|
Enabled user (1 - Enabled, 0 - Disabled).
|
NMFIELD12
|
|
TEXT
|
255
|
Blocked user (1 - Blocked, 0 - Unblocked).
|
NMFIELD13
|
|
TEXT
|
255
|
FGNOTICE (1 - Receive news from SoftExpert, 0 - Do not receive news from SoftExpert).
|
NMFIELD14
|
|
TEXT
|
255
|
FGUSERTYPE ().
|
NMFIELD15
|
X3
|
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).
|
NMFIELD16
|
X
|
TEXT
|
255
|
User e-mail address.
|
DSFIELD01
|
|
TEXT
|
4000
|
List of department ID # and position ID #. For each item that represents the department and position, it must be represented as: 'ID #-department#ID #-position'. In case of more than one item such as department and position, a comma must be used to separate it.
|
DSFIELD02
|
|
TEXT
|
4000
|
List of team IDs # separated by commas if you wish to add more than one team.
|
DSFIELD03
|
|
TEXT
|
4000
|
List of access groups IDs # separated by commas if you wish to add more than one.
|
|