How to Create an LS-Compatible Batch User Create File

Go to the Batch User Create tab of the User Manager module.
Leave the Empty template in the drop-down bar and click Download.
An excel file will be downloaded with a header.
Fill out the obligatory fields: first name, last name, password, and email address. All other information is optional.

At the Inactive status setting (column A), 1 is inactive, while leaving it empty or using 0 will both be interpreted by the system as active.

IMPORTANT: Dates included in the template (SP details) must be expressed in the following format: YYYY-MM-DD.

Numeral code used in the BUC file:

Inactive (column A):
- 0 (or cell left empty) - active
- 1 - inactive
Privileges (column J):
- 4 - SP
- 8 - learner
Race (column N):
- 1 - white
- 2 - black
- 3 - Hispanic
- 4 - Asian
- 5 - other
Sex (column O):
- 1 - male
- 2 - female
Children (column P):
- 1 - no child
- 2 - biological
- 3 - adopted
- 4 - foster

4. Save the completed file.

IMPORTANT: Only the Excel template downloadable from LearningSpace can be used for Batch User Create purposes.

5. At Step 2 of the Batch User Create process, upload the Excel file or the zip file, including the Excel file.

NOTE: Updating the ‘Custom fields’ of SP Users (defined in the Edit User pop-up of the User manager module) and their values through Batch user upload is not available.

See more at Additional Settings for SP-s.

For further information, visit our User Manager pages.