en:app:020cor:100sys:040imp:0200impusr

User Import

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

Transaction Panels

Import Users



Datafields

Datafield Description
Encoding of Import File Possible encodings are
“CP437” MS-DOS US
“CP850” MS-DOS Central Europe
“​UTF-8”​ UTF-8


en/app/020cor/100sys/040imp/0200impusr.txt · Last modified: 2022/09/02 12:45 (external edit)