Skip to Content
avatar image
Former Member

Data Types issue in MDM import Manger

Hi All,

I need to import the data from .xls file to MDM. I have a field Postal code in MDM main table and the same field is exists in source file too. In import Manager It is displaying the data types as Numeric in source and Text in destination. When i map, the fields are getting mapped but the values are not inserting/updating in destination MDM.

Can any one help me on this.

Regards,

Venki.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Mar 31, 2010 at 07:04 AM

    Hi Venki,

    please check if you map against the correct destination field.

    1. If you want to umport/update record in the main table you ned to choose for Source Hierarchy the Excel sheet with trhe data and for Destination Hierarchy - the Main Table. Then map all fields you need - you need to have at least 1 key field (e.g. Material Number, Vendor number, etc. against which you will do the matching). Then make sure that you map the needed fields(Postal Code) to Destination field (F). Then just choose the Key field as a Matching field and choose import action Create/Update All Fields and execute the upload.

    This should work.

    BR,

    ILIN

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Venki,

      yhis is not a problem - you can map numeric data type with Text data type. I have test it again now and it works fine and the field is updated as desired. What do you see on the tab: Map Field/Values below in the Source Values - you need to see your values which you want to import with a green dot in front, which means that they will be added. And also for the Update Action choose: Update All Mapped fields and let me know what is the result when you execute teh import?

      BR,

      ILIN

  • avatar image
    Former Member
    Mar 31, 2010 at 09:51 AM

    There was problem with the data manger, I loged off from data manger and re-logged in to make it work.

    Add comment
    10|10000 characters needed characters exceeded