How to import CSV-file available as FileDocument inside microflow with option to skip columns?

0
I want to import a .CSV file that exists as FileDocument parameter in a microflow. The FlatFile CSV importer app-store module requests a local directory and the CSV-module requires a very strict domain model which doesn’t allow for column skipping or much customisation. What alternatives do I have to import a CSV file into my system? Seems a bit odd a file within a microflow can’t be imported so easily. So, I’m open for suggestions.
asked
2 answers
1

Hi Sander, we’re using the Excel importer module to import Excel documents. This module has all the mapping configuration available by default, but only supports Excel documents as input. So we added an additional component to convert a .CSV or .TXT files into Excel.

Maybe that strategy suits you better or?

answered
0

Have a look at the flat file importer, this allows you to import the files by creating a configuration taht allows for skipping columns. See https://marketplace.mendix.com/link/component/429

answered