This transaction is used to import new users into the database or to update existing user data (e.g. changing the language of the user interface, modifying the user profile, etc.).
Text files are used for the import. One line in such a file represents one user. Each field has to have a defined, fixed field length.
The storage location of the import file can be determined via the fields “File Path” and “File Name” .
After clicking the icon the users are imported into the database. At the same time, the rights of the user within the system are updated accordingly in the file TDRIGHTS.INI.
Note: The subdirectory BATIN must be created in the DATA directory of the application. The converted import file has to be in that subdirectory. The structure of the import file depends on each individual environment and has to be clarified between the user and Surecomp DOS.
The file has to be available in ASCII format and has to have a .txt extension.
In the Developer Documentation further information about the Standard Import Procedures and customization requirements can be found.
Column | Field Size | Target Field(s) | Realization | Description |
---|---|---|---|---|
1 | 8 | USR\EXTKEY | User ID | |
9 | 40 | USR\NAM | User Name | |
49 | 8 | USR\ETY | Entity | |
57 | 1 | USR\LGIFLG | no text - Login profile enabled Y - No login profile | Login Profile |
58 | 1 | USR\PRI | 'X' for marking primary entity | |
59 | 6 | USR\USG | User Group | |
65 | 1 | USR\RELGRP | A - Authorized N - Not authorized | Release |
66 | 30 | USR\TEL | Phone | |
96 | 30 | USR\FAX | Fax | |
126 | 80 | USR\EML | ||
206 | 4 | USR\OENR | Org. Unit | |
210 | 8 | USR\ETAEXTKEY | Key of Entity Adress | |
218 | 40 | USRSEC\PRF | Profile | |
258 | 2 | USRSEC\UIL | Codes from Codetable “UILTXT” | Language |
260 | 1 | USRSEC\SECSTA | 0 - Normal 1 - Expired 2 - Blocked 4 - Reset 5 - New Password | User Status |
Datafield | Description |
---|---|
Encoding of Import File | Possible encodings are “CP437” MS-DOS US “CP850” MS-DOS Central Europe “UTF-8” UTF-8 |