cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Member

How can I export SIS ID from PowerSchool so I can do data matching between Canvas and PowerSchool?

SIS ID is the unique ID that Canvas imports from PowerSchool....how can I export SIS ID from PowerSchool so that I can troubleshoot users and data issues?

3 Replies
Highlighted
Community Member

Hi teststudent‌,

As we sync our data from PowerSchool to Canvas our Canvas SIS IDs are different than the student numbers in PowerSchool. For example, we have a student with the PS student number of 2468456, but their Canvas SIS ID is "student_104."

So to answer your question, I'm not sure what data from PowerSchool you would want to match apart from First_Name, Last_Name, Student Email address, Course Enrollments, and Student ID? Maybe I'm misunderstanding the question?

Are you just looking for how to do a quick export of student fields from PowerSchool?

Thanks,

Rob

0 Kudos
Highlighted
Community Member

Hi! Thanks for responding…I just did some research and found that the “user_id” in Canvas pulls DCID from PowerSchool…they used to use a field they liked to call “SIS ID” to develop user_id and I could not (and still cannot to this day) find out where it comes from in PowerSchool. I find it unfortunate that they have no field for Student ID number as this is the industry standard for unique student identifiers. I know that I can use email and other fields to identify students, but as we work on secondary integrations, this elusive SIS ID becomes a problem. I’m rambling now…at any rate, thanks for responding!

Sincerely,

Molly Nellman

Coordinator of 21st Century Learning

Centinela Valley Union High School District

310-263-3176

0 Kudos
Highlighted
Community Member

You can export the DCID from PowerSchool in a variety of places. I usually find it easiest through Quick Export. I couldn't get my screenshot to upload here in the community. The link is Shared album - Tricia Jackson - Google Photos .

0 Kudos