Format a user import .csv file Skip Navigation

Format a user import .csv file

In order to import a .csv user file, the following formatting standards are required:
Field Name
Description
Is Mandatory?
Username
The Username is a value that can be used to identify a user within the
BlackBerry Alert
system and the user repository (for example, LDAP or Microsoft Active Directory) within your organization. The Common Name field must contain a unique value, such as an Employee ID or a Windows user name. After the Common Name is registered with the
BlackBerry Alert
system, the user is linked to the user profile within your organization.
The username cannot contain spaces or any of the following characters: [ ] : ; | = + * ? < >. Leading or trailing spaces are trimmed during the import process. After the leading or trailing spaces are trimmed, the username is accepted and the user is imported.
Yes
Status
Use the Status column to enable, disable, or delete a user. The following attribute values can be used:
  • Enabled—Enable the user
  • Disabled—Disable the user
  • Deleted—Delete the user
The import file must contain a Status column, but the column can be empty. Note that if the Status column is empty but the database contains Status information, the current Status information is overwritten and replaced by the empty values in the import file on import.
Yes
HRCHY: Hierarchy Name
Use the prefix "HRCHY:" to specify the location in your User Base Hierarchy where the user is a member. You can view your organizational hierarchy by going to
Users
>
Users
and clicking on The Groups icon.
No
SDL: Static Distribution List Name
Use the prefix "SDL:" to specify the name of the static distribution list to which users will be added. You can view your distribution list hierarchy by going to
Users
>
Users
and clicking on The Groups icon. There can be multiple "SDL: list name" columns. If the user does not already exist, this option can only be used to add the user to a static distribution list. A valid value is "Yes" (the user will be added to this static list).If the user already exists, this option can be used to add or remove the user from a static distribution list. Valid values are "Yes" (the user will be added to this static list) or "No" (the user will be removed from this list).
No
User Attribute Name
Specify user attribute as column heading to update user attribute value.
No
Device: Device Name
Use prefix "Device:" for specifying any device name in the import file. For pager addresses, specify pager carrier ID followed by a colon (:) before the pager number. For example, to import pager number, "5551222" with pager carrier ID 3, use "3:5551222" as the pager address in the .csv file. To view the list of pager carrier IDs and names, see "Pager carrier IDs and names" in the
BlackBerry Alert
Create and Publish Alerts Guide
.
No
Password
Passwords must conform to the password rules set in
Settings
>
Security Policy
>
Password Update Rules
.
No
Organization
Only available for enterprise organizations with user uniqueness enabled. Specify the display name for each organization. New users are created in the specified organization and existing users are moved to the specified organization.
If the following error occurs while importing users in the Enterprise, "[Organization]: Column was not recognized as an attribute or device", it is because user uniqueness is not enabled. You can enable user uniqueness in
Settings
>
General settings
.
No