PowerSchool SMS (Data Extractor)

3.1.11.2 (released: 2014-05-14)

Downloads

User guide:: SMSGuide.pdf
Windows:: SMSBridge_3.2.1.0.msi
OS X:: Not available

Overview

The PowerSchool SMS (Data Extractor) bridge allows you to export your student data into Principalm, Teacherpalm and a variety of other products.

This bridge requires an OS of Windows XP or greater, Windows Server 2003 or greater.

Known Issues

This bridge has been updated to the new SIS Liberty User Interface, please see this knowledge base article for information on How to upgrade to SIS Liberty

This Bridge has not been tested on versions lower than 6.3.
Grades are currently not extracted on most systems. Due to the ID_SMS_CLASS field being null in the CSL_SMS_STUDENT_GRADES table. If you know how to resolve this issue, please contact Discovery Support.

Support

Discovery Software provides support for any software downloaded from this page.

Last updated 2014-05-14.

Release history

Version 3.2.0.0 (June 24th, 2014) adds the following features and fixes:

Updated with clearer error and warning messages
Internal updates to better support Teacherpalm

Version 3.1.11.2 (Apr 4th, 2014) adds the following features and fixes:

Updated to work with SIS Liberty
Updated to work with Teacherpalm
Fixes grade score issues

Version 3.1.2.2 (Sept 13th, 2012)

Adds Student Homerooms from Homeroom table

Version 3.1.1.2 (July 27th, 2011)

Fixes Windows SxS issue
Packaged with Acorn 1.0.8.6

SMS Version 3.1.0.0 (July 4th, 2011) adds the following features and fixes:

New Acorn Data Extractor Release

Version 2.2.5.1 (September 9th, 2009) adds the following features and fixes:

Adds ability to filter HasCustody and IsEmergency Flags.

Version 2.2.4.1 (August 31st, 2009) adds the following features and fixes:

Contact Type is now extracted from Contact Type table in SMS. Allows OCC customers to use these types to customize which students are called.

Version 2.2.3.2 (July 9th, 2009) adds the following features and fixes:

Fixes issue when current key expired before Auto-updating license files.
Automatically Correct School Year Code
Fix issue with paths that have spaces on occupdate

Version 2.2.2.5 (March 9th, 2009) adds the following features and fixes:

Added Support for Active codes
Filter Staff Extracts
Better scheduling support.
Students Status greater than extraction date will be ignored
Auto-update License support
Additional Logging

Version 2.2.0.1 (October 15th, 2008) adds the following features and fixes:

New Attendance Handling
Updated to use New Import Spec Changes
Additional Logging
Added Section Enrollment Dates
Installer Fixes

Version 2.1.2.4 (May 5th, 2008) adds the following features and fixes:

Added Excused Field to Attendance
Added Student State Number
Added support for masking Student/Staff School Number

Version 2.0.3.0 (April 17th, 2007) adds the following features and fixes:

Adds Conduct.
Adds Health History.
Adds Health Conditions.
Adds Student Photos exported from the SMS database.
Automatically deletes old pdus from previous school years.
Provides District Scheduling. The extractor now schedules all schools in a batch file that runs them sequentially.
Various Bug Fixes.

Version 2.0.3.0 (April 17th, 2007) adds the following features and fixes:

Fixes scheduling issues where the timetable information is not exported (Period, Day and Reporting Period)
Exports Rotation Day information
Exports additional Student Demographic information.

Version 2.0.2.0 (December 5th, 2006) adds the following features and fixes:

Fixes issue with using the "Schedule This School" button if your school year contains a / character.

Version 2.0.1.1 (October 17th, 2006) adds the following features and fixes:

Fixes issue with Calendar year being pulled from a deprecated database field.
Added Nickname. (Preferred Name)
Fixed Grade Level bug where the grade was not being displayed on the school tab.
Added Homeroom for schools that use the Homeroom field in the student table. Previous version only supported section based homerooms.

Version 2.0.0.0 (September 6th, 2006) adds the following features and fixes:

Supports all features found in Principalm 7.1
Adds Bell Schedule
City and Language Lookups now pull from DESC field instead of CODE field.

Version 1.0.0.6 (February 3rd, 2006) adds the following features and fixes:

Licensing now works with both v7 and v6 style keys.

Version 1.0.0.5 (February 1st, 2006) adds the following features and fixes:

Student Demographics, Contacts, Schedules
Staff Demographics, Contacts, Schedules
Student Period/TimeFrame Attendance
Student Grades