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.
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.
Plan to join us for our PSUG-IL Fall 2017 User Group Meeting on Friday, November 10, 2017!! This meeting will be a full day event from 9 am until 3 pm, but come early for a continental breakfast provided by PowerSchool. Much of this meeting's agenda will focus on IL State reporting topics, and ISBE will be there for a Q&A session. To help us with meal counts, please sign up below if you plan to attend. Hope to see you there!!
AGENDA:
AGENDA:
- Welcome
- Illinois State Reporting
- IL State Reporting 101: Basic Setup
- Meeting Attendance on Student Exits
- Early Childhood Reporting
- ISBE Q&A / Open Discussion
- Summer School
- Lunch/Sponsor Presentation (Otus - Tim Brandau)
- PowerSchool: What's New and Coming Soon?
- Scheduling in Data Export Manager
- Must-Have Customizations
THANK YOU to our meeting sponsors:
- PowerSchool
- Otus - otus.com
Otus Contact: TIM BRANDAU - Sales Operations Manager
tim@otus.com
(773) 789-5444 ext. 117
Resources from the meeting:
- Setting up Summer School Slides (John Dunleavy)
- Early Childhood State Reporting Sides (John Dunleavy)
- Data Export Manager - Automated Export Notes (Nick Peronti)
- PARCCtastic Plugin version 4.0 (Nick Peronti)
- Multi Select Plugin (PowerSource)
- PowerTools Plugin (PowerSource)
- Mass Print Student Screen Plugin (Adam Larsen)
- SQLreports 5 (SISresources)
- Quick School (Adam Larsen)
Pages
