Administration Guide

Local Navigation

Importing profile information from a .csv file

You can update the Wi-Fi® profiles and VPN profiles that you want to assign to user accounts and the user names and passwords for the profiles by importing a .csv file using the BlackBerry Administration Service. When you import profile information from a file, you can configure the profile information for multiple user accounts at the same time.

The .csv file must contain the following information:
  • user accounts that you want to update
  • names of profiles that you want to change
  • whether you want to add, remove, or change the profiles

Best practices: Creating a .csv file that contains profile information that you want to import

Consider the following guidelines:
  • Specify only one action that you want the BlackBerry® Enterprise Server Express to perform in each row of the file.
  • To assign more than one action to a user account, create multiple rows for the user account.
  • If you are using a text editor to create the .csv file, include a comma (,) after the value that appears in each field in each row. If a field does not contain a value, include only a comma in the field.
  • If you are using a text editor to create the .csv file, include a character return at the end of each row.
  • If you are using a text editor to create the .csv file, use quotation marks (" ") if the value for a field contains a space (for example, "Westlee Barichak").
  • Add no more than 2000 actions to a file.
  • Assign a maximum of 32 profiles to BlackBerry devices that are running BlackBerry® Device Software versions that are earlier than 4.5.0.
  • Assign a maximum of 64 profiles to BlackBerry devices that are running BlackBerry Device Software version 4.5.0 and later.

Create a .csv file that contains profile information that you want to import

Before you begin: Using the BlackBerry® Administration Service, create profiles and specify the configuration settings for the profiles.
  1. Using the BlackBerry Administration Service, export user information for the user accounts that you want to update profile information for to a .csv file.
  2. In any application that permits you to update .csv files, add the following fields to the .csv file that you exported in step 1:
    • Attribute Name
    • Attribute Type
    • Action
    • User Name
    • Password
  3. Configure the fields for each user account in the file.
  4. Save the changes.

Example: Adding profile information to user accounts

"User Id","Display Name","PIN","Email Address","Logon Name","Attribute Name","Attribute Type","Action","User Name","Password"
"16","Westlee Barichak","","wbarichak@example.com",,"wifi_1","WLAN","ADD","test user","test password"
"17","Jovanka Buac","","jbuac@example.com",,"vpn_1","VPN","ADD"
"8","Sherisse Da Silva","2072C4B7","sdasilva@example.com",,"wifi_1","WLAN","ADD","wlan_user","wlan_pass"
"8","Sherisse Da Silva","2072C4B7","sdasilva@example.com",,"vpn_1","VPN","ADD"
"User Id","Display Name","PIN","Email Address","Logon Name","Attribute Name","Attribute Type","Action","User Name","Password"
"16","Westlee Barichak","","wbarichak@rim.com",,"wlan_1","WLAN","UPDATE","update_username","update_password"
"8","Sherisse Da Silva","2072C4B7","sdasilva@.rim.com",,"wifi_1","WLAN","UPDATE","update_username","update_password"
"User Id","Display Name","PIN","Email Address","Logon Name","Attribute Name","Attribute Type","Action","User Name","Password"
"8","Lou Sicoli","2072C4B7","lsicoli@example.com",,"wlan_1","WLAN","DELETE"
"9","Sarah Symonds","2072C4B7","ssymonds@example.com",,"vpn_1","VPN","DELETE"
"16","Westlee Barichak","","wbarichak@example.com",,"wlan_1","WLAN","DELETE"
"16","Westlee Barichak","","wbarichak@example.com",,"vpn_1","VPN","DELETE"

Fields in the .csv file that contains profile information

The following table describes the fields that you can configure in a .csv file. The BlackBerry® Administration Service uses the fields in the .csv file to update profile information that you assigned to user accounts.

Field

Description

User Id

This field specifies the user identifier that the BlackBerry Enterprise Server Express creates for each user account. You must specificy a value in this field.

Display Name

This field specifies the user name for the user account.

PIN

This field specifies the BlackBerry device PIN.

Logon Name

This field specifies the name that the user can use to log in to the BlackBerry Administration Service or BlackBerry® Web Desktop Manager.

Attribute Name

This field specifies the name of the Wi-Fi® profile or VPN profile. You must specify a value in this field.

Attribute Type

This field specifies whether the profile is a Wi-Fi profile or VPN profile. You must specify either WLAN or VPN as the value in this field.

Action

This field specifies whether you want to add, remove, or update the profile. You must specify ADD, DELETE, or UPDATE as the value in this field.

User Name

This field specifies the user name that the BlackBerry device can use to access the enterprise Wi-Fi network or VPN, if a user name is required.

Password

This field specifies the password that the BlackBerry device can use to access the enterprise Wi-Fi network or VPN, if a password is required. You can include quotation marks (" ") in the password.

Import profile information from a .csv file

The BlackBerry® Administration Service processes actions in the order that they appear in the .csv file. If two actions that you listed in the file contradict each other, the action that appears closer to the end of the file is the action that the BlackBerry Administration Service processes. If the BlackBerry Administration Service notices an error that is specific to an action during the import process (for example, you formatted an action incorrectly in the .csv file), the BlackBerry Administration Service continues to process the remaining actions in the file and displays an error message for the action that the BlackBerry Administration Service could not process.

  1. In the BlackBerry Administration Service, expand User > Manage users.
  2. In the Search for users section, click Update WLAN Information for users from a List.
  3. Click Browse.
  4. Navigate to the .csv file that you want to import.
  5. Click Open.
  6. Click Save.
Previous topic: Delete a VPN profile

Was this information helpful? Send us your comments.