Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

After defining the Source and the Destination of the Template, next step is to map the elements of the Source with the Destination.  

This screen appears only if you have selected Yes (Convert) data format while providing the definition of the Template.

  1. Select the mapping from the Select Mapping drop-down list and click Next. You can either use an existing mapping (created in the Developer's Studio) or create a new one.



    Click  to create a new mapping and do the following:

    1.  Provide the name of the mapping.

      You can also select the mapping from the Mapping Suggestion(s) drop-down list. This drop-down list will list all the existing mapping for similar data formats. Click Yes, when prompted to overwrite the existing mapping.

      Click Switch to Advanced Mapping to create the mapping using Developer's Studio Data Mapper.

    2. Create the mapping between the elements of the Source and the Destination. Mapping can be done either automatically or manually. 

      To map the elements manually, click a Source element first and then Destination element with which you want to map the Source element. This maps the elements and is shown with a green dot.


      Click  to map the Source and Destination elements automatically. You can map the elements automatically if the Source and Destination element names and hierarchy are exactly the same.

      You can perform the following operations while mapping the elements. 

       

       Mapping Functions

      You can also map the Source and Destination elements using /wiki/spaces/AC2/pages/656554. If you want to map the elements using mapping functions then click  > Expression and Variables.  

       

      Business applications accept specific values in their reference elements at the destination. When you click Expression and Variables for a reference element of such applications, Reference Selection window appears. You may use Reference and/or Lookup functions to locate the reference values using the values of their corresponding elements. 

      On the Expression Builder window, map the elements using the mapping functions displayed on the left menu.

       Copy Expression

      You can also copy the expression applied to a particular destination element and use it in another destination element. To copy the expression, click  > Copy Expression. The expression will get copied.

      Use the copied expression to another destination element by clicking  > Paste Expression. The same expression will get applied to the element.

      By default, Copy Expression and Paste Expression options are disabled. Copy Expression will get enabled if the expression is applied to a particular element. Paste Expression will get enabled after you copy the expression.

       Clone Node

      Cloning means generating the replica of the element. You can make a clone of a particular element or all destination elements. To clone an element or parent node:

      1. Click  > Clone Node.


         

      2. On the Clone Options window, provide the number of clones you need (maximum 300).
      3. Select Include Mapping check box to include mapping with the element.

      4. Click Create Clone(s).



        This creates the specified number of clones of the element. The element which is created using cloning is displayed with the suffix [1] after its name. Subsequent clones will have the suffix [2] and so on. For instance, if you make two clones of Name field then Name[1] and Name[2] will get cloned at the destination.

        You can delete the clone by clicking   > Delete Clone. You can delete the mapping between the elements by clicking  > Delete.

       Value Map

      Use this feature to map the values of an element at the Destination application. For instance, at source, Name element has John, Smith, Daniel, and Michael as values. You want to map John and Smith with Walter and Robert as the values in the Name element at the destination. This can be done using Value Map feature. Click Value Map to map the values.

      On the Value Map window, provide a unique value map name. Type the values that you want to map in the Value and Map.



      For other values (Daniel and Micheal), either provide the default value or click Pick From Source to map the same value as appearing at Source. If you provide the default value, then the same value will be mapped to other values. For instance, if you provide Paul as the default value, then Paul will be mapped to Daniel and Micheal at the destination.

      You can also import the values using CSV file by clicking Import CSV. On the Open dialog box, browse to and select the CSV file.

      After you have created the value map, apply this to the destination element. To apply the value map:

      1. Click  > Expression and Variables.

      2. On the Expression Builder window, scroll left menu to the Value Map section, and then click the value map to apply.

        The Value Map section will also list all the value maps of Project type created in the Developer's Studio.
      3. In the Expression tab, place the cursor between the brackets, click the field from the Source, and then click Save.



        This applies the value map to the element.

       Variables

      You can create a variable, assign a value, and use it while mapping the Source and Destination element. The value of a variable can be any constant, /wiki/spaces/AC2/pages/656554, or any source element.

      All the variables are listed in the Variables section in the Expression Builder window. The variables created for a particular destination element are listed in the Current category whereas variables created for the Record node are listed in the Parent category.

      To create a variable for a particular destination element or parent node:

      1. Click  > Expression and Variables. 



      2. On the Expression Builder window, click Variable tab. You can also create a variable by clicking on the Variables option from the left pane.



      3. Type a unique variable name.
      4. Type the value of a variable. The value can be any source element, any mapping function, or any constant. The following examples demonstrate how you can assign a value to a variable.

        Assigning a constant value to a variable
        Type a constant value in the box. Ensure that you have enclosed the constant value in a single quote.



        Assigning a source element as a value to a variable
        Click a field that you want to assign to the variable from the Source.



        Assigning a mapping function as a value to a variable
        Click a mapping function from the left menu and then click a field from the Source, if required.


      5. Click to add any additional comments related to the variable.
      6. Click Add Variable. This creates a variable and a suffix (LV) is displayed next to the element.



        All the variables created for a parent node or child node will get listed in the Variables section.



      7. After creating a variable, map it to an element by clicking  > Expression and Variables. 
      8. Click the variable from the Variables section.


         

        You can also apply a mapping function using a variable.
      9. Click Save.

        This maps the variable to the destination element.

       Applying Filter

      You can filter the elements from appearing in the target mapping. By filtering the elements, the values of the filtered element will not appear in the target mapping.

      You can filter both mapped and unmapped elements and also a single element or all elements of a node.

      To filter a single element or parent node:

      1. Click  > Apply Filter.

         

      2. This filters the selected element from the target mapping. The values of the filtered element (Emp_id) will not appear in the target mapping. Once the filter is applied to the element, a suffix (FL) is displayed next to the element.

       

      To filter all unmapped elements:

      1. Click to filter all unmapped elements.
      2. On the Mapping Settings window, click Filter Unmapped Elements.
      3. Click Save.



        This applies the filter to all the unmapped elements.

       Indenting Mapping Output

      Indentation enables a clearer view of the mapping output. You can indent mapping output to give a structured display, thus improving readability. By default, you will get the indented mapping output, however, you can disable the indentation. Disabling the indentation will increase the mapping performance and size.

      To disable the indentation:

      1. Click .
      2. On the Mapping Settings window, clear Indent Output XML.
      3. Click Save.

      This disables the indentation.

    3. Click Next to exit from the mapping.

  2. Provide the Documentation URL. This URL will have all the information related to the Template. 



  3. Click Save & Exit to save the Template.

    Next Step

    Activating a template

  • No labels