can someone help me in explaining how to implement excel importer to import data into mendix entity from excel file? i have already installed mx reflection and community common modules bbut stuck on further steps
Download and import MX model reflection and Excel importer from Mendix Marketplace.
Add the overview page of Mx model reflection and Excel importer from _USE_ME folder in your App’s navigation.
Run your application locally.
View your application in the browser, you can see MXModelReflection and ExcelImporter.
Go to MXModelReflection, Refresh once by clicking the Click to refresh button under the Modules column.
Choose you Module from Module column for which you are going to use Excel as data.
Go to ExcelIporter click on New template , pop window will get open , Fill the details as shown below
Give the Random Name and click the right arrow button in Mendix object to choose the entity of the module and fill the other things as it is shown in the below screen shot.
Click save and next.
Go to the columns ->Connect columns to attributes->connect col nr with your excel sheet->choose the primary key->Save.
Go to import file->import your excel from your local device.
Go to Mendix and check your database , you can see the data imported from your Excel sheet.