Creating and/or Updating Users Using the Standard CSV Import

The standard user import CSV can be used to:

  1. Create new users
  2. Update user information
  3. Delete users

Filling Out the CSV

Using any standard spreadsheet editing software, you're going to create a CSV with 16 columns that correspond to the fields necessary for uploading courses in batches. Here's a template to get you started.

Description of fields

The standard user creation CSV is similar to the standard course creation/update and registration CSVs in that it uses the same “1” is “yes” “0” is "no" logic for some of the fields. Below are descriptions of each field according to its corresponding column in any application that allows you to edit spreadsheets:

A. SyncID - User email or associate ID number (whichever is used to sync with courses) 
B. First Name 
C. Last Name 
D. Password 
E. Username 
F. Email 
G. Show Image - Always should be “1" 
H. Major - Can be left blank. 
I. Graduation - Can be left blank. 
J. Faculty - 1 is “yes” and 0 is “no” meaning that it is a student account. 
K. Website - Can be left blank. 
L. Active - Should always be “1” when creating users. When updating users, enter “0” if for those to be deactivated. 
M. Birthdate - Can be left blank. 
N. COPPA - Needs to be “1” for account to be created. Means that users are over the age of 13 and/or have a COPPA form on file. 
O. Update - “1” if the user in the row is being updated and “0” if the user is being created for the first time. 
P. Delete - “0” if the user is being created or updated and “1” if you wish to delete them

Preparing the CSV for Export

Once all of the relevant data has been put into the file in the correct format, be sure to remove any of the guides that were being used so that the first cell (A1) has [user] in it, immediately followed by the data being uploaded as shown in the image above.

Go to the Administration tab

Click on Import

Select "Upload"

Check off "Debug" before selecting and uploading your CSV

The "Logs" Page

After a standard CSV, you'll be brought to the "Logs" page where you'll be able to see how many imports have been attempted and how many entries within those imports have been successful.

Refresh to view your results

After refreshing, you'll be able to view the results of your import once it's complete and then adjust or re-upload accordingly. Keep in mind that for large data imports, you'll have to wait a few moments before this information becomes available.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.