Crimson FAQ- How to Resolve the Excel Date Import Issue

 

There is a known issue with Mac Excel versions that are from 2008 or older. These Mac Excel versions can manipulate the date by about 4 years when they are imported into Crimson. 

The dates will look correct in your Excel, but when you upload the file to Crimson, the preview of the file in Step 1: Upload File will show incorrect dates and Crimson will also generate the notification below if it detects dates older than a year: 

 

 Image

 

Updating the Excel File to Correct Dates before Importing: 

Once you receive the notification above, you’ll need to follow these steps to correct those dates before importing the file. 

  • Open your Excel file, then copy and paste the date column into Notepad. 
  • Open a new Excel file, then copy and paste all of the fields from the original Excel, EXCEPT the date column you already copied into Notepad, into the new Excel file. 
  • Now, copy and paste the dates from Notepad into a column in the new Excel file. 
  • Save the new Excel file and then exit it. 

NOTE: Some versions of Excel have a default setting that does not include Leap Year dates in their formatting (formatting that occurred before January 1904). To fix this and prevent further problems, see https://support.microsoft.com/en-us/kb/214330 and follow their guide based on the version of Excel that you have. If this problem exists in a file that did not originate from you, contact the organization in which you received the file and alert them to the potential issue. 

  • Go to the Import module in Crimson and attempt to upload the new Excel file you just saved. 
  • Confirm that the dates look correct in Step 1: Upload File and that you’re not receiving the notification about detecting dates older than a year in the file. If everything looks correct and you’re not receiving that notification, continue through the Import steps to upload your file into Crimson. 

 

**Please reference the Crimson: Importing – List of New Contributions guides on the HelpDesk for more information about importing into Crimson.

Have more questions? Submit a request

Comments

Powered by Zendesk