User not found for enrollment in SIS Import API

[jessHervil]

Hi!,.

I am having errors during my SIS Import with:

• enrollments.csv - User not found for enrollment (User ID: xxxxxs, Course ID: xx, Section ID: 30226_2025FATRAD)

I am wondering if something in my API call might be wrong and is where I need your help.

My API call is: $url = "https://$domain/api/v1/accounts/xxx/sis_imports.json?import_type=instructure_csv&override_sis_stickiness=true&multi_term_batch_mode=true&change_threshold=100"

I read on another post that this error might be related to the multi_term_batch_mode which I set to tru and I added the threshold as well, I am even receiving this errors if I try to import using the UI. 

What am I missing? Please #sendHelp

[chriscas · Accepted solution]

Hi @jessHervil,

I don't think there is anything wrong with the API call you're using (unless you wanted to use different options, that's up to you).  The error you're getting is really referring to the content of your CSV file(s).  It's indicating for the enrollment line referenced, it can't find a user with the sis_id that's indicated as the user_id in the file (since these are sis csv files, the data is matching the sis+id in Canvas, not an internal Canvas usr id number).  So this may sound silly to ask, but have you verified that you do have a user with that sis_id in Canvas?  That's the first thing I'd check at least.

-Chris

[chriscas · Accepted solution]

Hi @jessHervil,

I don't think there is anything wrong with the API call you're using (unless you wanted to use different options, that's up to you).  The error you're getting is really referring to the content of your CSV file(s).  It's indicating for the enrollment line referenced, it can't find a user with the sis_id that's indicated as the user_id in the file (since these are sis csv files, the data is matching the sis+id in Canvas, not an internal Canvas usr id number).  So this may sound silly to ask, but have you verified that you do have a user with that sis_id in Canvas?  That's the first thing I'd check at least.

-Chris

[LindaWilin1 · Accepted solution]

Hello @jessHervil ,

I hope you've solved your mystery.  Incase you haven't, I receive this similar error when I'm using a csv file and the SIS Import function and I've forgot to add the leading zeros to the SIS_User_ID.  Our IDs are 9 characters long.  So when a person's number is less then 9 characters, leading zeros have to be added to the SIS_User_ID column in the CSV file.  I fix this by clicking on the column, choosing 'format Cells', choose Category of Custom, then Type of 0, and then add more zeros in the Type: field until there are 9 zeros.  Tip, if you save the csv file and re-open it, you'll have to add the leading zeros again before using the SIS Import.  Hope that helps.

[jessHervil]

Thank you for your replies! I confirm y issue was related to an unmatching SIS ID! which I already fixed. Again, thanks for your set of eyes 🙂