Import users from a .csv file Skip Navigation

Import users from a .csv file

When you import user details into
BlackBerry Alert
using a .csv file, the values that exist in the .csv file overwrite any existing values in the database. If the file contains blank fields, the current values in the database are replaced by empty values. You should make sure that all required fields are populated before you upload the file.
To import users from a file, the file must be correctly formatted. If you do not know how to format the file, see Format a user import file.
To import operators from a file, see "Importing and exporting operators" in the
BlackBerry Alert
Operators and Administrators Guide
.
If duplicate users (identified by username or mapping ID) are found in the .csv file, they  are not imported and one of the following error messages is displayed:
[Username]: <username> already exists in the payload
[Mapping ID]:<mapping id> already exists in the payload
The remaining non-duplicate users in the .csv file are imported.
If a username contains a space or one of the following characters, the user is not imported and an error message is displayed:
[ ] : ; | = , + * ? < >
If the username contains leading or trailing spaces, the spaces are ignored and trimmed during the import process. After the spaces are trimmed, the user is imported.
  1. In the navigation bar, click
    Users
    .
  2. Click
    Users
    .
  3. Click
    More Actions
    >
    Import
    >
    Users
    .
  4. Select the
    Import
    option.
  5. If you want to download a blank .csv file to use as a template for your import user file, click the
    Download a template CSV file
    link. Save the file to your computer and fill in the appropriate user information.
    Using the template ensures that all of the mandatory attribute columns are included in the import file.
  6. Click
    Browse
    .
  7. Navigate to the location of the import user file on your computer.
  8. Open the file to enter or modify the user data.
  9. Ensure that columns with multiple values have the correct format to import correctly.
    • The entire entry must be enclosed within double-quotes. This rule is true even if the multi-select picklist has only a single entry.
    • A comma must be used to separate each of the values. There can be no spaces before or after the comma.
      Examples:
      • This example shows two column names, separated by a comma (no space before or after the comma).
        POSITIONS
        is a multi-select picklist column:
        USERNAME,POSITIONS
      • This example shows a multi-select picklist attribute column with multiple entries:
        Cadiz,"ESH Team Tech Supv,FMT Coordinator,SITE 300,Exercise Call Out,Field Monitoring Team,Coordinator DOC"
        • The entire entry starts and ends with regular double-quote characters (not the "smart quotes" used by some word-processors).
        • Each picklist entry is separated by a comma (no spaces before or after the comma).
        • An entry can have a space within it. For example:
          Field Monitoring Team
      • This example shows a multi-select picklist attribute with a single entry:
        East,"LEDO"
  10. Optionally, make sure that any geolocation attributes in the .csv file are in the correct string address, "Latitude,Longitude" or Point(long,lat) format. For example, 311 Fairchild Drive, Mountain View, CA, "37.538226,-122.32726", or POINT(-122.32726,"37.538226).
  11. (Optional, for enterprise organizations with user uniqueness enabled.) If you want to prevent users from being moved between organizations after you have imported them, include the
    Prevent User Move
    column, and enter
    Yes
    for all users.
  12. After you have entered your data, save and close the file.
    Microsoft Excel hides some characters from view. If you edit the file in Excel, it might format your entries with extra characters. The incorrect format might cause the import operation to fail. If you are using anything other than a text editor for the above steps, complete steps 13 through 15. Otherwise, skip to Step 16.
  13. Optionally, save and close the file.
  14. Optionally, open the file in a text editor such as Microsoft Notepad, review the syntax for problems, then save the modified file as a .txt file.
  15. Optionally, edit the file name and manually change the extension from
    .txt
    to
    .csv
    .
    The import function requires a
    .csv
    file type. This method preserves the formatting in the text file.
  16. Click the filename, and click
    Open
    to upload the file into the system.
    The filename appears in the User CSV File field on the Import User File screen. Each of the columns from the import file are listed in the
    Select the columns to import
    section.
  17. Optionally, select the
    Partial User Import Enabled
    check box to enable partial user data to be imported. When selected, if a user entry contains an invalid value, the rest of the user's data is still imported.
    Even if you do not select this option, partial user import is still applied when importing geolocation attributes that use a physical address.
  18. Select each of the columns of data you want to import or click
    Select All
    .
  19. Review the
    Columns that cannot be imported
    list to make sure it does not contain important data that you must be able to view within
    BlackBerry Alert
    . If the list contains important columns of information, contact
    BlackBerry Alert
    customer support for help.
  20. Click
    Import
    . The Importing Users window opens. The import happens in batches of 5000 users.
  21. While the import is in progress, a
    Stop Import
    button appears on the
    Importing Users
    window. Clicking this button stops the import process immediately and prevents the next batch of users from being imported from the file. However, records that have already been added are not removed and records that have been updated are not restored to previous values.
When the import completes, an import summary screen appears, listing the following information:
  • Total number of users in the import file
  • Total number of users who were processed
  • Number of users who were successfully processed
  • Number of users who were partially processed
  • Number of users who failed to be processed
  • Username of the person who imported the file
  • Time the file import process started and ended
To import and export operators, see the .