A Powershell Module to import reports from Sapphire SIS
Download zip file or use git: git clone https://github.com/andrewzirkel/SapphireDownloader.git
Use Set-SDParameters to set options
See examples in SapphireDownloaderExample.ps1
Set options for download.
Set-SDParameters -Username $SDusername -Password $SDpassword -URL $sapphireURL -DistrictID $SDdistrict_id -SchoolID $SDschoold_id -SchoolYear $SDschool_year
Note: Only School ID can be changed on the fly with Set-SDParameters -SchoolID $SDschoold_id
Get Class Roster Report
Get Custom Demographics report
Get report writier report
Get ConnectEd (School Messenger) Report
Get Blackboard Connect report
Note: Header contains duplicate entries, so if importing to csv you must change the header row, see example file.
Get Marking Periods for current building
usage: Get-SDDictionary $DictionaryName
currently supported dictionaries are: Durations,DURATION_MP,DURATION_GROUPS
returns array of objects with Duration Code, start and end dates
returns array of objects with sapphire users
must have access to Admin > Security, Users and Staff > Users
usage: Get-SDStudentFees -StudentID $id
returns array of objects with fees
usage: Set-SDStudentEmailAddress -StudentID $id -EMail $email
sets email address for student record
usage: Set-SDStudentEmailAddress -StudentID $id -Fee $fee -Category $categoryLongNameOrShortName
returns: $false on failure
Adds a fee record for a student