Navigate to the Export Format editor by selecting Configure > Input / Output > Export Format from the Navigation Panel.
Select the Editor and Format you wish to view/adjust from the respective drop-downs.
The Export Format editor offers following fields:
- Editor - Allows you to select the editor where the format will be available. Currently, you have only Agent editor as an option.
- Format - Allows you to select the required format for the selected editor.
- Format Details
- Format Id - Unique export format ID
- Name - Name of the export format
- Description - Description of the export format
- Delimiter - The delimiter for export format
- Line Break - The line break style
- Sort By Field - This field defines how the results should be arranged in the export file.
- Sort Order - Set the sort results in Ascending or Descending.
- Add Quotes To - Specify which fields should be placed in quotes
- Print Header - Indicates whether a header row is included in the export file.
- Column Mapping Details
- ID: Mapping ID
- Field: The mapped field which represents a column in your export file
- Header: The cosmetic name assigned to the Mapping's column
- Date Format: The date format applied to a field if any
- Number Format: The number format applied to a field
- Time Zone: The time zone which applies on date or time fields
- Fixed Width Size: The fixed width size of the field if any
- Padding Chars: The number of padding characters if Fixed Width Size is configured
- Alignment: The alignment style of the column in the export file
- Order: Displays the number which specifies the order of the column in the export file.
The Export Format editor offers the following buttons:
- Add Mapping - Creates a new mapping column. For more information, see Add Mapping section.
- Delete Mapping - Deletes the selected column mapping. For more information, see Delete Mapping section.
- Copy Format - Copies the selected format.
- Add New Format - Creates a new format. For more information, see Create a New Export Format section.
- Delete Format - Deletes the selected format. For more information, see Delete an Export Format section.
- Save Format - Saves updates on the selected format.
- Cancel - Discards the changes.