Help Center/ Rostering & Setup/ Importing Managers, Teachers, Student Rosters and Demographics

Importing Managers, Teachers, Student Rosters and Demographics

Step by step guide for importing students, teachers, and manager rosters

9 min read · Updated 2026-08-19


 

This Manual Imports guide provides step-by-step instructions for quickly and efficiently importing Managers, Teachers, and Students into Amira Learning.

 

Here you will find the five manual import job types you can perform when importing into Amira Learning. For all other automated nightly imports, please refer to the article Amira Learning Roster and Login Options.

 

Prior to an import, please verify that Campus Codes have been entered correctly.

Prior to processing an import job, it is important to verify campus codes in Amira Learning. Verification or entering of campus codes can be done by selecting the Administration tab. Next, select Import & Roster Management and then Campus Codes in the left menu. If there are multiple changes to be made at once, a template can be downloaded from the page and then uploaded with the new information.

 

The Campus Codes page with Import & Rostering and Campus Codes outlined in the menu, and a table of campuses with editable Campus ID and State ID fields.

 

Step-by-Step Guide to Manual Import Jobs

Step 1: Compile Information

Compile a list of students to be imported into the Amira Learning system. This information can be pulled from a school data management system. The template provided is simply a place to start, but others may be used with their own column headers as long as the following REQUIRED columns are included:

  • Student’s first and last name
  • District-assigned student ID
  • District-assigned grade
  • Teacher’s first and last name
  • Teacher's e-mail address
  • Campus code(s) that uniquely identifies the school where the student is enrolled

 

NOTE: If part of a statewide implementation, there may be certain other required fields that are necessary (i.e., statewide unique ID numbers).

 

Any row that does not contain the above-REQUIRED information will cause a validation error and ultimately will not be imported into Amira Learning. Additional optional column headers are listed below. More details about the column headers can be found in the Data Dictionary.

 

Student/Campus Information

  • Student’s middle initial
  • Student’s user name (must be unique within a school)
  • Student’s password
  • Teacher’s username
  • Teacher ID (must be unique within a district)
  • Classroom ID
  • Class name (Default naming conventions are “Classroom - M Smith” for classrooms containing multiple grade students or “1st Grade - M Smith” for grade-specific classes.)
  • Class period

 

Demographic Information

Step 2: Save .CSV File

After the file is compiled, save it as a .CSV file by following these steps:

  1. Choose Save As.
  2. Select the location to save the file.
  3. Choose CSV from the drop-down menu under the typed name of the file.


Image of CSV being selected as a the file format for a file in the Windows operating system.

When opening a CSV formatted spreadsheet in Excel that contains leading zeroes, Excel has a habit of removing those leading zeroes. Before saving over the original CSV file, please ensure the leading zeros are still intact. If you are unsure of how to do so, please perform a web search on "Keeping leading zeros and large numbers in Excel".

 

Step 3: Log On

It is necessary to be logged into the Report and Management Web site to import student and teacher data. Ensure that the domain matches the one provided in the welcome e-mail from Amira Learning. For rostering assistance, please contact Amira Learning Support Services by sending an email to rosteringsupport@amiralearning.com.

 

Step 4: Create Import Job

1. Select the Administration tab at the top of the page.


The Amira Learning top navigation with Admin outlined in red, beside Home, Reports and Resources.

 

2. Then select Import & Rostering and Create New Import Job from the menu.

 

The Administration menu with Import & Rostering and Create New Import Job outlined in red.

 

Step 5: Select Import Job Type

  1. 1file: This import type is for importing students, teachers, and classroom data. This data must come from a single file.
  2. teachers: This import type is for importing teacher and manager accounts. Teacher accounts must be created in order for teachers to log into the customer Web site or to create classrooms for teachers.
  3. demog: This type is for importing student demographic information to existing student accounts.
  4. OneRoster v1.0: Import CSV tables formatted to IMS Global OneRoster v1.0 standard.
  5. OneRoster v1.1: Import CSV tables formatted to IMS Global OneRoster v1.1 standard.

 

Image of the available import job types in the Istation reporting website. The options include 1File, tch/mgr, demog, OneRoster v1.0, and OneRoster v1.1.

 

Click here to learn more about import job types.

 

Step 6: Import Settings

There are several settings associated with an import job. 

Import Settings with 2024/2025 as the school year, welcome and job completion e-mails ticked, header row on Auto-Detect, and no items set to be removed.

 

  1. School Year to apply upload data, This will generally default to the current semester, and occasionally more than one semester may be available. In addition to the current school year, a Summer School option is available within 100 days before the start of the next school year. The next school year is not available. Do not import for the next semester until after Amira Learning usage is complete for the current semester. Students who change schools for the new semester will be unable to access Amira Learning from their previous school.
  2. Send welcome e-mail to new teachers, This will send an e-mail to new teachers with a temporary password when their account is created by the import.
  3. Send a class change notification e-mail to teachers, This will notify teachers that students have been added or removed from their classroom.
  4. Send a job completion notification e-mail to me, A confirmation e-mail will be sent to the e-mail address on your profile once the submitted job is complete.
  5. Remove unreferenced items from Amira database, These options are used to ensure that enrollment in Amira Learning mirrors records in a district’s student information system. As such, students, classrooms, and/or teachers added manually at a campus may be removed. Use these options with caution. Typically this affects ESL and Special Education classes that are manually created if they are not in the district import file.
  6. Students, Checking this box will remove any existing accounts for students who are not included in any classrooms in the import file from the system. Those students may be re-added to a classroom in any school in the district, and all original student data is retained.
  7. Classrooms, Checking this box will remove any existing classrooms that are not included in the import file. Students in these classes who do not appear anywhere else within the district will be removed from view.
  8. Teachers, Checking this box will remove any existing accounts for teachers who are not included in any classrooms in their school, and their accounts will be deactivated. This option alone does not affect classrooms or students.

 

Warning!

Though each case is different and we are happy to discuss your particular situation, the typical recommendation is to check the teacher box for the first import of the year to clean the campus and then do not select it throughout the year in order to prevent ESL and Special Education teachers from being removed. You can also check the Students box to keep your data clean from incorrect information.

 

Import File

Click Upload File to choose the Comma Separated Values (.CSV) file related to this import job. (The file can also be a tab-delimited file. The type is auto-detected.) Use the Browse button to find the file on the computer and then the Upload button to move to the Map Columns step.

Image highlighting the Upload File button.

Notes:

  • Excel files (those that end in .xls or .xlsx) are not supported and will cause errors.
  • Additionally, files must be smaller than 10 MB. Large files can be split into multiple smaller files for a manual process or can be automated through the FTP process.
  • A header row is optional but highly recommended. If the first row of the file contains "ID" either as a whole word or at the end of a word, the row is considered to be a header row. The file associated with this job can always be deleted or replaced if the data requires editing or the wrong file is selected.

 

Import Job Actions

Image displaying the Import File and Import Job Actions options available when uploading a roster file.

  • Replace: Remove the current import file and replace it with a different file.
  • Export: Download the currently imported file to review.
  • Save: Save import job at any time and return to edit at a later date if needed.
  • Cancel: Cancel any updates you have made since the last save.
  • Delete: Delete the entire import job.
  • Process: Complete the actual import of data from your .CSV file to the Amira Learning database. This can only be selected after the columns mapping process has been completed.

You will receive a confirmation of submission. Created Date and Last Modified Date for the import job are available on this page as well.

 

Step 6a: Summer School Import Settings

Follow the same steps for any other import, but choose the "Summer 20XX" option in the import settings window. The summer school option will be available 100 days before the start of the new school year (rollover date). 

The Create New Import Job form with Import Settings filled in, Summer 2025 selected as the school year to apply the upload data to.

View additional information for summer school imports at Summer School Importing.

 

Step 7: Map Columns

From the drop-down options in the middle of the screen, select the column header in the file that matches the options in Amira Learning.

Mapping columns is the process of creating data element mappings between Amira Learning and <your_school>.CSV data models. The Map Columns Web page has three columns: Amira Names, Import File Column Headers, and Import File CSV Examples.

 

The Map Columns step, with Amira Names, Import File Column Headers and CSV Examples side by side and the required student and teacher fields outlined in red.

 

Required fields are indicated with a red asterisk (*). For optional fields, select the blank option in the drop-down box if you do not wish to specify a value. A value will be assigned automatically, using the Amira Learning default format, if the following fields are left blank: Student User name, Student Password, Teacher User name. Refer to the Data Dictionary for more information about the fields.

 

In order to check the validity of the data submission prior to processing, click the Validate button. You will be provided a list of validation errors if any, and provided the next steps for the process.

 

Step 8: Validate File

On the Validate File page, there might be validation errors if the file is missing data or has data in an incorrect format. The validation results will inform the user of errors and the line number in the file where they occurred.

 

The following example was missing an e-mail address for a teacher on line 2, had an incorrect ID format on line 4, and unknown demographic value on line 6.

 

The Validate File step warning of four validation errors, including a missing e-mail and an invalid Student ID, with Process Job greyed out.

 

Possible errors include:

  • missing a required column
  • unknown campus ID
  • invalid grade
  • invalid e-mail address
  • invalid student ID
  • invalid date format

 

At this point there are several options:

  • If there are validation errors because of file issues, edit the job by clicking Edit Job to import a new file.
  • If there are validation errors because of column mapping issues, re-map the columns by clicking Map Columns.
  • If there are validation errors but the import should be processed anyway, ignoring those lines, click Edit Job and then Process Job. (If it is completed, the import will skip the students with missing data.)
  • If there are no validation errors, click Process Job to continue.

 

Step 9: Process Job

To complete an import, click the Process Job button. The screen will display the job number.

 

The Validate File step reporting there are no validation errors, with Edit Job, Map Columns and Process Job all available.

 

The status of jobs can be found under the My Import Jobs option on the left side of the screen.

 

Image highlighting the My Import Jobs button on the Administration page of the Istation reporting website.

 

When the job has finished processing, it will be listed on the Completed Jobs tab, and an e-mail notification will be sent if that option was selected. Additionally, updates will be visible when viewing classrooms within the campus(es).

 

Completed/Processed Import Jobs

The status of import jobs can be monitored on the Import Jobs webpage.

 

Active Jobs

Image highlighting the Active Jobs tab.

The Active Jobs tab lists import jobs that are either pending, queued, or currently being processed.

 

Completed Jobs

Image highlighting the completed jobs tab and the view button.

The Completed Jobs tab lists import jobs that have been processed. Click the View button to see the results of a completed Import Job.

 

Saved Templates

The Saved Templates tab lists any saved templates used for processing FTP Import jobs.

Image highlighting the Saved Templates tab.

 

View Import Job

Image highlighting the view button in the completed jobs tab.

Image displaying all the available options within the View Import Jobs page.

 

The following information is available on the View Import Job page:

  • Import Job results will list details from the import (how many students or teachers were added/removed, etc)
  • Import file details
  • Column mapping information through the View Column Mapping button
  • Import settings
  • Option to save import as a template through the Save as Import Template button

 

SFTP/FTPS Settings

View the FTP Imports article for information on setting up an FTP connection using the SFTP protocol.