The ReadnQuiz PowerSchool plugin sends your class rosters from PowerSchool SIS to ReadnQuiz
Auto Roster every night. There are no SQL reports to write and no OneRoster to set up: install
the plugin, make three exports in Data Export Manager, and schedule them. It takes about
30 minutes, and you never change it for a new school year.
Before you start
- PowerSchool 20.11 or newer. The version is shown on the PowerSchool
sign-in page.
- A PowerSchool district administrator account that can install plugins.
- Your ReadnQuiz SFTP account (host, username and password). They're in
your ReadnQuiz Auto Roster setup email. Don't have one yet? Email
support@readnquiz.com.
- Who runs your PowerSchool? If PowerSchool or your district hosts it,
you're set. If your state hosts it for every district, the state may decide which
plugins can be installed; check with them first. North Carolina, for example, approves
vendor plugins itself.
What the plugin sends
Three files, built from the current term's classes:
student.csv: one row for each student in each class (K through 12, active
students): school, student number, name, grade, birthdate, gender, class.
teacher.csv: each teacher who teaches a current class: school, name,
PowerTeacher login, email.
class.csv: each current class: school, course, section, course name, teachers
(the section's main teacher is the lead).
It sends every school and every current class. ReadnQuiz keeps only the schools in your
subscription and the schools, grades and classes you choose on the
ReadnQuiz Roster Setup page, so you don't need to filter anything in
PowerSchool. An optional fourth export, schools.csv, lists your school numbers and
names so we can match your schools quickly at setup.
The plugin only reads. It changes nothing in PowerSchool. When you enable it,
PowerSchool lists every field it reads, so you can review them before you approve.
Set it up
Menu names vary a little between PowerSchool versions; the closest match is fine.
- Install the plugin. Go to System > System Settings > Plugin
Management Configuration (on some versions: System Management > Server >
Plugin Configuration). Click Install, choose the zip you downloaded, and
click Submit.
- Enable it. Tick Enable next to ReadnQuiz Rostering.
When PowerSchool shows the data the plugin reads, approve it.
- Connect to ReadnQuiz. Open Remote Connection Manager (on the
Plugin Management page) and click Create Connection. Name it ReadnQuiz,
enter the SFTP host, username and password from your setup email, tick Allows
upload, and click Submit.
- Make the three exports. Open Data Export Manager (under
Data and Reporting > Exports, or System). Choose Export Data,
then Additional Data Sets, and type
NQ to find the ReadnQuiz
queries. Pick com.readnquiz.roster.student and select all of its columns,
keeping their order. Set the output to:
- File name:
student.csv
- Comma-separated, values in double quotes, header row on, UTF-8
Save it as a template, for example ReadnQuiz student. Do the same with
com.readnquiz.roster.teacher (file name teacher.csv) and
com.readnquiz.roster.class (file name class.csv). Use the file
names exactly as shown.
- Schedule them. On My Templates, click the calendar icon on each
ReadnQuiz template. Run it every weekday evening (for example at 9 PM) and set Send
Output To to the ReadnQuiz connection. Give all three the same time.
- Test it. Run each template once and check that Last Run shows
Completed.
- Choose what we roster. Sign in to the
ReadnQuiz Roster Setup page with the same SFTP username
and password. Click Check for new files, then choose your schools, grades and
classes (the student count updates as you go) and how students and teachers sign in, and
click Save setup. Then email support@readnquiz.com.
We check the files and run your first roster with you. After that, ReadnQuiz picks up your
files every weekday morning. You can come back to the setup page any time.
Sign-ins
- Teachers sign in with their PowerTeacher login (or their email, if you
choose that) and pick their own password the first time. Later rosters never change it.
- Students use their PowerSchool student portal username, or their student
number if they don't have one. You choose the student password rule on the setup page
(student number, initials, one word for everyone, and more). The plugin itself sends no
passwords.
Questions
Do I need to change anything for a new school year or term?
No. The plugin picks the current term's classes by date.
Do I need to contact PowerSchool?
No. District administrators install plugins themselves. The one exception is a state-hosted
PowerSchool (see
Before you start).
The ReadnQuiz queries don't show up in Data Export Manager
Check that the plugin is enabled and its data access was approved (steps 1 and 2), and that
you typed
NQ in the
Additional Data Sets list.
How do I update to a new version?
Download the new zip. In Plugin Management, click
ReadnQuiz Rostering, then
Update, and choose the new zip. Approve the data access again if PowerSchool asks.
Your export templates and schedules keep working.
How do I remove it?
Turn off the three scheduled exports, then disable the plugin and delete it in Plugin
Management. Deleting it removes the ReadnQuiz queries, so templates built on them stop
working.
We already use ClassLink
Then you may not need this plugin: ReadnQuiz can take your rosters from ClassLink. Email
support@readnquiz.com and we'll set it up.