AnsweredAssumed Answered

SIS import Issue

Question asked by Asha Vanch on Jun 11, 2017
Latest reply on Aug 26, 2017 by chofer@morainepark.edu

Like • Show 1 Like1
Comment • 8

I am testing my SIS integration. I have SSIS packages creating the csv files that are uploaded to Canvas via curlScript. I tested uploading the files manually via the SIS Import in Canvas website. All the files get uploaded manually except the student_users file. I checked to see if there are any characters that are in this file but I cannot find any. There were a couple of times when I was able to upload the same exact file manually via SIS import (through the website) but I got the error message when the curlScript executed
I wanted to find out if any of you out there had any similar issue and is there any work around that you did to get this working. Thank you-Asha

No one else has this question

Outcomes

8 Replies

James Jones Jun 11, 2017 8:58 PM
Mark Correct
Correct Answer
Asha,

The image of your error didn't come through. It links to a file in your Outlook Web App, which we don't have access to. Can you fix that so we can see what's going on.

You may also need to do a screen shot of the first couple of lines of the CSV file that is failing (you can blur out any student information).

Since I don't yet know if the error message is Canvas related or cURL related, you may also need the code that you're executing.

Sometimes an error message is enough to figure things out, but often it takes more information about what was going on.
3 people found this helpful
Like • Show 1 Like1
Actions
- Asha Vanch @ James Jones on Jun 11, 2017 11:26 PM
  Mark Correct
  Correct Answer
  This is the error message I am getting:
  Error while importing CSV. Please contact support. (Error report 53,630,000,918,170,656)
  
  Asha Vanch
  Information Technology Services
  Rancho Santiago Community College District
  Phone: (714)480-7421
  Email: vanch_asha@rsccd.edu
  2 people found this helpful
  Like • Show 0 Likes0
  Actions
  - James Jones @ Asha Vanch on Jun 12, 2017 12:32 AM
    Mark Correct
    Correct Answer
    Thank you, Asha.
    
    That error message is not going to be helpful to anyone here in the Community as it's specific to your institution and we don't have access to it.
    
    That error report is an ID that someone will need to look up the error report. That is not an error code that you can look up somewhere to know what it means. I'm a Canvas admin for our site, but I'm not the Canvas Admin who handles error reports and I couldn't tell you where to look for this. That means that it might possibly be in the tracking system where help tickets go. Again, this is conjecture.
    
    However, that error message is generated in the /lib/sis/csv/import.rb file of the source code and that isn't going to be much help without the error report. Basically, any error in the process generates that error message, so looking at the code doesn't help you figure out what caused it. Since I don't know what's in those error reports, I also cannot know how helpful they're going to be.
    
    Since I don't know how to get at that error report, let me throw something else out there and see if it will help. You can get a list of the SIS imports using the Get SIS import list endpoint. It returns information about the SIS imports, with the latest one first.
    GET /api/v1/accounts/:account_id/sis_imports
    A normal one looks like this. Once the progress reaches 100, it should have a workflow_state of "imported".
    
    If there is a problem, though there will be a couple of differences.
    
    The first is that the workflow_state won't be "imported". In my example, it's "imported_with_messages". I can't say what it is in all the cases; we have a controlled system where I do a lot of error checking first to make sure it's smooth, so we rarely have a problem with the format of the file that causes it to be completely unusable.
    
    The second is that there is a "processing_warnings" section that may provide additional clues as to what went wrong. In my case, it was in the users.csv file and I had the same login information for two different users. However, other people have talked like there may be an error_report_id and I don't have an example of that to know if the processing_warnings (or something similar) is still there.
    
    Here are some other places in the Community that I found helpful while researching this.
    SIS Imports - Show Robust Errors and Human-Friendly logs
    SIS Import Report -- and in particular Garth Egbert's comments about the error_report_id means that you should let your system admin know about it. I don't know if he knows what the admin had to do to find the error.
    
    You may be experiencing a different issue altogether since you said the file sometimes works through the web interface. That means it might be a setting with your cURL that is keeping it from processing correctly. But I would start with the SIS Import list and see if that helps you.
    3 people found this helpful
    Like • Show 1 Like1
    Actions
Teri Ross Jun 12, 2017 8:47 AM
Mark Correct
Correct Answer
You generally have to call support on that error. They are able to see more than you admin can on what happened.
4 people found this helpful
Like • Show 1 Like1
Actions
- James Jones @ Teri Ross on Jun 12, 2017 11:48 AM
  Mark Correct
  Correct Answer
  Thanks, Teri, I wasn't sure how to handle it. My experience has always been it's something I'm doing on my end if it doesn't work and I figured it out without needing to contact help so I wasn't sure what to do.
  3 people found this helpful
  Like • Show 2 Likes2
  Actions
Garth Egbert Jun 13, 2017 7:12 AM
Mark Correct
Correct Answer
Asha Vanch the issue is most likely related to the foramt of the data, here is what I would do to debug this issue.
Just to be safe, I would use either Beta or Test to do this, not the production instance:
- Get sample data from here:
  SIS Import Format Documentation - Canvas LMS REST API Documentation
  Specifically, data associated with the "users.csv"
  Sample data from that page:
  Sample:
  user_id,login_id,authentication_provider_id,password,first_name,last_name,short_name,email,status 01103,bsmith01,,,Bob,Smith,Bobby Smith,bob.smith@myschool.edu,active 13834,jdoe03,google,,John,Doe,,john.doe@myschool.edu,active 13aa3,psue01,7,,Peggy,Sue,,peggy.sue@myschool.edu,active
- Create your own csv file manually using the sample data, and import it into your Canvas instance to confirm it is working properly.
- Compare your automatically generated csv file with your new manually created csv file to determine what is different
- Make adjustments to your auto-generated csv file and try your process again
2 people found this helpful
Like • Show 0 Likes0
Actions
Garth Egbert Jun 14, 2017 2:26 PM
Mark Correct
Correct Answer
Asha Vanch I just re-stumbled across this document, which includes links to sample csv files:
- http://guides.instructure.com/m/4214/l/164118-how-do-i-format-csv-text-files-for-uploading-data-into-a-canvas-account
I hope this helps.
2 people found this helpful
Like • Show 0 Likes0
Actions
chofer@morainepark.edu Aug 26, 2017 10:37 AM
Mark Correct
Correct Answer
Hello there, Asha Vanch ...

While I don't have an answer for you myself, I wanted to check in with you because we've not seen any new activity in this thread since June 14th. Have you had an opportunity to review all the responses you've received above? Did any of them help to answer your question? Or, are you still looking for some help with your initial question? If one of the above responses helped to answer your question, please feel free to mark it as "Correct". However, if you are still looking for some help with this question, please let the Canvas Community know by posting a message below. For now, I'm going to mark your question as "Assumed Answered" because there hasn't been any new activity in this particular thread for over two months. However, that won't keep you or others from posting additional questions/comments below. I hope that's okay with you, Asha. Looking forward to hearing back from you soon!
1 person found this helpful
Like • Show 1 Like1
Actions

SIS import Issue

Outcomes

Related Content

Recommended Content