Migrator CLI metadata mappings for BMC Helix ITSM


The Migrator CLI provides support for BMC Helix ITSM through XML documents that enable mapping to an entry ID as the foreign key, and the ability to inject data during migrations.

Warning

Using Migrator CLI with BMC Helix ITSM applications might introduce inconsistencies in the application data. Instead, BMC recommends that you use the Data Management Tool with BMC Helix ITSM applications to ensure consistency.

XML mapping documents for BMC Helix ITSM

The following BMC Helix ITSM mapping documents are available:

  • ItsmMetaData.xml
  • ItsmMetaDataEnableDelete.xml

A configuration file, ItsmConfiguration.xml, is also available, with the Group Data Merge option set to Replace.
The COM:Company form serves as the root in the BMC Helix ITSM mapping document. The following table outlines the forms handled by the BMC Helix ITSM mapping document.



Forms and BMC Helix ITSM mapping

Mapping to a foreign entry ID field

When Migrator migrates or compares data based on the mapping document, it checks the entry ID maps on a per-form basis if the foreign field ID is an entry ID. If Migrator finds an entry for that entry ID value in the source entry, it obtains the destination value from the map, and replaces the field value in the entry being migrated or compared.

Injecting data

In the mapping document, you can define characters to inject into each entry being migrated or compared for the mapping item. This injection can be added within the <insert-value-fields > element, as shown.

<form name="COM:Company" unique-field-id="179" type="update" disable-related-workflow="false">
<insert-value-fields>
<field-value id="1000000076" value="LOAD"/>
</insert-value-fields>
<name-fields>
<!--Company Name-->
<field id="1000000001"/>
<!--Company ID-->
<field id="260000032"/>
</name-fields>
</form>


Child elements can be added within the <insert-value-fields > element to specify field ID and value pairs to insert into an entry before that entry is modified or compared on the destination.


 

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