Question

Problem Populating Enums with Excel Import

0

I have an Excel Import template that imports about 3 data fields. 1 of these fields are defined as a enum in the entity. All the data is populated in the Excel file being imported. However, I am consistently seeing blank data being populated in enum fields. What could cause this? They are actually null values in the database also.

asked 2016-04-14

Somabrata Pani

3 answers

Ronald Catersels · Answer 1 · 2016-04-15

Here is an example: https://modelshare.mendix.com/models/5b1aa87c-794e-4900-9359-fa9fccf166a0/string-to-template-status-enum

Regards,

Ronald

Dennis Kho · Answer 2 · 2016-04-15

If you want the Excel Importer to automatically populate the correct enum value, you need to make sure that the value in the Excel file is the enum key value instead of the caption value. If you use the enum key values they will get mapped automatically.

In case that's too much of a hassle, the alternative is what Ronald is suggesting.

Mitchel Mol · Answer 3 · 2016-04-14

You need to convert the data with a processing microflow in the excel import template, because for the import it is considered flat text and he can't convert that without any help.