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.

Download the ReadnQuiz PowerSchool plugin (zip)

Version 0.1.1. For PowerSchool SIS 20.11 or newer. Don't unzip it: PowerSchool installs the zip file as it is.

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.

  1. 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.
  2. Enable it. Tick Enable next to ReadnQuiz Rostering. When PowerSchool shows the data the plugin reads, approve it.
  3. 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.
  4. 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.
  5. 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.
  6. Test it. Run each template once and check that Last Run shows Completed.
  7. 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.