Creating Users Using the Simple Upload CSV

Drew Albenesius

August 20, 2018 21:47

This is the quickest and easiest way to create user accounts in small to medium sized batches (999 lines is the limit) via import.

Generate Simple Upload CSV

Using any standard spreadsheet editing software, you're going to create a CSV with 9 columns that correspond to the fields necessary for registering users into courses. This is the only import in which the headers used as guidelines do not have to be removed before uploading. Here's a template to get you started.

Description of fields/columns

The simple upload CSV is different from the standard user import CSV in that it has less columns and uses a basic "yes" or "no" logic for two of it's fields instead of numbers. Below are descriptions of each column in the CSV:

A. AccountID - Exactly the same thing as the SyncID in the standard user import CSV. This makes it possible for users to be batch-enrolled in courses. 
B. FirstName 
C. LastName 
D. Username 
E. Email 
F. Password 
G. IsFaculty - Either “yes” or “no.” “No” means the user will be created as a student. 
H. HaveCOPPA - Must be “yes” to create the account. Affirms that the student is over 13 or has a COPPA form on file with the school. 
I. Birthdate - Can be left blank.

Export your file as a CSV

Go to the Administrator tab

Click on "Upload Simple"

Find and upload your CSV

View Results

If any errors are to occur, you will be notified here. Errors will only occur if there is already a user in the system with the same SyncID already. In that case, you'll want to verify that both accounts are for separate individuals before proceeding.