Hallo dear community, I am new to Mendix and in my project I am working on the following use case: A page with a load/save button and a view to represent data. The data is coming from csv files. The loading process of the csv content is released by pushing the button. The problem I am facing now is that the content of the csv is not consistent. That means the amount of columns can vary. Also the names of the columns not fix or the data types that are hold in the rows. What I know from now is that to represent data in Mendix we have to create an entity which will describes the data for the view. But this is static way and will not help me to load all the different contents in the view. So my questions are: Is it possible with Mendix version 10.6.4 to represent dynamic content in a view? What view type, modules and java actions do I have to use to implement the use case? Exists examples, tutorials or academy constributions to this topic? Thank you veriy much in advance for your help and tips. Best Regards, Stephan Franke
asked
Stephan Franke
1 answers
1
When the csv is not consistent and the number of column changes and the content changes this will be difficult to import and show in a single page as the underlying entity is strongly typed. You will need a differetnapproach to importing the data. Maybe you need to normalize the data in different obejcts and read the csv column by column, determin the type and create a row entity for each read row and associated entities to hold the strings, integers, etc. So that you can import the data and then with microflow logic create the data in a singel entity with enough columns to respresent the data. The csv files will need to be processed with some java action though.