Transaction IMPUSR
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.).
Import File Requirements
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.
Field Mapping
| 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 |
Please follow the below gif and the step mentioned to upload files into the system :
1.Set up the putty configuration as shown
2.Select the file to transferred .Do a drag and drop
3.Execute the command in DOKA .Incase of Currency upload follow section Processing of files
Follow the below gif to upload users in bulk
Sample Template used has been attached for reference
Comments
0 comments
Please sign in to leave a comment.