Importing New Users from a Spreadsheet

Use the following steps to add new user accounts without updating existing user accounts.

To import new user accounts and Contacts records:

  1. Prepare a spreadsheet by exporting it from an external user store or creating it manually. For guidelines, refer to Preparing a Spreadsheet for Importing Users.
  2. Verify that the Do Not Modify option is selected. This prevents existing user accounts from being updated if they exist in the spreadsheet.
  3. In the Import user spreadsheet area, click Browse and navigate to the spreadsheet that contains users you want to import.
  4. Click Find to search for a user that will serve as a template for the imported users. Imported accounts receive the template user's product-access type, role assignments, group membership, privileges, preferences, notification subscriptions, and password settings.
  5. To create Contacts records for the imported users, select the Create Associated Contacts check box.
  6. Map spreadsheet data to SBM user and Contacts record fields. For guidance, refer to Mapping Attributes to SBM Fields.
  7. Set logging parameters as described in Logging And E-mail Options.
  8. Decide if temporary passwords should be generated for active users that are imported or updated. This option is useful in the event that the e-mail that contains the user's initial temporary password is sent to the wrong e-mail address or if it is no longer available. Note the following:
    • If your system will not use Windows or LDAP authentication after the import is finished, this option helps ensure that users are not created with empty passwords.
    • This option is disabled if your system uses Windows or LDAP-only authentication in which passwords are not stored in SBM.
    • When this option is selected, an e-mail is automatically sent to each user with the newly-generated temporary password.
    • If new users have not changed their temporary passwords yet, and you are updating users, this option regenerates the temporary passwords for those users as well. The users will still be required to change the password upon initial log in.
    • This option is selected by default.
    • This option is disabled if the Password user attribute is mapped to a column in your spreadsheet.
  9. Click Import now to begin the import.
  10. Select the Import Log tab to monitor the progress of your import.