Question

Upload File

1

I'am new to mendix. So I need to upload excel, parse it, and save data into db. How can I upload a file, and pass the file to a microflow.

asked 2012-10-04

Nikola Ivanov

3 answers

Pieter van de Braak · Answer 1 · 2012-10-05

You can upload a file with the file manager widget. You need to put it in a dataview that points to an entity that is a generatlization of system file document. Then you can pass that entity as an input param in your microflow and do anything with it you like.

However as Ankit pointed out, it really does sound like you would like to use the excel importer.

Ankit Kavi · Answer 2 · 2012-10-04

create a microflow that retrieves the template you are using from the excel importer package. check to see that the template is not empty. if it isnt, call the java action in excel importer called start import by template.

hope this helps.

Lex van Rooy · Answer 3 · 2012-10-07

Nikola

the "basic" modeler created application only has a facility to import/export XML. However the APPstore has a component that you can download from the appstore and that will add functionality to your APP in the modeler.

Download the component from the APPstore and follow the guidelines to merge it into your project.

Now if you deploy you project you will find a specific set of screens that allow you to identify the EXCEL to import, define the parsing parameters, and actually import the files and process them into your application.

Note that this means that importing EXCEL stuff NEEDS to be done in a "life" environment.

Hope this clears things up for you