Configuring Matching Rules for Imports

You can configure how the importer matches imported objects to existing objects.

See Also
Configuring Properties
  1. Create or open the text file to contain customized properties. For more information, see Editing Properties Using MQL.
  2. To enable or disable fuzzy matching for supplier names and supplier codes, follow these steps:
    1. Add or edit this line in the file used to import properties into a page object: 

      emxMaterialComplianceCentral.importer.fuzzySupplierMatching=false

      Fuzzy matching is done by tokening the supplier names and supplier codes into whole words as follows:

      • Case-sensitivity is ignored
      • Leading and trailing SPACE character is added to the string
      • The characters _-.,()/[]`' are replaced with SPACE
      • The sequence "SPACEandSPACE" is replaced with "SPACE&SPACE"
      • The sequence "SPACECHARSPACE&SPACECHARSPACE" is replaced with "SPACECHAR&CHARSPACE"
      • The string is tokenized into a list of whole words that are delimited by SPACE

      Whole words that are insignificant are removed from the tokenized list. The list includes the words (case insensitive):

      the oflightinggroup
      co supplyspacoatings
      company plasticsplasticas
      incoilsteelsro
      incorporated cvohgfluid
      systems industrialnorthvan
      ltd industriesinternationalstamping
      limited rubberspringaluminum
      assoc metalcorporationaluminium
      associates syspolymergraphics
      corp llcpolymersuk
      industries mfgmanufacturingsl
      usa ltdagmbhtool
      canada centeruniteddie
      and americaabfoam
      sa divagfrance
      de productkg
      electronics productsund
      electronic autoeurope
      group automotiveinstruments

    2. Set the value for this property depending on your business requirements:

      • true The import attempts to match similar supplier names and supplier codes from Materials Compliance Connect spreadsheets.
      • false Supplier names must match exactly including full case sensitivity.

  3. To indicate whether or not fuzzy supplier matching requires MEP matching, follow these steps:
    1. Add or edit this line in the file used to import properties into a page object: 

      emxMaterialComplianceCentral.importer.fuzzySupplierMatchingRequiresMEPMatch=false

    2. Set the value for this property depending on your business requirements:

      • true
      • false

      The default value is false.

  4. To indicate whether to include the manufacturer location as criteria when matching a Manufacturer Equivalent Part, follow these steps:
    1. Add or edit this line in the file used to import properties into a page object: 

      emxMaterialComplianceCentral.importer.manufacturerLocationInMEPMatch=false

    2. Set the value for this property depending on your business requirements:

      • true
      • false

      The default value is false.

  5. To indicate what to do in the case of duplicate enterprise part imports, follow these steps:
    1. Add or edit this line in the file used to import properties into a page object: 

      emxMaterialComplianceCentral.importer.duplicateDefinitionMode=Replace-Existing

    2. Set the value for this property depending on your business requirements:

      • Replace-Existing (default) Replaces the existing part with the imported part.
      • Ignore-New Ignores the imported part information and keep the existing part information.

  6. When finished updating the text file with all properties you want to modify, including the ones shown here, use the text file to modify the emxMaterialsComplianceCentral.properties page object. For more information, see Editing Properties Using MQL.