Remote key mapping in Category table

[Former Member]

Hi,

We are not able to populate the Remote key in the Category table.

In standard repository the Category table only has one field 'Category Name' which is defined as Display Field.

In order for us to map customer file records which has UNSPSC code with our Category definitions we have added a field 'UNSPSC ID' in the Category table.

As 'Category Name' is the field that should be displayed we need to use the Remote Key function in order to get a unique identifier in the Category table for automatic mapping of supplier records to the Categories in the Category table. However, we are not able to populate the Remote key field in the destination table Categories.

The Category table has 'Key mapping' set to yes and in the Import manager we clone the field 'UNSPSC ID' and map the clone to destination field 'Remote Key'. However, 'Remote Key' does not come up as unique Matching field and performing the Import we can see that the Remote key is blank for all records in the category table.

Does anyone out there know what needs to be done in order to populate the 'Remote Key' in the Category table?

Please note that we are able to map and populate the Remote key field in other tables such as Product Group, Supplier etc but not in the Category table. Is there some special considerations as this is a taxonomy table?

Regards

Jan

[jason_boggans]

Dear Poster,

As no response has been provided to the thread in some time I must assume the issue is resolved, if the question is still valid please create a new thread rephrasing the query and providing as much data as possible to promote response from the community.

Best Regards,

SDN SRM Moderation Team