PowerSchool: Community: Article Details

Importing Staff Demographic and Assignment info

By Kris Schutt on August 15, 2016

Does anyone export, update and import Staff Demographic and Staff Assignment info? If so what table to you import into or more generally how do you import this information. I have tried several imports, PowerSchool looks like it import correctly but when I check the individual records nothing has updated. Thanks for any ideas!!!

Tags:

Comments

4 Responses to "Importing Staff Demographic and Assignment info"

Wayne Wiens on August 15, 2016

Make sure your TeacherNumber's are correct. If one is wrong, the whole import will fail. It wont identify the incorrect line in red, but it might put in UNKNOWN STAFF. Other fields with incorrect data could cause the import to fail.

I import one record to make sure I have the format correct. You could divide and conquer by trying to import half of the records and if that doesn't work, take half of the half, and keep going till you find the bad records.

Kris Schutt on August 15, 2016
OK, I'll try that! Thanks Wayne!!!

Kris Schutt on August 15, 2016
What table to you import into for each template?

Wayne Wiens on August 16, 2016
You can import into the Teacher table. It really isn't a true table b/c it is a visible summary of the SchoolStaff table and Users table, but PS allows you to import to it and then the data populates the other tables.

Would you like to comment? Join The PowerSchool Community for a free account, or login if you are already a member.