Uploading users.csv in batch mode

Jump to solution
ianjohnston
Community Novice

We are looking at manually running our users SIS import process in batch mode once a year to keep our user's list cleaned up. I began testing this in our test instance using a blank users.csv file to make sure this type of process would not have an adverse impact on our manually created user account. The issue I ran into is doing a batch import requires that you specify a term and as far as I can tell users do not belong to any term so running the users.csv file in batch mode appears to have no effect. What is the proper way to upload a users.csv file in batch mode?

1 Solution

 @ianjohnston ​ one approach would be to leverage the provisioning report.

  1. Run a provisioning report on users.
  2. Use your users.csv report to compare against the provisioning report, and flush out the students that are not listed in your users.csv report (Excel would be a good tool to use for this).
  3. Once you have the list of students who no longer exist, make a new uesrs.csv file from that list, and change the user "status" to "deleted"
  4. Import your "deleted" users.csv file to remove the unwanted records.

Have you already tried this?

What was your solution?

View solution in original post