cancel
Showing results for 
Search instead for 
Did you mean: 
swaldie
Community Participant

Report listing status of recent CSV import attempts

Jump to solution

Following is a list of CSV files generated from our SIS:swaldie_0-1621535081379.png

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?

swaldie_1-1621535214440.png

Where else can I find this info, if not.

0 Kudos
1 Solution

Accepted Solutions
robotcars
Community Champion

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.

 

View solution in original post

0 Kudos
2 Replies
robotcars
Community Champion

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.

 

View solution in original post

0 Kudos
swaldie
Community Participant

@robotcars - thank you!