Loading User Data and Sites
You use this function to load user data for employees and sites into the CRM middleware repository for the first time. You can also create assignments between employees and sites, and between sites and subscriptions.
User data can only be loaded for employees that already exist in the SAP CRM system. Likewise, the subscriptions to be assigned must have already been created in the Administration Console
.
At least one ASCII file is required for user data and site information. A further ASCII file contains the subscriptions that are to be assigned.
Field Name |
Description |
Length |
|
|---|---|---|---|
NAME_LAST |
Employee's last name |
40 |
|
NAME_FIRST |
Employee's first name |
40 |
|
USERID |
User ID of the employee |
40 |
Has to be unique |
PASSWORD |
Password of the employee |
5-10 |
If the field is empty, the initial value is valid. |
SITE_NAME |
Name of the site |
32 |
Has to be unique |
SITE_DESCR |
Description of the site |
255 |
|
SITE_TYPE |
Site type |
30 |
For mobile clients: SAP mobile client CRM |
CNGP_NAM |
Connection group |
40 |
You can find the valid connection groups in the administration console. |
TRSV_GRP |
Name of the transport group |
40 |
You can find the valid transport groups in the administration console. |
INACTIVE |
Indicator |
1 |
To generate the sites as inactive, set X. |
The fields have to be separated by tabs.
Name and order of the fields must not be changed.
The data is separated by tabs and displayed in the following rows.
Field values that exceed the length limit are cut.
The entire line is not accepted if the user ID is not unique, the password length is incorrect, the site name or site type is not unique, or CNGP_NAM or TRSV_GRP cannot be found in the database.
The values of the fields SITE_TYPE, CNGP_NAM, TRSV_GRP, and SUBSCRNAME must be written correctly.
The entries are case-sensitive: make sure that you enter the data correctly. Otherwise your data may not be accepted.
If a line in the ASCII file contains an error, the report continues processing at the next line.
The second ASCII file contains SUBSCRNAME (length 64) as its header line. This is where you can enter the names of existing subscriptions.
Only subscriptions for publications with type Unfiltered can be assigned to the sites.
The system ignores all other specified subscriptions, and subscriptions that are not found in the database.
In the administration console, choose , and select Execute
.
Select No DB-update - only data check
, to check the data that has been provided for loading.
Specify whether the activation status of the sites is taken from the ASCII file, or whether all sites to be loaded with status activated or deactivated should be transferred to the administration console.
If you do not want the activation status to be read from the ASCII file, then any status information that the file may contain is ignored during the import.
Choose the directory and name of the ASCII file(s) to be loaded and choose Execute
.
Possible errors are reported after processing.