Adding SIS ID's to pre-existing users (Salesforce integration)

[IsabellaFaro]

Hello, 

I am trying to create an excel template to add SIS IDs (which are Salesforce IDs) to current users via their login  ID's. I used the following sheet structure to attempt this:

user_id	integration_id	login_id	status
Salesforce ID	Salesforce ID	We use user's email addresses as their login IDs	active

When I did this, it created a new user with only user's SIS ID instead of updating their contact to include their SIS ID.  What fields do I need to include in my template to update existing users?

[chriscas]

Hi @IsabellaFaro,

Assuming you're trying to use the SIS import process for this, I believe you'll want to use the format listed under the change_sis_id.csv section of the SIS Import Format Documentation - Canvas LMS REST API Documentation guide.

Based on what you're doing, I think you need the following:

old_id	new_id	old_integration_id	new_integration_id	type
	Salesforce ID	Salesforce ID	Salesforce ID	user

Let us know if this works or not!

-Chris

[IsabellaFaro]

Thank you for your help! Yes you are right, I am using SIS imports. Unfortunately that did not work- it gave me the error message: "An old_integration_id referenced a non-existent user and was not changed." I don't think any content in the template you suggest would be linked to the existing user (like their user_id)- am I missing something?

[chriscas · Accepted solution]

Hi @IsabellaFaro,

So I was assuming based on your initial post that you had an integration populated for each user, but sounds like this may not be the case after all.  In order to use the sis method, you'd need to have either an existing sis_id or integration_id.  Without either of those pieces in place right now, it gets a bit trickier to add an sis_id.

What I would suggest in this case is to run a provisioning report for users from your root canvas account.  You can then open that file and populate the user_id column with the desired sis_ids (there is definitely some confusion between a canvas_id and an sis_id in different areas of Canvas), save the file, and upload it to Canvas.  This should get the sis_id populated for the existing users.  I tested this in my instance before posting just to verify it still worked.

Hope this helps!

-Chris