Question

Uploading data from excel

0

I have excel importer and MX modeler, but am trying to build the framework to actually upload the files. Do i need to make a microflow for every every attribute on the excel file (every column)? I feel like i shouldn’t but I keep getting an error trying to do it the way the documentation says to do it (one microflow).

asked 2019-04-04

Peter Kalivas

2 answers

Quang Nhat Tran · Answer 1 · 2019-04-05

1- Go to reflection tick all necessary module to refresh all entity and microflows

2- Create excel template or import excel from this menu to create an template

3- then write a flow and map to the button on object grid view, when press a button, will show a popup to select import file. micro flow behind should be like this

Done, you can import excel to entity that you want.

Martijn Rijneveen · Answer 2 · 2019-04-04

Hi Peter,

Can you give us a bit more information? What kind of columns do you have in your Excel file and how does the entity structure within Mendix look like? Also, what is the error you get?

To answer your question: it is not needed to create a microflow for every attribute, if your cell value (column header in Excel) is the same as your attribute (attribute of your entity in Mendix). However, you need to make sure your caption is spelled correctly!