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

Got it - I think. I did not add the scripts and css pages.

Marie Prescott

I have uploaded all the files as per the documentation and am still receiving the message - waiting for report parameters after I have entered dates. When I hit submit - it takes me back to the calendar. Do you have any suggestions as to what am I missing? Thanks.

Marie Prescott

I cannot log out of custom reports setup mode - am I missing a logout button or should the submit button take me back to home?

Marie Prescott

Where did the dashboards in this customization come from/Who designed them?

I've got several that are quite simply pulling incorrect data. I'm guessing our school setup differs from other schools? Ones I noticed right off:
Attendance Count - for past 3 years shows 100% attendance, even though I can verify this is incorrect. (If I go back to 10-11, the single-year dashboard works properly, but the 3-year one still does not)
Student Day List on Attendance Dashboard shows nothing, even though other dashboards like Attendance Distribution do show attendance counts.
Grade Distribution - no data no matter what store codes I use
Single Sign On - we are not using this, yet it shows log ins. My guess is it pulls staff log ins, but then this is very misleading and at our schools that DO use SSO, this will be confusing/incorrect.

Where can I get information about what these dashboards are supposed to show, so I can accurately troubleshoot these for our school districts?

Gina Ciprotti
SIS Administrator
Accel Schools

Jason T I believe made all the dashboards in the bundle.

Attendance Count. This dashboard works using Daily Attendance. If you aren't using Daily Attendance the numbers won't work. We'll look into hiding this dashboard if meeting isn't used at the school in question. The reason they show 100% is because there are no daily attendance codes to subtract from the students membership.

Student Day List - See above.

Grades Distribution - Did you make sure to enter the stored grade bins in the following format? 'T1',T2'

The 'Stored Code','Stored Code 2', 'Stored Code 3' format is required for Oracle.

Attendance Count - Why is the single-year different from the multiple-years? If I switch and go back to 2010-11 school year in PS - May 2011 shows 95.66% attendance on the "Attendance Percent by Month", but in both 10-11 and 11-12, the "Attendance Percent by Month for Last 3 Years" for May 2011 shows 100%.

Edit - Also, the Student Day List seems to work on my school that ONLY has daily, but my school that has both it doesn't. Is that working as expected? Because the school that has both WOULD have daily records.

The Grades Distribution - I tried just using one store code like Q1 or multiples like you showed above and still nothing came up. Where should I start looking for why?

It's a bit time-consuming to implement all the images into CPM, so I'm testing this on one of our servers before I copy it to all 35. I want to work out any bugs we'll be running into.

Gina Ciprotti
SIS Administrator
Accel Schools

The dashboard would only show daily attendance records that are created by the bridge period. If you are using meeting to day and after x periods they are present then the dash won't work for you as intended.

If you are defining a single bin then in would be entered like 'Q1' with the apostrophes

I figured out the grade distribution. I forgot the particular district I was in uses a different storecode than the term name. It's G1 (grading period 1) instead of Q1. I do get two submit buttons on that screen and not sure what the difference is.

As for attendance and the Student Day List report
School Preferences are Daily as the default. Meeting and Daily both checked. FTE is Daily/code-to-day and conversions are setup for those codes. Period 1 is the bridge period, but most of their attendance is entered straight into daily by an overseeing staff member.

Gina Ciprotti
SIS Administrator
Accel Schools

The only one that works for me is the Print. I'm using a Mac with Safari and Firefox. I saw a previous post with the command line change from sData=$.trim(sData) to sData=jQuery.trim(sData) but that was already in the system. Any ideas? Thanks

Make sure that you have uploaded the SWF files as indicated in the install instructions above if you are using CPM.

Thank you. I only had one of the files uploaded. It works.

I currently have the Custom Reports Bundle 3.3.0 installed. Can I simply copy and replace all of the files on the custom side with the 3.4.1 version? And if I do so, will I still have all of the custom SQL reports that I've added?

Yes and Yes

What is the best way to change what is considered "passing grades" for the following report: Teacher Pass Rate Dashboard

Some of our classes use different grading scales. Is it using whether or not the student received credit for that grade? We typically do not assign credit to classes that do not actually receive High school credit towards graduation. Do we need to do so in order for that report to work or is there a work around?

Gina Ciprotti
SIS Administrator
Accel Schools

I'm having trouble with this report since I upgraded the newest Custom Report Bundle...I hit submit and absolutely nothing...any suggestions?

Chris Hay

Use a browser other then IE.

Guys, First off, thanks a million for the work that was put into this report bundle. I really appreciate the talent and effort that went into making such a quality product.

I am, however, having a problem with SQL reports. After I create a new report, the category shows on the SQL report list, but nowhere do I see the report itself. Maybe just a bit of clarification is needed, or maybe my installation is somehow corrupt, but I cannot for the life of me figure out how to "run" the report.

Please shed some light on this for me.

Thanks.

benjamin solomon
district technology director
a.w.brown-fellowship leadership academy
dallas, tx 75237

Make sure you are running the newest version of the bundle because there were some issues a few versions ago. Also I believe you can collpase the group to hide the reports, you might want to check that as well.

Thanks Brian. I think I have the latest version of the bundle (3.4.1). Maybe I should reinstall the files. I may have missed something. Am I correct in thinking that I must only place all the files in the proper folders on the server?

brs

benjamin solomon
district technology director
a.w.brown-fellowship leadership academy
dallas, tx 75237

Still not showing up. Here is a link to the screen shot.
http://www.awbrown.org/pics/screenshot.png

Hovering over the category displays a link to http://ps.awbrown.org/admin/reports/customsqlreports.html#

Note: Nothing after the hash mark

Help...

benjamin solomon
district technology director
a.w.brown-fellowship leadership academy
dallas, tx 75237

We have been having the same problem for a couple of weeks now. I just updated the server to 7.1.4 and re-imported the Custom Report Bundle and the patch, hoping it would solve the problem, but unfortunately it hasn't.

I'm not sure if it's related, but on the custom reports tab, we are just getting the spinning icon, and the reports are not showing either.

Any suggestions? Thank you.

Hagelk, I believe your issue is related to the images and scripts from the download not being installed on your image server.

I'm having the same issue. This is on 7.1.4 on a development system. It doesn't have a separate image server.

Yes, that was it. I looked at the pages in Chrome Developer Tools and realized it wasn't seeing the custom jquery and other files. As soon as I moved put all the files on the image server, everything seems to be working again. Thank you.

Okay, I have tried everything I know how to do. I have made sure I am running the latest version of the bundle (3.4.1), I have replaced the customsqlreports.html file, I have even attempted to checkout the code to determine why I can't see reports. I understand that the html file creates a list of, what I believe to be, a JSON formatted pairs ("dcid":"~(reportdcid)"), but I do not have a clue where (or how) the reports themselves ever get displayed. Of course, if we cannot see them, we cannot run them.

Any further help would be appreciated.

Ben

benjamin solomon
district technology director
a.w.brown-fellowship leadership academy
dallas, tx 75237

When you added the newest version did you add all the files onto the server, like \admin\includes. Also have you tried a different browser?

Everything from the zip file has been installed, to includes files within admin/includes/templates. Is there a way to run the sql report manually? I am in desperate need of a Perfect Attendance report using a specific query that I can put on a menu for our registrar. We have a particular way of calculating what we call "Perfect Attendance" that requires students to not have any unexcused absences, and less than 3 tardies or early releases for the entire school year.

I have the query if anyone is interested. The end of the school year is here, and I have been beat up for not having something available for the registrar.

Thanks a million.
Ben

benjamin solomon
district technology director
a.w.brown-fellowship leadership academy
dallas, tx 75237

Has anyone come up with a solution for this problem? I still cannot see any sqlreports listed after their creation. Help

benjamin solomon
district technology director
a.w.brown-fellowship leadership academy
dallas, tx 75237

After racking my brain for a while I think I know what might be going on. Did you name or title a report with a " in it?

You can search the gen table for the following and it should return the record causing the issue.

cat=SQLREPORTS

Look for a a record with name or value with a " in it. If there is one use DDE to remove the "'s.

I can confirm that a " in the title or report name will break sqlReports, finding the record and removing the " will fix the reports not showing issue. This will be corrected in the new version.

Thanks Brian. I did have a " or 2 in a record or two. It seems that a previous install of a Phoenix version of SQLReports had many records already existing in the GEN table. Once I removed those records, it was not an issue at all.

Thanks again. You guys are great.

benjamin solomon
district technology director
a.w.brown-fellowship leadership academy
dallas, tx 75237

I am not sure if any of this makes sense, Brian, but when I run the log entry report on my IMAC - stand alone computer, it works - I am able to copy to excel and print a report. However, on my laptop and our administrator's lap top - the report "sticks" on waiting for report parameters and when hitting submit - goes back to the calendar. Please let me know if there is something different that I need to be doing - pulling for a different area? Thanks!

Marie Prescott

Try clearing the browser cache. Also make sure that the scripts/images from the download made it on to the server.

Any chance of getting the Teacher Portal "Monthly Attendance Review" updated to v7??

Julie Payne
Falmouth Public Schools

I installed the bundle through CPM as my first-ever customization, but when I turn on customizations, I get the old PS interface (we're on 7). The reports show up fine, but everything else doesn't. Any guesses?

It sounds like while you imported the data into CPM, CPM isn't actually turned on. You'll need to go into PS Administrator and enable Custom Page Management then click submit on the enabled customization screen.

Thanks Brian, but that was the first thing I checked. The customized pages show up, it's just everything else rolls back to an old version. Could this happen is someone had copied the tree structure into the webroot at some earlier date, even though we've never used customtizations up to this point?

It could. You might want to remove/move the \admin\reports folder/files from the old web_root to your desktop to see if that clears the issue up.

I emptied the custom\webroot entirely, and it's fixed. Thanks.

Wondering if there is a quick way to add coding to this report that would allow us to search for a blank. Currently, it allows us to search for marks that are in the grade scale.

I LOVE the Log Entry Search Report! It pulls almost EVERYTHING that we need. I would like to add ethnicity, gender and duration to the report. What do I need to do to make it work for me? Any help is appreciated! Thanks

This report is exactly what I need, but there is not a link at the bottom of the results that allows me to make those students the current selection, like some of the other reports do. I want to send letters to those students to warn them about consequences if further absences occur.

Is there something I can do to keep these students selected?

Thanks.

Patti

Hello. I am working on a customization for the attendance frequency report to add a button to allow the teachers to take the students form the report and make them the selected group. I reviewed the code from attFrequencySearch.html and altered the section that does this to match our school boards version of this report. Here is what I came up with:

a class="button" href="/admin/studentlist/functions.html?ac=buildsel;table=students;list= ~[tlist_sql; SELECT DISTINCT s.DCID FROM Attendance att INNER JOIN Students s ON s.ID = att.StudentID INNER JOIN Attendance_Code attc ON att.Attendance_CodeID = attc.ID INNER JOIN CC ON CC.ID = att.CCID INNER JOIN Courses crs ON CC.Course_Number = crs.Course_Number
WHERE att.SchoolID = ~(curschoolid)AND att.Att_Date <= '~[prefschool:attfreqedate]' AND att.Att_Date >= '~[prefschool:attfreqsdate]'
AND att.Att_Mode_Code = 'ATT_ModeMeeting'
AND attc.Att_Code IN (~[prefschool:attcodes])
AND to_char(s.Grade_Level) LIKE CASE WHEN to_char('~[gpv:gr]') is null THEN '%' ELSE to_char('~[gpv:gr]') END
GROUP BY s.DCID, s.LastFirst, s.Grade_Level, crs.Course_Name, CC.Course_Number, CC.Section_Number, CC.Section_Number, CC.ID
HAVING COUNT(att.ID) >= CASE WHEN to_char('~[prefschool:attfreq]') is null THEN 0 ELSE to_number('~[prefschool:attfreq]') END
;]~(sdcid;l),[/tlist_sql]" target="_blank" Make these the active selection of students /a
This works great by the way :).

I have come across an issue where the browser URL character limit is restricting the number of students that will be returned as follows:

IE will return a maximum of 390 students (character limitation of 2048), Firefox will return a maximum of 1428 students (approx 11,000 character limit), Safari will also return a mximum of 1428 students( same character limit as firefox), and Opera will not return any at all(this may be a server issue on our end)

Is there anyway to change this function to get around passing the student ID's through the URL so that the browser limitations will not come into play?

Thanks
Dwayne Joy

my brain is melting

Ok. Im attempting to submit this as a POST method instead of a get Method. spiting each name value pair after the .html? I am running into an issue where the script is collecting the student ID's and passes them forward to the next page and that page will not use them. Instead it just displays apparently random student selections. here is the code I am attempting. can anyone give me some direction?

form action="/admin/studentlist/functions.html?" method="POST" target="_blank"
input type="hidden" name="ac" value="buildsel;table"/
input type="hidden" name="table" value="students"/
input type="hidden" name="list" value="~[tlist_sql; SELECT DISTINCT s.DCID FROM Attendance att INNER JOIN Students s ON s.ID = att.StudentID INNER JOIN Attendance_Code attc ON att.Attendance_CodeID = attc.ID INNER JOIN CC ON CC.ID = att.CCID INNER JOIN Courses crs ON CC.Course_Number = crs.Course_Number
WHERE att.SchoolID = ~(curschoolid)AND att.Att_Date <= '~[prefschool:attfreqedate]' AND att.Att_Date >= '~[prefschool:attfreqsdate]'
AND att.Att_Mode_Code = 'ATT_ModeMeeting'
AND attc.Att_Code IN (~[prefschool:attcodes])
AND s.Enroll_Status = 0
AND to_char(s.Grade_Level) LIKE CASE WHEN to_char('~[gpv:gr]') is null THEN '%' ELSE to_char('~[gpv:gr]') END
GROUP BY s.DCID, s.LastFirst, s.Grade_Level, crs.Course_Name, CC.Course_Number, CC.Section_Number, CC.Section_Number, CC.ID
HAVING COUNT(att.ID) >= CASE WHEN to_char('~[prefschool:attfreq]') is null THEN 0 ELSE to_number('~[prefschool:attfreq]') END
;]~(sdcid;l),[/tlist_sql]"/
input class="button" type="submit" value="Make these the active selection of Students"/

my brain is melting

I would like to use the User Login Report to view if the parents have logged in to the portal in a specified time frame. The report is nice but it only seems to flag the students who are the first student a parent may have in their portal. For example, I have 3 children registered in my parent account, X, Y & Z. Since X is the first child that appears after logging in, that student and login times will appear on the report. When I am actually spending more time looking at child Y's grades and attendance, that student does not register in the list of students who have logged in on that date in the report. The login times do appear under 'Net Access' for that student though. How can we get the report to show the times for all the children registered to a parent, not just the first one?

The user login report to view when parents have logged into the portal has a big bug in it to render it useless to us. The report only shows the logs for the first child that comes up when the parent logs in. If the parent views another child, that is not shown in the report but it does appear under 'Net Access'. This report would be great if it actually worked...having solid proof of when parents are viewing their child's grades and attendance and for how long would eliminate us having to send a paper home for a signature from the parent assuring us they had viewed the grades online.

Anyone know how to set the permissions for groups to see different tabs under the Custom Reports? I am trying to get my principal group to see the Validation tab. Any help would be appreciated here or sent to jlsehorn@enidk12.org

Are you trying to get just the validation tab to show for the principal group or just the group to show up at all? There isn't a way to hide a tab from a user group currently and all tabs should show up for all users.

Yes just for that group. I am in administrator group and I get all tabs. When principal or secretary group logs in they dont see the validation tab.

Pages

Subscribe to Comments for "Custom Reports Bundle 3.4.4"