Question

Validation on Excel sheet when using Excel importer

1

Hi, I have an issue with the Excel imports that I have to do. We are importing updated (new) Excel sheets on the same templates. I want to validate that the updated Excel sheet has exactly the same structure as the Excel sheet I used in the first instance, to prevent wrong data to be imported to the staging table. Annoyone knows a good solution? I preferably want to do this check before the import starts.

asked 2015-11-27

Sebastiaan van der Plaat

1 answers

Chris de Gelder · Accepted Answer · 2015-11-27

AFAIK it imports the columns as provided and you have to check the data afterwards. You can patch the excelimporter that it only imports the first line (I once did), that line should be the columnheaders. You can check them. After that use another template to import all lines.

Better alternative is to ask Mendix to perform a check against the columnheaders.