ParentSquare
This tasks creates up to 7 csv files that will be sent to the vendor via SFTP.
schools.csv
| school_id | From the School Code under Setup>Schools>Modify School |
| school_name | From the School Name under Setup>Schools>Modify School |
| school_zip | From the School Address/Contact Information under Setup>Schools>Modify School |
| principal_first_name | From the Principal's Name under Setup>Schools>Modify School |
| principal_last_name | From the Principal's Name under Setup>Schools>Modify School |
| principal_email | From the Principal's Email under Setup>Schools>Modify School |
| school_address | From the Address Line 1 under Setup>Schools>Modify School |
| school_phone | From the School Phone under Setup>Schools>Modify School |
| school_city | Version 2 export only |
| school_state | Version 2 export only |
students.csv
| school_id | From the School Code under Setup>Schools>Modify School |
| student_id | From the Student ID under Student Data>Modify Student>Demographics |
| first_name | From the First Name under Student Data>Modify Student>Demographics |
| last_name | From the Last Name under Student Data>Modify Student>Demographics |
| grade_level | From the Grade Level under Student Data>Modify Student>Demographics |
| student_email | From the Email Address under Student Data>Modify Student>Contacts |
| cellphone | From the Cell under Student Data>Modify Student>Contacts |
| state_student_id | From the State ID under Student Data>Modify Student>Demographics |
| is_504 | From the tracking record under Student Data>Modify Student>Tracking>Other>Student 504 |
| is_iep | From the IEP tracking record under Student Data>Modify Student>Special Ed |
| is_ell | From the tracking record under Student Data>Modify Student>Tracking>ML |
| is_reduced_meal | From the tracking record under Student Data>Modify Student>Tracking>Lunch |
| is_free_meal | From the tracking record under Student Data>Modify Student>Tracking>Lunch |
| is_special_education | From the Designated Special Ed under Student Data>Modify Student>Special Ed |
| included columns for selected User Flags | column header set to user flag codes |
| status | Version 2 export only. Is student Active? 1 - Yes. 0 - No. |
staff.csv
| school_id | From the School Code under Setup>Schools>Modify School |
| staff_id | From the Teacher ID under Staff>Staff>Modify Staff>Demographics |
| title | From the Employee Flags under Staff>Staff>Modify Staff>Demographics |
| first_name | From the First Name under Staff>Staff>Modify Staff>Demographics |
| last_name | From the Last Name under Staff>Staff>Modify Staff Demographics |
| From the Email under Staff>Staff>Modify Staff>Demographics | |
| mobile | From the Cell Phone under Staff>Staff>Modify Staff>Demographics |
| login | Version 2 Only |
| secondary_phone | Version 2 Only |
sections.csv
| school_id | From the School Code under Setup>Schools>Modify School |
| staff_id | From the Teacher ID under Staff>Staff>Modify Staff>Demographics |
| course_name | From the Desc: under Scheduling>Sections>Modify Section |
| term_id | From the Sem under Scheduling>Sections>Modify Section |
| is_primary | From the first teacher listed under Scheduling>Sections>Modify Section |
| period_number | From the Period listed under Scheduling>Sections>Modify Section |
| section_number | Version 2 Only |
roster.csv
| school_id | From the School Code under Setup>Schools>Modify School |
| section_id | From the course code and section under Scheduling>Sections>Modify Section |
| student_id | From the student ID under Student Data>Modify Student>Demographics |
terms.csv
| school_id | From the School Code under Setup>Schools>Modify School |
| term_id | From the Code under Setup>Schools>School Parameters>Attendance Cycles |
| term_name | From the Description under Setup>Schools>School Parameters>Attendance Cycles |
| start_date | From the Start Date under Setup>Schools>School Parameters>Attendance Cycles |
| end_date | From the End Date under Setup>Schools>School Parameters>Attendance Cycles |
| school_year | Always pulls the current school year |
parents.csv
| school_id | From the School Code under Setup>Schools>Modify School |
| student_id | From the Student ID under Student Data>Modify Student>Demographics |
| first_name | From the First under Student Data>Modify Student>Contacts |
| last_name | From the Last under Student Data>Modify Student>Contacts |
| From the Email under Student Data>Modify Student>Contacts | |
| email2 | From the second Email listed (if applicable) under Student Data>Modify Student>Contacts |
| mobile | From the Mobile Number under Student Data>Modify Student>Contacts |
| secondary_phone | From a second phone number that is not mobile under Student Data>Modify Student>Contacts |
| address | From the Address under Student Data>Modify Student>Contacts |
| iep | optional setting |
| language | From the Primary Language under Student Data>Modify Student>Demographics |
| relationship | From the Relationship under Student Data>Modify Student>Contacts |
| parent_id | Version 2 Only |
| login | Version 2 Only |
| educational_rights | Version 2 Only (column data blank) |
Groups may contain Bus Routes, Bus Numbers, Clubs and Sports based on configuration settings
groups.csv
| school_id | From the School Code under Setup>Schools>Modify School |
| group_id | "Bus" or Activity Type Code |
| group_name | "Bus# ..", "Route .." or Activity Name |
| category | "Bus," "Sport" or "Club" |
group_members.csv
| school_id | From the School Code under Setup>Schools>Modify School |
| group_id | "Bus" or Activity Type Code |
| student_id | From the Student ID under Student Data>Modify Student>Demographics |
emergency_contacts.csv
| school_id | From the School Code under Setup>Schools>Modify School |
| student_id | From the Student ID under Student Data>Modify Student>Demographics |
| contact_id | When a contact is first created and added to a student, it is given an internal contact ID that can only be seen under Admin>Audit Trail>Update/Deletes, using the Contact2 table |
| first_name | From the First under Student Data>Modify Student>Contacts |
| last_name | From the Last under Student Data>Modify Student Contacts |
| From the Email under Student Data>Modify Student>Contacts | |
| phone | From the Number under Student Data>Modify Student>Contacts |
Only contacts marked Emergency 1 - 4 ill be included in emergency file
attendance.csv
| school_id | From the School Code under Setup>Schools>Modify School |
| student_id | From the Student ID under Student Data>Modify Student>Demographics |
| date | today's date |
| period | column produces "all_day" in every row |
| code | A or T |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article