Question

compatibility issue between the data

1

I need to address a compatibility issue between the data in my Excel file and the Mendix domain model. Specifically, the attribute in the Mendix domain model is set as dateTime, while in the Excel file, it is represented as a string. Is there a solution or method to reconcile this disparity during the Excel import process?

asked 2023-12-13

UmaMaheswara Padhi

1 answers

Patrick K · Answer 1 · 2023-12-13

Hi UmaMaheswara,

I believe most standard notations are supported to automatically import as DateTime attributes but if the value changes or it throws exceptions. You can use the parse with option in the excel importer and create a microflow using these functions: https://docs.mendix.com/refguide/parse-and-format-date-function-calls/

Documentation for the parse with: https://docs.mendix.com/appstore/modules/excel-importer/#parse-with