Import operators using a .csv file Skip Navigation

Import operators using a .csv file

When you import operator 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 operators from a file, the file must be correctly formatted. If you do not know how to format the file, see Format an operator import file.
If duplicate operators (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 operators 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:
[ ] : : | = , + * ? < >
Leading or trailing spaces are ignored and trimmed during the import process. After the spaces are trimmed, the username is accepted and the operator is imported.
  1. In the navigation bar, click
  2. Click
  3. On the
    screen, click
    More Actions
  4. If you want to download a blank .csv file to use as a template for your import operator file, click the
    Download a template CSV file
    link. Save the file to your computer and fill in the appropriate operator information.
    Using the template ensures that all of the mandatory attribute columns are included in the import file.
  5. Click
  6. Navigate to the location of the import operator file on your computer.
  7. Open the file to enter or modify the operators' data.
    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 to modify the .csv file, open the file in a text editor such as 
    Notepad, review the syntax for problems, then save the modified file as a .txt file. Edit the file name to change the extension from .txt to .csv. This method preserves the formatting in the text file.
  8. Ensure that columns with multiple values have the correct format to import correctly.
    • A comma must be used to separate each of the values. There can be no spaces before or after the comma.
  9. After you have entered your data, save and close the file.
  10. Click the filename, and click
    to upload the file into the system.
    The filename appears in the Operator CSV File field on the Import Operator screen. Each of the columns from the import file are listed in the
    Select the columns to import
  11. Select each of the columns of data you want to import or click
    Select All
  12. 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.
  13. Click
    . The Importing Operators window opens.
When the import completes, the Import Details: Import Completed screen displays the following information:
  • Total number of operators in the import file
  • Total number of operators who were processed
  • Number of operators who were successfully processed
  • Number of operators who failed to be processed
  • Username of the person who imported the file
  • Time the file import process started and ended
Download Log
on the Import Details: Import Completed screen to download a .csv file that includes information about the sync status of the operator import.