How to Upload a Batch User Create File


  1. Open the Batch User Create tab of the User Manager module.


    Step 1 of the process appears.

Step 1

  1. Click the Download button to download the empty template, select a specific template from the drop-down menu, and then click Download.
    The template downloads in Excel format and contains a header with all data relevant to a user.

IMPORTANT: Zip file format is also supported, but only the Excel template downloadable from LearningSpace can be used for Batch User Create purposes—whether as a single Excel file or in a zip file.


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


3. Click Next to move forward to Step 2 of the process.

Step 2

4. Click Browse to upload the Excel file filled out and saved on your computer.

The Next button only becomes activated when a file is uploaded.

5. Select by clicking the respective radio button whether new user(s) should be created for each row or already existing user accounts should be updated.

6. When done, click Next.

Step 3

Step 3 shows an overview of how the system will upload the user accounts.

Hovering over the information icon prompts the tooltip window containing an explanation about the BUC table icons to appear.


IMPORTANT: If data is missing, the system warns the user about specific errors on the Step 3 surface. In such a case, the user needs to return to Step 2 and upload the corrected Excel file according to the error messages.

7. Click Finalize at the bottom of the tab.

Step 4

The Step 4 surface appears with

  • a summary of the number of updated versus inserted user accounts;

  • and also (if any) the number of user accounts that have not been uploaded due to accessibility issues.

8. Click Done at the bottom of the tab to conclude the Batch User Create process.

Step 1 is displayed for further possible uploads.


Important

Since User Managers cannot create Admin, System Manager, Room Manager, and Learner History/SP Activity privilege users, they also cannot use the BUC function if the users to be created would have any of the listed privileges. In such cases, the process fails as the Next button remains disabled.


See more at How to Create an LS-Compatible Batch User Create File

For further information, visit our User Manager pages.