PowerSchool Interaction with other Systems
PowerSchool communicates with several other systems. This is done in many ways (ftp, curl, sftp, flat files). Only the simplest exports are available within PowerSchool. PowerSchool can only handle exporting active students via ftp, flat file, and sftp. Any more complicated exports such as: only IEP students, first line contains an API key, or upload via curl, is done through a separate system. Below is a list of exports, where they are executed, and what transportation method is used.
System | Transport Method | Filename | Schedule |
Follett – Students/Staff | SSIS Package | StudentCombined.csv
staff.csv |
Daily 12:00 AM |
Follett – Schedules | SSIS Package | StudentCourses.csv | Sunday 11:30 PM |
Plasco – Students | FTP | students.csv | Daily 3:30 AM |
Plasco – Schedule | FTP | student_sched.csv | MTWHF 3:30 AM |
Netchemia – Students | SFTP | glenbard.txt (tab) | Daily 12:01 AM |
Naviance – Students | cURL | students.csv | Daily 11:30 PM |
Mastery Manager – Students | SFTP | students.csv | Daily 2:00 AM |
Mastery Manager – Schedules | SFTP | schedules.csv | Daily 2:20 AM |
Websmartt – Students | FTP | students.csv | MTWHF 4:00 AM |
Websmartt – Staff | FTP | staff.csv | MTWHF 3:30 AM |
MAP – Students | Download | mapcombined.csv | On Demand |
MAP – Groups | Download | mapgroups.csv | On Demand |