This git repository represents work and research done for the purpose of creating export definitions for MySchoolSask (an implementation of Follett Aspen).
-
The AspenNotes directory contains some general notes on how Aspen handles things like special variables for filters.
-
The ExportToolXMLs directory contains XML files to be used when creating an export definition in Aspen/MySchoolSask. They are organized into folders by vendor or product.
-
The Howto directory contains instructions for end-users on how to install an export XML file
-
The ReplicatedDatabaseSQLExports directory contains SQL queries to be used to generate reports from the Replicated/Reporting SQL database. Access to this database is an extra cost over-and-above MSS licensing, but Aspen's XML based export tool has limitations and some exports are not possible without direct SQL access.
-
The VendorDocumentation directory contains documents and/or links to vendor integration file specifications
- How to install an XML file from this repository
- How to set an export to run automatically on a schedule
- How to run an export manually
- Active Directory
- Note: Everyone's Active Directory implementation will be different, so this file may not be suitable for the way your organization handles AD integration now. You may need to change/add/remove fields, or reconfigure your existing identity system or scripts for these exports to work.
- AD Active Students
- AD Withdrawn Students
- Clever
- Clevr - With hard-coded Tenant IDs (that you must set in the XML file)
- Clevr - Pull the tenant ID from the MSS database (must exist or school is ignored)
- Insignia Library System
- L4U Library System
- Lifetouch (School Photos)
- LSSD Lunch (In-house school lunch tracker)
- SchoolMessenger
- SchoolMessenger Contacts - MSS top 2 - Exports the top 2 contacts for students. No control of which contacts it exports, aside from priority.
- SchoolMessenger Contacts - MSS top 3 - Exports the top 3 contacts for students. No control of which contacts it exports, aside from priority.
- SchoolMessenger Multipart Demographic Export
- These two "multipart" exports allow finer grained control of which contacts are exported. They are configured to export the first 3 with "Has Family Portal Access" permission, and most importantly, nobody that doesn't have this permission (unlike the other SchoolMessenger exports)
- SchoolMessenger Contacts - Multipart - Students
- SchoolMessenger Contacts - Multipart - Contacts
- Script to combine these: SchoolMessenger demographics multipart combiner script
- Xello
- Imagine Everything Education Forms (and possibly other "Forms" products from Imagine Everything)
Click the link below to download this entire Git repository in a zip file.
https://github.com/LivingSkySchoolDivision/MySchoolSaskIntegrations/archive/master.zip
Living Sky School Division maintains another list of SQL queries designed to be run against the MSS Replicated Database here: https://github.com/LivingSkySchoolDivision/MySchoolSaskRDSQLQueries
These are more specific to Living Sky School Division's needs, and the repository contains SQL for our internal HR system as well, so we store these separately from this MSS-specific repository.