To add a new mapping column in the export format:
- Click Add Mapping from the bottom menu. The Add Mapping window appears.
- Specify all the mapping details. The following options define a mapping:
- Entity: Select the required editor from the Entity drop-down list.
- Field: Select the required field from the drop-down list. This selected field is going to be a column in your export file.
- Header: Displays text as Active Agent for Contact and Agent editors, and Account for Report Map.
- Hide: Check the box if you need to hide the field.
- Date Format: Select the date format option depending on the field you are adding. For example, if a date or time DB field is mapped, you must select a date format from the Date Format drop-down list.
- Time Zone: Select a time zone from the drop-down list (optional).
- Number Format: Select the number format option depending on the field you are adding. For Example, if a phone DB field is mapped, you must set a number format from the Number Format drop-down list.
- Fixed Width Size: If the column width is fixed and not delimited, you must specify values in the following fields:
Fixed Width Size
- For SMS, set the Fixed Width Size to a value greater than 150.
- The information gets truncated if the Fixed Width Size is set to a value less than the actual length of characters.
- Padding Chars
- Alignment
- Click Ok to add a mapping.