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

Since our upgrade to 7/5, the Teacher Free report seems to not be pulling all free sections. It appears it may only be pulling year long classes. Anyone else see this issue?

Since our upgrade to 7/5, the Teacher Free report seems to not be pulling all free sections. It appears it may only be pulling year long classes. Anyone else see this issue?

I tried to edit an existing custom report by adding ~(schoolname) to the heading. As soon as I submit it the report goes away.... Is there anyway to add a variable to the report heading? Thank you.

I am having trouble getting my sql reports to give me a current selection.
this is the query
SELECT DISTINCT s.DCID FROM students s, HonorRoll h where s.id = h.studentid AND h.storecode = (%param1%) AND h.yearid = ~(curyearid) AND h.method = %param2% AND s.schoolid = ~(curschoolid);

any help would be greatly appreciated!!!!

Max Bowie
Data Applications Specialist
Colonial Beach Schools
Colonial Beach, VA

Have you looked at the Yahoo tech group PSUG? There is a thread that has a discussion about SQL Reports and current selection. It is titled: Re: New Report Bundle 3.3.2. The link is: http://tech.groups.yahoo.com/group/PSUG/message/113315. Maybe that thread will give you an idea.

Jose

under Live Scheduling, Student Free doesn't work in Chrome.

Student Free does work in FireFox.

Thanks for any help,

Mark Hartung
Grant Wood AEA

The Grade Detail Verification Information Report is not displaying data in our District's schools. The file name is verificationDetail.html. The label for this report in the Custom Reports tab is Verification Detail Information. I have run the results tlist_tsql query in Oracle SQL Developer and I get data. Has anyone else seen and solved this problem? Would love to have some assistance in what is preventing the data from displaying on the page.

Thanks in advance,
Jose.

I would like to add date fields to this report. Our middle school runs this report during lunch hour homework, so the admin running it needs to be able to put dates in for missing assignments. Is there anyway dates can be added to the criteria? If not, do you guys do custom reports that we could pay for?

Melissa Tront
St Joseph County ISD

I imported the bundle twice but I don't have all of the items that I see on other folks systems. I don't have a create or import on the Custom reports page and I don't have the Validation tab on the Custom Reports. I was hoping someone could give me some suggestion on how to clear everything out and try again.

Thanks

Mike Rackler
Technology Director
Portales Municipal Schools
Portales, NM 88130
mrackler@portalesschools.com

Over the Christmas break, we upgraded to the latest version of PowerSchool, 7.6.0.1. We have now discovered that we cannot open any of the categories we developed which contain all of our SQL reports. At times, some may open but mostly they will not display the reports contained within the category selection. Is there a fix for this???

I'm having the same issue, they will open when you first go to SQL reports but after that the categories
will not open.

I have the same issue here as well. I can't access some of my reports that are in another category, and I desperately need them! Does anyone know a workaround to access the other categories?

I am not getting any results when I run the missing grades report in the custom bundle. Maybe I'm not doing something correctly or don't have something installed. Any thoughts?

Janet
Elk City Schools

I like this report but I had to take a lot of the code out to show a course request that an administrator put in. So by taking out the course that requested the recommendation out I got all requests. Is this something that is possible to show both or just one or the other.

the link for the student leads you to the incident page it needs to lead to the course recommendation page.

if you need the new code let me know

Jon

Good Morning,

We recently upgraded to PS 7.6.0. Our custom report bundle tab has disappeared. Do we need to reinstall?

thank you,
Nancy
nhoffman@sau10.org

Perhaps. I've heard some schools updated to 7.6.0 and CPM was turned on by the update process. That doesn't really make sense but it's happened to a few different servers that I know of. It's possible your CPM was turned on in which case turning it off will fix your issue. That is assuming you weren't using CPM to begin with. This is sporadic and so far once turned off it doesn't turn itself back on in our experience.

If that's not your problem then yes, you probably will need to reinstall. Its possible that your pages weren't put in the custom/web_root and so when you updated the custom pages were overwritten. Ultimately that'll depend on how you put the customization on your server.

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

Hi... I am having the same problem since upgrading to version 7.6.01.
However, it is not consistent. Sometimes, when click on the categories then show reports under it, while most of the computers especially Macs, it does not display any reports.

I believe the issue is with the accordion class ... this line ' div class="accordion" '
to solve the current issue, I have changed it to ' div class="box-round" ' to permanently display the reports

...Vinit

Vinit Pathela

I am unable to edit existing SQL reports and unable to create new SQL reports. When I try to edit one, I get a HTTP Status 500 error. I have had this problem for about a week or two since upgrading to PS 7.6

Jeremy Roper
Independence School District
Independence, MO
Jeremy_Roper@isdschools.org

I'm following the CPM directions and I'm stuck on the Please note sections...my files are created, but where do I "upload" the needed files in PS as directed in steps 2 & 4 below? thanks!

2. Upload copy_cvs_xls_pdf.swf and copy_cvs_xls.swf from the \scripts\tabletools\swf folder from the unzipped download.
4. Upload all the files from the \images\css\theme\crm-css\images folder from the unzipped download.

When I click on a "Report Group" name the page appears like it is trying to render the extended list, but it doesn't, all I can see are "titles' of the report groups, it will not allow me to click on the arrow to expand my selection under any of my report groups...any suggestions? Thank you!

The accordian fix posted earlier does seem to work.

Which file do you make the modification in? I am having the same problem. It works in Chrome if you go to custom sql tab and "open in new window." Where am I making the div class=box_round change? Thank you.

Like others, I'm having difficulty with the Custom SQL Reports customization... I've tried reinstalling (via CPM) the latest version, and it is still not working. I'm on PowerSchool 7.6.0.1.

Chris Potter
Data Manager
West Shore Educational Service District

I believe I had this problem before but cannot find how I fixed it. They updated our TEST server (not on an array) with state updates last week. Everything looks OK except for the Admin home page. It looks like the old PS6 home page. I check in CPM against my live server (on an array) and the admin\home.html is blue like it's customized, but it's blank. What am I missing?

**I just "customized" the original admin\home.html and published it. Rebuilt custom page links and it seems to be working. ???? ** Does anybody have an idea of what might be happening or if this really "fixes" the problem? Thank you.

Hi... I am having the same problem since upgrading to version 7.6.01.
However, it is not consistent. Sometimes, when click on the categories then show reports under it, while most of the computers especially Macs, it does not display any reports.

I believe the issue is with the accordion class ... this line ' div class="accordion" '
to solve the current issue, I have changed it to ' div class="box-round" ' to permanently display the reports

...Vinit

Vinit Pathela

Good Morning,

I have successfully installed the report bundle on our test server 7.6.0 using CPM. I installed it on our production server also but I had an older custom report bundle on our production server, and have migrated it over from web root to CPM. Now the older version of the bundle shows up. Should I go through the import process again via CPM. or does the web root files just need to be deleted?
Thanks for the help, this is all very new to me.
thanks,
Nancy
nhoffman@sau10.org

I edited the "MissingAttendance" report to be able to scan multiple days. If you're interested in the report, shoot me an email at acox AT renewschools DOT org. You're welcome to use it, or include it in future releases.

The Make/Add current students to current selection buttons do not work in the bundle. We re running PS v7.6. Is this a known issue?

Hi Dean, thanks for this program. Its great. However, since 7.6 (we think) the report groups will not open to show the reports. We can't see them to run them. It will only the show the reports in the first Report Group. All we see is the report group headings. Clicking on the error just makes the screen bounce. We can't access our custom SQL reports to change the Report Group. We also can't change it in the GEN table because RptGroup is in a custom section of the Gen table.

To correct this, I deleted all our SQL reports out of the GEN table and created them again under one report group.

I'm having the same issue, I'm unable to open the report categories on the SQL reports page. The first category is open when I open the page, but I'm unable to open the other categories and when I click on a different category, the first group closes and won't open up again.

Didn't have this issue before 7.6.1.

Am I supposed to create it?

Johanna Johanson
Rio Rancho Public Schools

I havent had the same errors everyone is mentioning when I upgraded to 7.601

I did add new columns to some of my reports and had CLG add a report for me a couple of weeks ago for attendance.

The only issue I am having is it seems the flash is crashing on my export to excel or csv buttons. I use chrome and my administrators firefox and everything is up to date. Has anyone else run into this?

I loaded the custom reports bundle on my test server. It works very well, but now i cannot get into PowerSchool Administrator - it keeps saying the user name and password are invalid - I have tried several different user/password combinations that work just fine in production.

Forget this - problem resolved!

Johanna Johanson
Rio Rancho Public Schools

I'm not sure if anyone is still developing for the bundle but the student attendance list is really slow again for all beginning dates after August. It takes about 15 minutes to run 1. This is the same problem as it had before, but it reappeared with 7.6. Hopefully someone can apply a similar fix again. Thanks.

We are running the custom reports bundle 3.6.2 but I am not seeing the projected enrollment summary under either the custom tab or system reports. I do see it in CPM however. Can you tell me where to look for it?

Barbara Thomason
Peninsula School District
Gig Harbor, WA

I believe you have to add a link to the report. I added a link on Enrollment.html page.

Has there been any fixes to Custom SQL reports not functioning properly after upgrading to 7.6.01. I have not seen any solutions to the reports categories not staying open. Does anyone have a fix?

I'm trying to validate the "Last Update" report data. Can you explain which field(s) are read to designate "update" ? ANY kind of update? Assignments added? Student grades calculated? I personally worked in a teacher's gradebook this week, yet for one subject the report shows no updates when I used either 30 or 120 days to test.

School and District Admin is keen on this information, too, and I want to insure accuracy in my interpretation. Thanks for any explanation.

--David Van Ness

When using custom report - search for low grades aka letter grade report - will not show all males when that is the current selection. Girls will show when they are the current selection, selecting all students will show both boys and girls.

Anyone else with this problem? Any suggestions?

Can anyone tell me how they have handled securing the Custom SQL Reports Tab so that users can access reports, but not create them?

I'm having trouble getting this to run. Nothing happens upon submit, whether I have one or many students selected, regardless of settings. Can you help please? thanks!

I'm having the same problem! Has there been a solution? It worked great last year.

Chris Hay

I never got a reply, but found that the report renders for me if i run it in FireFox. It will do nothing in IE9.

Linda Morse

I am able to get it to run in Firefox, Chrome, and IE10. However, if I run IE10 in compatibility mode it does not render. It appears to be an IE specific issue.

Does this replace the current custom reports bundle? Will this override the other one?

I have a student that won't show up on this report. He has an absence code just like another student on the report - not sure what to check. When I run the standard "Absentee Report" in PS he shows up on the list.

After reviewing the custom reports bundle on our test server I tried loading it to production. When I click on the Custom Reports tab, it says it is loading reports, but they never appear. I tried "Rescan" to no avail.

Our production setup is a stand-alone database server with six virtual application servers and an image server (also virtual). Do I need to do something special to handle these on an array?

Production and test are on 7.6.0.

Johanna Johanson
Rio Rancho Public Schools

The "No Subtype" row appears to be counting log entries for logs other than discipline. Is that the case? Could it be corrected to use the Discipline log only?

Johanna Johanson
Rio Rancho Public Schools

This is a great report but the Student Discipline Report doesn't pull any dates for Incident Date. I'm not sure where this data comes from. The field names for date & time entered on the New Log Entry page are entry_date and entry_time. How can I have that info pulled.
Thanks
Linda

Pages

Subscribe to Comments for "Custom Reports Bundle 3.4.4"