Plasco Export
Plasco take student and schedule data from PowerSchool and imports into the database on a nightly basis.
Students
File:students.csv
Schedule:Daily 3:30 AM
Only basic student information is needed for plasco. In there settings there is an disable checkbox.
Fields exported:
- schoolid
- id
- student_number
- First_name
- last_name
- middle_name
- dob
- mailing_street
- mailing_city
- mailing_state
- blank
- mailing_zip
- dean
- grade_level
- home_phone
- Motherdayphone
- fatherdayphone
- IL_FER
- Emerg_Phone_1
Schedules
File:student_sched.csv
Schedule:MTWHF 3:30 AM
The schedules need to be parsed before going to Plasco. The double periods need to be split into separate periods.
Fields Exported:
- student_number
- period
- Abbreviation (S1 or S2)
- Course_number
- Room
- Last_name (teacher)
- first_name (teacher)
- section_number
- course_name
- students.id