Customizing Export Formats
Table of Contents
The export format identifies the type of file that is being exported. The format of a file ensures that the exported files can be accessed and used by other applications. It also helps in maintaining the structure of the data during export.
The LiveVox Portal (LVP) enables you to export a file as a comma separated values (CSV) file. Using the Export Format editor, you can configure the data in a specific format. LVP uses the format that you set using the Export Format editor to export data from the Agent editor, Contact editor, and Report Writer.
Accessing the Export Format Editor
To access the Export Format configuration window, on the Configure tab of the LiveVox Portal, click Input / Output > Export Format.
Select the editor and format you want to view/adjust, from the Editor and Format drop-down menus.
Export Format Window Field Descriptions
Field |
Description |
---|---|
Editor | Select the editor you want to use. Choose from Agent, Contact, and Report Map |
Format | Select the required format for the selected editor. |
Format Details |
|
Column Mapping Details |
|
Export Format Window Buttons
Button |
Description |
---|---|
Add Mapping | Creates a new mapping column. |
Delete Mapping | Deletes the selected column mapping. |
Copy Format | Copies the selected format. |
Add New Format | Creates a new format. |
Delete Format | Deletes the selected format. |
Save Format | Saves updates on the selected format. |
Cancel | Discards the changes. |
Creating a New Export Format
- Click Add New Format from the bottom menu.
- Select the required editor from the Editor drop-down list. Choose from Agent, Contact, and Report Map.
- Each format is represented by a unique Format Id once it is created.
- Enter the Name of the format. This Name is used to refer to the export format throughout the configuration manager.
- Enter the Description to provide additional information about the export format.
- Select the desired field delimiter from the Delimiter drop-down menu.
- Select the line break style from the Line Break drop-down menu.
- Select Sort By Field from the drop-down list. This defines how the results should be arranged in the export file.
- Select Sort Order from the drop-down list to set the results in Ascending or Descending order.
- Select Add Quotes To from the drop-down list. You can use this option to specify if no fields, all fields, or only those containing the delimiter should be placed in quotes.
- Select the Print Header checkbox if you want to include a header row in the export file.
- Add the mapping to the format.
Adding a Mapping
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 want 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
- Padding Chars
- Alignment
- Click Ok to add a mapping.
Updating a Mapping
To edit or update a column mapping in the export format:
- Select the required editor from the Editor drop-down list.
- Select the required format from the Format drop-down list.
- Double-click on the mapped row which you want to update. The Mapping Details window opens.
- Update all the required fields.
- Click Ok to update the mapping.
- Click Save Format to update the export format.
Deleting a Mapping
To delete a column mapping in the export format:
- Select the required editor from the Editor drop-down menu.
- Select the required format from the Format drop-down list.
- Select the mapped field row which you want to delete from the export format.
- Click Delete Mapping. The deleted mapping appears in red text.
- Click Save Format to update the export format. The deleted mapping disappears from the list.
- Click Add Mapping from the bottom menu. The Add Mapping window appears.
- Click Save Format to create a new export format.
Deleting an Export Format
To delete an existing export format:
- Select the required editor from the Editor drop-down list.
- Select the required format from the Format drop-down list.
- Click Delete Format. A confirmation pop-up window appears.
- Click Yes to confirm deleting the format.