How do I Add or Import student import file?
Sadlier Connect administrators and teachers can add students individually or by importing. Student accounts are necessary before you can set up classes. This article will go through the steps to add an individual student and create the student import file.
Your school's Sadlier Connect administrator can turn off adding, editing, and removing students for teachers. If your role in Sadlier Connect is a teacher role and you do not see the Add Student and Import Roster on the Manage Students screen, please contact your school's Sadlier Connect administrator.
Manage Student Page
Add Individual Student
Please note, most integrations require the username to be the school email address.
The template file is a Comma Separated Values (CSV) file. A CSV is a plain text file containing a list of data. Use Excel, Google Docs Spreadsheet, Numbers (mac application), or other similar software to edit the.
Creating the Import File
Most import file columns are required. Do not alter the columns' order or leave out information in a required column to avoid errors. The first two rows are example data.
Import File Column Information:
| Action (required)
Enter A to add a new student account to the system.
Enter U to update an existing student 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.|
|Username (Required)||Usernames need to be unique within your school's Sadlier Connect site. The username provided in this column will be what the student uses to log in to Sadlier Connect. If you plan to integrate after importing students, you should use their school email address in this field.|
|Password (Required)||A password is required, and students can 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.|
|Status Active/Inactive (Required)|| This required field accepts Active and Inactive.
Active enables the student account.
Enter inactive to disable an existing student account.
|School PID (Optional - District Only)||
Only internal Sadlier Connect processes use this column. You will not provide any value in this field.
Saving the Student Roster Import File
- Please remember to remove the example rows before saving your Student Roster Import file.
- Save your Student Roster 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 Students 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 an error in the first row. Above the column labels is a scroll bar. Scroll to the right, and there is a message to indicate what caused the error. The error message indicates the user name is a duplicate. 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. Once you have an error-free upload, click the Import Roster button.