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. |