Mapping Fields in an Extract Template

Prerequisites

To map fields in an extract template you should have:

  • Business objects and business services defined in the application.

  • Schema associated with the business object or the business service.

Procedure

To map fields in an extract template

  1. Ensure that the Field Mapping section is expanded when you are defining, editing or copying an Extract Template.
  2. Click Generate.

    Field mapping is generated with the details such as sequence, field names and the source field Xpath in the extract template based on the selected the services.

    The Field Mapping section contains the following fields:

    Column Name Column Description Mandatory (Yes or No)
    Sequence Used to specify the display sequence of the field. Yes
    Field Name Used to specify the name of the field to be displayed in the extracted data file.
    Note: If you select the Extensible Markup Language option from the File Format list then the node names gets displayed.
    		 Yes
    Start Position Used to configure the starting position of a particular field.
    Note: This field appears when you select the Fixed Position option from the File Format list.
    		 Yes
    End Position Used to configure the ending position of particular field.
    Note: This field appears when you select the Fixed Position option from the File Format list.
    		 Yes
    Source Field Path Used to specify the XPath of the source field from where the data is to be extracted.
    Note: The Search (The Search Icon) icon appears corresponding to this field. On clicking the Search icon, the Field XPath Search window appears and corresponding algorithm gets auto populated in the respective field.
    		 Yes
    Target Field Path Used to specify the XPath of the target field into which the extracted data is to be saved.
    Note: This column appears when you select the Extensible Markup Language or JavaScript Object Notation option from the File Format list.
    		 Yes
    Do not extract Used to indicate whether you want to exclude corresponding field mapping from the extracted information. Yes
    Edit Input Used to indicate whether you want to define the default value for the corresponding field.
    Note: If you select this checkbox then the Default Value field is enabled.
    		 Yes
    Default Value Used to indicate the default value which you want to be displayed for the corresponding field in the extract template.
    Note: This field is enabled when you select the Edit Input checkbox.
    		 Yes
    Date Time Format Used to specify the format in which you want to define the date and time in exported file. Yes
  3. Enter the required details in the Field Mapping section of the extract template.
  4. If you want to map more fields in the extract template, click the Add (The Add Icon ) icon and then repeat step 2.
    Note: However, if you want to remove a field from the extract template, click the Delete (The Delete Icon) icon corresponding to the service.
  5. Click Save.
    The fields are mapped in 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