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. Click Transformation Designer on the toolbar. The Transformation Designer dialog is displayed.
  2. From the File menu select New Transformation or click Create a new Transformation on the toolbar.
  3. On the New Transformation dialog enter the details required:
    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.
  4. Click OK. The TML Details window or the Script view is displayed.
    Where both the source and the target are the same SunSystems data format, the field-to-field mapping is automatically generated for you.