Error Uploading Majors

  • 1
  • Problem
  • Updated 9 months ago
  • Acknowledged
I exported the majors from Administrator, made changes to the file that was exported, now I get an error when I try to upload the edited file.   If I export the majors, then upload the same file without ever opening the file, it uploads succesfully.  However, when I open the file, even if I don't make any changes other than reformatting the dates back to mm/dd/yyyy, I get an error message (see screenshot).  I see others have posted the same issue but the posts don't have a solution. 
Browser: Chrome
OS: Windows 8 - 64bit
Excel 2013

Photo of Mirna Duarte

Mirna Duarte

  • 35 Posts
  • 0 Reply Likes

Posted 9 months ago

  • 1
Photo of Charley

Charley

  • 4 Posts
  • 1 Reply Like
Just out of curiosity, what OS and app are you using to edit the file? I’ve had problems submitting MIS files in the past when the files have the Unix line break instead of the Windows line break. I recommend opening and saving the file using Notepad or a text editor like Ultra Edit which has a function to convert Unix line breaks to Windows. Hope this helps.
Photo of Michael D. Ward

Michael D. Ward

  • 7 Posts
  • 8 Reply Likes
Yes, similar to as Charley mentioned, the issue is when you edit the file on a PC at the end of each line (new line / Enter or Return key) the PC will use a Carriage Return (Hex 0D) and Line Feed (Hex 0A) character (CR+LF).  For Linux/Unix/Mac, they only use Line Feed (LF) and the CCC Tech Center server is most likely a Linux or Unix server so it does not handle the CR which causes the error.  This was mentioned to CCC Tech Center Support and it looks like the programmer/developer already implemented a fix in Pilot.  From what I heard the fix will eventually make it into Production soon this month too.  In the meantime, you will need to use a conversion utility program or a text editor like UltraEdit or Notepad++ which have built-in file conversion features that you can convert then save the file in the format that the server needs.
Photo of Michael D. Ward

Michael D. Ward

  • 7 Posts
  • 8 Reply Likes
If using UltraEdit, the conversion feature may be under:  File, Conversions, DOS to Unix. 
If using Notepad++, the conversion feature I think is under:  Edit, EOL Conversion, UNIX/OSX Format.