HOW TO IMPORT AN EXCEL IN MENDIX 10 | Excel Importer

Welcome guys, My name is Ricardo Pereira and today I going to teach you how to import an excel file using Excel Importer module in Mendix.
Mendix With Me Community
Discord: discord.gg/YHre8dXz3q
Medium: medium.com/p/511cf2f765ed
#mendix #mendixstudiopro #lowcode #excel #importer #howto

[@KuzcosPoison]

Hello Ricardo, thank you for the video.
How would I do this when executing an item search (for my app) that grabs from multiple non persistent entities, and then exporting the search results?

[@주지찬-v3u]

정말 도움이 많이되고 있어요 from korea

[@ciandravilletepancho6884]

Worked on me, thank you!!

[@ciandravilletepancho6884]

Subscribed!

[@KundanKumar-ey7el]

Hi Recardo, Awesome video but some bug is there in the code. When we select other excel file, those records also getting imported. please rectify that bug in the code/mf, and let me know as well. thank you!

[@MrCP-ds7nz]

Hi, Ricardo! Good example, but how to make the same with an entity with more attributes?

[@MendixWithMe]

Hi, it should be the same. You can apply the same logic you saw in this video to the new attributes

[@ashishlathigara9602]

I am facing error for activity - StartImportByTemplate. Error in console is - If custom error handling is enabled there must be an outgoing sequence flow set as error handler.

[@MendixWithMe]

Hi @ashishlathigara9602, right click on the arrow below the java action activity and select "Set as error handler".

[@ashishlathigara9602]

@@MendixWithMe Thanks for the reply. But I already have fixed in the same way..!! Although having another error related to my fields.

[@ashishlathigara9602]

I am trying to import Attendance using an excel (emp id, email, month, year, present days, absent days, total working days). Attendance is associated with Employee and in the template I have set email as reference, it doesn't work in the way you show. It throws following error: "The following error occurred while import document: attendance_XLSX(1).xlsx - requirement failed: Reference 'MyFirstModule.attendance_employees' only accepts ids of type 'MyFirstModule.employees' (Id '[MendixIdentifier:: id=23080948090338298 objectType=MyFirstModule.Files entityID=82]' is not allowed)." Kindly let me know if I am wrong at any point, let me know if you need any other information.

[@MendixWithMe]

@@ashishlathigara9602 Send me a DM on Discord discord.com/invite/YHre8dXz3q