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

1.1 (2019-06-19)
- Fixed View Details link issue.

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

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".

--
Rob Staats
PSCB Development

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.

I ran into the same issue that non-discipline logs showed fine but discipline logs did not show up. I was wondering if you have solved it.

Katie EunJeong Kim
Admissions Coordinator
Daegu International School
22, Palgong-ro 50-gil, Dong-gu,
Daegu, Korea, 41021
Tel: 82 53 980 2100
Dir: 82 53 980 2104
Fax: 82 53 980 2101

I have the same issue...can see everything but Discipline Logs...I have other log reports but I liked the "link" to the log. We use a date picker so I don't think it's the date. So is it set to pull log type #(-100000) for Discipline?

None of my schools are able to use this report. Because VA has a ton of its own state fields, we have chosen to hide many of these fields, so they are not filled in any more. The only field that I would need to trigger the record would be the LogType of Discipline. I'm not sure if you have it set to look at other fields, too.

Jennifer Bocrie
Goochland County Schools
Goochland, VA

The Discipline Log Entries Summary report will only display discipline log entries (log type #(-100000).

The Log Entries Summary (Non Discipline) report provides a menu of other available log types. You will only see log types that have been marked as accessible for your security group. The report will display log entries for the selected non-discipline log type.

Rob Staats
PSCB Development

--
Rob Staats
PSCB Development

When I print the report in PDF it drops several fields. I can't get it to print all the data in PDF.

I am having this issue, too. Did you find a resolution?

What browser are you using? Try setting the page setup to landscape mode.

--
Rob Staats
PSCB Development

Rob - I have tried in both Chrome and Firefox and I am having the issue too. Any ideas? Where is the page setup you mentioned?

Due to the large number of columns and data being displayed on the results page, the Export PDF File button does not always format the PDF document correctly. In that case, you should use the Copy Data or Export CSV File buttons.

Another option you can try:

Select Print from the Browser Options Menu
Change the Orientation to Landscape
Change the Scale, if necessary to fit the page.
Then choose Print or Print to PDF

Note: The Export PDF File button will be removed from this report in the next release of the plugin.

Rob Staats

--
Rob Staats
PSCB Development

FYI-The title of the report is spelled wrong!

It says "Disciple Log Entries Summary" on the report when you want to run the report and on the list of reports the "Log Entries Summary (Non Discipline)" report has it miss spelled as "log Entries Summary (Non Discpline)

Also: if we select "All Incident Sub-Types" should it pull even if our log entry doesn't have a Incident Sub Type populated?

The typo has been corrected. You can download and re-install the plugin.

The report will return discipline log records even if the entry does not include a sub-type.

--
Rob Staats
PSCB Development

Hi
Wondering if there is any way to sort these reports, eg by student name; otherwise we end up with several logs related to one student spread through the report.
Absolutely love the report though!

You need to install the PSCB - Base Resources v2.4 plugin which is required for all PSCB customizations.

This plugin will provide sorting and filtering for all columns in the reports.

--
Rob Staats
PSCB Development

Having a bit of a weird issue with the Discipline Log Entries Summary report. When clicking "View" for Entry Details - the log entry opens, however the student it opens for is the incorrect student. However, when clicking the student's name - the log entry for the student opens as expected.

We are having the same issue, if you have viewed a student previously that student stays in the cache for the wc:title_student_end_css

edit out* and we are seeing the wrong data from another student being pulled into Customlogentrydetails.html. *

I just took out the view link column and telling staff to click on the students name.

Correction. Another team member had changed the tlist so it was pulling student dcid instead of log dcid. The wrong student in the page was our error not PSCB.

L

Thank you for brining this issue to our attention. It will be corrected in the next release of the plugin.

--
Rob Staats
PSCB Development

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