Creating transformations

Use Transformation Designer to create XML based scripts to carry out certain functions or processes during a transfer. For example, you can map one data format to another, and set values in particular fields depending on certain conditions.

Note: Before creating a transformation, the required data formats must have already been created using Format Designer. The transformation must then use the defined data fields in the same order as that specified in the flat file schema definition (.fsd).

To create a new transformation:

  1. Create a new profile or edit an existing profile. Click the Manage button in Transformation.
  2. Specify this information:
    Script Type
    Select either TML or XSL. When you select XSL, you can only create transformations in Script view, and the button is disabled so you cannot change the transformation view.
    Name
    Enter a name for the new transformation rule.
    Description
    Enter a description for the new transformation rule.
    Source Format
    Select a source data format. This refers to the data formats available within Format Designer, and include user defined data formats.
    Target Format
    Select a target data format. These data formats refer to those available within Format Designer, and include user defined data formats.
    Note: At least one of either Source Format or Target Format must be a SunSystems component.
  3. Click the TML Details tab to specify the mapping. Click Script to view the mapping as text.
    Where both the source and the target are the same SunSystems data format, the field-to-field mapping is automatically generated for you.
    1. For each line in the map, select the Operation that converts the source value to the target value:
      • Map
      • Assign To
      • Function
      • Lookup
      • Undefined.
    2. Click OK.
  4. Click Test to test the transformation, then click Validate to confirm it is correct.
    To view or edit the transformation source code, click Script to display the code in the Script viewer.
    Note: Any source or target data displayed with a grey background is read-only data.