on 03-31-2010 7:45 AM
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.
There was problem with the data manger, I loged off from data manger and re-logged in to make it work.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.