Excel import causing issue for file with complex structure

0
i have to add excel import functionality for this excel structure. this file has 2 rows for headers and around 30 columns.    https://medium.com/mendix/how-to-import-excel-file-with-excel-importer-mendix-10-fb3a5276f26c I have followed the steps mentioned in this. The import is working for a simple demo file with only few columns. But on clicking upload for this excel, it doesnt throw any error or import the file either. it just shows a loader and then nothing happens. The entity has a lot of attributes as well. What could i do to make this work?
asked
1 answers
0

Pranav,

Have you looked in the log to see if Excel Importer reports any errors there?  Sometimes I will see errors in the log with no error reported via the user interface.  In Studio Pro, look in the console after trying to import this file for any errors.  Screen shot below:

image.png

 

If there are no errors generated, the next thing I try is to import the spreadsheet into an entity with all columns having a string datatype.  This eliminates any attribute type conversion issues that may pop up.  

 

Hope that helps you move forward,

Mike

answered