Data Types issue in MDM import Manger

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

I aready did the same I have choosen the matching field too. All other fields are getting updated other than Postal code. So i assume It is due to mismatch datatypes of source and destination fields. So my questin is can we map numeric data type with Text data type?

Regards,

Venki

[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