The One to One Plus Zap includes student, guardian, and demographic data so that districts can easily provision accounts within One to One Plus. The Zap can be configured to extract this information on a scheduled basis, ensuring that your data remains synchronized between the two products. This lesson provides the Business Rules for the One to One Plus export Zap.
Before you Begin
Need a refresher on installing a Zap? Visit to Pre-Built Export Zaps learn more.
Business Rules
New Student Import
The Zap offers the following options:
- Grade Level filter
- School Type filter
- School filter
- Include Pre-registered Students
new_student_import.csv
The exported file will have tab-delimited data (despite the file name) and with no header row.
The Grade Level, School Type, and School filters are applied to the students' current school and grade when the Zaps' Source Year is the current year.
The Grade Level, School Type, and School filters are applied to the students' scheduling school and grade when the Zaps' Source Year is the next year.
Inactive students will be ignored.
| Field in order of output | eSD Business Rules |
|---|---|
| First Name | Student's first name |
| Middle Name | Student's middle name |
| Last Name | Student's last name |
| Gender | Student's Gender code |
| Student Number | Student's ID number |
| School Abbreviation | Student's current school's school code if the Source Year is the current year or their scheduling school's school code if the Source Year is the next year |
| Grade Level | Student's current grade if the Source Year is the current year or their scheduling grade if the Source Year is the next year |
| Homeroom Teacher | Student's homeroom teacher in Last Name, First Name format |
| Mailing Street | 1. Pull the student's household's mailing street number, mailing street suffix, and mailing street if available. 2. If the student's household has a mailing apartment, add " Apt# " and then the apartment to this field. 3. If the student's household has a mailing condo/community, add " #" and then the condo/community to this field. 4. If the student's household has a mailing P.O. Box, add " P.O. Box " and then the P.O. Box to this field. |
| Mailing City | Student's household's mailing city |
| Mailing State | Student's household's mailing state abbreviation |
| Mailing Zip | Student's household's mailing zip and zip4 |
| Home Phone | Student's household's phone number in "000-000-0000" format if there is no extension or in "000-000-0000 Ext. XXXX" format there is an extension. |
| Acceptable Use Policy | Left blank |
| Insurance Status | Left blank |
| Parent First Name | First name of guardian first in derived priority who is not deceased and has the correspondence flag on for the student. |
| Parent Last Name | Last name of guardian first in derived priority who is not deceased and has the correspondence flag on for the student. |
| Parent Email | Email addresses (separated by semicolons) of guardian first in derived priority who is not deceased and has the correspondence flag on for the student. |
| Information Release | Left blank |
| Special Programs | Left blank |
| State Student ID | Student's state ID number |
| Enroll Status | Always "0" |
| Student Email | Student's email address |
Staff Import
staff_import.csv
The exported file will have tab-delimited data (despite the file name) and with no header row.
The School Type and School filters are applied to school-level staff. District-level staff will always be pulled.
Only active staff will be included.
District-level staff related to eSD system functions, eSchoolData Administator, API Updater, and Portal Updater, will be ignored.
| Field in order of output | eSD Business Rules |
|---|---|
| Staff ID | Staff's ID number if available, else pull the staff's primary key (Internal Code) |
| First Name | Staff's first name |
| Last Name | Staff's last name |
| User Status | Always "1" |
| Email Address | Staff's email address |
| Site | For school-level staff, their school's school code. For district-level staff, always "DCO" |
| Job Title | All of the staff's staff types separated by commas |
| Staff Phone Number | All of the staff's phone numbers separated by commas |