Please plan to join us for our PSUG-IL Spring Meeting on Friday, May 11th at Marquardt School District 15.  Much of the focus for this meeting will be on Illinois State Reporting (with Karin Jensen/PowerSchool).  We have also asked Adam Lowery from ISBE to join us and are awaiting confirmation.  Mary Toner will also be present to talk about PowerSchool 12, including Unlimited Contacts. This will be a half-day event from 9 AM - 12 NOON.  A continental breakfast will be available at 8:30 a.m., courtesy of PowerSchool.  Please sign up below. 

AGENDA:
  • PowerSchool 12 - What's New, Unlimited Contacts, Other (Mary Toner, PowerSchool)
  • IL State Reporting (Karin Jensen, PowerSchool)
    • Update on reports
    • What is needed?
    • Upcoming Changes for 18-19
  • Open Discussion

Hope to see you there!!

MEETING PRESENTATIONS:

What's New in PowerSchool 12? 

(Note from Mary Toner:  Jason also covered all of this in PowerSchool Insider Podcast Episode 39
The PSUG-IL Spring 2018 Meeting will be held on Friday, May 11th at Marquardt School District.  Please hold the date and check back for details!
Most of us need to move data contained in PowerSchool to outside systems. Usually this involves exporting student data to a flat file and sending it to the outside system on a schedule.  For a long time PS admins have used Autosend to accomplish this.

During the fall PSUGIL meeting we looked at how templates in Data Export Manager can be scheduled.  But what if you needed to include data from a bunch of joined tables, transform the values, or do some advanced filtering?  For this we need SQL!

In this workshop we will demonstrate how to take a SQL query, wrap it in a plugin, and schedule it to output results to an SFTP site.  Many 3rd party systems/services can be used to accomplish this very thing. What we will be demonstrating is how to accomplish it all within PowerSchool.  This workshop is not about how to write SQL queries (though we will be working with a bunch of examples).  All experience levels are welcome to attend. However some prior knowledge of SQL will be beneficial.

Pages

Subscribe to Front page feed