How do I add or import teachers?

Sadlier Connect Administrators can add teachers individually or by importing. Teacher accounts are necessary before you can set up classes. This article will go through the steps required to create the teacher import file.

Manage Teacher Page

Log into Sadlier Connect with your school administrator account and click on the settings icon in the lower right corner of your screen.
Select Manage Teachers from the setting menu.

Add Individual Teacher

Click the Add Teacher button.
The resulting page is a simple form to fill out for the teacher.

Please note, most integrations require the username to be the school email address.

Import Teachers

From the Manage Teachers page, click the Import button.
Click the Download Teacher Import Template link, or you can download the template here.

The template file is a Comma Separated Values (CSV) file. A CSV is a plain text file that contains a list of data that can be used with Excel, Google Docs Spreadsheet, Numbers (mac application), or other similar software.

Creating the Import File

Many import file columns are required, and the order cannot be altered. Omitting information in a required column for a row will result in an error. The first two rows are example data.

Column Label	Description
Action (required) Valid Entries: A, U	Enter A to add a new teacher account to the system. Enter U to update an existing teacher account already in the system.
Unique User ID (Optional)	This field allows you to keep a unique identifier for the user account from another system.
School PID (Optional - District Only)	This is unnecessary and is used by internal Sadlier Connect processes. You will not provide any value in this field.
Username (Required)	Usernames need to be unique within your school's Sadlier Connect site. The username provided in this column will be what the teacher uses to log in to Sadlier Connect™. If you plan to integrate after importing teachers, you should use their school email address in this field.
Password (Required)	A password is required, and teachers have the ability to change the password of their accounts.
First Name (Required)	This is a required field.
Middle Initial (Optional)	This is an optional field.
Last Name (Required)	This is a required field.
Grade (Optional)	The acceptable values are: K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, and 12.
Email address (Required)	We recommend using the teacher's school email address if available.
Status Active/Inactive (Required)	This required field accepts Active and Inactive. Active enables the teacher account. Enter inactive to disable an existing teacher account.

Saving the Teacher Import File

Please remember to remove the example rows before saving your teacher import file.
Save your teacher import file by selecting File > Save As...
Set the File Format section of the Save As screen to Comma Separated Values (.csv).

Sadlier Connect will only import Comma Separated Values (.csv) file formats. Please be sure to select the correct file format, Comma Separated Values (.csv), when saving your file.

Uploading the import file

Return to the Import Teachers page in Sadlier Connect.
Click the "Choose File" button and find the CSV file you created.
Click the Continue button.

Sadlier Connect will check the import file for errors. In the image below, the system detected errors in the file. Above the column labels is a scroll bar. Scroll all the way to the right, and there is a message to indicate what caused the error. The error message indicates the teacher's username is already in use. If you get an error on any rows, they will not import, and you should fix them in the file and upload the new saved CSV.