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.

[Kieran Anson]

Hi.

You can load these into the core company table. If you have the Integration Commons for CMDB plugin installed, I'd use the following as it will tidy up a company name prior to creating a core_company record.

new sn_cmdb_int_util.CmdbIntegrationHardwareModelUtil().cleanseCompany(input);

The above returns an object with two keys, companyName and companySysId.

You don't need to create normalization records unless you have a database of normalized and discovered names. If you have that, you'd create a record in cds_client_name, and then mappings in cds_client_mapping. These would need to exist beforehand. Otherwise all of the records imported would be classed as canonical 

[Ram117]

cleanseCompany function is good .

[Ram117]

@Kieran Anson , Thank you for the response. Let me give a try with the cleanseCompany() and get back to you here.

I do have the cds_client_name and cds_client_mapping table being used. So I need to beforehand create records in these tables for each individual vendor / manufacturer records ?. One of the challenge i see is that, there are certain manufacturers listed in my file which may be already existing in the Normalized Company Names table, though the ones I have is completely a different naming format.

eg : 'American Power Conversion (APC) American Power Conversion (APC) ' this is one value already existing in Normalized Mappings, but the one which I have in my file is ' American Power Conversion (APC) by SE '

So do you have any suggestion on how this mapping to be created ? .

Out of 1000+ vendor / manufacturer records, I was able to find only 90 matches in the normalized mappings table.

[Kieran Anson · Accepted solution]

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

For the APC example, you would add a new mapping populating "Discovered Name" with your variant.