I am struggling to create a PowerSchool data export with enough information to set up Schoology Parent Accounts. I am one year into my role and have not mastered DDE exports by any means. I need to look for the unique contact user ID and email address, but they are buried in all of the tables.
Has anyone created an export from PowerSchool to run regularly to upload to Schoology for creating and updating parent user accounts? I am avoiding using the access codes and having parents enroll themselves at all costs. Managing Schoology is a very small part of my role and I am willing to do extra work to eliminate the requests I would get to walk parents through that process.
An identifier that is unique district-wide (this will be their Unique ID)
A username or email address
If you know a way to associate students and parents with some number in PowerSchool, I have been looking for that, too. FamilyID is no longer supported I am told, but there must be a way PS associates contacts and students.
You can export most student data using Quick export. Using the Data Export Manager, you can export contact information from PowerSchool by choosing PowerSchool Data Sets from the Category pop-up menu, and then Contacts from the Export From the pop-up menu. You can use these Student-Contact-DAT-code-Examples