BlueCielo Meridian Enterprise 2013 Administrator's Guide | BlueCielo ECM Solutions

Configuring the mappings

The job mappings specify to which items in the destination system items from the source system are imported. To combine the values of multiple source properties into one destination property value, simple expressions can be specified.

Notes

To configure job mappings:

  1. In the Enterprise Server Configurator, double-click the job for which you want to configure the mappings. The job's configuration pages appear.
  2. Click PROPERTY MAPPING. A list of the current mappings appears, grouped by property set if the items are properties.

    The icons and columns are described in the following table:

Mapping icons and columns
Column or icon Description

Item is mapped and included

Item is not mapped

Item is mapped but excluded

DESTINATION

The item names in the destination system

SOURCE

The item names in the source system

EXPRESSION

An expression that calculates the value of the item in the destination system
  1. To change the mapping of an item, double-click the item name. The item expands to show its mapping options.
  2. Click options or type values for each column using the descriptions in the following table.
Column Description

SOURCE

Select an existing source system item from the list.

EXPRESSION

To edit the expression, see the following steps.

SEPARATOR (multi-value properties only)

Type the character that separates individual values in a multi-value property.

For unprintable characters, type newline or tab

  1. Click Update to save your changes to the item mapping.
  2. To assign an expression to an item mapping:
    1. Select the item name that you want to assign the expression to and then in the toolbar, click Edit Expression. The EXPRESSION dialog box appears and lists the available properties in the source system.
    2. In the Expression pane, type an expression to evaluate. The expression may use any .NET compliant methods (except Parse) and operators in the C# language syntax. The result of the expression will be the property value in the destination system. Click items in the Source Metadata pane to insert them into the expression. The result of the expression must be compatible with the data type of the destination property. If necessary, you can convert data types, for example, using the ToString method.

      Following are examples of text and date expressions:

      {Title 1} + " " + {Title 2} + " " + {Title 3}
      {PropertyName}.SubString(0, 1)
      {NonStringProperty}.ToString() + " days"
      {ProjectEndDate}.AddDays(-30)
      
    3. To validate the expression, click CHECK. Errors in the expression appear in the Errors pane. Correct all errors until the Errors pane is empty.
    4. When you are finished editing the expression, click SAVE. The expression appears in the EXPRESSION column.
  3. Repeat steps 3 through 6 for each mapping that you want to change.
  4. When you are finished configuring mappings, click SAVE.

 

 


Copyright © 2000-2013 BlueCielo ECM Solutions

www.bluecieloecm.com