PSCB - Custom Reports (Contacts)

View PSCB Plugin Directory

Version 1.6

Description

This bundle includes 6 Contacts reports.

Contacts - Duplicates
(View Duplicate Contacts list.)

Contacts - Phone Number Search
(Search all contact phone numbers for a partial or complete phone number match.)

Contacts - Students List
(Lists contacts information and associated students. )

Students - Contacts Access List
(View a list of students whose contacts have/have not accessed their accounts for a selected date range. )

Students - Contacts Address List
(Lists contacts address information for each student. )

Students - Contacts List
(Lists contacts information for each student. )

Acknowledgements

PSCB Development Team
Rob Staats
Manjit Basra
Michael Moore

Version Info

1.0 (2019-09-30)
- Initial Release

1.1 (2020-03-10)
- Added two additional reports.
Contacts - Phone Number Search
Students - Contacts Address List

1.2 (2020-06-10)
- Updated the SQL query in the Students - Duplicate Contacts report.

1.3 (2020-08-20)
- The Contacts - Duplicates report was modified to work with the current student selection only. Using a smaller student selection will improve report performance.
Powerschool Compatible Versions

1.4 (2020-09-16)
- The Students - Contacts Address List report was modified to display address, unit, city, state and zip in separate columns.

1.5 (2020-10-05)
- The Students - Contacts List report was modified to include Original Contact Type.

1.6 (2020-10-19)
- The Students - Contacts Access List report was modified to include Account User Name.

19.x, 20.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 Contacts link to access the Contacts Reports menu.

PS Verions

12.x: 
N
19.4: 
Y
Plugin: 
Y
CPM Import Friendly: 
Y
Report Type: 
Web Based Report
19.11: 
Y
20.4: 
Y

Comments

Oops wrong Thread.

I was testing it at a school with 53 students. I went back and did some further testing. It looks like if I choose "All Students" as the report filter selection... it never processes. It gets stuck at the loading screen. If go back to the home screen select all the students and then run the report with the "Current Selection (53)" filter selection it runs fine. Tested a few other smaller schools and the same thing happened.

Is there any upper limit to the total number of student selection you would suggest?

Thanks for bringing the "All Students" issue to our attention. This issue will addressed in the next release of the plugin.

--
Rob Staats
PSCB Development

Hey there!

Big fan of all of your plugins.

Wondering if it would be feasible to add a "Make current student selection" option on these reports.

An example would be - the Contacts - Student List report.

I'm able to quickly search for say all Contacts who have @yahoo.com - and that shows me the associated contacts w/ students associated. But from there, I cannot make those students my selection if I wanted to work with only those students who have contacts associated with @yahoo.com

Thanks regardless!

The Make Current Selection button is already included with these reports. Confirm that you have installed and enabled the following plugins.

PSCB- Base Resources 3.0
PSCB- Custom Reports (Contacts) 1.3

--
Rob Staats
PSCB Development

When using the new UI in PowerSchool 20.4+ when you click on the contact name using the duplicate contact report it no longer opens the Contact consolidation screen.

Thanks for bringing this issue to our attention. The PSCB Development will investigate the cause.

--
Rob Staats
PSCB Development

First off, thank you so much for these fabulous reports! Contacts are such a bear (super helpful but a bear nonetheless), and these reports are a huge help when managing them.

My question is regarding the address line. The address line currently has the whole address on the one line so when you export, you need to split it up to be able to use it for mailing labels. In a future release, would it be possible to break up the address like it is in PS; Street in one column, city in one column, state in one column and zip in one column?

The PSCB - Custom Reports (Contacts) v 1.4 was published today.

- The Students - Contacts Address List report was modified to display address, unit, city, state and zip in separate columns.

--
Rob Staats
PSCB Development

You all are the absolute best!! Thank you so very much :)

I tried to download the Students Incident Summary and it downloads the Historical Grades Tabs. I click on the view for the Students Incident Summary and it takes me to the Historical Grades Tabs.

I want the Students Incident Summary!

The links have been corrected. Please try again.

--
Rob Staats
PSCB Development

Any chance you could add a column for OriginalContactType to the Students - Contacts List report?

OriginalContactType will added in the next release of the report.

--
Rob Staats
PSCB Development

Hi, for the student access account related reports, can we add in the username? The email address of the user is there, but it would be more helpful to have the username so we can help troubleshoot quickly with families. Thanks!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

Account Username will be included in the next release of the plugin which is scheduled for next week.

--
Rob Staats
PSCB Development

You guys are the best thank you!

Alison Blazey
ablazey@ehtp.org
Data and Systems Manager
KIPP NYC College Prep

PSCB - Custom Reports (Contacts) plugin v1.6 was published today. The Students - Contacts Access List now includes Account User Name.

--
Rob Staats
PSCB Development

Hi Guys,
Love this report but are the filters supposed to work . I chose Priority 1 as a filter and it did not update the display.

Also, a request would it be possible to have the export to csv added?

Doug Robertson

Wait for the report to display all records before making a priority selection.

After selecting a priority, it may take some time to render the results depending on the number of contact records listed.

The Export to CVS option already exists for the contacts reports.

Confirm that you have installed and enabled the PSCB - Base Resources 3.0 plugin.

--
Rob Staats
PSCB Development

Hi Rob,
Thanks for the response. the filter does take time to render, I guess I am too impatient! I have base resources 3.0 install and enabled. I chose 6 students in test and tried the priority filter and it worked. Tried the same 6 students in production and the priority filter did not work. But the Export to CSV does not show at the top on production but shows on my test server. The only difference is that production is on 19.X and test is on 20.4. I thought, as well, that maybe another plugin was colliding with it, but there is the same plugins installed and enabled on test as to production excepting test server identification. Could this be it?

Doug Robertson

Pages

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