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
  • Clever - Enrollments
  • Clever - Schools
  • Clever - Sections
  • Clever - Staff
  • Clever - Students
  • Clever - Teachers
• Clevr - With hard-coded Tenant IDs (that you must set in the XML file)
  • Classes
  • Locations
  • School Demographics
  • Staff
  • Staff Classes
  • Staff Demographics
  • Student Classes
  • Student Demographics
  • Students
• Clevr - Pull the tenant ID from the MSS database (must exist or school is ignored)
  • Classes
  • Locations
  • School Demographics
  • Staff
  • Staff Classes
  • Staff Demographics
  • Student Classes
  • Student Demographics
  • Students
• Insignia Library System
  • Insignia - Student List
• L4U Library System
  • L4U Current student list
• Lifetouch (School Photos)
  • Lifetouch student list
• LSSD Lunch (In-house school lunch tracker)
  • LSSD Lunch - student list
• 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
  • Xello Students

• Imagine Everything Education Forms (and possibly other "Forms" products from Imagine Everything)
  • IE-EduForms - Contacts
  • IE-EduForms - Enrolments
  • IE-EduForms - Schools
  • IE-EduForms - Sections
  • IE-EduForms - SpecEd
  • IE-EduForms - Staff
  • IE-EduForms - Student Custody
  • IE-EduForms - Students
  • IE-EduForms - Teachers

Click the link below to download this entire Git repository in a zip file.

https://github.com/LivingSkySchoolDivision/MySchoolSaskIntegrations/archive/master.zip