Setting up Weekly Low Grade Exports - Filter Method
Minimum version: BrightArrow Base 2 v9.2.1
Schools are constantly trying to find ways to involve parents/guardians with student's progress. Report cards come only a few times a year and they report on the past. Keeping parents informed when there are potential problems helps improve student performance. One way schools can keep parents informed before the report cards is weekly low grades notifications. These notifications tell parents when their student is struggling in a course and can be used to prompt action. There are 2 version, this version is the simpler version that uses the settings from the filter page for simplicity.
Filters
This export will respect the settings from the BrightArrow Settings area. For more information on how to change the settings read How to Change the Weekly Low Grade Filters. Once the export is set up and scheduled all changes other than export time changes can be done from the settings area.
Setting up Weekly Low Grade exports
The export should be set up in DEM from District Office. For information on getting to DEM read Getting to Data Export Manager (DEM)
- Category = Additional Data Sets
- Export From = BrightArrow Grading - Search by Store Code - from Filter
- Fields -> Select the checkbox next to "PGFINALGRADES" to select all fields. Fields are already listed in proper order.
- Click Next
- No filters here, controlled by the settings page filters
- Click Next
Note: Before the next section becomes editable the entire template must run. This is not a quick process and the larger your district the longer this will take.
- Export File Name = low_grades.txt
- Line Delimiter = CR/LF
- Character Set = UTF-8
- Click Save Template
- Name = BrightArrow - Low Grades
- Click Save as New
- Switch to the My Templates tab
- Find the row for the new template and click the calendar button to schedule this template. If you do not see the calendar button or the Scheduled System Templates tab you don't have permission to schedule exports. For more information on that read Enabling DEM Scheduling
- Days to Execute = Pick a day to run. Thursdays give a chance to notify before the weekend in case there is extra work that can be done
- When to Execute = pick a time 5 to 10 minutes before you want the message to go out. There needs to be some processing time for PowerSchool to generate the file and send it to us. If you want the message to go at 10:10am then export at 10:00am.
- Send Output To = BrightArrow
- Email Completion Report To (optional) = your email or an email to keep a record of if the export and file transfer was successful or if it failed.
- Click Save
- Your export will go at the scheduled time and day(s). To send a copy now so that we can get started setting up the import of the file you can click the Send Now button which looks like the Play button from DVD player
- Let us know that the file is ready so that we can set up your import
