Skip to Content
avatar image
Former Member

Value conversion in Import manager

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 08, 2007 at 02:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 08, 2007 at 02:45 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded

    • 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.