Problem updating account using logins.csv

[rvyhmeister]

I'm wanting to add a second login for a user (will eventually need to do it for all users, but for now testing)... so I create a logins.csv file that has just these two rows:

user_id,login_id,password,existing_integration_id
"19402610",user@gmail.com,,

And it returns this error: 

No existing user provided for login with SIS ID 19402610

Yes, when I go to People, it shows

SIS ID: 19402610

So what am I doing wrong?

Thanks for any advice

[chriscas]

Hi @rvyhmeister,

From what I can tell from a couple quick tests:

• user_id,login_id are required and are values for the new login, these have to be unique and not something already in use for the exsiting login (so each login needs a unique user_id)
• password is optional and you don't even need to include it in the csv at all if you're not setting one
• You need some combination of existing_user_id, existing_integration_id, existing_canvas_user_id, and/or root_account to identify which user you're adding the login to.

With that being said, your example lacks the information in the third bullet for the import to know which user to attach the new login to.  If you're just trying to change the login but keep the sis_id the same, there is a different file to use for that.  If you're trying to have multiple logins under one sis_id, I don't think you'll be able to accomplish that with the sis_import files, though I could be incorrect on this.

Let us know if this helps at all!

-Chris

[rvyhmeister]

OK... Let me give you all screenshots (attached, can't figure out how to embed), so you can see...

I have this user (user.jpg)

I want to add a second login for them, so here's the CSV file, where the User ID is the SIS ID as indicated by https://community.canvaslms.com/t5/Admin-Guide/How-do-I-format-CSV-text-files-for-uploading-SIS-data... :

user_id,login_id,password,existing_integration_id
11111112,user2@test.com,,

And I get this error when importing (error.jpg).

What I want to have when it's done is a user that looks like this (correct.jpg)

I can do this manually, but I have literally thousands to do, so want to be able to do them via an import. 

Thanks in advance

[chriscas]

Hi @rvyhmeister,

You won't be able to get the exact thing you're looking for through the sis upload option.  With my testing, using the logins.csv file, you can create 2 logins for a user but each login must have a unique sis_id.  To create another login without having to have additional sis_ids, I think you'd likely have to use the Logins API. This shouldn't be super difficult for someone with a bit of programming and api knowledge, but is definitely more daunting that the sis csv method.

Hope this helps.

-Chris

[rvyhmeister · Accepted solution]

Spent some time talking with Canvas this morning... the key is that the example CSV is not complete... you need to have also one of the following fields:

• existing_user_id^
• existing_integration_id^
• existing_canvas_user_id^

With that it works great! 18,000 new updates in less than 10 minutes, and no API programming!