Question

Database Replication - for data migration

1

Im using DB Replication module for data migration. The issue is, in my source DB I have some columns with type "String". But the mapped attribute in the mendix entity is of type "Enumeration". So, when im trying to map a string with enumeration, we are getting NULL values. Can someone suggest me how to resolve it. Thank You

asked 2017-06-07

Ganesh Gandipally

2 answers

Sushuma Bandanadham · Answer 1 · 2017-06-21

When doing the column mapping, we have to select the Format with microflow as Yes and map the microflow which consist of converting the String type to Enum which is written in modeler.

In the microflow we have to take parameter which accepts a String type. Now we can create a variable of type enum and based on the parameter we have to do conditional handling and assign the enumerator value to the variable and finally we have to return this variable at the end event.

At times even though we have created a microflow, this won't get reflected in the application when we try to do the mapping. So we need to open the model reflection page and check the module where the microflow is present and click to refresh. In this way we can view the microflows.

Regards,

Sushuma

Ronald Catersels · Answer 2 · 2017-06-07

Are you able to trigger a microflow during the import? I do not the DB replication module well but for instance the Excel importer you can call a microflow where you can do conversion stuff. In the microflow you need to map the strings to the right enum.

Regards,

Ronald