Show TOC

Procedure documentationLoading 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.

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 Sites File

    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.

Procedure

  1. In the administration console, choose Start of the navigation path Extras Next navigation step Upload Users/Sites End of the navigation path, and select Execute.

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

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

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

Result

Possible errors are reported after processing.