Skip to Content

Issues for multi combined remote key mapping


I have 2 problems for import data from external system to SRM-MDM Catalog lookup tables.

  1. I add a field 'condition id' to the Price table which already have a field 'info record id' .I want a combine of this two fields as a unique key for this table.But when it comes to the import manager for importing data,only one field can be mapped to the Remote Key,how can i combine the two fields value and map to the Remote Key?
  2. As Price table have some qualified field such as 'Amount','Currency',I mapped all the non-qualified fields and compound the qualified fields as price information,then mapped the price information and its qualified fields and set value mapping as Add.After set match records,the import status said 'Ready to import'.But error message said 'some records could not be imorted' after excute, the log showed 'Import failed. Unable to retrieve qualified lookup field id'. I added some records in the Price table manully, then did the import map again, record succeed update to the Price table and its qualified fields. The only difference between this two is the compound price information value mapping, I mapped the source value to the manully added record in the destination field the second time,not Add.I don't know why it could not add a new record to the qualified table, even if i set MDIS Unmapped Value Handling to Add and set Qualified to Update and New Links to Create.

Could anyone tell me why and provide any solutions?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers