Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 21 Next »

Available to User Managers or Admins

In Batch User Create (refered to as BUC in the following) you can upload or modify details of several users all at once.

The feature is broken down into steps and presented as a flow chart to make the process easier to follow. 

NOTE: Continuing or resuming to a step can be done by the blue Next and Previous buttons at the bottom of each tab.

In BUC you can either create a brand new user group or update an existing one.

Using a template

To import user details in BUC, you need to use a custom excel template which is available in Step 1.

a. Download an Empty template in case you want to create a new group from scratch

Openning the spreadsheet, you will find that headers are already added. Each column represents the corresponding 'personal information' field also found in Groups & Users.

One row equals one user: (warning) First name, Last name, Password and Email cells are mandatory for successful user import. All other details are optional.

Some details can be defined by a number (e.g. in the Privilege column, 8 creates a Learner, 4 creates an SP user). Scoll down to the bottom of this page for codes.

Once you are finished with entering user details, go to Step 2, select Create a new user account for each row and import the excel sheet.

b. Select an existing group from the Download template drop-down

The same rules apply here as described in point 'a.', only, cells contain user details from the system where fields were already completed. 

NOTE: Any date entered in the template needs to be in the following format: YYYY-MM-DD(Applicable when entering SP details.)

The name of the excel file defines the group you modify in the system. To modify the group you started off with, leave the name of your downloaded file unchanged. Otherwise, there will be a new group created.

You can modify any detail of a user. After saving, go to Step 2, select Update existing user account, and import the spreadsheet. 

Upload photos

User profile pictures can also be uploaded along with user details.

1.Use an excel template retrieved from Step 1

2.Gather the photos you would like to include

Include only .jpg /.jpeg photos in your .zip file. Uploading other file formats in BUC will not be successful.

3. Enter the precise name of the photos to each user in the User Photo column (M) like Photo.jpeg

Make sure to enter the names of each file in the BUC spreadsheet exactly the same way they are named in the .zip folder: paying attention to upper and lowercase letters, but always enter the file format in lowercase letters for successful file upload.

4. Save your spreadsheet and close it

5. Select all the photos and the spreadsheet and make a compressed folder (.zip format)

6. Go to Step 2, select either options, and import your .zip file

Codes for the BUC excel file


Inactive (column A):
0 (or none)active
1inactive


Privileges (column J):
1Admin256Activity Manager512SRP
4SP2048User Manager8192OEQS Data Entry
8Learner4096Record Manager32768FON Data Entry
Race (column N):
1white4Asian
2black5other
3Hispanic

Sex (column O):
1male
2female
Children (column P):
1no child3adopted
2biological4foster


  • No labels