Configure the Mappings

• The job mappings must be updated manually if the configuration of the source or destination systems changes.

• By default, document types and reference types are automatically synchronized between Meridian Enterprise and Meridian Explorer.

• There is a single property mapping configuration for all source and destination systems of the same publishing job. Also, the system takes advantage of matching property names in the systems when possible. This means that if there is an unmapped property in one of the source systems that matches an unmapped property in one of the destination systems, it will be imported even though no explicit mapping has been configured.

  This also means that to configure unique property mappings between specific systems, you may need to create separate publishing jobs. For the best results when mapping properties between multiple source or destination systems, they should have the same properties.

• We recommend that you not map properties that are specified in a destination vault's Field-Path definition unless the Identify by Global ID if document path is not available option is enabled as described in Configure the Miscellaneous Options. This is because their values have already been determined by the location of the document. Errors can occur and the publishing job may fail if the destination folder and the Field-Path definition property values do not match.

To configure the system mappings:

1. In Meridian Enterprise Server Administration Console, in the Data Exchange group, click Jobs.

   The All Jobs page opens with a list of existing publishing jobs. The jobs are grouped by the name of the computer (cluster node) to which they have been assigned.

2. Double-click the job for which you want to configure the mappings.

   The job's configuration pages appear.

3. In the menu, click Property Mapping or Type Mapping (if the job is a Meridian Explorer synchronization job).

   A list of the current mappings appears, grouped by property set if the items are properties. To configure the mappings for other item types (a Meridian Explorer synchronization job), click Object Tag or Project in the page header.

   The icons and columns are described in the following table:

   Mapping icons and columns

   Column or icon	Description
   	Item is not mapped
   	Item is mapped and included
   	Item is mapped but excluded
   Destination	The item names in the destination system Note: When a single-value Meridian Enterprise source property is mapped to a multi-value destination property, separate multiple values in the source data with the semicolon character (;).
   Source	The item names in the source system
   Expression	An expression that calculates the value of the item in the destination system

   If no mappings appear, they have not yet been defined, such as for a file system destination, for example.

4. Choose between two options:

   • To create matching properties from the source system:

     1. In the toolbar, click Edit Destination Properties.

        The Edit Destination Properties dialog box appears.

     2. Click Create From Source.

        A new destination property definition is created for each source system property and is added to the list. Duplicate property names appear in red text and must be renamed to be unique. Unique property names appear in green text. You will only be able to save the property definitions when all property names are unique.

     3. To change the settings of a property, click its row to make it editable and then use the following instructions for editing the settings of a manually created mapping.

     4. To remove a property from the mapping, select the row that you want to remove and then in the toolbar click Remove.

     5. Click OK.

        The new mappings appear on the page.

   • To create a new mapping manually:

     1. In the toolbar, click New.

        A new property row appears in the list with default settings.

     2. Type a unique name in the Name column and select the appropriate data type from the Data Type list.

     3. Click Update.

5. Choose one or more of the following options:

   • To exclude an item from publishing:

     • Select the item name and then click Exclude. The icon changes to indicate the item's new status.

   • To include an item in publishing:

     • Select the item name and then click Include. The icon changes to indicate the item's new status.

   • To change the mapping of an item:

     1. 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.

     3. Click Update.

   • 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 be evaluated during publishing.

        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. Double-click a property in the list to insert it into the expression. For multi-sheet drawings, layout properties may also be selected, __LayoutProperties._NAME, for example. 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.

6. Repeat steps 4-5 for each mapping that you want to change.

7. When you are finished configuring mappings, click Save.