How can I update sis_user_id,if it was already in use

[moonshot]

and i cann‘t find account with that sis_user_id in system

[James]

@moonshot 

To find which user has that SIS ID, go to Admin > Settings > Reports > Provisioning. Configure it to give you the Users CSV for all terms. Be sure to check the box to include deleted objects from the bottom before you run the report. 

You'll get an email when the report is generated with a download link. Then you can search the CSV file for the ID to figure out who has already used it.

When this situation happened to me, it was because a user with the SIS ID had been deleted. I had to go find that user, restore it, change/remove the SIS ID within the web UI, and then I could reuse the SIS ID for a different user. It's been many years, but I may have had to do a SIS import to reactivate the old user so that I could then change/remove the SIS ID.

[stimme · Accepted solution]

All types of SIS ID must be unique. When a user with an SIS ID associated with a login is deleted, it stays with their deleted account. You can find and restore their deleted account and proceed from there.

First, go to your institution account's Settings page, click on the Reports tab, configure a provisioning report to produce a Users CSV with the box checked to include deleted objects. Wait a minute or two, refresh, and download the report. The CSV file should include the SIS User ID you're seeking. Get the numerical Canvas User Id for the user.

Second, restore the user. How do I restore a deleted user in an account? 

You can update the restored user so that it's useful to the person it belongs to or, if it belongs to someone else, edit its login details removing the SIS ID. Save. Give the SIS ID to the other user, and it should work this time.

[James]

The Restoring a deleted user solution you gave is easier than doing a SIS import. Thanks for mentioning that. Most of what I do is on the backend and I don't know about all the tools on the admin side.