Amira Learning supports several import formats to help you get campuses, classes, teachers, and students set up quickly and accurately.
- Choose 1File to import campuses, classes, teachers, and students together in a single file, ideal for most rostering needs.
- Use the Teacher/Manager (tch/mgr) import to add teacher or administrator accounts in bulk.
- The Demographic (demog) import lets you add demographic details to existing student accounts.
- Amira also supports OneRoster v1.0 and v1.1, with v1.1 recommended for broader compatibility.
Below, you'll find the required and optional fields for each import type, along with formatting notes and tips to avoid duplicate records.
1File - Import Campuses, Classes, Teachers, and Students
This import type is the most common used for rostering purposes. You can use this to import your campuses, classes, teachers and student information. You can even add multiple teachers to the same class using this import. Please note: while not required it is highly recommended to use the Class ID and Class Name column to ensure do duplicate classes are being created.
| Required for Import | Column Headers | Description | Remarks/Values |
| Required | campus_id | Campus / School ID | Designates the campus or school ID of your choice. This is required to place users at the correct campuses. |
| Optional | campus_name | Campus / School Name | Name a new campus. Used in conjunction with campus_id |
| Required | id | Student ID | Unique district-assigned ID number. |
| Required | fname | Student First Name | Student Given Name |
| Required | lname | Student Last Name | Student Family Name |
| Optional | mi | Student Middle Initial | Student Given Middle Initial |
| Optional | login_id | Student User Name | If not specified, the default login_id is constructed by combining the student's first name and the first initial of the student's last name. |
| Optional | password | Student Password | If not specified, the default is a random 4-digit number for students in grades 1 and below. Otherwise, a random 6-digit number. |
| Required | grade | Student Grade | Number 1-12 | 0 = Kinder | -1 = PreK |
| Optional | student_email | Student Email | The assigned student's email address |
| Required | tfname | Teacher First Name | Teacher Given Name |
| Required | tlname | Teacher Last Name | Teacher Family Name |
| Required | Teacher Email Address | The teacher assigned the email address | |
| Recommended but not required | tid | Teacher ID | Teacher ID. Used to uniquely identify a teacher across all schools. |
| Optional | tlogin_id | Teacher User Name | If not specified, the default login_id is the first initial of the teacher's first name + the teacher's last name. |
| Optional | tprimary | Primary Teacher | Used to flag the primary teacher of a class. Enter TRUE to designate the Primary teacher. If left blank, the first teacher in the file will default to the class's primary teacher. This field is not case sensitive. |
| Recommended but not required | cid | Classroom ID | Uniquely identify a classroom at a school. If not specified, a classroom is identified by Grade and Class Name. |
| Optional | period | Class Period | Optional period string appended to the default class name. Example, the generated class name for Mary Smith's first grade class period 001 is: 1st Grade - M Smith (001) |
| Recommended but not required | class_name | Class Name | Name for a classroom. If not specified, the default classroom is of the form "Classroom - M Smith" |
| Optional | state_id | State ID | Student's State ID. Optional field, but recommended if state reporting is required. |
| Optional Demographic Fields |
Teacher/Manager (tch/mgr) - Import additional Teachers or Managers (Admins)
This import is used to upload Teacher and Administrator accounts. While you can also do this manually in the platform, if you have many users to import at once, the upload is suggested.
|
Required for Import |
Column Headers |
Description |
Remarks |
|
Required |
campus_id |
School ID |
This column may contain a Campus ID or State ID as previously configured in the Amira Learning system. The currently configured values are available on the web site under Manage > School Information. The Amira Learning domain is also accepted in this field. (the steps will change once the new pages are in production) |
|
Optional |
grade |
|
Number 1-12; 0 = Kinder; -1 = PreK. Any words beginning with "K" are set to Kinder. Any words beginning with "P" are set to PreK. This sets the teacher's grade for when they log into the student application with their own account. |
|
Required |
tfname |
Teacher First Name |
|
|
Required |
tlname |
Teacher Last Name |
|
|
Required |
|
Teacher Email Address |
|
|
Recommended but not required |
tid |
Teacher ID |
District-assigned teacher ID or employee number. This ID is used to uniquely identify a teacher across all schools in the district. |
|
Recommended but not required |
tstate_id |
Teacher State ID |
State-assigned teacher ID or employee number. This ID is used to uniquely identify a teacher across the state. |
|
Optional |
ismgr |
Is Manager |
Y = Yes; N = No; Yes indicates that an individual should have access to all student data at that campus. The default setting is No. |
|
Optional |
tlogin_id |
Teacher User Name |
If not specified, the default login_id is constructed by combining the first initial of the teacher's first name with the teacher's last name. |
Demographic (demog) - Import student demographics to existing student accounts.
This type of import is used to import student demographic information to existing student accounts. The initial 1File import also includes these demographic fields. Please Note: If you have different values in your SIS for any of these demographic fields, please contact support@amiralearning.com. Your Support Specialist is able to add additional accepted values to the existing column headers.
OneRoster - Versions 1.0 & 1.1
V1.0 - Amira does support V1.0, however we highly suggest using V1.1 when using OneRoster imports as it's a more widely supported version and V1.0 will be deprecated in upcoming school years.
See the IMS Global OneRoster webpage for more information.
In addition to the IMS Global OneRoster specifications, Amira Learning may have additional requirements:
-
users.csv file must contain a column for "metadata.grade". This field is required for records marked as "student".
-
schools participating in state programs that make a State Student ID a requirement can provide the state id in the users.csv file with a column titled "metadata.state_id".
Unlike other import types, OneRoster v1.0 does not require a template before sending files via FTP. The strict nature of the specification includes file names and column names. The FTP site will be able to process the files without a template. An FTP template may be used with OneRoster to specify other import options.
V1.1
See the IMS Global OneRoster webpage for more information.
In addition to the IMS Global OneRoster specifications, Amira Learning may have additional requirements:
-
while the users.csv file "grades" column is an optional value for OneRoster V1.1, it is actually a required field for student records.
-
schools participating in state programs that make a State Student ID a requirement can provide the state id in the users.csv file with a column titled "metadata.state_id".
Unlike other import types, OneRoster v1.1 does not require a template before sending files via FTP. The strict nature of the specification includes file names and column names. The FTP site will be able to process the files without a template. An FTP template may be used with OneRoster to specify other import options.