This documentation supports the 23.3 version of BMC Helix ITSM.To view an earlier version, select the version from the Product version menu.

Alias replacement during validation

During validation, the alias replacement function for data loads replaces alias values on staging forms with the actual values based on defined alias mappings. It can assist in reducing the number of errors generated during the dataload validate step.

Related topics

Creating-and-managing-data-load-jobs

Data-Management

The alias replacement function replaces the alias on staging forms with the actual value from DMT:AliasMapping form for a defined data type field existing in DMT:SYS:CleanseFields during the validation process.

Alias replacement for an alias only occurs when the current record for this field does not exist in either the system or the parent staging form, but it exists on the DMT:AliasMapping form.

The following data type fields on the staging forms are supported:

  • Company name
  • Site name
  • Organization
  • Support group name
  • Department
  • Support organization
Example

The current system contains a company record with the name Apex Global.
The alias mapping form contains an alias AG for the company Apex Global.

  1. You run the data load which triggers the validation process.
  2. The case insensitivity function checks if AG exists on either the Company form, Load Company staging form, or alias mapping form, and does not perform case conversion if AG is found.
  3. In this case, the record is not found in either the Company form or the Load Company staging form, but it is found in the alias mapping form.
    Validation then runs on the converted value Apex Global, and passes without error.
  4. The alias replacement functions runs, and AG on staging form is converted to Apex Global.
  5. The validation process then runs on the converted value Apex Global, and completes successfully.

Important

Alias replacement is not performed on records in the following parent staging forms:

  • Company
  • Site
  • People Organization
  • Support Group
    Alias replacement is not supported when importing Service Request Managementdata.

If there is more than one field with the same alias type on a staging form, the alias replacement function only replaces values on the primary field with the same field ID as the parent form of this alias type.

If you select Replace Case/Alias, the dataload job runs slower because it must perform more lookups. 
221_Alias.png

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*