Plugin Change History: Data Plugin

Data plugins are customized to your district’s settings. Every single district will have a unique, though fairly similar, data plugin. Changes to which fields you want to pull are in this plugin.

Note: as of Jan 2023 updated versions will have the version reflect the date the last change was made to your specific copy. Thus version 23.02.24 would essentially be 9.4 and eligible for the small update. 

V24.08.28 (min Base Plugin 1: v24.08.13, min Base 2: v24.08.20)

This update matches the changes made to the stock version of the PQs. This update is not necessary unless the school would like to populate students in lists for all schools they have at least 1 class in. If students are only to show in their main school's list then this update can be skipped.

• PQ Changes:
  • 5 PQs (Basic - Parents from Legacy, Basic - Students from Legacy, Basic - Parents from Contacts, Basic - Parents from Contacts - Alternate, Basic - Students from Contacts)
    • Updated how they find current classes so that they now can find an alternate school where a student is taking classes before the cc start date. Uses the same padding values from the settings page as rosters and teacher sections.

V24.08.20 (min Base Plugin 1: v24.08.13, min Base 2: v24.08.20)

This update matches the changes made to the stock version of the PQs so that the fields align. This update is not necessary and is used for easier setup and management in the future.

• PQ Changes:
  • BrightArrow - Basic - Parents from Legacy - Custom
    • Add guardian day phone, emergency 1-3 phones to match stock PQ
  • BrightArrow - Basic - User Contacts - Custom
    • Add additional_phone_01 fields to match stock PQ

V24.06.17 (min Base Plugin 1: v24.04.19, min Base 2: v24.06.17)

This update matches the changes made to the stock version of the PQs so that the fields align. This update is not necessary and is used for easier setup and management in the future.

• PQ Changes:
  • BrightArrow - Basic - Parents from Legacy - Custom
    • Improved performance when prefs duplicate. Ultimately the duplicate should be removed (try PowerTools for help)
    • Add activities placeholder so it is consistent in the future
    • Add voice/text fields for each phone (hard set as 1 for enabled) to align the phones with the contacts PQ
    • Add phone6 placeholder to match field count in other PQs
  • BrightArrow - Basic - Students from Legacy - Custom
    • Improved performance when prefs duplicate. Ultimately the duplicate should be removed (try PowerTools for help)
    • Add activities placeholder so it is consistent in the future
    • Add home_phone placeholder to align with parent PQs
    • Add phone4-phone6 placeholder sets to match other PQ field counts
  • BrightArrow - Basic - Parents from Contacts - Custom
    
    • Improved performance when prefs duplicate. Ultimately the duplicate should be removed (try PowerTools for help)
    • Add activities placeholder so it is consistent in the future
  • BrightArrow - Basic - Parents from Contacts - Alternate - Custom
    
    • Improved performance when prefs duplicate. Ultimately the duplicate should be removed (try PowerTools for help)
    • Add activities placeholder so it is consistent in the future
  • BrightArrow - Basic - Student from Contacts - Custom
    
    • Improved performance when prefs duplicate. Ultimately the duplicate should be removed (try PowerTools for help)
    • Add activities placeholder so it is consistent in the future
  • BrightArrow - Basic - User Contacts - Custom
    • Improved performance when prefs duplicate. Ultimately the duplicate should be removed (try PowerTools for help)
    • Add Lunch ID to match stock version

V24.03.11 (min Base Plugin 1: v224.02.09, min Base 2: v24.02.19)

This update matches the changes made to the stock version of the PQs so that the fields align. This update is not necessary and is used for easier setup and management in the future.

• Current Selection Changes:
  • pages no longer include data plugin version, version is now injected in live to be the most accurate
  • Student sort order changed to include student number to separate when multiple students have the same first and last names so that their contacts don't get mixed up
• PQ Changes:
  • BrightArrow - Basic - Parents from Legacy - Custom,
    BrightArrow - Basic - Students from Legacy - Custom
    • Add City, School Category, District of Residence
    • Add contact firstname, lastname, relationship placeholders
    • Add ability to only use enabled schools from settings
    • Add ability to include all schools a student takes a class in instead of just the enrolled school if setting is enabled
  • BrightArrow - Basic - Parents from Contacts - Custom,
    BrightArrow - Basic - Parents from Contacts - Alternate - Custom,
    BrightArrow - Basic - Student from Contacts - Custom
    
    • Add City, School Category, District of Residence
    • Add contact firstname, lastname, relationship from contact record
    • Add ability to only use enabled schools from settings
    • Add ability to include all schools a student takes a class in instead of just the enrolled school if setting is enabled
    • Add ability to use the built in Contacts language if enabled
    • Add isVoice toggle and obey setting from Base 2
    • Obey isText toggle from setting in Base 2
    • Correct date calculation to use real date/time instead of DB node date/time
    • Add options to obey legalGuardian, caregiver, volunteer, schoolpickup flags if set in settings
    • Change sort from contact stored priority order value to calculated sort order so it will be correct
  • BrightArrow - Basic - User Contacts - Custom
    • Add home school category and school populate filter category
    • Massive improvement to query to accurately reflect schools user is active in
    • Add ability to only use enabled schools from settings
    • No longer require PTAccess checkbox to be turned on to count as "active" PT record, only the active checkbox is needed now
    • Status now counts all schoolstaff records, not just the home school. If a user is inactive in the home school but active in another school they will now be considered active. Previously active required home school to be active.

V23.07.13 (min Base Plugin 1: v23.03.10, min Base 2: v23.07.13)

This update introduced new PQs and removed some older ones to simplify setup. The name change is to remove some confusion. This update is not necessary and is used for easier setup and management in the future.

• File moved to align with changing requirements in 23.5
  • /admin/brightarrow/student.baAlterations.content.footer.txt -> /admin/students/bastudent.baAlterations.content.footer.txt
• New PQs:
  • BrightArrow - Basic - Parents from Legacy - Custom
    • Custom version of the stock PQ BrightArrow - Basic - Parents from Legacy
    • Simplified version of BrightArrow Student Contacts. Select all fields and they show up in the correct order.
    • Use only when exporting parents using legacy (1:1) fields for phones and emails such as home_phone, guardianemail
    • Only active and pre-enrolled students will be included
  • BrightArrow - Basic - Students from Legacy - Custom
    • Custom version of the stock PQ BrightArrow - Basic - Students from Legacy
    • Simplified version of BrightArrow Student Contacts. Select all fields and they show up in the correct order.
    • Use only when exporting students using legacy (1:1) fields for phones and emails such as cellphone_ba, studentemail
    • Only active and pre-enrolled students will be included
  • BrightArrow - Basic - Parents from Contacts - Custom
    
    • Custom version of the stock PQ BrightArrow - Basic - Parents from Contacts
    • Simplified version of BrightArrow Student Contacts New. Select all fields and they show up in the correct order.
    • Use only when exporting parents using the contacts module for phones and emails.
    • Only active and pre-enrolled students will be included
  • BrightArrow - Basic - Parents from Contacts - Alternate - Custom
    
    • Custom version of the stock PQ BrightArrow - Basic - Parents from Contacts - Alternate
    • Simplified version of BrightArrow Student Contacts New - Alternate. Select all fields and they show up in the correct order.
    • Use only when exporting parents using the contacts module for phones and emails and need to use the alternate filter
    • Only active and pre-enrolled students will be included
  • BrightArrow - Basic - Student from Contacts - Custom
    
    • Custom version of the stock PQ BrightArrow - Basic - Student from Contacts
    • Simplified version of BrightArrow Student Contacts New - Student. Select all fields and they show up in the correct order.
    • Use only when exporting students using the contacts module for phones and emails.
    • Only active and pre-enrolled students will be included
  • BrightArrow - Basic - User Contacts - Custom
    • Custom version of the stock PQ BrightArrow - Basic - User Contacts 
    • Same as BrightArrow User Contacts but numbered so that the fields are in order and the fields no longer used are removed. At this time no emergency contact fields are included but they can be added back if needed.
    • Only active users will be included

V23.05.15 (min Base Plugin 1: v9.2.2, min Base 2: v9.2.1)

If your school has a custom staff query then an update to utilize the new filter option is advised but far from urgent. It makes changing that setting easier later on but does not hinder performance today. 

If your school does not have a custom user query then the update is completely unnecessary unless you need to include web_id as a mail merge field now.

• PQ Changes:
  • Updated 4 PQs (BrightArrow Student Contacts, BrightArrow Student Contacts New, BrightArrow Student Contacts New - Alternate, BrightArrow Student Contacts New - Student)
    • Removed lunch_status. All balance exports should now use the new filters and have ways to account for differences in thresholds based on lunch status without sending us this field.
    • Add students.web_id for possible export field.
  • Updated BrightArrow User Contacts
    • Add school_populatefilter option. This calculated field will replace schoollist, schoollist_all, schoollist_inactive, schoollist_admin, schoollist_teacher, schoollist_autosend as schools move to use the filter option to make the decision instead of going into the export and changing the field manually

V9.4 (min Base Plugin 1: v9.2.2, min Base 2: v9.2.1)

• PQ Changes:
  • Updated BrightArrow User Contacts - Default to obey the 5 exclude options
  • Updated 4 PQs (BrightArrow Student Contacts, BrightArrow Student Contacts New, BrightArrow Student Contacts New - Alternate, BrightArrow Student Contacts New - Student)
    • Now includes new column for PDF_Password which will return the value based on the setting
    • Added column fake_email which is hard coded to 'donotemail@brightarrow.com'

V9.3 (min Base Plugin 1: v9.2.0, min Base 2: v9.2.0)

• New File:
  • Add page fragment /admin/brightarrow/student.baAlterations.content.footer.txt which will contain custom legacy field information to be used in the Student BrightArrow Settings page
• PQ Changes:
  
  • Updated descriptions on all PowerQueries to be more helpful now that they are displaying in DEM
  • All student queries updated to obey the student exclude all toggle
  • Added to nearly all PowerQueries
    • School_Name
    • School_Phone
    • School_Principal
    • School_Principal_Email
    • School_Principal_Phone
  • Added att_sec_email to all attendance PowerQueries
  • Added students.lunch_id to student PowerQueries
  • BrightArrow User Contacts: Remove the schoolIDList options (list of schools using school number) and kept the versions of the same columns for schoolList (list of schools using school abbreviations)
  • PQs that use contacts: expired and disabled contacts are not included when counting the top 2, 3, 4, etc contacts
  • Fixed issue with student cell phone voice/text fields not getting the default value and exporting null
• Instant Connect Only:
  • Updated Publisher Name to be LINQ, Inc. since the purchase from eSchoolView. You will need to delete the old plugin and install the new one fresh or PowerSchool will show an error.

V9.2 (min Base Plugin 1: v9.1.2, min Base 2: v9.1.0)

• Add logic to properly decode home_language based on which parent language setting was selelcted
• Separate student language into home_language_std to allow for separate languages for parents and students
• Add logic so that queries using contacts obey override settings

V9.1 (min Base Plugin 1: v9.0.0, min Base 2: v9.0.0)

• Add summerschoolid, summerschool (summer school abbreviation), summerschoolnote to plugins
  • BrightArrow Student Contacts - legacy version
  • BrightArrow Student Contacts - unlimited version
  • BrightArrow Student Contacts - unlimited from filter
  • BrightArrow Student Contacts - unlimited from filter - Alternate
  • BrightArrow Student Contacts - unlimited from filter - Student

V9.0 (min Base Plugin 1: v9.0.0, min Base 2: v9.0.0)

• No longer need separate data plugins for contacts vs legacy. This version works for both.
• Add wildcards/brightarrowCustom/baParentLang.txt for custom parent/guardian language fields. Used instead of repeating language setup many times and reduces the need for custom data.html page if the only change is language
• Add wildcards/brightarrowCustom/baStudentLang.txt for custom student language fields. Most schools do not send students messages in any language other than english, but previous data plugins used the parent language as the student language
• data.html pages respect the language wildcards. Will now easily switch parents from legacy to contacts without needing a plugin change. Will also respect student change from legacy to contacts if necessary
• PQs updated to respect enable/disable settings
• New optional PQ for student exports from contacts (rather than parent/guardian exports from contacts)
• Updated staff PQ with emergency contact field information

V8.0

• Update for contacts users to respond to filter changes.

V7.4 & 6.5

• Update data plugins so that PowerTeacher search works more before/after section start/end dates.

V7.1

• Fix for contacts - calculates phone sort order instead of using PowerSchool’s field

V7.0

• Initial release for use with PowerSchool Contacts module

V6.4

• Changes staff to have 1 row per userid instead of 1 row per userid per schoolid

V6.3