Table of contents 

• Abstract 
• When to apply value transformations
• Value transformation example
• Value transformations while creating and editing Configs
• Value transformations while updating a config
• Mapping formulas
• Mapping formula example
• Value maps
• Value maps with content control
• Value maps without content control

Abstract 

When creating, editing or updating Configs, sometimes it is required to perform Value transformation between the ILAP Terms and the Host fields. This can be done in multiple ways. In this article it is explained how to do this.

When to apply value transformations

Value transformations are mostly applied when creating configs. Some ILAP Terms cannot be directly mapped, this means that the value for the ILAP Term cannot be applied one-on-one in the Host field or vice versa. These ILAP Terms need a value transformation.
When editing Configs, value transformation can be added or edited. Finally, when updating Configs, value transformation might also be required for e.g. added fields to a Template.

Value transformation example

example 

Value transformations while creating and editing Configs

Value transformations while creating and editing Configs work the same. All the ILAP Terms for which direct mapping has been turned off in the step “Direct mapping “ping“, will be available in the “Value transformation” step.

For each of these fields, a mapping formula can be added by clicking “+ Add” in the Mapping formula column. Once added, the formula is displayed in the Mapping formula column instead of the "+ Add” button. It can be edited by hovering over the formula and clicking on the pencil icon.
 To add a Value map, click “+ Add” in the Value map columns. To view and edit the value map after it has been added, click the “View” button in the Value map column that has replaced the “+ Add” button.

The “Value transformation” tab in a config with a “being created” or "being edited” status. The columns “Mapping formula” and “Value map” are highlighted.

Value transformations while updating a config

When the Template that a Config is using is edited, the Config needs to update. In the case that an ILAP Term has been added to Template and direct mapping is turned off, a value transformation is required. Also, when the Content control has new values that require new values in the value map, a value transformation is required.

Click “+ Add” in the Mapping formula column to add a mapping formula. Once added, the formula is displayed in the Mapping formula column instead of the "+ Add” button. It can be edited by hovering over the formula and clicking on the pencil icon.
 To add a Value map, click “+ Add” in the Value map columns. To view and edit the value map after it has been added, click the “View” button in the Value map column that has replaced the “+ Add” button. In case a value map requires updates, click “Open” in the Value map column to add the missing fields.

The “Template updates” pop-up window for a config with ILAP terms that have been added and for which the content control has changed.

Mapping formulas

A mapping formula transforms values from ILAP term values to Host field values, or vice versa. Formulas can be type or pasted directly in the formula textbox, or selected from the example formula picker dropdown. Users can also select a host field. This host field is used in the formula as [VALUE]. Comments can also be added to describe the transformation that the mapping formula is performing.

Click “Save” to save the formula to the config.

Mapping formula example

Your content goes here

Mapping formula pop-up window with the example formula picker dropdown opened.

Value maps

There are two types of value maps, with and without content control. With content control, the host values have to be mapped against valid values defined in the content control. Without content control, both input and output values have to be defined. Below, both value maps are explained.

Value maps with content control

The value map pop-up window, when there is content control, consists of a table with four columns. The first two consists of the Template value and the Template value description. These are set in the content control of the ILAP Term. The last to columns contain Host value and Host value description and need to be defined in this window, corresponding to the Template value in that row. This is done by populating the text fields.

In some cases, one template value corresponds with multiple Host values. In that case a row can be duplicated by hovering over it and clicking the duplicate icon. Duplicated rows can also be removed again by hovering over the row and clicking the “X” icon.

When you have populated all text fields, click “Save” to save the value map to the config.

A value map pup-up window in the case of content control.

Value maps without content control

The value map pop-up window, when there is no content control, consists of a table with three columns. The first column represents Template values, the second the Host value and the last is for Comments about the Value map.

Values can be added by clicking the “+ Add value” button above the table to the right. There are two options: “Single value” and “Upload in bulk”. By clicking “Single value”, one row is added and can be populated by typing or pasting in the text boxes. When selecting “Upload in bulk” a new pop-up window appears. See below for how this works.

Value map pop-up window in the case of no content control.

The “Upload values” pop-up window consists of a big text box where you can type or paste values. Each line contains a Template value, Host value and a Comment. They are separated by semicolons and must not contain internal semicolons. The text can be previewed with the toggle in the top right of the text box.

When done, click “Submit” to insert the values into the value map. Click “Save” to save the value map to the Config.

Upload values pop-up window in edit mode

Upload values pop-up window in preview mode

Value map pop-up window in the case of no content control, with values.