Visitor Aware | Singlewire Software

Within PowerSchool, you can export csv files and then send those files via SFTP to Visitor Aware.


Common PowerSchool exports that you will create for Visitor Aware are:

students.csv

visitors.csv
visitors_powerschool.csv ( 

If you find each student/guardian relationship is exported as a new row from your student information system instead of multiple Student IDs comma-separated in the Students column, please use this template.

 )

Templates for the CSV files above( and more ) can be found in Visitor Aware on the Import Resources page.


Helpful PowerSchool Support Articles

Create Data Exports

Export Data Using the Data Export Manager


Useful queries for PowerSchool Data Exports

psql example - retrieving data from the students' table:

SELECT 
student.id AS `Student ID`
student.first_name AS `First`, 
student.last_name AS `Last`, 
student.dob AS `DOB`, 
student.grade AS `Grade`, 
"" AS `Self Signout`,
"" AS `Notes`,
student.school_id AS `School ID`, 
FROM students;