AnsweredAssumed Answered

Leading Zeros CSV SIS Imports

Question asked by Bradley Moser on May 6, 2015
Latest reply on Jul 1, 2015 by David Willmore

I am working with our SIS, Tyler SIS, and the data we pull comes with leading zeros for our teacher IDs. After I export it, manipulate it in Excel or Google Sheets, then create the CSV file and re-open that CSV file I find that the user_id leading zeros are missing. This is very annoying.

 

I found a solution by creating the CSV file and never opening it but go straight to importing it into Canvas. It will work.

 

I am asking if there is a better solution than what I am doing?

Outcomes