Value conversion in Import manager

[Former Member]

Hello everyone,

My question is. I have a field containing a code, lets assume it is a country code (123) which actually refer to country Spain. I have a country code (123) field in my source system, but in my data manager I want to see a country name (Spain). Is it possible to write some program to make that mapping in Import Manager, so I import country name to my repository, not the code?

[Former Member · Accepted solution]

Yes, while importing, the field containing this value (lets say it's called "Country") will show the countryCodes. You'll have to either load first the Country-Code relationship, and then just map, or manually transform each code value into the String value.

the first approach is more maintainable. Create a table for country/codes equivalences and load all the countries. Then in your main table, create a lookup field to point to this table. Remember to set the CountryName as displayField.

while importing, do an automap and this should do the trick

Greetings

Alejandro

[Former Member]

Well, the problem is that I can't change my repository tables... So the only place I can do the change is Import manager.

And as I understand there is no workaround for not doing this manualy...

Thanks!

[Former Member]

In Import Manager, Click on the tab, Map fields / Values in the Field Mapping grid and select the field (Country in this case). Below that you will see 'Value conversion and mapping' grid. On the left side, source values will have provision to convert them. Here, you enter the converted value (For eg value '123' - converted to 'Spain').

Hope it solves your problem.

Thanks,

Satyanarayana.