Difference between revisions of "Customization"

From California PowerSchool User Group
Jump to: navigation, search
(Test Score Display (BETA))
(PSUG MEA Resources)
 
(16 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
*[[PSCB Customizations|PSCB Customizations and Custom Reports Page]]
 
*[[PSCB Customizations|PSCB Customizations and Custom Reports Page]]
  
=== sqlStudio ===
+
=== SQL Studio ===
*[https://auroraedtech.com/plugins-all/subscription/sql-studio sqlStudio] - by Adam Larsen at Aurora Educational Technology. It is the only query development environment that is embedded entirely within PowerSchool.  It does not require VPN connections, special Oracle passwords, or ODBC drivers.  It is also available for both local and hosted installations of PowerSchool. Free with premium features available with a paid subscription.
+
*[https://auroraedtech.com/plugins-all/subscription/sql-studio SQL Studio] - by Adam Larsen at Aurora Educational Technology. It is the only query development environment that is embedded entirely within PowerSchool.  It does not require VPN connections, special Oracle passwords, or ODBC drivers.  It is also available for both local and hosted installations of PowerSchool. Free with premium features available with a paid subscription.
  
=== PSUG ME Resources ===
+
=== PSUG MEA Resources ===
*[[Media:Customization 1 - Intro.pdf|Customization 1 - Intro.pdf]] - Presentation slides in PDF format
+
*[https://drive.google.com/drive/folders/14HZSD-Bka92tWGm446tr5aimpJqSeJkI?usp=sharing PSUG MEA 2022 Shared Folder] - PSUG MEA 2022 Shared Folder for presenter Roger Sprik
*[[Media:Customization 1 - Intro Handout.pdf|Customization 1 - Intro Handout.pdf]] - Handout in PDF format
 
*[[Media:Customization 2 - Coding Basics in PowerSchool.pdf|Customization 2 - Coding Basics in PowerSchool.pdf]]
 
*[[Media:Customization 3 - jQuery and Page Fragments.pdf|Customization 3 - jQuery and Page Fragments.pdf]]
 
*[[Media:Customization 5 - SQL and using sqlReports.pdf|Customization 5 - SQL and using sqlReports.pdf]]
 
*[https://goo.gl/zaih5z PSUG ME Shared Folder] - Files from Customization 6 - Beyond 1 to 1
 
  
 
=== Hide Student Contacts ===
 
=== Hide Student Contacts ===
 
This plugin will hide the new Student Contacts feature released in version 12. It allows for selective enabling of contacts based on group security. Useful to give yourself time to prepare before allowing your users to interact with the new feature.
 
This plugin will hide the new Student Contacts feature released in version 12. It allows for selective enabling of contacts based on group security. Useful to give yourself time to prepare before allowing your users to interact with the new feature.
  
Version 1.7 fixes bug introduced in PS v19.11
+
Version 2.0 is now compatible with the new experience Start page in PS 20.4+
 +
*[[Media:Hidecontacts 2.0.zip|Hidecontacts 2.0.zip]]
 +
*[[Media:Hide Contacts Plugin ReadMe 2.0.pdf|Hide Contacts Plugin ReadMe 2.0.pdf]] - Documentation for Hide Contacts Plugin
 +
 
 +
Version 1.7 fixes bug introduced in PS v19.11 (USE VERSION 2.0 above for PS versions 20.4 and higher)
 
*[[Media:Hidecontacts 1.7.zip|Hidecontacts 1.7.zip]]
 
*[[Media:Hidecontacts 1.7.zip|Hidecontacts 1.7.zip]]
 
*[[Media:Hide Contacts Plugin ReadMe 1.7.pdf|Hide Contacts Plugin ReadMe 1.7.pdf]] - Documentation for Hide Contacts Plugin
 
*[[Media:Hide Contacts Plugin ReadMe 1.7.pdf|Hide Contacts Plugin ReadMe 1.7.pdf]] - Documentation for Hide Contacts Plugin
Line 37: Line 36:
 
*[[Bell Schedule Header]]
 
*[[Bell Schedule Header]]
  
===Test Score Display (BETA)===
+
===Test Score Display ===
 
This plugin creates a configurable and more readable test score display screen to supplement the existing one.
 
This plugin creates a configurable and more readable test score display screen to supplement the existing one.
*[[Media:test_score_display_1_0_1.zip|test_score_display_1_0_1.zip]]
+
* TSD is now a part of ACME and the latest version can be found at [https://easyregpro.com/acme.php ACME Projects Page]
*[[Media:Test score display 1_1b.zip|test_score_display_1_1b.zip]] - Adds option to sort test by reverse date (newest to oldest)
 
*[[Media:Test score display 1.2.zip|Test Score Display 1.2.zip]] - Fixes blank test name problem
 
*[[Media:Test score display 1.3.zip|Test Score Display 1.3.zip]] - Adds option to suppress test sections with no scores
 
*[[Media:Test score display 1.4.zipTest Score Display 1.4.zip]] - Fixes incompatibility with PS 19.11. Changes the Angular bootstrap.
 
  
 
===Individual Discipline Summary===
 
===Individual Discipline Summary===
Line 66: Line 61:
 
Adds "Prev Week" and "Next Week" buttons to the Enter Attendance screen. NOT TESTED RECENTLY. This is provided "AS IS". It is not a plugin, file must be unzipped and uploaded manually via CPM.
 
Adds "Prev Week" and "Next Week" buttons to the Enter Attendance screen. NOT TESTED RECENTLY. This is provided "AS IS". It is not a plugin, file must be unzipped and uploaded manually via CPM.
 
* [[Media:EnterAttendancePrevNext.zip|meeting.PrevNext.content.footer.txt]] - This is a zip file, must be unzipped before uploading. It is NOT a plugin. File must be uploaded to same folder path on your CPM.
 
* [[Media:EnterAttendancePrevNext.zip|meeting.PrevNext.content.footer.txt]] - This is a zip file, must be unzipped before uploading. It is NOT a plugin. File must be uploaded to same folder path on your CPM.
 +
 +
===Sort by First Name for PowerTeacher Attendance===
 +
Adds a toggle button to switch been first name format and sorting and back to the default Last, First format and sorting to the screen where teachers take attendance. Helpful if using an online learning tool like Zoom where the default sort is by First name. The change is "sticky", it will remember the teacher's sort preference. Only for the single day attendance screen.
 +
* [[Media:AttendanceSort 2.0.zip|AttendanceSort_2.0.zip]] - Compatible with PS 20.4.3+ and the new "Group by Track" feature
 +
 +
===Fill Attendance Code for PowerTeacher Attendance===
 +
'''ONLY FOR VERSIONS PRIOR TO 20.4.3'''. Adds a "Fill Code" button next to the attendance code selector to allow the teacher to quickly fill in all blank attendance boxes. Will only fill blanks... so for example, the teacher can mark absences, then use "Fill Code" to complete the rest of the attendance codes with a present code. Useful if the district has to use "positive attendance" where a blank for present is not allowed. Beginning with 20.4.3, PowerSchool added a Fill Code button that is featured when the teacher enables "Group by Track". This customization is NOT intended to be used with versions 20.4.3 and higher.
 +
* [[Media:AttendanceFill 1.0.zip|AttendanceFill_1.0.zip]]
  
 
== Database Extensions, Fragments, and Plugins ==
 
== Database Extensions, Fragments, and Plugins ==

Latest revision as of 18:17, 4 March 2022

General

PSCB Customizations

PSCB Customizations is a collection of newly developed pages, reports and updates/enhancements to plugins previously posted on PowerData Solutions. This ongoing project is the result of the collaborative efforts of Rob Staats, Manjit Basra and Michael Moore. Each member of the PSCB Development team has 15+ year experience in developing PowerSchool custom pages and reports.

SQL Studio

  • SQL Studio - by Adam Larsen at Aurora Educational Technology. It is the only query development environment that is embedded entirely within PowerSchool. It does not require VPN connections, special Oracle passwords, or ODBC drivers. It is also available for both local and hosted installations of PowerSchool. Free with premium features available with a paid subscription.

PSUG MEA Resources

Hide Student Contacts

This plugin will hide the new Student Contacts feature released in version 12. It allows for selective enabling of contacts based on group security. Useful to give yourself time to prepare before allowing your users to interact with the new feature.

Version 2.0 is now compatible with the new experience Start page in PS 20.4+

Version 1.7 fixes bug introduced in PS v19.11 (USE VERSION 2.0 above for PS versions 20.4 and higher)

Codeset Manager

  • Codeset Manager 1.3 - Codeset manager by Jim Parsons. Warning! - modifying codesets comes with a certain risk of modifying or deleting codes that are in use. Please use carefully!

San Diego Unified - District Student Search Customization Presentation

Enhanced Parent Portal

NOTE!!! EPP may not be working with the latest versions of PowerSchool. The Enhanced Parent Portal (EPP) is a popular add-on to PowerSchool to enhance the Student/Parent Portal with additional pages and give you the control of hiding/showing any of the existing or custom pages.

Bell Schedule Header

This plugin adds the current day's schedule name to the header of all the portals, with a link to a popup with period details.

Test Score Display

This plugin creates a configurable and more readable test score display screen to supplement the existing one.

Individual Discipline Summary

Copied from PSUG Yahoo Groups National Files - legacy 2006, but still works
An adaptation of a Reporting Engine Discipline report. It includes instructions on how to add a link to a PS screen so as to provide the studentid automatically. The result is a report showing only discipline logs within a user defined data range for the individual student. Included is the entry date, sub-type, Subject, Detail (Entry) and Consequence for each discipline log entry. Definitely provided "as is", your mileage may vary.

PowerScheduler Teacher Assignments Display

We created this to provide a paperless means of communicating to teachers their future teaching assignments based on the data in PowerScheduler. Includes control school-by-school of whether or not to display the assignments and display custom messages for both enabled and disabled states. This is a plugin, use Plugin Management Configuration to install the zip. You'll find the settings under School - (Scheduling) - Preferences. Posted by Roger.

Add Reset Class Counts to Special Functions

If the section class counts are incorrect, the only solution is to have someone with the correct access run the "Reset Class Counts" operation from the System - Special Operations page. This customization creates a custom page containing ONLY the Reset Class Counts function, and a page fragment adds the link to this new page to the Special Functions screen. Add both of the files below to the admin folder in your custom webroot or CPM.

  • PowerSource Download 449 - This is a link to PowerSource for the custom page itself, posted by Linda Brock
  • functions.resetclasscount.content.footer.txt - This is the fragment that will add a link to "Special Functions" and update the "striping" to preserve the alternating row colors. Because MediaWiki does not allow "txt" uploads, this is a zip file that must first be unzipped before being uploaded. It is NOT a plugin.

Enter Attendance Prev5

Adds a link right after "Enter Attendance" with the start date as 5 days ago and the end date as 1 day ago, for the purpose of modifying prior days attendance. Our secretary is often working with prior week's attendance on Monday, for example. This makes it easier to get to the prior dates very quickly. Upload this fragment via CPM to the admin/students/ directory.

Enter Attendance Previous/Next Week Buttons

Adds "Prev Week" and "Next Week" buttons to the Enter Attendance screen. NOT TESTED RECENTLY. This is provided "AS IS". It is not a plugin, file must be unzipped and uploaded manually via CPM.

Sort by First Name for PowerTeacher Attendance

Adds a toggle button to switch been first name format and sorting and back to the default Last, First format and sorting to the screen where teachers take attendance. Helpful if using an online learning tool like Zoom where the default sort is by First name. The change is "sticky", it will remember the teacher's sort preference. Only for the single day attendance screen.

Fill Attendance Code for PowerTeacher Attendance

ONLY FOR VERSIONS PRIOR TO 20.4.3. Adds a "Fill Code" button next to the attendance code selector to allow the teacher to quickly fill in all blank attendance boxes. Will only fill blanks... so for example, the teacher can mark absences, then use "Fill Code" to complete the rest of the attendance codes with a present code. Useful if the district has to use "positive attendance" where a blank for present is not allowed. Beginning with 20.4.3, PowerSchool added a Fill Code button that is featured when the teacher enables "Group by Track". This customization is NOT intended to be used with versions 20.4.3 and higher.

Database Extensions, Fragments, and Plugins

User created guide

Building a Plugin from Start to Finish

An example (Vehicle Tracking) of using Database Extensions, Fragments, and building it all into a plugin.

Test Server Modifications

Changing Logos and Colors on a Test Server

For your test server, you may want to change the color scheme as an indicator that you are using a test server vs. using the production server. You can also change the displayed name from “PowerSchool” to something else. This PDF documents how to do this. See also the "Sample SVG Files" posted below.

Sample SVG Files

These files are related to the "Changing Logos and Colors on a Test Server" above. These are sample SVG files for replacing the "PowerSchool" name logo with "PlaySchool". These are named "playschool" intentionally. For them to work on your server, they need to be renamed to:
/images/img/powerschool.svg
/images/img/powerschool-white.svg

Test Server Watermark

Adds a green "Monkey Wrench" background watermark to your test server. This is a plugin, install through System - System Settings - Plugin Management

Angular and GridWidget

  • birthdays_2_0.zip - A sample plugin showcasing the Angular Grid Widget with Tile Carousel (does not use PowerQueries)

Additional Links