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.
Comments
jwydra
Mon, 09/30/2019 - 2:41pm
Permalink
YAY!
Thank you so very much!!
jnovzen
Fri, 10/04/2019 - 5:46am
Permalink
Custom Reports (Contacts)
I have installed the PSCB Custom Reports (Contacts) however I am having the same issue that it doesn't show in my navigation menu. I checked my admin_nav_menu_left_css.txt file however I have 3 files which are: admin_nav_menu_left_css.PSCB_AttendanceEnrollment.leftnav.footer.txt
admin_nav_menu_left_css.mba_medLink.leftnav.footer.txt
and the original:
admin_nav_menu_left_css.txt
Can anyone give me advice on which one to modify so that I can get the PSCB Custom Reports (Contacts) to show?
Thanks!
PSCB
Fri, 10/04/2019 - 6:40am
Permalink
Custom Reports (Contacts) - Reply
You need to also install and enable the following two plug-ins.
PSCB - Custom Reports (_Home Page)
PSCB - Base Resources
--
Rob Staats
PSCB Development
jnovzen
Wed, 10/09/2019 - 7:20am
Permalink
Custom Reports (Contacts)
They are installed but still not showing ... Any other ideas?
PSCB
Wed, 10/09/2019 - 7:48am
Permalink
You may have a customized
You may have a customized 'admin_nav_menu_left_css.txt' file that is preventing the PSCB - Custom Reports from appearing.
Go to CPM and check to see if a customized version of the file exists.
--
Rob Staats
PSCB Development
jnovzen
Wed, 10/09/2019 - 9:03am
Permalink
Custom Reports (Contacts)
I have two - one is customized "admin_nav_menu_left_css.mba_medLink.leftnav.footer.txt " and the other is not customized "admin_nav_menu_left_css.txt"
Would it be the customized version causing the issue?
PSCB
Wed, 10/09/2019 - 12:08pm
Permalink
Do you see this file in the
Do you see this file in the wildcards folder?
'admin_nav_menu_left_css.PSCB_Reports.leftnav.footer.txt'
--
Rob Staats
PSCB Development
jnovzen
Thu, 10/10/2019 - 11:49am
Permalink
Custom Reports (Contacts)
No - I only have:
admin_nav_menu_left_css.mba_medLink.leftnav.footer.txt
admin_nav_menu_left_css.PSCB_AttendanceEnrollment.leftnav.footer.txt
admin_nav_menu_left_css.txt
PSCB
Thu, 10/10/2019 - 1:42pm
Permalink
Custom Reports (Contacts) - Reply
You are missing the "admin_nav_menu_left_css.PSCB_Reports.leftnav.footer.txt" file.
This would indicate that the PSCB - Custom Reports (_Home Page) plugin has not been installed and enabled.
Download the plugin and install/enable. You should then see the PSCB Custom Reports link on the left navigation panel.
--
Rob Staats
PSCB Development
jnovzen
Fri, 10/11/2019 - 10:59am
Permalink
Custom Reports (Contacts)
This is great! Working now and thank you!
swalters
Mon, 10/14/2019 - 10:05am
Permalink
Contacts Plugin
I installed the contacts plugin but the tab did not appear in under the Custom Reports Tab. I enabled the plugin and I have the Custom Reports Bundle Base version 4.2.1 installed. Am I missing something?
PSCB
Mon, 10/14/2019 - 10:43am
Permalink
This would indicate that the
This would indicate that the PSCB - Custom Reports (_Home Page) plugin has not been installed and enabled.
Download the plugin and install/enable. You should then see the PSCB Custom Reports link on the left navigation panel.
You also need to install the PSCB - Base resources plugin.
The Custom Reports Bundle Base version 4.2.1 contains resources used for the old PDS CRB bundles.
--
Rob Staats
PSCB Development
--
Rob Staats
PSCB Development
daveski
Wed, 10/16/2019 - 6:42am
Permalink
Duplicate's not showing
When choosing the Contacts - Duplicates option, I get no results although the screen indicates Total Records: 1, but no record is displayed. Is the duplicates option working?
Dave Tchozewski
Director of Information Technology
Kenowa Hills Public Schools
2325 Four Mile Rd. NW
Grand Rapids, MI 49544
(616) 965-4023
www.khps.org
LSC0106
Tue, 04/14/2020 - 12:47pm
Permalink
No Duplicate Contacts
How does this report calculate the duplicate contacts? My report is blank even when run from the district level!
PSCB
Wed, 04/15/2020 - 6:48am
Permalink
No Duplicate Contacts - Reply
The report lists all duplicate contacts that are displayed on the student's Contacts page.
Check to see if you can find a student that has duplicate contacts listed.
What PowerSchool version are you currently using?
--
Rob Staats
PSCB Development
LSC0106
Mon, 04/20/2020 - 3:38pm
Permalink
No Duplicate Contacts
We just upgraded to v19.11.0.2. I am a duplicate contact on my both of my children's records. I am on their Contacts screen with my name twice, one with work email, one with personal email and also twice with my work email, once with my name and once with No Name as the name..
PSCB
Mon, 04/20/2020 - 4:55pm
Permalink
No Duplicate Contacts - Reply
Run the report at the District Office level.
--
Rob Staats
PSCB Development
LSC0106
Tue, 04/21/2020 - 1:50pm
Permalink
No Duplicate Contacts
I clicked All at the district level to make 42534 students my current selection. PSCB Custom Reports > Contacts > Contacts - Duplicate Contacts > Current selection (42534) = No Duplicate Contacts. I just randomly thought to do a query of last_name=my last name at the LEA level to bring up my children (one at an elementary/one at a middle) and my niece at a high school and was able to get results??
PSCB
Tue, 04/21/2020 - 1:56pm
Permalink
No Duplicate Contacts - Reply
What version of PowerSchool is installed on your server?
--
Rob Staats
PSCB Development
LSC0106
Tue, 04/21/2020 - 3:21pm
Permalink
No Duplicate Contacts
Our state - North Carolina - just upgraded to v19.11.0.2
drsimon44
Wed, 04/22/2020 - 9:34am
Permalink
No duplicate contacts
We have the same issue with some of our North Dakota schools. It appears to be an issue with our large schools that are on a server array. For the districts that are on a single server, it works fine. We are on version 19.11.0.2.1407804
PSCB
Wed, 04/22/2020 - 10:04am
Permalink
No duplicate contacts - Reply 2
Thanks for sharing this info with us. I'm not sure what PSCB can do to address the server array issue, but we will investigate a solution.
--
Rob Staats
PSCB Development
jrpfahl
Sat, 05/09/2020 - 8:09am
Permalink
no duplicates
i have the same issue with no duplicates showing, the student list does show duplicates, but the duplicates list is blank, both at school level and DO. hosted by PS and at version 19.11.0.2
Jason Pfahl
Director of Technology
Clinton Central School Corp
INdiana
PSCB
Mon, 05/11/2020 - 10:25am
Permalink
No Duplicate Contacts - Reply
The duplicate contacts list is generated on the matching of contact names. If you are listed as "No Name" that will not generate a match and thus will not be included in the report results.
--
Rob Staats
PSCB Development
mellsworth
Fri, 11/22/2019 - 10:34am
Permalink
Mailing Address Doesn't Display
Thank all so much for this report. It is super helpful. I am trying to run the mailing list under contact and the home address pulls out but the column for mailing address is empty. Where we live 98% of our student/parent population has a PO Box. Any help with getting this to display would be appreciated. Marta Ellsworth, Eagle CO
PSCB
Fri, 11/22/2019 - 1:30pm
Permalink
Mailing Address Doesn't Display - Reply
The report displays the contact's primary email address.
If the the primary box for the email address is not checked, the email address will not appear on the report.
--
Rob Staats
PSCB Development
mellsworth
Mon, 02/10/2020 - 4:22pm
Permalink
Still Looking for PO Boxes in the address report
Hi I'm still trying to figure out how to get the mailing address to pull in the "Student Contact Mailing List" report instead of the physical address. Any chance of getting a second report filter option of home or mailing when running this report? Thanks for all the awesome reports you provide us. Marta Ellsworth
PSCB
Mon, 02/10/2020 - 5:20pm
Permalink
Still Looking for PO Boxes in the address report - Reply
The Student Contact Mailing List report displays the Physical Address, Mailing Address and Primary Email Address that has been entered for each contact.
If any of the addresses do not display, it would indicate that the information has not been entered for the individual contact.
After entering all address information for each contact, the report columns can be filtered for the type of address you want.
--
Rob Staats
PSCB Development
mellsworth
Tue, 02/11/2020 - 10:43am
Permalink
Mailing Address Doesn't Display
Hi Rob when running this report only the physical address displays. The mailing address is empty however 95% of our contacts have a PO Box for their mailing address and none of them display.
PSCB
Tue, 02/11/2020 - 1:08pm
Permalink
Mailing Address Doesn't Display - Reply
Select a Student.
Navigate to the student Contacts page.
Click on a Contact Name.
Navigated to the address section.
Confirm that a physical and mailing address has been added for the contact.
Note: The report will display the addresses entered for each contact.
--
Rob Staats
PSCB Development
mellsworth
Wed, 02/12/2020 - 3:25pm
Permalink
Hi Rob out contacts contain a
Hi Rob out contacts contain a PO Box those aren't missing on the contact page for a parent. It doesn't pull. Only the physical address pulls onto the report. Sorry to be a pain. Marta
PSCB
Wed, 02/12/2020 - 6:29pm
Permalink
Hi Rob out contacts contain a
Select a Student.
Navigate to the student Contacts page.
Click on a Contact Name.
Navigated to the address section.
Send a screenshot of the addresses displayed on this screen,
Thanks
--
Rob Staats
PSCB Development
mellsworth
Thu, 03/05/2020 - 8:47am
Permalink
Mailing Address Doesn't Display
Hi Rob is there any update on the mailing addresses not pulling into the contacts report to include it?
Thanks
Marta Ellsworth
PSCB
Thu, 03/05/2020 - 3:14pm
Permalink
Mailing Address Doesn't Display - Reply
We have discovered the issue with this report. An updated version will be published by 3/15/20.
--
Rob Staats
PSCB Development
mellsworth
Fri, 03/13/2020 - 3:40pm
Permalink
THANK YOU!
I can't thank you all enough for fixing this report! This is going to be so helpful for our district.
Marta Ellsworth
Eagle, CO
sue.costello
Tue, 04/21/2020 - 9:07am
Permalink
Students - Contacts List-Lists contacts information for each st
We love this report but are wondering why (when a contact has only one phone number) it populates the second phone number column and not the first? The first phone number column is blank (not set). This does not happen all of the time that there is only one phone number, just sometimes. Do you know why?
PSCB
Tue, 04/21/2020 - 11:59am
Permalink
Students - Contacts List-Lists contacts information - Reply
Sorry, but we were unable to duplicate the issue you described. We will continue to investigate.
--
Rob Staats
PSCB Development
gormsby
Mon, 05/11/2020 - 7:00am
Permalink
Update
Hello,
Has this been updated? Last change is 3/10 but you said above you will release a new version on 3/15.
Also, I am under the impression that these reports in the bundle are for v12 contacts and not for the old contacts. Is that correct?
Gloria
Gloria Ormsby
PSCB
Mon, 05/11/2020 - 10:13am
Permalink
PSCB - Custom Reports (Contacts) 1.1
The PSCB - Custom Reports (Contacts) 1.1 is latest version. We are still investigating the issue where no duplicate contacts appear in some instances. This reports bundle is only compatible with the new unlimited contacts setup and versions 12.x, 19.x and 20.4.
--
Rob Staats
PSCB Development
pmedema
Thu, 05/21/2020 - 12:06pm
Permalink
Duplicate Contacts doesn't seem to work
I have some buildings that it will pull data for, and others that pull nothing. Some will pull if I select all students first, but some that still pull nothing. This really needs to work from District Office, and it pulls nothing there, with or without a current selection. I have the most recent versions of the report, base, etc., and the most recent PS version.
Peggy Medema
PSCB
Thu, 05/21/2020 - 1:59pm
Permalink
Duplicate Contacts doesn't seem to work - Reply
Does your current PowerSchool installation use a Server Array?
--
Rob Staats
PSCB Development
adam_thomas
Wed, 07/15/2020 - 2:55pm
Permalink
This is a helpful plugin but
This is a helpful plugin but I would like to request a report that combines the students - contacts list and students - contacts address list please.
PSCB
Thu, 07/16/2020 - 2:30pm
Permalink
This is a helpful plugin but - Reply
Sorry, it is not feasible to design a report that would combine all of the information in both reports.
--
Rob Staats
PSCB Development
rwickberg
Fri, 07/17/2020 - 11:42am
Permalink
Chrome wouldn't let me download this
Just an FYI, Chrome wouldn't let me download this bundle, it said the file "may be dangerous, do Chrome has blocked it." Firefox let me do it. Maybe you could contact someone at Google and complain about that?
aplarsen
Mon, 08/03/2020 - 9:05pm
Permalink
I'm not seeing this behavior
I'm not seeing this behavior on Chrome 83.0.4103.106 in Windows 10. Are you still getting this error now?
PSCB
Fri, 07/17/2020 - 12:22pm
Permalink
Chrome wouldn't let me download this - Reply
A Google html verification file needs to be added to the PDS web server.
PSCB does not manage the web site, so I have contacted the web master to see if they want to add the verification.
Thanks for bringing this to our attention.
--
Rob Staats
PSCB Development
geggler
Mon, 08/10/2020 - 12:31pm
Permalink
Enhancement Request
Please add the parent's username to Students - Contacts Access List.
Thank you!
PSCB
Tue, 08/11/2020 - 1:19pm
Permalink
Enhancement Request - Reply
This request has been added to the PSCB Enhancement List.
--
Rob Staats
PSCB Development
adriancarlson
Tue, 08/18/2020 - 7:49am
Permalink
Duplicate Contacts
The duplicated contacts report is not working on PowerSchool 20.4.2 or 20.4.3 for version 1.2. It just sits at the loading dialog. I have tried firefox and Edge and cleared the cache in both browsers. Looking at the SQL code it might have something to do with the addition of
jaro_winkler. I am not familiar with the jaro winkler algorithm othewise I would try to proved a fix.
PSCB
Tue, 08/18/2020 - 8:38am
Permalink
Duplicate Contacts - Reply
If you are searching on a large selection of students, the report will take an extremely long time to complete and can time out.
The report works best with a smaller selection of students.
--
Rob Staats
PSCB Development
Pages