PSCB - Custom Reports (Logs)

Description

This bundle includes 2 Logs reports.

    Discipline Log Entries Summary
    Log Entries Summary (Non Discpline)

Acknowledgements

PSCB Development Team
Rob Staats
Manjit Basra
Michael Moore

PowerData Solutions Contributors
Jason Treadwell
Brent Johnson
Brian Andle
Tim Scoff
Matt Freund
Roger Sprik
Dean Dahlvang

Version Info

1.0 (2018-05-24)
- Initial Release

Powerschool Compatible Versions

10.x, 11.x, 12.x

Additional Plugin Requirement

The following PSCB plugins should be installed prior to the installation of this reports bundle.

PSCB - Base Resources
PSCB - Custom Reports (_Home Page)

Installation

Install in System > System Settings > Plugin Management Configuration

Do not unzip the plugin. Install the entire zip file. Be sure to enable the plugin once it's installed.

If you are updating, you can now click on the Plugin name and then use the Update button, and then browse to the new file and click Submit and it will then load the update and then ask you to enable it.

Instructions

Select a school and go to the Powerschool start page.
Click on the PSCB Custom Reports link on the left navigation menu.
Click on the Log Entries link to access the Log Entries Reports menu.

PS Verions

7.x: 
Y
8.x: 
Y
9.x: 
N
10.x: 
Y
11.x: 
Y
12.x: 
Y
Plugin: 
Y
CPM Import Friendly: 
Y
Report Type: 
Web Based Report

Comments

Hello, I've installed the log entries report. the non-discipline report works great and shows the log entries. The discipline log entries summary does not show any data. Thoughts?
thank you!

The Discipline Log Entries Summary report has been hard coded to display only log entries that were created using the log type "Discipline". This is the default log type included in PowerSchool. All other log types are excluded from this report.

The Log Entries Summary (Non Discpline) report will display all log type entries other than "Discipline".

Thank you, I understand. The Discipline Log entries report is not showing data and we have many Discipline log entries. The Non Discipline is working correctly but I am not getting any data from the Discipline log entries report.

I've seen something like that happen with other discipline log reports and it usually has to do with bad data in the log table, especially dates. For example, one user may have entered Aug 1, 2018, in one of the date fields vs 8/1/2018 or whatever format is allowed. Some of the date entry points are actually text fields and will allow bad date, and then the report won't work because it runs into the date formatting issue. The only way to know for sure is to export the data from your Log table and check over the data the report is looking at - look for bad dates or things such as spaces before or after a date.

You can also check the system logs area of PS and look for ORA- errors if the report is using tlist_sql to output the results. Any ORA-, which are Oracle errors, will get logged and you can sometimes tell from them what the issue may be.

Thanks Matt, I did an export and the dates look good. I can't see any Oracle errors in the system logs. Any other ideas?

Make sure you're checking dates for all the discipline records in the log table and not just ones within a certain date range. Might not be a bad idea to export other pieces of data that the report is suppose to return to see if there's anything that could be an issue. For example, if the report is suppose to export the log entry text part, there could be something in a record, such as a special character, causing an issue.

Otherwise, if you're familiar with tlist_sql, you could modify the sql in the report to see if you get data with a barebones where statement and then add more criteria from the original where back in to see if something breaks it.

OK, thanks Matt.

Subscribe to Comments for "PSCB - Custom Reports (Logs)"