Sunday, January 13, 2019

CSV Import of Currency Exchange Rate > Invalid effective date reference key

The error is generated when Date Format of the Effective Date column in the CSV file is inconsistent with that of Home > Set Preferences > General tab > Formatting portlet > Date Format field.


To resolve:
1. Modify the Date Format in the CSV file to match that of the preference.
2. Modify the Date Format in the preference to match that of the CSV file
3. Modify the Effective Date value during mapping by clicking on the pencil/edit icon and setting the default value that matches the date format of the preference. 

No comments:

Post a Comment