How to create a microflow to read an excel file into a database without having to write a file to a folder first.

0
It seems like as soon as you call the ExcelImporter module as a parameter it writes the imported excel file to a folder. I need to bypass this because we are using a docker image to deploy the app in AWS and we are not making use of any storage container to provide a write area for writing the excel file. I would appreciate any feedback. Thanks very much
asked
2 answers
0

Hi Pieter,

 

Looking at the Importer Microflow, you need an object of the Generalised System.FileDocument. Use the CommunityCommons Base64Encode to create a string (unlimited) in your domain model. The Base64Decode can be used to populate the Generalised System.FileDocument object. 

 

I think you will need a new widget that takes in a file from a filesystem and returns the Base64encoded string. Maybe this could work https://marketplace.mendix.com/link/component/208170 or you need to build it yourself

 

Go Make IT

answered
0

Thanks so much Marco. I will attempt this and inform whether i was successful :-)

answered