Update for the 2021-2022 school year: Amplify plans to replace Structured CSV enrollment with OneRoster CSVs via our Enrollment Portal. If you have used Amplify’s structured CSV files in the past and would prefer to continue using those formats, you may continue to do so until further notice, and you will continue to upload your CSV files to Amplify via Egnyte, our secure file-sharing system. If you are a new customer, please refer to this article before continuing with enrollment.
Structured CSV enrollment is a method you can use to securely share your roster data with Amplify via multiple CSV templates that you fill out with enrollment information. This document walks you through the multiple CSV enrollment process, including examples of properly formatted CSV files. You should only review this document after communicating with our E&L team.
The templates for the files described in this guide are available via the embedded links that can be found throughout the document. You can also download a zipped folder containing all of the templates.
In addition, your E&L team member will send you an email that contains a link to share the completed files via our file sharing system, Egnyte.
If you're missing any of this information, or are unable to download the templates from this page, please contact your E&L team member or Amplify Customer Services.
The diagrams in this section are provided as a reference to help you visualize how the CSV enrollment files relate to the district hierarchy.
This example includes the following:
One school out of two in the district is participating with Amplify. The information for this school (School 1) will be included in the organization.csv.
One District Administrator (D1) who will need curriculum access to Amplify. The information for this educator will be included in the districtadministrator.csv.
Two School Administrators (A1, A2) who will need curriculum access to Amplify. The information for these educators will be included in the schooladministrator.csv.
Four Teachers (T1-T4) who need access to Amplify. The information for these educators will be included in the teacher.csv and in the roster.csv.
Six students (S1-S6) who need access to Amplify. The information for the students will be included in the student.csv and the roster.csv.
Now that you’ve seen the example of the District hierarchy with the raw numbers of staff and students, the next step is figuring out the breakdown of how they will be using the curriculum throughout the day.
At this example school there are three periods throughout the day and one class each of Science and ELA during each period, but not everyone is in a class all day.
The table above outlines how the teachers and students are grouped together throughout the day.
How do these class sections, teachers, and students fit into the CSV files? The next section will break it down one file at a time.
CSV Files Overview
The CSV files for enrollment are as follows, in order of hierarchy:
Organization.csv: contains information for the schools that make up your organization
Section.csv: contains information on the class sections within the schools
Student.csv: contains information on the students in the class sections
Roster.csv: connects the educators and students via class sections in the Amplify system
The organization.csv file focuses on the schools that will be using the Amplify Curriculum. For this file, you will only need the data related to the schools themselves, and will not need to add any user data.
Fields in the organization.csv file
To learn more about the columns, the data requirements, and the accepted values for each field in this CSV file, you can download the organization.csv data dictionary.
Sample organization.csv file
For the school in the example, you’ll enter its information into the organization.csv as shown:
The section.csv file focuses on the class sections that will be using the Amplify Curriculum. For this file, you will only need the data related to the class section, not the class roster.
Fields in the section.csv file
To learn more about the columns, the data requirements, and the accepted values for each field in this CSV file, you can download the section.csv data dictionary.
Example section.csv file
In the example, there are six class sections using Amplify throughout the day. The CSV file has one line for each class, each with its specific enrollment information. (Columns A and B will come from the organization.csv file.)
The remainder of the data in the section.csv file consists of information for the school that the class should be connected to. In this example, all of the classes are at School 1 so each line is the same.
Districtadministrator.csv / Schooladministrator.csv / Teacher.csv
These files focus on just the administrators or teachers who will be using the Amplify Curriculum or the educators who will need access to students’ work in the Amplify Curriculum app. You’ll only need the data related to the educators themselves, not their class rosters, for these files. These files are all identical except for the CSV file name, which is where you indicate whether the file is for a teacher, district administrator, or school administrator.
Fields in the teacher.csv, districtadministrator.csv and schooladministrator.csv files
To learn more about the columns, the data requirements, and the accepted values for each field in these CSV files, you can download the teacher.csv data dictionary.
Example teacher.csv file
In the example, the school has 10 teachers, but only four teachers need access to Amplify.
Teacher 1 is the primary science teacher.
Teacher 2 is the primary ELA teacher.
Teacher 3 is an interpreter for Student 5, and needs access to the student’s submitted work in Amplify.
Teacher 4 is a SPED specialist assigned to student 6, and needs access to the student’s submitted work in Amplify.
As in the section.csv file, all of these teachers are at School 1 so you can enter the same information in columns A and B for every line.
Example districtadministrator.csv file
The district in the example has multiple administrators, but only one district administrator needs access to Amplify. The one difference between the districtadministrator.csv file and the other two educator files is that you should leave the org_guid and org_sis_id columns blank.
Example schooladministrator.csv file
The school in the example has multiple administrators, but only two school administrators need access to Amplify.
The student.csv file focuses on the students who will need their own accounts in the Amplify Curriculum app. You’ll only need the data related to the students themselves, not their class roster, for this file.
Fields in the student.csv file
To learn more about the columns, the data requirements, and the accepted values for each field in this CSV file, you can download the student.csv data dictionary.
Example student.csv file
There are six students who need to be enrolled with Amplify in this example. Like the previous files, all of these students are at School 1, so you can enter the same information in columns A and B for every line.
To fill out the roster.csv file, you’ll need the information you’ve filled in for the sections, teachers, and students in their respective CSV files. You’ll then use this information to connect the teachers and students to their class sections. This file should not contain any personal information on staff or students; it is focused entirely on connecting teachers and students to class sections.
Fields in the roster.csv file
To learn more about the columns, the data requirements, and the accepted values for each field in this CSV file, you can download the roster.csv data dictionary.
Example roster.csv file
To fill out the roster.csv file, you’ll need to revisit the class schedule from the Example section.
The only classes that need to be rostered are the sections that will be using Amplify Curriculum. In this example, there are three science sections and three ELA sections (the unassigned group does not need to be listed in the roster.csv file). The instructions below will show you how to fill out the roster.csv file, starting with the first science section. Then you can go from there!
Section information in the roster.csv file
Starting with the first science section, there will be one line in the roster file for each person associated with that class (teacher, student, etc.)
First, locate the section information required for all of the teachers and students. You can find the section GUID for this section in the section.csv file. The start_date will always be today’s date. For end_date, enter the day that your school year ends, or leave it blank.
Teacher information in the roster.csv file
Still focusing on the first science section, the roster file will have one line for each person in that class (teacher, student, etc.)
For the staff members in the class, you'll enter their GUIDs in the user_guid column, “teacher” in the type column, and “Active” in the status column.
Student information in the roster.csv file
The process is similar for the students in the class. You’ll enter their GUIDs in the user_guid column and enter “student” in the type column.
Next Steps for Enrollment
Once you fill out each of your CSV templates, save them as copies in an easily accessible location so you have the empty templates as well as the completed files for making any future roster updates.
Connecting with the Egnyte Secure File Transfer service
To share data via Egnyte, follow our instructions for using Egnyte’s secure file transfer link. If you don’t have your district’s Egnyte link, please contact your E&L team member or Amplify Customer Services.
Making and submitting roster changes
To make roster changes (roster additions, deletions, class section changes, etc.) after you complete and submit your initial CSV files, you can update your Amplify enrollment by submitting new CSV files containing the changes you want to make. Examples of the types of changes you may need to make are outlined in Step 2 below. Please reach out to your E&L contact or Amplify Customer Services if you have any questions.
Step 1: Locate your blank CSV file templates (or download new ones here) and open the template for the file you need to change. You may also wish to open your saved completed files to reference the data in them. The data you enter for roster changes must match the original data you entered when submitting your enrollment files.
Step 2: Add your roster changes to the file. You should only enter new or updated roster information, do not edit the files you submitted when you first enrolled with Amplify.
Step 2a. Delete sections:
In the section.csv file, enter the information for the section you want to delete and enter True in the column ‘delete_section’.
Step 2b. Delete staff or students:
In the roster.csv file, create a line for each staff member or student to delete and enter ‘deleted’ in the status column.
Step 2c. Create accounts for new staff or students:
Using the corresponding CSV file, create a line with the information for each new staff member or student.
Step 2d. Add staff or students to sections:
To add a teacher or student to a section, create a roster.csv file with one line for each new teacher or student (see the roster.csv example).
Step 2e. Remove teachers or students from sections:
To remove a teacher or student from a section, create a roster.csv file with one line for each teacher or student you want to remove, and enter ‘deleted’ in the status column.
Step 2f. Move teachers or students from one section to another:
To move teachers or students, create the file from Step 2e to remove the teachers or students from their current section and then create the file from Step 2d to add the teachers or students to their new section.
Step 3: Once you add all the required changes, send the completed CSV files using the Egnyte Secure File Transfer system.
Step 4: Make sure you update your saved roster files with these changes to keep them current with your Amplify enrollment records.