Bulk importing of users

Last Updated : Mar 06, 2015 |

Procedure

  1. On the System Manager web console, click Services > Bulk Import and Export.
  2. Click Import > User Management > Users.

    Also, to gain access to Import users, from the System Manager web console, click Users > User Management. Click Manage Users and select More Actions > Import Users.

  3. On the Import users page, in the Select Import File Type field, select one of the following file types:
    • XML

    • Excel

      Note:

      Use the Excel template that System Manager supports. If you use an unsupported template, the system displays a message <file_name>.xlsx file is not a valid excel template for the current System Manager release. Use the Excel template that you downloaded or exported from the current System Manager release.

  4. On the Import users page, in the Select File field, type the complete path of the file or click Browse to locate and select a file.
  5. Select one of the following error configuration options:
    • Abort on first error

    • Continue processing other records

  6. For the XML file type, click Complete in the import type.

    If you select the Excel file type, the system does not display the import type option.

  7. Select one of the following import options:
    • To skip users in the import file that match the existing user records in the database, click Skip.

    • To replace the users in the database with new users from the imported file, click Replace. Use this option to import new users and retain the existing users.

      If you select Excel file type, the system does not display the replace option

    • To update and merge the user attributes data from the imported file to the existing data, click Merge.

    • To delete the user records in the database that match the records in the imported file, click Delete.

      Note:

      For import by using Excel, the system deletes the user records permanently.

  8. To run the job, in the Job Schedule section, select one of the following:
    • To import the users immediately, click Run immediately.

    • To import the users at a specified time, click Schedule later, and set date and time.

  9. Click Import.

    If you use the default configurations option Importing Users > Add Users in the database, the system imports the next user record even if the import user operation encounters an error while importing a user record. The system logs an error. Skip import of users that already exist in the database. The system schedules the import job to run immediately.

    Note:

    The operations, Communication Manager synchronization and bulk import of users, must not overlap in time. When bulk import of users is in progress and if Communication Manager synchronization starts, the records that are in process fail. When synchronization is complete, the remaining bulk import records process successfully. You must reimport the records that fail to import during synchronization.