Student Contact Information

dmott
Practitioner

Student Contact Information

I am trying to find information about exporting student contact information. I am referring to the contact table, not the demographics table. Is there anything in terms of a data dictionary that could be used?

 

I have tried exporting through the Data Export Manager, but the fields I need seem to be nested in several different tables and I can't seem to find the ID fields to link them. 

 

All I am trying to get is a list of Contacts, the student they are associated with, the custody flag, and their email address.

Any assistance would be greatly appreciated. 

1 Solution
dmott
Practitioner

It turns out that I found the solution to my problem using Data Export Manager. I had been selecting "Contact Information" or "Tables"  from the Category dropdown. I finally selected "Show All" and then selected "Contacts" in the Export From drop down. This populated the list of fields with the relations between tables.

View solution in original post

4 Replies
ItsOnlyDoug
PowerSchool Mentor
PowerSchool Mentor

It is a bit unwieldy and working this out has been difficult for us as well, but there is a Custom Reports Bundle on PowerDataSolutions that has a bunch of different Contacts related reports.  I use them almost exclusively now when I need to find something quick.

 

You can find the PSCB here: https://powerdatasolutions.org/content/pscb-plugin-directory-0

 

The Contacts Report is under the PSCB Custom Report Bundles

 

The reports are free.



Doug Skinner

District Instructional Data Officer
Gateway Regional School District



Did your issue get solved? Please remember to give Kudos and/or select Accept As Solution on the helpful posts to thank the author and to help others find the solution.


dmott
Practitioner

It turns out that I found the solution to my problem using Data Export Manager. I had been selecting "Contact Information" or "Tables"  from the Category dropdown. I finally selected "Show All" and then selected "Contacts" in the Export From drop down. This populated the list of fields with the relations between tables.

agreaney
PowerSchool Mentor
PowerSchool Mentor

There is also a Contact DAT Builder plugin available in PowerSource.  It can be used with Quick Export.  Very handy!

https://support.powerschool.com/exchange/view.action?download.id=948&fromSearchResults=true

 

Andrea Greaney
Diocese of Evansville, Indiana

Mentors_badge
BrookeR
PowerSchool Champion
PowerSchool Champion

 I am going to piggy back onto this thread...

 

I want to do a form letter that has the CONTACT access log on name and password so that I can send it out to parents.

 

Any ideas?