If you are transitioning from BPOS to Office 365 and have lots of Blackberry users, you’ll probably want to create a .csv file to import those users into the new Blackberry Service. RIM has provided some information about the process in their documentation, but their instructions call for you to export all users and then clean up the export with only the users you want to import.

This script is a little better, because it exports only the users that have a Blackberry license assigned to them in BPOS, and it also exports the primary SMTP address to the email address field. Additionally, it allows you to specify values for the other fields in the .csv, when you run the export. Only the email address and group name are required. You can edit the script to specify the values for fields prior to running it.

Download the BPOS Blackberry user export script here.

When the script runs, you will need to open the file it creates and do a find and replace on the “ character, replacing it with nothing.

.csv file fields

Field Description
Email Address The field is required and specifies the email address for the user account.
Group Names This field specifies the names of groups that you want to add the user account to. If you do not want to specify any groups, place a – character in the field.
Activation Password Operation This field specifies whether an activation password is required to activate the user account and whether that password should be specified by the administrator or the BlackBerry Administration Service. The activation password value specified in this field can either be “specify”, “none”, or “generate” in lower case only. The activation password operation must be the same on each line in the .csv file. If the field is set to “specify”, the activation password and the expiry time (in hours) are optional fields in the .csv file. If the activation password and the expiry time values are not included in the .csv file, you are prompted to specify these values the after uploading the .csv file. If you specify the activation password and the expiry time for the user accounts, the values must be provided on every line of the csv file.
If the field is set to “generate”, the password is automatically generated by the BlackBerry Administration Service and the final two fields of each .csv line must be empty. The activation password expires if the user does not activate the BlackBerry device on the BlackBerry Business Cloud Services before the password timeout elapses. The default value is 48 hours.
If the field is set to “none”, the user account is created without an activation password and the final two fields of each .csv line must be empty.
To activate a device on the BlackBerry Business Cloud Services over the wireless network, an activation password is required.
Activation Password This field specifies the activation password for the user account if an activation password is required.
Activation Password Expiry This field specifies the amount of time, in hours, that can elapse before the activation password expires if an activation password is required.
The activation password will expire if the user does not activate the device on the BlackBerry Business Cloud Services before a default value of 48 hours elapses.
Was this article helpful?
YesNo