Help Center/ Rostering & Setup/ Import Job Types and Data Dictionaries

Import Job Types and Data Dictionaries

Details on the various types of import options

5 min read · Updated 2026-08-12


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 ImportColumn HeadersDescriptionRemarks/Values
Requiredcampus_idCampus / School IDDesignates the campus or school ID of your choice. This is required to place users at the correct campuses.
Optionalcampus_nameCampus / School NameName a new campus. Used in conjunction with campus_id
RequiredidStudent IDUnique district-assigned ID number.
RequiredfnameStudent First NameStudent Given Name
RequiredlnameStudent Last NameStudent Family Name
OptionalmiStudent Middle InitialStudent Given Middle Initial
Optionallogin_idStudent User NameIf 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.
OptionalpasswordStudent PasswordIf not specified, the default is a random 4-digit number for students in grades 1 and below. Otherwise, a random 6-digit number.
RequiredgradeStudent GradeNumber 1-12 | 0 = Kinder | -1 = PreK
Optionalstudent_emailStudent EmailThe assigned student's email address
RequiredtfnameTeacher First NameTeacher Given Name
RequiredtlnameTeacher Last NameTeacher Family Name
RequiredemailTeacher Email AddressThe teacher assigned the email address
Recommended but not requiredtidTeacher IDTeacher ID. Used to uniquely identify a teacher across all schools.
Optionaltlogin_idTeacher User NameIf not specified, the default login_id is the first initial of the teacher's first name + the teacher's last name.
OptionaltprimaryPrimary TeacherUsed 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 requiredcidClassroom IDUniquely identify a classroom at a school. If not specified, a classroom is identified by Grade and Class Name.
OptionalperiodClass PeriodOptional 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 requiredclass_nameClass NameName for a classroom. If not specified, the default classroom is of the form "Classroom - M Smith"
Optionalstate_idState IDStudent'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 

email

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.