Excel Importer - How to reconcile Data

0
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 ?
asked
1 answers
0

Surabhi,

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,

Mike

answered