Defining the File Formats for an Extract Template

Prerequisites

To define the file formats for an extract template you should have:

  • Values defined for the EXTRACT_​TEMPLATE_​FILE_​FORMAT.

Procedure

To define the extract formats for an extract template:

  1. Ensure that the Template Formats section is expanded when you are defining, editing or copying an Extract Template.

    The Template Formats section contains the following fields in a grid:

    Field Name Field Description Mandatory (Yes or No)
    File Format Used to indicate the format in which you want to extract the information. The valid values are:

    • Comma Separated Values

    • Extensible Markup Language

    • Fixed Position

    • JavaScript Object Notation

    • Pipe Separated Values

    • Tilde Separated Values

    		 Yes
    File Extension Used to specify the file extension corresponding to the file format selected to extract information. Yes
    Root Tag Used to specify the name of the root tag in which you want to enclose the extracted information.
    Note: This field is enabled only when you select Extensible Markup Language or JavaScript Object Notation option from the File Format list.
    		 Yes (Conditional)
    XML Namespace
    File Level
    Enclosed Quotes Required Used to indicate whether you want to enclose the extracted information in quotes.
    Note: The Enclosed Quotes Required field check box is enabled only when you select the Comma Separated Values, Pipe Separated Values or Tilde Separated Values option from the File Format list.
    		Yes (Conditional)
    Column Header Required Used to indicate whether you want the column headers for the extracted information.
    Note:

    • If this check box is selected then the field names of the mapped fields are used as the column headers for the extracted information.

    • The Column Header Required field check box is enabled only when you select the Comma Separated Values, Pipe Separated Values or Tilde Separated Values option from the File Format list.

    		 Yes (Conditional)
    Do Not Extract
    Payload Log
    Same as Source XML Used to indicate whether the target field XPath is same as the source field XPath while mapping the fields.
    Note: This checkbox appears when you select the Comma Separated Values, Pipe Separated Values or Tilde Separated Values option from the File Format list.
    		Yes (Conditional)
  2. Enter the required details in Extract Formats section.
  3. If you want to define more than one extract format for the extract template, click the Add (The Add Icon ) icon and then repeat step 2.
    Note: However, if you want to remove an extract format from the extract template, click the Delete (The Delete Icon ) icon corresponding to the extract template.
  4. Click Save.
    The extract format is defined for the extract template.

Related Topics

For more information on... See...
How to define an extract template Defining an Extract Template
How to edit an extract template Editing an Extract Template
How to copy an extract template Copying an Extract Template