Bulk Import Users

Use this feature to create, activate, or suspend users by uploading a .CSV or .XLSX file with the appropriate values. An optional column, “Groups,” allows you to import based on user groups.

The imported file must contain the following columns:

If any first or last names contain international characters, then you must upload using an .XLSX file.

Value Required? Description
fname Mandatory A user's first name.
lname MandatoryA user's last name.
username Mandatory The name the user uses to log in. This includes the iPass domain assigned to the user (e.g. <user>@<ipassdomain>.
email Mandatory A user's email address.
company Mandatory CompanyId assigned to your company.
password Optional Leave this field empty if your company is set up for auto-generated passwords.
departmentCode Optional This must match the Cost Center provisioned in the Open Mobile Portal. If the Cost Center feature is not set up for your company, leave this field empty.
trialStart Optional This column is only for trial users and should be left empty for any other type of user.
trialEnd Optional This column is only for trial users and should be left empty for any other type of user.
activateNotification Optional Available options are True or False. If you enter create into the action field, the self-service activation email will be automatically sent unless activateNotification is set to False.
suspendNotifcation Optional Available options are True or False. If set to False, the user will not receive a suspension email.
homeCountry Optional This must match the pre-defined two-letter ISO Country Code in the Open Mobile Portal.
action Mandatory create: Create and activate a new user
update: Update existing user information
remove: Suspend a user (Please note that this will not delete a user.)
edit: Update existing user information with the exception of passwords. In addition, entering edit will create a user if they don't exist.

To import users:

  1. Browse for the appropriate user file. .CSV and .XLSX files are both acceptable file types. However, if you have international characters as part of first names or last names, you must upload using an .XLSX file.
  2. Click on the Upload button.

Go to: Account Tab > RoamServer Users

 

©2015 iPass Inc. All rights reserved. Terms of Use