Difficulty troubleshooting user uploads via CSV

[Rachel_P]

I'm trying to learn how to import new users via CSV. We do not use an SIS. After I import them as users, I will be adding them to a course as students. 

When I try uploading a test users CSV, Canvas tells me that the import has been successful, with no error messages (see attached image). But then the test student I have uploaded does not appear in the "People" section of our account. 

The header row of my CSV is also attached as an image.

Any thoughts about what might be going wrong here? 

(Sorry for the attachments: the forum interface isn't showing me an option to upload an image directly into my post, and it won't let me paste images into my post.) 

[Sandie]

Hi @Rachel_P 

I use this simple CSV headings. Leave integration id blank if you know use it. Status put in "active/delete". We don't use inactive as we use SSO as well. Cant remember if that's inactive/suspend. I think inactive for course enrolment and suspend for account suspension.

user_id

integration_id

login_id

password

first_name

last_name

full_name

email

status

Hope this helps!

[NicoletteStaley · Accepted solution]

@Rachel_P I recommend that you review the formatting of the users.csv to use for Canvas SIS imports.  This formatting is covered in the How do I format CSV text files for uploading SIS data into a Canvas account? .  Included in the guide is a sample users.csv file that you can use as a template to input your user data.  Canvas isn't creating a new user when you upload the file because the declared_user_type isn't a supported heading.  Since users in Canvas can have multiple enrollment types, there is no use for this field.  

What you are seeing on the "success" page after the import is that Canvas saw one user in the users.csv that you uploaded--that doesn't mean that Canvas created a user or that there were any state changes that resulted from the imported data.

[Cyn7]

I'm having a similar issue.  I have many staff in my LMs and I want to add students as students to be able to sort them later. According to the current SIS Import Format Document, declared_user_type is certainly a heading.  It's in there.  It is useful, but it doesn't work.

Either A. Canvas doesn't support it anymore and hasn't updated it's SIS documentation file, which is bad, as it has seriously wasted my time and make it more difficult to sort users after import.

Or B. It is not working.