Adding Transformation Details in a File Request Type

Prerequisites

To add transformation details in a file request type, you should have:

  • File Segment Type defined in the application.

  • The File Transformation Required flag should be True.

  • File Format field should have either of the following values:

Procedure

To add transformation details in a file request type:

  1. Click the Admin link in the Actions / Navigation area.
    A list appears.
  2. From the Admin menu, select F and then click File Request Type.
    A sub-menu appears.
  3. Click the Add option from the File Request Type sub-menu.
    The File Request Type screen appears.
  4. Enter the appropriate details in the Main section, if required.
  5. Enter the appropriate details in the Messages and Services section, if required.
  6. Ensure that the Transformation Details section is expanded when you are defining, editing, or copying a file request type. The Transformation Details section consists of following fields:
    Column Name Column Description Mandatory (Yes or No)
    File Segment Type Used to specify the file segment type. The valid values are:

    • Field Detail

    • File Footer

    • File Header

    		 Yes
    Sequence Used to map the field values in a CSV or PSV format files. The sequence number will be proportionate to the fields in a file.
    Note: You can map or configure the same sequence number to multiple fields (Number of Fields can refer to same field value provided in an individual record). A sequence number ZERO: 0 is reserved for capturing default values.
    		 Yes
    Field Name Used to specify a unique field name, that will contain mapped file sequence field value.
    Note: A map with these configured Field Names and the corresponding Field Values is provided as an input to the transformation algorithm.
    		 Yes
    Map Field XPath Used to specify a syntax in an XPath expression, referencing to the elements in the instructions’ referenced business objects.
    Note:

    The Search (The Search Icon) icon appears corresponding to the Map Field XPath field. On clicking the search icon, the File Request Transform Map Field Zone window appears.

    		 No
    Start Position Used to specify the starting position in the file from where you want to transform the characters.
    Note: This is required if you have selected Fixed Position as file format type.
    		 No
    End Position Used to indicate the ending position in a file till where you want to transform the characters.
    Note: This is required if you have selected Fixed Position as file format type.
    		 No
    Required Used to indicate mandatory field level validations for every record while uploading data using the File Transform and Upload (C1-FTRAN) Batch. No
    Record Identifier Used to indicate that duplicate entries of a file record must be checked before uploading the file in the ORMB system. No
    Default Value Used to set the default values while the record payload is generated. Yes (Conditional)
    Note: This is required when Sequence Number is ZERO: 0. The sequence number ZERO: 0 is reserved for capturing default values.
  7. One or more transformation details can be configured. If you want to define more than one transformation detail for the file request type, click the Add (The Add Icon) icon and then repeat Step 6.
    Note:

    However, if you want to remove a transformation detail from the file request type, click the Delete (The Delete Icon) icon corresponding to the file segment type.

  8. Enter the required transformation details and click Save.
    The transformation details are added in the File Request Type.

Related Topics

For more information on... See...
File Request Type screen File Request Type (Used for Searching)
Search File Request Type zone Search File Request Type
How to add messages in a file request type Adding Messages in a File Request Type