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
OIDINTERFACE	X	TEXT	32	Primary key - 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).
NMFIELD17		NUMERIC	255	User's mobile phone.
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
OIDINTERFACE	X	TEXT	32	Primary key - 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
OIDINTERFACE	X	TEXT	32	Primary key - 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
OIDINTERFACE	X	TEXT	32	Primary key - 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.