How do I found out Teacher that was deleted

[leo_satara]

My SIS import is running and giving me error that USER ID cannot be found under enrollment file.  I tried to run Provisioning report on Users.csv to included deleted objects but did not found deleted user that way.  Any other way to found out who is mystery user?

[rmurchshafer]

Leo,

Does the error not tell you the user_id or some other identifier?  If so, try accessing your test instance of Canvas and search users using that number.  The test instance of Canvas was probably refreshed about two weeks ago so if you think the user was deleted since then their account might still be on Test to look up.

Rick

[leo_satara]

Yes I have User ID, that is my only clue. Great idea...I tried under Test and Beta, no luck. Oh well...it was worth a try.

[James]

If you have the user ID, then you can ignore most of what I typed in the other message, but the first part still applies. If it's not in the provisioning users.csv report when you include all terms and deleted objects, then Canvas probably never had an account created for that user.

Make sure their user information is in the users.csv file that you SIS import and then Canvas will have the ID on record and it should allow the import from enrollments.csv.

Another thing that may have happened is that the account was merged with another account and you are using the wrong ID. We get those issues periodically at our institution where someone entered a new student account and once we discover it, we merge them with the existing account.

[leo_satara]

Thanks James, I do have User ID, since it was listed in my failed enrollment file.  That is what initiated my hunt. Our SIS imports are triggered automatically twice a day via oneRoster API connection with Infinite Campus. I never see SIS import, unless I do one manually myself. I think you are right and this user was never created, it was just weird error, that got me thinking and going in circle. Great idea with merged account, that is definitely something to keep in mind. Sometimes these automated imports work out on the next scheduled time...will see.

[James]

 @leo_satara ,

What makes you think that the problem is because someone was deleted? If you ran the provisioning report and included deleted objects, then Canvas doesn't think the account was deleted, it doesn't think it was ever created in the first place.

A couple of ways come to mind to track this down, both involving working with the enrollments file.

You can take the user IDs in the enrollments.csv file and try to match them up with the user_id from the provisioning report users.csv file and see which one doesn't match. You can do this in Excel using an =MATCH() function and look for ones that give you errors, I would copy both the enrollments.csv file and the users.csv file into a single Excel workbook on different sheets to make the calculations easier.

A second way is that you can divide your enrollments.csv file in half and upload one half of it. If it still has the error, then you know that it's in the that part and you can then cut that part in half and try again. If it's not in the part that you upload, it's in the other part. Keep narrowing the file down by 1/2 each time until you find the problem. Make sure that you're not checking that this is a full SIS import when you do this. If you have a lot of enrollments, this technique is not very efficient, but if it was a small incremental update, then this might actually be quicker.

A third way that I just thought of works for small enrollments.csv files. That's to take the user IDs that are in the file and search for them from the Admin People page. You can also take your provisioning CSV file and use a find feature to look for the user_ids. The match() is faster, but only if you know how to use match().