Issue while importing excel data using Advance Excel module...

0
I have used AdvanceExcel marketplace module for exporting data from mendix to excel it works fine. At the same time while importing from excel i am facing some issues because of a particular attribute which is of DateandTime attribute. But importing MicroFlow works fine with String type attributes. How to Solve this error...  
asked
2 answers
0

Hello Vasanth, 

 

Have you already tried to fill in the attribute mapping property.

I think the system tries to map StartDate on your age attribute.

You can overcome this with the attribute mapping or by creating matching names like the caption describes.

 

Hope this works,

 

Good luck

answered
0

Hi Vasanth,

 

Please check below options.

 

Option 1: Import the column data as a String value even for Date columns. Then after import, convert the Date string value into actual Date.

Option 2: Add the logic to convert the String Date into Actual Date in import microflow and then store that in Date attribute.

 

Thanks,

Steffy D.

answered