Loading User Data and Sites 

Use

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.

Prerequisites

·        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.

Header of the employee and site file

 

Field name	Description	Length
NAME_LAST	Employee surname	40
NAME_FIRST	Employee 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	Flag	1	To create the sites inactive, set X.

·        The fields has to be seperated 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.

¡        Remember that the system distinguishes between upper case and lower case. Otherwise your data may not be accepted.

¡        If a line in the ASCII file contains an error, the report will continue 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.

Procedure

...

       1.      In the Administration Console, choose Extras ®Load Users/Sites and choose Execute.

       2.      Select No DB-update – only data check in order to check the data that has been provided for loading.

       3.      Specify whether the activation status of the site is taken from the ASCII file or whether all sites to be loaded with status activated or deactivated are to be adopted in 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.

       4.      Choose the directory and name of the ASCII file(s) to be loaded and choose Execute.

Result

Possible errors are reported after processing.