Share via

Map Published Data

  • Article

The Map Published Data activity transforms the existing Published Data items or variable values into new values according to the rules that you specify. You can use this activity to convert numeric values to word values, simplify multiple versions of software program names into one name, or perform other string conversion activities within a runbook.

When you place this activity in a runbook, you must place it after the activities that create the Published Data items that you want to transform, and you must place it before activities that will use the new transformed items. If you use the Map Published Data activity to transform variable items, you can place it at the beginning of the runbook.

Configure the Map Published Data Activity

Before you configure the Map Published Data activity, you need to determine the following:

  • The names of the Published Data or variables that you want to transform.

  • The method you want to use to transform the Published Data or variable.

    Use the following procedure to configure the Map Published Data activity.

To configure the Map Published Data activity, follow these steps:

  1. From the Activity pane, drag a Map Published Data activity to the runbook.

  2. Double-click the Map Published Data activity icon to open the Properties dialog.

  3. Configure the settings in the Mapping rules tab. Configuration instructions are listed in the following table.

Map rules

Settings Configuration Instructions
Add Select Add to open the Add Mapping dialog.
Output Published Data Enter the name that you want to assign to the new Published Data item that you're creating.
Source data Insert Published Data or variable items to map to the new Published Data item. To insert items, right-click the edit box and select Subscribe, select Published Data or Subscribe, and select Variable. You can insert as many items as you want.

You can also enter text to transform to a new Published Data item.
Pattern Enter the existing pattern that you want to transform.
Map To Enter the new text that replaces the text of those items that match the Pattern.

Select OK to return to the Map Published Data Properties dialog.
Add, Edit, Remove If you want to add more rules, select Add and repeat the Pattern and Map To configuration instructions. On the Mapping rules tab, you'll see a list of all the transformations you created.

To remove items from the rules list, select Remove. To edit an item in the rules list, select Edit.

Examples

The following examples describe how to use the Map Published Data activity.

  • Single Published Data or variable item

    The Read Line activity creates a Published Data item called File and path name. If the path in this item is expressed as a drive letter, you can create a mapping to convert it to a UNC path.

Map a drive letter to a UNC path

  1. In the Source data field, insert the File and path name Published Data item from the Read Line activity.

  2. In the Pattern field, enter the drive letter and a colon, such as Y:

  3. In the Map to field, enter the UNC path that will replace Y:, such as \\servername\folder.

  4. Select Add, and select OK.

  • Convert output of one system to be compatible with another system’s formatting

    You use two software programs that express severity levels with the following methods:

    • Numerically: 0, 1, 2, and so on.

    • Descriptions: High, Medium, or Low

Convert the numbers expressed by one software program to the words used by another

  1. In the Source data field, insert the Published Data item for the severity level from the software program that expresses severity levels in numbers.

  2. In the Pattern field, enter 1.

  3. In the Map to field, enter High.

  4. Select Add.

  5. Repeat for each severity level, such as 2, 3, and 4; match the appropriate word to each numeric value.

  6. Select OK.

    To transfer severity levels to the software program that expresses them in words, insert the Published Data item that you created in the field. Items from the originating software program with a severity level of 1 are placed into the receiving software program with a severity level of High.

  • Wildcards

    You can replace strings of words with wildcards combined with words. For example, a Published Data item can describe Windows Server 2008 R2 inconsistently, as either Win2K8R2 or W2K8R2.

    There are two wildcards available:

    * - use the asterisk to search for any number of characters after your alphanumeric search character. For example, a* will produce aa, aaa, aaaa, aaabbb, and so on.

    ? - use the question mark to find a specified number of characters after your alphanumeric search character. For example, a?? will produce aaa, abb, abc, aac, but not aaaa or aaabbb and so on.

Change variations in the data to a single value

  1. In the Source data field, insert the Published Data item that represents the inconsistent names.

  2. In the Pattern field, enter W*K8.

  3. In the Map to field, enter Windows Server 2008

  4. Select Add and select OK.

  • Multiple Published Data or Variable Items

    Operating system names are composed of multiple parts, such as manufacturer, platform, version year, and release. In Orchestrator, each part of a name can be represented by an individual Published Data item. You can combine multiple Published Data items into one new item, such as Windows Server.

Map multiple values to a single value

  1. In the Source data field, insert each Published Data item that you want to combine into the new item, separated by spaces.

  2. In the Pattern field, enter Windows Server*.

  3. In the Map to field, enter Windows Server.

  4. Select Add, and select OK. All the references are changed to Windows Server.

Published Data

This activity only generates Published Data that you specify.