User Import Tool - Class Upload

Enrolling Students into Classes with the User Import Tool

The User Import Tool (UIT) is a Windows-only tool available for download on the Coordinator Home Page, in the Import Users section. If you do not have access to a Windows computer, complete Steps 1 and 2 below and then contact Customer Support for further assistance: support@learning.com or 800.580.4640 x2.

Step 1: Create and Format a Spreadsheet with Class Information

Create a spreadsheet with class information (i.e., student account to be enrolled in the listed Class, taught by the listed Teacher, at the listed School). See below for an example. The User Import Tool is particular about formatting so it is important to abide by the following guidelines.

  • Be sure that headers are entered exactly as shown below in the spreadsheet.
  • Only use alphanumeric characters (letters and numbers). No special characters (i.e., hyphen, apostrophe, spaces, etc.)
  • All information should match the Learning.com accounts and platform.

Please note: A teacher that instructs at two or more schools cannot create classes using the import tool.

Step 2: Save the spreadsheet

Save the file in the comma separated value format, i.e., CSV (Comma Delimited). Close the file.

Step 3: Download and launch the Learning.com User Import Tool from your computer

Enter your coordinator login credentials and follow pictures below.

Helpful tips

  • During the validation step, the User Import Tool examines the CSV file for problems and compares the data to the current accounts. Error messages relate to this process. It is possible to see and correct errors, run the tool again, and get different errors.
  • The errors in the detail window can be copied and pasted out of the window into a word processing application. This is helpful when reviewing and correcting the errors. Checking the “Skip Errors” box tells the import tool to ignore those rows in the CSV file.
  • Warnings sometimes appear during the validation process. These relate to actions the User Import Tool is going to complete, often adding or creating data, and cannot be skipped.
  • The User Import Tool verifies that the listed StudentID in a row is at the school listed. It also ensures that the listed Teacher Username represents an instructor at the listed school. For a student to be enrolled in a class successfully, both of these must match the listed school.

Common Error Messages

Error Message Meaning Example Solution
This username already exists in the district Same username with a different Student ID.

Julie Smith, 1122334, (jsmith) vs.

Jude Smith, 5566778, (jsmith)

Change one of the usernames. For example, add a number, jsmith and jsmith1.
Cannot find Washington Elementary in the district The school name must match the name listed in the Learning.com database. Washington Elementary vs. George Washington Elementary Log in to coordinator account. Click Edit Schools. Copy the name listed there.
Username must not contain non-alphanumeric characters Only letters and numbers. No special characters from the keyboard (i.e., apostrophes, space, underline, hyphen, etc).

incorrect: B Rubble or B'Rubble

correct: BRubble

Remove non-alphanumeric characters. To remove spaces, run Find and Replace in the CVS file. Put a space in the Find column and nothing in the Replace column. Repeat with other characters as needed.
Password must be 4 or more characters The passwords listed in the CSV file have less the 4 characters. SSD or 123 Extend the password. Can be simple like 1234, the name of your school/district, the school mascot (i.e., finches).
Access Denied (at Login page) Only District Coordinators can run uploads by default. School Coordinators need to be given access.   District Coordinator logs into their account. Clicks Import Users. Checks the box to allow School Coordinators to use the User Import Tool.
Webpage