ADMUSR - User data import

This import template allows inserting/editing:

• User data;
• Relationship between user, department, and position;
• Relationship between user and access group.

For the insertion of each one of these items, the standard documented below must be followed.

Insert/edit user

Column	Required	Type	Precision	Description
CDINTERFACE	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	Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component.
FGOPTION	X	NUMERIC	2	Code of the operation to be performed: 1 - Insert user; if the record exists already, it will be edited; 2 - Insert user; if the record exists already, an error will be returned; 3 - Edit user; if the record exists already, an error will be returned;
NMFIELD01	X	TEXT	255	Name used by the user to log in to the system.
NMFIELD02	X	TEXT	255	User ID.
NMFIELD03	X	TEXT	255	User name.
NMFIELD04	X	TEXT	255	Enter the user language code, in accordance with the "Database encoding" column in 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 user 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 to the domain controller from which the user was imported (used to synchronize user data with the domain controller).
DSFIELD01		TEXT	4000	User e-mail address.
DSFIELD02		TEXT	4000	User description.

Insert/delete relationship between user, department, and position

Column	Required	Type	Precision	Description
CDINTERFACE	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	Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component.
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 ID.
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
CDINTERFACE	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	Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component.
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 ID.
NMFIELD02	X	TEXT	255	Access group ID #.

Disable user

Column	Required	Type	Precision	Description
CDINTERFACE	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	Code of the system for which the integration will be performed: 153 - Code of the SoftExpert Administration component.
FGOPTION	X	NUMERIC	2	Code of the operation to be performed: 5 - Disable user.
NMFIELD01	X	TEXT	255	User ID.