Edge Import - Incorrect Date Format Validation

The following features are included in this enhancement:

  • Incorrect Date Format Warning Message - This functionality was released with the June 24 patch.
  • Incorrect Date Format Validation

With the June 24 patch, when data in an invalid data format is present in an Edge Import load, a new warning message is visible on the Load Details page and in the Excel error report for the load to indicate that data in an incorrect date format was present in the file. This is just a warning message and will not stop the data in the incorrect data format from being loaded. This functionality is currently available in all environments.

With this release, when data in an invalid date format is present in an Edge Import load, instead of just receiving a warning, it will not be imported. The date will be stripped from the row in the import file prior to processing. In this case the row would be loaded as if the date was not provided. The error message visible on the Load Details page and in the Excel error report will indicate that the data was not imported due to an incorrect format. Instructions to resolve invalid date format errors are included in this Knowledge Article.

The behavior described in both of these fixes occurs when all of the following conditions are met:

  • The source file is Excel
  • The file contains cells that use a date format that begins with an asterisk (*)
  • The load uses a configuration that specifies "Day First" or "Year First" as the value for the Format Question "How are your dates ordered?"

Error Message Example

How Does this Enhancement Benefit My Organization?

This enhancement helps organizations identify and prevent the upload of bad data into Cornerstone portals.

Resources

Knowledge Article: Instructions to resolve invalid date format errors

Implementation

This functionality is automatically enabled for existing Edge Import customers.

The Incorrect Date Format warning message is available as of the June 24 patch. With the August '22 Release, this informational warning message will change to a regular warning message, and the invalid date data will not be imported.

Permissions

The following existing permission applies to this functionality:

PERMISSION NAME PERMISSION DESCRIPTION CATEGORY
Access Edge Import Grants access to the Edge Import tool, which enables administrators to load data into their portal. This permission cannot be constrained. This is an administrator permission. Edge Import