Custom Reports Bundle 3.4.4

Version 4.0 is out and is modular and built for PowerSchool 7.9 and above. If you are looking for the reports bundle go here unless you are on PowerSchool 7.8 or older. This version will remain open only for users who absolutely need these reports and are on an older version of PowerSchool. If you can wait we recommend you do wait and install after upgrading PowerSchool to at least 7.9

3.4.4 (5/8/2013)

  • Various report fixes where current selection is used.

3.4.3 (2/23/2013)

  • Bug Fix: Fixed sqlReports accordion
  • Adjusted reports that use current selection to use method that handles over 1,000 students.

3.4.2 (5/16/2012)

  • New Report: Sub Finder - Find teachers that PowerSchool thinks are free to cover a selected staff member.
  • Bug Fix: Projected Enrollment - Issue where counts were off when viewed from District Office.
  • Bug Fix: Grades Dashboard - Removed extra submit button.
  • New Feature: Consecutive Days - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
  • New Feature: Attendance Frequency Search - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
  • New Feature: Student Attendance List - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
  • New Feature: Exit/Entry Report - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
  • New Feature: Search Grades & Attendance - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
  • New Feature: Address Issues - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
  • New Feature: Phone Number Search - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
  • New Feature: Birthday List - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
  • New Feature: Youngest Child - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
  • New Feature: Student Free - Added Make/Add Current Students to current selection. PS 7.0.3+ Required
  • New Feature: Bus Search - Added Make/Add Current Students to current selection. PS 7.0.3+ Required

Patch 3.4.1a (4/11/2012)
This patch is just a update to 3.4.1. CRB 3.4.1 must be installed first then this patch on top.

  • New Report: CPM Files/Folders - Lists all the active custom files in Custom Page Management (CPM).
  • Bug Fix: Student Attendance List - Widened the date entry boxes.
  • Bug Fix: Monthly Attendance Review - Changed the date code used in the SQL query.
  • Bug Fix: Projected Enrollment - When run from a school, the school can only see current, outgoing and incoming students.
  • Bug Fix: Log Entry Search - Students without a Discipline_ActionTaken were not listed on the report. This has been resolved.
  • Bug Fix: Instruction Time - Sections that were not full year were showing higher hours. This has been resolved.

Changes in version 3.4.1 (4/6/2012)

  • Report Update: Phone Number Search updated to look at more stock phone number fields and report format is updated. (doctor_phone, emerg_phone_1, and emerg_phone_2)
  • Performance Fix: Student Attendance List performance should be improved
  • Bug Fix: Fixed Bad Entry Dates. Results will now show.
  • Bug Fix: Fixed Projected Enrollment. Results will now show.
  • Bug Fix: Updated Student Request Letters text wrapping.
  • Bug Fix: Fixed issue where table tools and sorting would not work after running reports.
  • Bug Fix: Fixed issue where popups on Exit/Entry, Consecutive days and Gradebook vs Stored would not work.
  • UI Fix: Updated parameter box to be wider.
  • New Report: Instruction Time. Shows how many hours/minutes a section meets based on the calendar setup.

About:
The Custom Reports Bundle is a collection of custom html reports and dashboards for PowerSchool. The content in this bundle has been contributed by several members of the PowerSchool customization community. The bundle also includes the Custom SQL Reports customization created by Dean Dahlvang.

Features:
The 3.x release of the Custom Reports Bundle has many great new features.

  • New PS7 compatible layout on all reports
  • Report data is retrieved with AJAX. No more page refreshes to get results.
  • Most reports are now printable and sortable
  • Some reports are exportable to PDF and CSV
  • Performance improvements to underlying report queries.
  • Improved UI for report parameters

Known Issues:
Several reports are still undergoing a transition to the new layout. As a result some are not working.
Broken Reports

  • Schedule Course Demographics (/admin/reports/schedule/coursedemographics.html)
  • Sections with no room Assigned(/admin/reports/schedule/SectionnoRoom.html)
  • NY State Reports

Install Instructions - Custom Page Management:

To upload an entire zip you’ll have to be on PowerSchool 7. Then the steps are as follows:

Switch to District Office.
Use one of the 2 methods below to get to the import/export screen. I would click the export button on the screen listed below to make a backup of your current customizations so you have a backup copy.
A. PS Administrator->Custom Pages->Import/Export
B. District->Localization Administration->Import/Export Customizations
Export the current customizations as a backup.
After you have done that, click browse and select the PDS (or other customization) zip and then click import.

NOTE - The following steps will need to be done if using CPM, because of a bug in PowerSchool, to enable all the bundle features.
1. In CPM navigate to \scripts\tabletools\ click Add then Create Folder with the name swf, if it doesn't already exist.
2. Upload copy_cvs_xls_pdf.swf and copy_cvs_xls.swf from the \scripts\tabletools\swf folder from the unzipped download.
3. navigate to \images\css\theme\crm-css\ click Add then Create Folder with the name images, if it doesn't already exist.
4. Upload all the files from the \images\css\theme\crm-css\images folder from the unzipped download.

Install Instructions - Custom Webroot:
Unzip the downloaded file and place the included files in the same folder structure that exists in the zip in your data\custom\webroot folder.

Customization:

Contributor: 
Jason Treadwell
Brent Johnson
Brian Andle
Tim Scoff
Matt Freund
Roger Sprik
Michael Moore
Dean Dahlvang
Plugin: 
N
CPM Import Friendly: 
Y

Comments

No, there isn't a list. But you could take the version you installed, unzip it and it'll show you all the files it installed. I can give you some hints at things to look for:

1. Anything in the /admin/dashboards folder as that entire folder was created by CRB
2. /admin/reports/[folder that isn't crb] -> if it's blue in CPM then it's brand new and likely was added by CRB. I say likely in that it's possible you or someone you work with added a file in there. The nice part about CRB is that it was easy to add new reports to it.

I will re-enable the link for this old version. However if you didn't have this exact version installed you may have a slightly different list. For the most part this is the list of files though.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

How can I uninstall this? Is that possible?

That depends on how you installed it in the first place. Was it custom/web_root or CPM? If it was CPM you'll need to log into CPM and delete all the files you find in the zip folder (you can re-download if you no longer have that zip). If you're only uninstalling so you can upgrade to the new version you only need to remove the reporttabs.html file. The rest are good to clean up but shouldn't stop you from upgrading.

If you installed via custom/web_root simply go in and remove the files from their current location. You can see the files you're looking for by downloading this version and uncompressing the zip file. That will show you all the files in the folder structure. Follow that same structure in your custom/web_root and remove the corresponding files. Again, this isn't necessary to upgrade but it is a good practice to clean up your custom/web_root a little. The only necessary one to remove for upgrading is /admin/reports/reporttabs.html

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

Schools with Rotating Days (A/B) scores are being combined by the period/teacher. Can this be broken out by Day? or add an additional parameter to choose the day?

Example: Teacher A is teaching Geometry 1(A) and Algebra Honors on 1(B) day. On the dashboard Period 1 is combining all scores for both days/classes into one average.

We Appreciate ALL you do and provide. Any assistance is appreciated.

Since I've updated to PS 8, I've noticed a problem with the student course request report. On the print outs, page 3 is narrowed by about 3% width. Page 4 is an additional 3%( relative to page 1) narrower, and it keeps shrinking every subsequent page. I've tried IE and Safari and they seem to be fine, I just do everything in Firefox so hoping it's something simple to fix.
Is there hope for CRB 4 updates to the schedule reports?

When I am adding the info we want on our “student course request report” that we are using to mass print the rising 9th grader options, it is coming out on 2 pages (with the 2nd page blank)… I REALLY want it on one page if possible…I have tried it in Mozilla and in Chrome….any suggestions?

Since there aren’t any 8th graders with requests out there, I just try it with my own child, Michael Navel, and I finally got it to fit on one page (at 90%) but the second page still comes out…?

Any thoughts would be appreciated! Thanks.

I have two "Custom Reports" Tabs showing on my reports page. Any suggestions for troubleshooting this issue? From what I can see, I have the reporttabs.crb.report.tab.txt in the reports file, not in the CRB file. Is this correct? I cannot see this duplicated anywhere else.

I cannot install. I get this: Plugin file contains an unrecognized file: admin/dashboards/attcntdashboard/attcount.xml

Andrew Ayers

Pages

Subscribe to Comments for "Custom Reports Bundle 3.4.4"