Question

Imported excel validation check

0

Good day everyone. I need to validate an import Excel file(5000 lines or more and approximately 30 Columns). Some rows are mandatory, some are conditional. How to validate the excel file during uploading the file to the system? Can someone give me an idea how to do it? Thanks in advance for any suggestion.

asked 2024-09-05

Selcuk Emre

1 answers

Vicky Schnitzler · Answer 1 · 2024-09-05

Hi Selcuk,

A way to approach this is to have the data imported to temporary objects and create the permanent objects by using microflows with the needed validation.

I do not think it is possible to do the validation during the import itself, unless all the mandatory values are also key values. In that case you could mark the mandatory fields as key fields and make sure the rows with empty key fields are not synchronised:

https://docs.mendix.com/appstore/modules/excel-importer/#ignore-objects-with-empty-keys