Skip to Content
0
Former Member
Jun 30, 2009 at 05:08 PM

MDIS Value Map and Add

40 Views

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.