Default language.

Metadata mappings and BMC Remedy ITSM


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

Error
Warning

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

XML mapping documents for BMC Remedy ITSM

The following BMC Remedy 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 Remedy ITSM mapping document. The following table outlines the forms handled by the BMC Remedy ITSM mapping document.


 Forms and BMC Remedy ITSM mapping

Mapping to a foreign entry ID field

When BMC Remedy 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 BMC Remedy 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*

Remedy Action Request System 20.02