Excel Importer - How to reconcile Data

Hi, I am  using the Excel Importer Module from App Store to upload legacy data. However I don't see any way of knowing why there were any failures if any. Is there any way to check errors ? How do we know why some of the records failed to load ?
1 answers


AFAIK, there is not an error tracking capability in the Excel Importer module.  The method I use is to

  1. import a spreadsheet into an interim table, with the Create An Object For Each Row setting selected
  2. once the data is in Mendix, create a microflow to process it

This approach enables you to validate your data, set associations and keep track of which records have an have not been processed.

Hope that helps,