Allow the possibility to configure the hard-coded date format used in ExcelImportService when string-type date is detected

[sct999]

Hi, it would be nice to allow the configuration of the date format used in ExcelImportService.

Just today I ran into an issue with this :)
In my app, dates are meant to be in dd/MM/yyyy format, and some user entered them as text...

[Michael-Habbert-mpf]

We had the same problem.
A few days ago we extended the property-map like:

static Map propertyConfigurationMap = [
releaseDate : ([expectedType: ExpectedPropertyType.DateJavaType, dateFormat: "dd.MM.yyyy", defaultValue: null]),
]
and added the dateFormat handling to the ExcelImportService like:

String dateFormat = DEFAULT_DATE_FORMAT
if (propertyConfiguration.dateFormat) {
dateFormat = propertyConfiguration.dateFormat
}
def df = new java.text.SimpleDateFormat(dateFormat)

May be I can provide a pull request for that.

[sct999]

Hi @Micbert thank you a lot for your answer, we already had overriden some methods in the excel import service, for now I changed the default date format (as a temporary solution).