I know this has been discussed but I'm running into a peculiar problem.
For Default MDIS Handling:
Automap unmapped values: Yes
Unmapped value handling: Add
I'm trying to import into Catalog Items table.
The field Supplier is setup with 2 display fields: ID and Name.
The field Product Group is setup with 2 display fields: ID and Name.
The field Category is setup with 2 display fields: ID and Name.
Category ID and Product Group ID are the same value, the ECC Material Group #.
The ECC extract only has the ID's for all 3 fields, and I'm getting 3 different types of behaviors.
Automap for all 3 fields should NOT happen, since the source only has the ID, where as the destination has ID and Name. And I have not saved any template in the mapping as suggested by other posts.
Supplier mapping fails, and the unmapped values are not added to the Supplier table, creates ValueX exception.
Product Group automap is successful (I'm not too sure why), even though the source only has the ID.
Category mapping fails, and the unmapped values are ADDED to the Categories table.
So 3 fields and 3 different kinds of mapping behavior. Any clues?
Thanks.