Skip to main content
Version: 2.2.1

ADMUSRCOMP - Full user data import

This import template allows inserting/editing:

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

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

Insert/edit user​

ColumnRequiredTypePrecisionDescription
CDINTERFACEXNUMERIC10Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
153 - Code of the SoftExpert Administration component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
27 - Insert user; if the record exists already, it will be edited; Department, position, teams, and access groups are replaced;
28 - Insert user; if the record exists already, it will be edited; Department, position, teams and access groups are added.
NMFIELD01XTEXT255Name used by the user to log in to the system.
NMFIELD02XTEXT255User ID.
NMFIELD03XTEXT255User name.
NMFIELD04XTEXT255Enter the user language code, in accordance with the "Database encoding" column in the Localization section, in the System Requirements document.
NMFIELD05X¹TEXT255User password.
NMFIELD06TEXT255User countersign.
NMFIELD07TEXT255Maximum number of simultaneous user connections.
NMFIELD08TEXT255User phone #.
NMFIELD09TEXT255Leader user ID #.
NMFIELD10X²TEXT255User unique ID # in the domain controller.
NMFIELD11TEXT255Enabled user (1 - Enabled, 0 - Disabled).
NMFIELD12TEXT255Blocked user (1 - Blocked, 0 - Unblocked).
NMFIELD13TEXT255FGNOTICE (1 - Receive news from SoftExpert, 0 - Do not receive news from SoftExpert).
NMFIELD14TEXT255FGUSERTYPE ().
NMFIELD15X³TEXT255ID # of the connection to the domain controller from which the user was imported (used to synchronize user data with the domain controller).
NMFIELD16TEXT255User e-mail address.
DSFIELD01TEXT4000List of department and position identifiers. Each item that represents the department and position must be represented as: 'ID #-department#ID #-position'. For there is more than one item representing department and position, the separation must be with a comma.
DSFIELD02TEXT4000List of team identifiers separated by commas, if you wish to add more than one team.
DSFIELD03TEXT4000List of access group identifiers separated by commas, if you wish to add more than one.
info

Note:

  • X¹ - The password is required only for user registration; for user editing, the password is an optional field.
  • X² - The user unique ID # in the domain controlled is required for creating and editing domain users.
  • X³ - The ID # of the connection to the domain controller from which the user was imported is required for creating and editing domain users.