How do you handle student drops through SIS?

[SwatiD]

Hello members,

We recently moved to Canvas, this is our first term in the new LMS.

We use Banner as database and Argos is the reporting tool.

Currently, I am importing Banner data through Argos and manually running the daily SIS imports.

The csv files are formatted accordingly and they are functional. Using four datafiles - Users, Courses, Sections and Enrollments.

Problem is, all newly added or switched courses are getting updated in Canvas but the dropped courses are not going away/ not dropping from the student enrollments creating confusion among students and instructors. I have crosschecked the feed files, the "deleted"/dropped course information is present in those csv imports but not updating in Canvas.

How do you manage the student drop in Canvas. Any suggestion/sharing would be helpful.

Thanks in advance,

Swati Dey

[stimme · Accepted solution]

In our enrollments CSV file, we include records of deleted enrollments with the status “deleted,” as well as the active enrollments. A deleted row looks something like this:

user_id	section_id	role	status
0101	fa24_phil_1	student	deleted

Your initial post makes it sound like you are doing the same thing. A couple of things to consider are:

1. Is your enrollments CSV using the section_id field? Since you are creating sections via SIS Imports, that would be the best approach.
2. Check the file to see that there is not a second "active" enrollment record for a user in a section with a role that should be deleted. If there are two records concerning the same possible enrollment, the second row will take effect.