after get excel file from AWS, how to show data in excel file on Mendix?
hello guys. I am trying to get file from AWS which is excel sheet. and I am trying to use excel importer to show data on excel file on Mendix. this is what I made microflow to get data on excel from AWS. for this, I have two question for you guys. is this okay to show data on Excel? if it is okay then what should I put argument below image? thank you. :) this is the detail information that I have concern. The current concerns I have are as follows: 1. I would like to check the existence of an Excel file in Mendix after getting it from AWS. 2. Additionally, I want to create the same template in Mendix based on the template inside the Excel file. 3. After creating the template, I would like to display all the original Excel information in the Mendix template. 4. It would be great if this process could be automated, so that whenever an Excel file is stored in AWS, the steps 1, 2, and 3 are repeated automatically.
You are almost there.
Your file i.e. the excel can reside anywhere. You have chosen AWS S3 which is ok.
To get the file from AWS S3 you are using the correct module
Once the file comes to Mendix runtime, now it needs parsing so that its Content can be READ and WROTE into the mendix domain model to represent it in a nice UI for your end customers. For this you are using ExcelImporter module that is also right
So based on the excel files STRUCTURE(the sheets it has, the columns per sheet etc.) you first need to create a TEMPLATE in the ExcelImporter module provided pages
Once the template is ready give it a good name which can be queried in the microflow
This Microflow where the first part of the logic is to get the file from AWS S3 (can also be a SUB MF) and the second part is using ExcelImporter Module provided Java actions or Helper microflows to Parse it into your domain model
while making the template you give the domain model entity, attributes to which you need yout excel data to be mapped
this way the Template facilitates the data entry into the domain model when it gets parsed by the MFs/JA’s of the ExcelImporter module
The existence of the file can be checked by checking the GetObject Actions Responses. It will have properties that can be checked to see if some properties are usefull which indicates the file has contents (its size, name etc.)
Now about the automation part:
Since the Automation has to get triggered from the source, basically you need to setup some kind of event trigger to Call the mendix Microflow(which gets from S3, Parses, loads etc.) as soon as the FILE gets dropped in S3.