Report listing status of recent CSV import attempts

[swaldie]

Following is a list of CSV files generated from our SIS:

And I would like to confirm that they were imported to Canvas.

Will any of these items under the 'Reports' tab provide that for me?

Where else can I find this info, if not.

[robotcars · Accepted solution]

Hi @swaldie 

Check out https://canvas.instructure.com/doc/api/sis_imports.html#method.sis_imports_api.show

This endpoint provides stats on an import.

It includes:

• supplied_batches - what types you sent in - users, sections, courses, terms etc
• counts - how many rows were imported for each type
• statistics - how many {created, restored, deleted} objects were passed for each type
• csv_attachments - each file you sent, including upload status
• completed_importers - which supplied batches were completed.

Supplied batches and completed imports are grouped by CSV type.

It does not break down whether each of your files was imported, but you should be able to math your way through it. For example, my import workflow counts the number of rows that I created in files for a type (users in 2 files, students and employees) and I can compare this to the number of users imported in data.counts.users.

Additionally, unless the importer returns anything but 'imported', there should be an error status, which should reveal which rows had issues. If there are no errors, each file was imported.

[swaldie]

@robotcars - thank you!