Importing Students, Teachers, and Classes
Overview

The best way to add a large group of students to the Symphony Learning roster is through the use of the Import tab in the Symphony Administration Panel. This area allows the upload of a formatted template that contains information on students, teachers, and class assignments. The steps below can also be found in the Import tab.

The following instructions are taken from the Import tab. In order to complete the import process, you will need to log in to your Symphony Administration Panel.
Step 1:
Download the Import Template

Click here to download the Import Template File, a comma-separated (CSV) file that contains the proper fields necessary for import.
Step 2:
Add Import Information

Open the Import Template using a spreadsheet program such as Microsoft Excel. Add the information to the file. Please refer to the Import Codes Specification for details on codes for student demographic information.

  • The first row of the Import Template file contains field headings. Your finished import template file MUST contain this first line.
  • If you choose to not include optional fields, leave them blank in the template.
  • If you add information for the Teacher, Teacher Email, and Class Name fields, teachers and classes will automatically be created, and students will be enrolled in those classes. You must include information for all three fields.

Additional Details on the Import Template:

Field Name Required? Type Max.
Length		 Notes
Account # YES Number 32 School Account #
First Name YES Letters/Numbers 64  
Last Name No Letters/Numbers 64  
MI No Letters/Numbers 2  
Username YES Letters/Numbers 64 Must be Unique,
No spaces
Password YES Letters/Numbers 64 No spaces
Grade YES Letters/Numbers 2 Must be PK,K, or number 1-13
DOB No mm/dd/yyyy 10  
Race No Letter 1 See Table 1 for codes
Gender No Letter 1 See Table 2 for codes
Language No Letters 3 See Table 3 for codes
Characteristics No Letters 256

See Table 4 for codes

Separate each code with a hyphen, e.g. "ESL-ADA"
Teacher No* Letters/Numbers 64  
Teacher Email No* Email 64 Must be proper email address
Class Name No* Letters/Numbers 32  
* If you add information for the Teacher, Teacher Email, and Class Name fields, teachers and classes will automatically be created, and students will be enrolled in those classes. You must include information for all three fields.
Step 3:
Send the Import Template

Make sure you are logged in to the Symphony Administration Panel, and are at 'Step 3' of the Import tab. Click 'Browse' above to locate the Import File that you saved in Step 2. When you click 'Browse...', a prompt will ask you to locate the Import File. In most cases, this file will be located on the Desktop, where you downloaded it in Step 1.
Step 4:
Confirm Import

Review the Import Information. If the information is correct, click 'Finish' to complete the import. If the information is not correct, click 'Previous' to return to the previous step.
Symphony Learning © 2010