Mendix supports multiple options to import data in an application, and all of them proves to be really good based on the requirement of the source type.
In this blog, I’ll focus on one such method which is importing and exporting CSV-formatted data with the help of Mendix offered module called CSV module. When we have a lot of data to import, CSV is a great option which we can think of while the source is Excel.
CSV Module offers some cool advantages, as mentioned in the marketplace :
The Community Commons Function Library module provides a number of reusable Java methods for our apps, which can be called from microflows or other custom Java actions. Most of them are generic while a few are specific, but we have the possibility to adjust them all based on our needs. It’s all Java from here, but don’t you worry, we’ve got it!
I will walk you through customizing java actions by using an example I faced.
The situation was to set the value of an attribute PrevStatus of type “Enumeration” based on a “String” type attribute returned by another object.
I have been working as a Mendix Developer and being a developer we have to face new challenges everyday and think out of the box exploring new possibilities. Thankfully, Mendix is there for the rescue !
During one of my development task I came through a situation wherein exposing data via REST in CSV format was required. But to return an object via REST Service we need to first define an export mapping which as of now can be either JSON or XML mapping. The third option is to return a file.
Now, the challenge here was to return object…
Mendix Developer- Learning, Building, Growing