Team, We have requirement to provide excel import option to end-users and so we need to have custom logic for records-validation/processing records before it gets saved into DB. I understood Mendix provides Excel Importer plugin, which more works based on template(first template should be created and post-which template should be selected for uploading excel and directly loads records into DB). This might not be useful in my use-case. Could you pls share your thoughts on any approach, that can work here. Appreciate inputs..! Thanks.!
The Excel Importer includes functionality to add custom microflows for data processing. It uses the MxModelreflection to allow you to select a microflow for processing when you create a new template. You can set a different microflow for each column in your sheet: