Parent Square Export

Modified on Thu, Mar 20 at 10:27 AM

ParentSquare

This tasks creates up to 7 csv files that will be sent to the vendor via SFTP.


schools.csv

school_id
school_name
school_zip
principal_first_name

principal_last_name

principal_email

school_address

school_phone

school_city
Version 2 export only
school_state
Version 2 export only



students.csv

school_id

student_id

first_name

last_name

grade_level

student_email

cellphone

state_student_id

is_504

is_iep

is_ell

is_reduced_meal

is_free_meal

is_special_education

included columns for selected User Flags
column header set to user flag codes
statusVersion 2 export only.  Is student Active? 1 - Yes. 0 - No.


staff.csv

school_id
staff_id
title
first_name
last_name
email
mobile
loginVersion 2 Only
secondary_phone
Version 2 Only


sections.csv

school_id
staff_id
course_name
term_id
is_primary

period_number

section_number
Version 2 Only


roster.csv

school_id
section_id
student_id


terms.csv

school_id

term_id

term_name

start_date

end_date

school_year


parents.csv

school_id

student_id

first_name

last_name
email
email2
mobile
secondary_phone

address

iepoptional setting
language

relationship

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

group_id

group_name
"Bus# ..", "Route .." or Activity Name
category
"Bus" or Activity Type Code


group_members.csv

school_id

group_id

student_id



emergency_contacts.csv 

school_id

student_id

contact_id
first_name
last_name
email
phone

   

Only contacts marked Emergency 1 - 4 ill be included in emergency file


attendance.csv

school_id

student_id

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article