Manufacturer & Vendor records to the platform

[Ram117]

Experts,

I have a list of manufacturers and vendors which I need to load into the platform. The platform is enabled with Data Normalizations plugin. Most of these manufacturers / vendors are non-existent in the Normalized Company table (cds_client_name) . How do I proceed to load this into the instance and also make sure that any future load of companies do not introduce any duplicates ?

Thx

ram.

[Ram117]

I did not follow with your statement

"You only need to create records in cds_client_name if you have a normalized name, and related discovered names. You're effectively adding to the downloaded normalized values from ServiceNow"

If I just import the vendor / manufacturer file into core_company table, All the company records which doesn't have a normalized value, would be getting created and mapped as 'normalized'. If that is case, what would happen in the future if someone tries to add a different variant of the company record which is already existing in the core_company, but doesn't have any normalized mapping 

If I consider ' American Power Conversion (APC) by SE' as the vendor, how would I map this to the normalized name 'APC' . How can I programmatically map the vendor name from the file to the Normalized mapping record ?

[Kieran Anson]

It would require something to create a mapping at a later stage, and then verify the core_company record which is a discovery name, not a normalized one, has the "canonical" flag set to false.