4.14 Mapping Table Editor

The Mapping Table editor allows you to create, edit, and manage mapping table objects. A mapping table object is used by a policy to map a set of values to another set of corresponding values. After a mapping table object is created, the Map token maps the results of the specified tokens from the values specified in the mapping table.

To use a mapping table object, the following steps must be completed:

  1. Section 4.14.1, Creating a Mapping Table Object

  2. Section 4.14.2, Adding a Mapping Table Object to a Policy

To edit a mapping table, see Section 4.14.3, Editing a Mapping Table Object.

4.14.1 Creating a Mapping Table Object

A mapping table object can be created in a library, driver object, Publisher channel, or Subscriber channel.

  1. In the Outline view, right-click the location to create the mapping table, then select New > Mapping Table.

  2. Specify the name of the mapping table object, then click OK.

    Select Open the editor after creating the object to open the Mapping Table editor.

    Creating a mapping table object fields

  3. In the File Conflict message, click Yes to save the project before opening the Mapping Table editor.

  4. In the Mapping Table editor, select column_new-1.

  5. Specify a column name and data type, then click Close.

    Column names must be unique. The data type lets you specify if the column values are Case Sensitive, Case Insensitive, or Numeric.

  6. Select New Value to specify a cell value.

    New value in a row

  7. (Optional) To add another column, click the Add Column icon Add Column icon, then repeat Step 4 and Step 5.

  8. (Optional) To add another row, click the Add Row icon Add Row icon, then repeat Step 6.

  9. Press Ctrl+S to save the mapping table object.

  10. Continue with Section 4.14.2, Adding a Mapping Table Object to a Policy.

4.14.2 Adding a Mapping Table Object to a Policy

  1. Either create a policy to use the mapping table in, or select an existing policy to edit.

  2. Launch the Argument Builder in the Policy Builder.

    For information on how to access the Argument Builder, see Launching the Argument Builder.

  3. Double-click Map from the list of verbs to add it to the expression panel.

    Map verb in the Argument Builder

  4. In the Mapping Table DN field, browse to and select the mapping table object created in Section 4.14.1, Creating a Mapping Table Object, then click OK.

    Selecting the Mapping Table object

  5. Select whether the mapping table DN is set relative to the policy or not.

  6. Select the source column name by clicking the Browse icon.

    Select the source column

  7. Select the destination column name by clicking the Browse icon.

    Select the destination column

    The mapping table can be used in any manner at this point. In this example, the OU attribute is populated with the value derived from the mapping table.

    Map token in the Argument Builder

4.14.3 Editing a Mapping Table Object

Designer provides the following options to edit the mapping table:

Table 4-5 Editing Options for the Mapping Table Editor

Option

Description

Undo Add ColumnUndo Add Column

Undoes the last action performed in the table.

Redo Add ColumnRedo Add Column

Redoes the action that was undone.

Add ColumnAdd Column

Inserts a column to the mapping table.

Add RowAdd Row

Inserts a row to the mapping table.

Delete ColumnDelete Column

Deletes a column from the mapping table.

Delete RowDelete Row

Deletes a row from the mapping table.

Move Row UpMove Row Up

Moves the selected row up in the mapping table.

Move Row DownMove Row Down

Moves the selected row down in the mapping table.

Move Column LeftMove Column Left

Moves the selected column left in the mapping table.

Move Column RightMove Column Right

Moves the selected column right in the mapping table.

The Mapping Table Editor also supports keyboard shortcuts for several of its operations:

Table 4-6 Keyboard Shortcuts for the Mapping Table Editor

Keyboard Shortcut

Description

Ctrl+Shift+Insert

Insert a column to the right of the current column.

Ctrl+Shift+Delete

Delete the current column. You are prompted to confirm the deletion.

Ctrl+Shift+C

Rename the current column. Opens the Column Edit dialog box.

Alt+Insert

Insert a row below the current row.

Alt+Delete

Delete the current row. You are prompted to confirm the deletion.

Ctrl+Up Arrow

Navigate up one row.

Ctrl+Down Arrow

Navigate down one row.

Ctrl+Left Arrow

Navigate left one column.

Ctrl+Right Arrow

Navigate right one column.

4.14.4 Importing Data from a CSV File

The Mapping Table editor allows you to import data that is stored in a CSV file. It then populates the table with the information in the CSV file. To import a CSV:

  1. In an empty Mapping Table, select Import From CSV file Import From CSV file icon.

  2. Browse to and select the CSV file, then click Open.

  3. Click Yes to overwrite your existing data.

  4. Press Ctrl+S to save the data in the table.

4.14.5 Exporting Data to a CSV File

The Mapping Table editor allows you to export data to a CSV file. To export data to a CSV file:

  1. When the data in the Mapping Table is ready to export, select Export To CSV File Export To CSV File icon.

  2. Click Yes to save this editor’s changes and continue.

  3. Specify a name and location for the CSV file, then click Save.

4.14.6 Testing a Mapping Table Object

You can use the Policy Simulator to test the functionality of the mapping table. The Policy Simulator tests the mapping table by testing the policy that is using the mapping table. For more information, see Section 9.0, Testing Policies with the Policy Simulator.