---
title: Exporter V20
description: "# Introduction ***Effortlessly Sync and Manage 3CX Data with 3CX Exporter for Real-Time Custom Reports***. Experience seamless synchronization and effortless data management with 3CX Exporter. This tool enables you to sync your 3CX data and Call Detail Records (CDR) files…"
url: "https://voiptools.com/docs/exporter-v20/"
updated: "2026-08-10"
category: "Tools - V20"
---

# Exporter V20

# Introduction

***Effortlessly Sync and Manage 3CX Data with 3CX Exporter for Real-Time Custom Reports***.

Experience seamless synchronization and effortless data management with 3CX Exporter. This tool enables you to sync your 3CX data and Call Detail Records (CDR) files with popular databases like Microsoft SQL Server or MySQL. Let this Windows service work in the background, ensuring your external database remains in harmony with your 3CX system. Gain instant access to real-time information and generate custom reports for your business. Say goodbye to manual hassles and hello to streamlined operations with 3CX Exporter.

## What is 3CX Exporter?

The 3CX Exporter automates the export of Call Detail Records (CDR) from 3CX’s internal PostgreSQL database to Microsoft SQL Server or MySQL. This Windows service runs in the background, maintaining synchronization between the external database and the data in 3CX.

## Why 3CX Exporter?

| ![](https://voiptools.com/wp-content/uploads/2023/01/simplified-custom-reporting.png) | **SIMPLIFIED CUSTOM REPORTING** | Discover the capabilities of 3CX Exporter, which enables you to generate customized reports using well-known reporting tools. Store data in SQL or MySQL, opening up numerous opportunities for data analysis and reporting requirements. |
| --- | --- | --- |
| ![](https://voiptools.com/wp-content/uploads/2023/01/remote-cdr-access.png) | **REMOTE CDR ACCESS** | Exporter provides a simplified solution by utilizing our Relay. This enables you to access CDR files, eliminating any difficulties. Embrace seamless file retrieval with our user-friendly solution. |
| ![](https://voiptools.com/wp-content/uploads/2023/01/database-sync-2.png) | **EFFORTLESS DATABASE SYNC** | Achieve smooth synchronization between your external database and 3CX using this efficient Windows service. This service operates in the background, ensuring that your data stays up-to-date. |
| ![](https://voiptools.com/wp-content/uploads/2023/01/easy-archieving-2.png) | **EASY ARCHIEVING** | Archive historical information using 3CX Exporter. Categorize and structure vital data from your 3CX system, enabling convenient retrieval as required. |

## How to use 3CX Exporter?

Optimize your workflow using 3CX Exporter, a user-friendly tool that automates the export of Call Detail Records. Specify your preferred export frequency during installation, and let the tool handle the remaining tasks. You benefit from the convenience of adjusting both the export frequency and database settings as needed, granting you seamless control over your data management.

# Prerequisites

**Before installing 3CX Exporter, you need to ensure that your computer meets the minimum requirements mentioned below:**

| **PREREQUISITE** | **PURPOSE** |
| --- | --- |
| **3CX Version V20** | 3CX Exporter is designed to work seamlessly with this version for enhanced features and performance. |
| **Windows 10 or above / Windows Server 2012 or above** | These operating systems provide the necessary environment for the application to run efficiently. |
| **[IIS Features and Configuration – VoIPTools](https://voiptools.com/docs/iis-features-and-configuration/)** | IIS is needed as a web server to host and manage web-based applications and services. |
| **VoIPTools Universal Updater** | This component is necessary for updates, ensuring the application remains current and functional. |
| **VoIPTools Relay Service** | It is used for proper integration and functionality of the 3CX Exporter within the 3CX environment. |
| **Microsoft SQL Server 2016 or above (Including the free SQL Express edition)** | 3CX requires Microsoft SQL Server 2016 or later for database management. |
| **Static IP for VoIPTools and 3CX servers** | This is to ensure proper two-way communication, both the 3CX server (Relay) and the VoIPTools server. Dynamically assigned IP addresses are not supported. Additionally, it is recommended to use HTTPS for secure communication, which requires a FQDN for SSL/TLS certificate validation between the VoIPTools server and the Relay. |
| **Port number 6350 opened on your device** | Port 6350 is a specific network port used by 3CX for communication purposes. Opening this port on the device’s firewall allows incoming and outgoing traffic to pass through, enabling the 3CX software to send and receive data over the network effectively. |

> ![](https://voiptools.com/wp-content/uploads/2025/10/sticky_note_2_50dp.png)**NOTE:**
>
>
>
> - If you are installing 3CX Exporter in a server other than 3CX Server, then you should install ‘C++ 2010 redistribution package (X86)’ in the 3CX Server. You can install it from this [**link**](https://visualstudio.microsoft.com/downloads/).
> - Installation on a domain controller may require additional assistance

# Installation overview

| ![](https://voiptools.com/wp-content/uploads/2025/10/looks_one_50dp_000000_FILL0_wght400_GRAD0_opsz48-1.png) | **DOWNLOAD SOFTWARE** | You can order 3CX Exporter online at [https://www.voiptools.com](https://voiptools.com/downloads/). Your order confirmation email will include your license key and a link to download the software. |
| --- | --- | --- |
| ![](https://voiptools.com/wp-content/uploads/2025/10/looks_two_50dp_000000_FILL0_wght400_GRAD0_opsz48-1.png) | **INSTALL PREREQUISITES** | You must install several prerequisites before installing the 3CX Exporter. The Advanced Installer identifies and installs these applications automatically. Click **[here](https://voiptools.com/docs/exporter-v20/#4-toc-title)**to learn about the required prerequisites. |
| ![](https://voiptools.com/wp-content/uploads/2025/10/looks_3_50dp_000000_FILL0_wght400_GRAD0_opsz48-1.png) | **INSTALL 3CX EXPORTER** | This User Guide contains step-by-step instructions to successfully install 3CX Exporter. Begin by extracting the installer from the downloaded zip file (Step 1 above), then run the setup program named **Exporter.exe** |
| ![](https://voiptools.com/wp-content/uploads/2025/10/looks_4_50dp_000000_FILL0_wght400_GRAD0_opsz48-1.png) | **LOG IN TO THE WEB APPLICATION** | You can now log in to the web application using the extension number and the PIN. |

> ![](https://voiptools.com/wp-content/uploads/2025/10/sticky_note_2_50dp.png) **NOTE**:
>
>
>
> - When installing SQL Server, we recommend you install it in “Mixed Mode” to include SQL Authentication, and install SQL Management Studio
> - When installing IIS, be sure to install Basic Authentication, .Net Extensibility, and ASP.Net 4.X

# Step-by-step Installation Procedure

The following section guides you through a detailed walk-through of the installation process:

## **Step 1: Download 3CX Exporter.**

Find the software download link in the **Order Confirmation Email**, or you can download the application by following the procedure,

1. Open your browser and go to the **VoIPTools official website** or click ***[here](https://voiptools.com/downloads/)***to get redirected to the website.
2. Search for the**Exporter Application** and click the **Download**![](https://voiptools.com/wp-content/uploads/2024/01/download-button.png)button to download your application.

## **Step 2: Install Prerequisites**

Click on the software installer that was downloaded in step 1 above. The installation wizard will automatically identify the needed prerequisites and assist you with the installation of the prerequisites needed to run ‘3CX Exporter’. These include SQL Server Express (Web Installer) and SQL Server Management Studio.

1. Click the downloaded installer executable to launch the **Prerequisites Setup Wizard** and click **Next.**

![Prerequisites Setup Wizard](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-2.png)
Figure 1: Prerequisites Setup Wizard

1. In the **Prerequisites** window, the installer will identify the missing prerequisites. It is important that you install all the required prerequisites. However, you can select/unselect the applications to be installed based on your unique requirements. Click **Next** to continue.

 

![Select Prerequisites to Install](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-Select-Prerequisites-to-Install.png)
Figure 2: Select Prerequisites to Install

 

The installer will download and install the selected applications.

![Prerequisites Installation in Progress](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-4.png)
Figure 3: Prerequisites Installation in Progress

1. In the **Microsoft SQL Server License Terms**click the **Accept**button to acknowledge the license terms and continue.
   - This page appears if you do not have **SQL Server Express** preinstalled in your device.

![SQL Server Express: Accept License Terms](https://voiptools.com/wp-content/uploads/2024/11/screenshot-CW-V20-SQL-license.png)
Figure 4: SQL Server Express: Accept License Terms

1. View the SQL Server Media target location in the **Media Location** field. If required, you can click the **Browse**button to change the location. Click **Install** to begin the installation of SQL Server Express.

![SQL Server Express: Target Location](https://voiptools.com/wp-content/uploads/2024/11/screenshot-CW-V20-server-express-target-location.png)
Figure 5: SQL Server Express: Target Location

SQL server installation is in progress. This may take several minutes to complete.

![SQL Server Installation In Progress](https://voiptools.com/wp-content/uploads/2024/11/screenshot-CW-V20-server-installation-in-progress.png)
Figure 6: SQL Server Installation In Progress

1. Click the **Close**button once the prerequisites are installed.

![SQL Server Express: Installed Successfully](https://voiptools.com/wp-content/uploads/2024/11/screenshot-CW-V20-server-express-installated-successfully.png)
Figure 7: SQL Server Express: Installed Successfully

1. In the confirmation message box, click **Yes** to reboot the computer.

![SQL Server Express: Reboot your computer](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-reboot-your-computer.png)
Figure 9: SQL Server Express: Reboot your computer

## **Step 3: Start the installation process**

1. After all the prerequisites are installed, the **3CX Exporter Setup Wizard** appears. Click **Next** to Continue.

[![](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-Setup-Wizard-screen.png)](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-Setup-Wizard-screen.png)
Figure 10: 3CX Exporter Setup Wizard

1. On the **Select Installation Folder** window, the **Folder** field displays the location where the ‘3CX Exporter’ will be installed. Note that you cannot change the path.
2. Click **Next** to continue.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-7.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-7.png)
Figure 11: Installation Folder Location

## **Step 4: Test Relay Settings**

1. In the **3CX Relay Services** window, in the **Relay Host** field, enter *the FQDN of your 3CX server*.
2. Enter*880*1 in the **Relay Port** field.
3. Enter the *public key*you took from **VoIPTools Relay services**in the **Public Key**text area.

[![](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-Test-Relay-Settings.png)](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-Test-Relay-Settings.png)
Figure 12: Configure Relay Services

1. Click the **Test Relay Settings**to confirm ‘3CX Exporter’ can communicate with the Relay services running on the 3CX server.
2. If the ‘3CX Exporter’ is successfully able to communicate with the Relay services that run on the 3CX server, a **Success** message box appears. Click **OK**. If the test fails, you will not be able to continue until communication with the relay is established.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-9.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-9.png)
Figure 13: Test Relay Success Message Box

## Step 5: Configuring SQL Connection

The **SQL**tab lets you set up the database. You can select either SQL or MYSQL depending on the database you prefer.

### SQL:

You can set up the SQL database using SQL Authentication or Windows Integrated Authentication.

#### SQL Authentication

1. Select the **SQL**radio box to use the SQL database.
2. Enter *your server name* in the **Server** field.
   - If using the free ***SQL Express Edition***, the default SQL Instance name is ***SQLExpress***.

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **NOTE:**
>
>
>
> - If you want to use ‘SQL Authentication’, then install SQL Server in ‘Mixed‘ mode.
> - If SQL Server is installed on a server other than the server where 3CX Exporter is installed, you will need to configure SQL Server to allow remote connections.

1. Enter *your credentials* in the**Username** and**Password** fields.

> **![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png)** **NOTE:**
>
>
>
> Make sure that you select a SQL Login that has sufficient permissions to alter the database and create SQL objects.

1. Select or enter *3CX Exporter* in the **Database** dropdown.

[![](https://voiptools.com/wp-content/uploads/2026/08/Figure_14-1.png)](https://voiptools.com/wp-content/uploads/2026/08/Figure_14-1.png)
Figure 14: Configuring SQL Database

 

1. In the **Test SQL Connections** section, click the **Tool**button to test the connection.

[![](https://voiptools.com/wp-content/uploads/2026/08/Figure_15.png)](https://voiptools.com/wp-content/uploads/2026/08/Figure_15.png)
Figure 15: SQL Authentication – Test Connection Success

### MySQL:

1. Click the **MySQL**radio box to use the MySQL database.
2. Enter *the name of the server* in the **Server**field.
3. Enter *the name of the database* in the **Database**field.
4. Enter *your credentials* in the **Admin User** and the **Password** fields.

[![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-Configuring-MySQL-Server-.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-Configuring-MySQL-Server-.png)
Figure 16: Configuring MySQL Server

1. Click the **Tool**button to test the connection.

[![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-mysql-server-connection-success-message-box.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-mysql-server-connection-success-message-box.png)
Figure 17: MySQL Connection Test Successful Message Box

 

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **NOTE:**
>
>
>
> *The first time you install 3CX Exporter,***DO NOT***enter a database name. Choose***Select or enter a database name***and leave the database name blank. The installer will create the SQL database automatically and apply the necessary permissions. If upgrading 3CX Exporter from a previous version, select the existing database from the list.*

 

### POSTGRESQL:

1. Click the **POSTGRESQL**radio box to use the POSTGRESQL database.
2. Enter *the name of the server* in the **Server**field.
3. Enter *the name of the database* in the **Database**field.
4. Enter *your credentials* in the **Username** and the **Password** fields.

[![](https://voiptools.com/wp-content/uploads/2026/08/Figure_16-1.png)](https://voiptools.com/wp-content/uploads/2026/08/Figure_16-1.png)
Figure 18: Configuring POSTGRESQL Server

1. Click the **Tool**button to test the connection.

[![](https://voiptools.com/wp-content/uploads/2026/08/Figure_17-1.png)](https://voiptools.com/wp-content/uploads/2026/08/Figure_17-1.png)
Figure 19: POSTGRESQL Connection Test Successful Message Box

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **NOTE:**
>
>
>
> *The first time you install 3CX Exporter,***DO NOT***enter a database name. Choose***Select or enter a database name***and leave the database name blank. The installer will create the SQL database automatically and apply the necessary permissions. If upgrading 3CX Exporter from a previous version, select the existing database from the list.*

 

#### Windows Integrated Authentication

1. To use **Windows Integrated Authentication** check the **Trusted Connection (Windows integrated authentication)** checkbox.
   - The VoIPTools installer will create a local Windows user name as “VoIPToys” and give you sufficient rights to this user to create/update the SQL database.

[![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-Windows-Integrated-Authentication-.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-Windows-Integrated-Authentication-.png)
Figure 20: Windows Integrated Authentication

1. In the **Advanced Installer** section, click the **Tool**button to test the connection.

[![](https://voiptools.com/wp-content/uploads/2023/11/screenshot-exporter-SQL-database-test-connection-success.png)](https://voiptools.com/wp-content/uploads/2023/11/screenshot-exporter-SQL-database-test-connection-success.png)
Figure 21: Windows Integrated Authentication – Test Connection Success

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **NOTE:**
>
>
>
> - *We recommend you use SQL Authentication rather than Windows authentication. Many of our tools leverage a Call Flow Designer (CFD) application running on the 3CX.* *Frequently our CFD applications require access to an SQL database. If the 3CX server and the database server are not in an Active Directory domain, Windows authentication will fail.*
> - *To use SQL Authentication, you must configure the SQL server to run in Mixed Mode. If you install SQL Server with our tools, we configure SQL in Mixed Mode.*

## **Step 6: Installing 3CX Exporter**

1. In the **Ready to Install**window, click **Install** to start the installation of the ‘3CX Exporter’.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-10.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-10.png)
Figure 22: Install 3CX Exporter

The application installation progresses. It may take several minutes to complete.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-11.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-11.png)
Figure 23: Installation of ‘3CX Exporter’ in Progress

1. Click the **Finish**button when the installation is completed.

[![](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-Finish-Button.png)](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-Finish-Button.png)
Figure 24: Installation Complete

 

## Step 7: Log in to the Web Application

1. Double-click the **3CX Exporter Icon**  ![3CX Exporter Icon](https://voiptools.com/wp-content/uploads/2026/08/Exporter_icon.png)  to open the web application.
2. On the **Login**page, do the following tasks,
   1. In the **Extension**field, enter your 3CX extension number.
   2. In the **PIN**field, enter your 3CX voicemail PIN.
   3. Click the **Login**button to log in to your account.

 

[![Login Page](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-login-page.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-login-page.png)
Figure 25: Login Page

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **NOTE:**
>
>
>
> Access to the 3CX Exporter application is limited to Manager accounts. If you attempt to log in as a User, access will be denied, and the following image will be displayed.

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon-5.png) **NOTE:**
>
>
>
> It is essential to re-register the Exporter application because the framework application has transitioned from Windows to Blazer.

# 3CX Exporter Web Application

## Overview of the Web Application:

This section explains to you the overview of the 3CX Exporter web application.

[![Overview](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Overview_annotated-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Overview_annotated-scaled.png)
Figure 26: 3CX Exporter Settings Menu Overview

| ![](https://voiptools.com/wp-content/uploads/2023/01/1-7.png) | **Left Side Panel** | The left navigation pane provides access to the main areas of 3CX Exporter: - **Reports** — Contains **Report Designer** and **Report Viewer**. - **Logs** — Provides access to application logs. - **Settings** — Opens the configuration page described above and is highlighted when active. |
| --- | --- | --- |
| ![](https://voiptools.com/wp-content/uploads/2023/01/2-5.png) | **Logout Button** | Displays the name of the user. You can log out using the **Logout**![](https://voiptools.com/wp-content/uploads/2023/01/logout.png)button. |
| ![](https://voiptools.com/wp-content/uploads/2023/01/3-6.png) | **[Support Resources Button](https://voiptools.com/docs/exporter-v20/#25-toc-title)** | The **Support Resources**tab gives you general information about the software and the VoIPTools company. |
| ![](https://voiptools.com/wp-content/uploads/2023/01/4-5.png) | **Display Pane** | The main content area showing the active page. |

 

## Settings Menu

The **Settings** menu is the first page displayed after you log in to 3CX Exporter. Use this page to configure export settings, data processing, retention policies, role-based access, and custom branding.

| **Section Name** | **Purpose of the section** |
| --- | --- |
| **[Export Frequency](https://voiptools.com/docs/exporter-v20/#21-toc-title)** | Ensures timely synchronization of data from your 3CX database to the Exporter database. |
| **[Export Tables](https://voiptools.com/docs/exporter-v20/#22-toc-title)** | Grants control over which data tables are exported to your database. |
| **[CDR Settings](https://voiptools.com/docs/exporter-v20/#23-toc-title)** | Streamlines Call Detail Record (CDR) file management, automating processes and saving resources. |
| **[Retention Policy](https://voiptools.com/docs/exporter-v20/#24-toc-title)** | Allows you to configure the automated deletion of older CDR files, optimizing data storage and system efficiency. |
| **[Role Access Permissions](https://voiptools.com/docs/exporter-v20/#24-toc-title)** | Manages page access and permissions for each user role. |
| **[Custom Branding](https://voiptools.com/docs/exporter-v20/#24-toc-title)** | Configures custom branding settings for the application. |

[![Settings Menu](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Overview-1-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Overview-1-scaled.png)
Figure 27: Settings Menu

### Export Frequency Section

In the Export Frequency section, you can define how often you want to export tables to the database. This setting controls the automatic synchronization of updates from the 3CX database to the Exporter database.

To set the export frequency, follow the procedure,

1. In the **Settings**menu, expand the **Export Frequency**section.
2. In the E**xport Frequency** field, set the frequency (in seconds).

[![Export Frequency Section](https://voiptools.com/wp-content/uploads/2026/08/Export_Frequency_Section.png)](https://voiptools.com/wp-content/uploads/2026/08/Export_Frequency_Section.png)
Figure 28: Export Frequency Section

### Export Tables Section

In the **Export** screen, you can set up the exporting of tables. From here, you can select and export the desired tables from the list to the database.

Follow the procedure to export the tables to the database,

1. In the **Settings**menu, expand the **Export Tables** section.
2. Select the tables to export to the database and click the **Save**button.

You can set the export frequency in the **[Export Frequency](https://voiptools.com/docs/exporter-v20/#21-toc-title)** section.

[![Export Tables Section](https://voiptools.com/wp-content/uploads/2026/08/Export_Tables_Section.png)](https://voiptools.com/wp-content/uploads/2026/08/Export_Tables_Section.png)
Figure 29: Export Tables Section

### CDR Settings Section

The CDR Settings section lets you manage and process your CDR (Call Detail Record) files within the 3CX Console. By configuring the CDR Settings and **[Delete Policy](https://voiptools.com/docs/exporter-v20/#24-toc-title)**, you can streamline the storage and maintenance of your call records. This ensures that older processed CDR files are automatically deleted, saving you time and resources.

Follow the procedure to process CDR files or Click to learn***[how to configure 3CX to create CDR files](https://voiptools.com/docs/exporter-v20/#26-toc-title),***

1. In the **Settings** menu, expand the **CDR Settings**section.
2. Check the **Process CDR Files** check box.
3. Click the **Restart**![](https://voiptools.com/wp-content/uploads/2023/01/refresh-1.png) button to save your settings.

You can configure the delete policy of the CDR files in the **[Delete Policy section](https://voiptools.com/docs/exporter-v20/#24-toc-title)**.

[![CDR Settings Section](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_CDR_Settings.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_CDR_Settings.png)
Figure 30: CDR Settings Section

### Retention Policy Section

Use **Retention Policy** to remove processed CDRs after a set number of days. CDR means Call Detail Record, which contains details about a call.

#### Enable CDR deletion

1. Expand **Retention Policy**.
2. Select **Enable automatic deletion of processed CDRs older than**.
3. Enter the number of days in **Retention Period (Days)**.
4. Select the time in **Delete At (Time)**.

Processed CDRs that are older than the set retention period are deleted at the selected time each day.

***To stop CDR deletion:** Do not select **Enable automatic deletion of processed CDRs older than**.*

[![Delete Policy Section](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Retention_Policy-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Retention_Policy-scaled.png)
Figure 31: Delete Policy Section

### Role Access Permissions

Use **Role Access Permissions** to control which pages each role can access in 3CX Exporter.

#### Select a role

1. Expand **Role Access Permissions**.
2. Select a role from the **Role** list.
3. Review the permissions shown for that role.

The available roles include **User, Receptionist, Supervisor, Department Administrator, Manager, Owner, System Administrator,** and **System Owner**.

[![Role Dropdown Options](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Role_Access_Permissions_Role_Dropdown-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Role_Access_Permissions_Role_Dropdown-scaled.png)
Figure 32: Role Dropdown Options

#### Set page permissions

1. Select or clear **Report Designer** to allow or block access.
2. Select or clear **Report Viewer** to allow or block access.
3. Select or clear **Logs** to allow or block access.
4. Select or clear **Settings** to allow or block access.

The selected checkboxes show the pages that the chosen role can access.

[![Page Checkbox Options](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Role_Access_Permissions-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Role_Access_Permissions-scaled.png)
Figure 33: Page Checkbox Options

#### Reset permissions

Select **Reset** to restore the permission settings for the selected role.

#### System Administrator and System Owner permissions

**System Administrator** and **System Owner** have all four page permissions selected by default. Their checkboxes appear greyed out and cannot be changed from this section.

### Custom Branding

Make the portal look like your own: change the logo, header title, and accent colors.

[![Custom Branding section expanded showing color pickers and logo upload area](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Custom_Branding-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Settings_Menu_Custom_Branding-scaled.png)
Figure 34: Custom Branding section expanded showing color pickers and logo upload area

1. 1. Click **Custom Branding** to expand the section.
   2. Enter a **Header Title** to replace the default application name at the top of the portal.
   3. Upload a logo via **Choose File**, or pick a previously uploaded one from the **Select Logo** ![](https://voiptools.com/wp-content/uploads/2026/01/arrow_drop_down.png) dropdown.

1. Set your colors using the pickers below.
2. Click **Apply** to save everything.

#### Color settings

  **Header Gradient Color:**Top and bottom gradient colors for the portal header **Grid Color:**Background color for table/grid headers across the whole app **Accent Text Color:**Color for page titles and highlighted text throughout the portal **Grid Preview Text:**Text color inside grid headers — updates automatically when grid color changes, but can be overridden manually  **Before clicking Reset:** Note down your color hex codes. There’s no undo once defaults are restored.

## Reports – Report Designer

The **Report Designer** is a visual tool that lets you build and customize report templates for 3CX Exporter. You can add data fields, arrange layout elements, and preview the result before anyone runs a report.

### Getting to Report Designer

1. **Open the Reports menu.**
   In the left sidebar, click `Reports`. The section expands to show two options.
2. **Click Report Designer.**
   The designer workspace opens in the main area.

The Report Designer has four main areas. Understanding what each one does will make the rest of this guide much easier to follow.

![](https://voiptools.com/wp-content/uploads/2026/08/report_designer_annotated-scaled.png)

Figure 35: Report Designer Overview

| ![](https://voiptools.com/wp-content/uploads/2023/01/1-7.png) | **Toolbar** | Provides editing actions like cut, copy, paste, undo, redo, and zoom controls. |
| --- | --- | --- |
| ![](https://voiptools.com/wp-content/uploads/2023/01/2-5.png) | **Left Sidebar** | Contains tools for inserting elements onto the canvas, such as text labels, tables, images, and charts. |
| ![](https://voiptools.com/wp-content/uploads/2023/01/3-6.png) | **Design Canvas** | The main work area where you arrange and preview the report layout. |
| ![](https://voiptools.com/wp-content/uploads/2023/01/4-5.png) | **Right Panel Tabs** | Four icon tabs on the far right that each open a different configuration panel. |

 

### Left Sidebar – Design Tools

The left sidebar holds all the elements you can place on a report. Click any icon and then click on the canvas to place that element. The tools are organized into four groups.

The tools are grouped into four categories based on what they do. The groupings below match the visual sections separated by spacing in the sidebar.

[![Left Sidebar – Design Tool Icons](https://voiptools.com/wp-content/uploads/2026/08/report_designer_leftpalette-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/report_designer_leftpalette-scaled.png)
Figure 36: Left Sidebar – Design Tool Icons

#### Text and Layout Elements

| Tool Name | What it places |
| --- | --- |
| Label | A static text block. Use this for headings, column titles, or any text that does not change based on data. |
| Rich Text | A text field that supports formatted content such as bold, italic, and lists. |
| Panel | A blank container box used to group and organize other elements within a band. |
| Character Comb | A fixed-width text field divided into individual cells. Useful for forms where each character needs its own box, such as ID numbers. |
| Checkbox | A checkbox element that displays a true or false value from a data field. |
| Picture Box | An image placeholder. Drop a logo, photo, or graphic into this element. |
| Table | A structured data table for displaying multiple rows and columns of records. |

#### Drawing Elements

| Tool Name | What it places |
| --- | --- |
| Line | A straight line. Use it to separate sections or add visual structure to the report layout. |
| Shape | A geometric shape such as a rectangle, circle, or triangle. Useful for design accents or highlighting areas. |
| Barcode | A barcode element. Bind it to a data field to generate barcodes or QR codes from your report data. |

#### Data Visualization and Advanced Elements

| Tool Name | What it places |
| --- | --- |
| Chart | A visual chart element. Connect it to a data source to generate bar charts, line graphs, pie charts, and more. |
| Gauge | A circular gauge or dial indicator. Good for showing progress or performance metrics at a glance. |
| Sparkline | A small inline chart that shows a data trend without axes or labels. Fits inside a table cell. |
| Cross Tab | A pivot-style table that groups data across both rows and columns. Use it for summary and comparison reports. |
| Sub Report | An embedded report inside your main report. Use it to pull in a separate report template as a section of this one. |
| PDF Content | Embeds PDF file content directly into the report layout. |
| PDF Signature | A signature field for PDF output. Allows a digital signature to be placed in the report. |

#### Page and Structure Controls

| Tool Name | What it places |
| --- | --- |
| Table of Content | Generates a table of contents based on bookmarks or report sections. Useful for multi-section reports. |
| Page Break | Forces the report to start a new page at that point in the layout. |
| Cross-band Box | A box that spans across multiple bands on the canvas. Use it to draw a border or background that covers more than one section. |
| Page Info | Displays page numbers, total page count, or print date. Place it in a margin band for standard page footers. |
| Cross-band Line | A line that spans across multiple bands, similar to Cross-band Box but as a single line instead of a filled box. |

### Toolbar

The toolbar runs across the top of the canvas. It gives you quick access to common editing actions.

[![Toolbar Icons Overview](https://voiptools.com/wp-content/uploads/2026/08/report_designer_toolbar_focus-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/report_designer_toolbar_focus-scaled.png)
Figure 37: Toolbar Icons Overview

| Control | What it does |
| --- | --- |
| ☰ (Menu) | Opens a file menu with options to create, open, save, and configure the report. See the [Menu](#exp-menu-section) section below. |
| Cut / Copy / Paste | Standard clipboard actions for selected elements on the canvas. |
| Delete (✕) | Removes the selected element from the canvas. |
| Undo / Redo | Steps backward or forward through your recent changes. |
| Zoom controls | Use the minus and plus buttons or the dropdown box to change the canvas zoom level. 💡**Tip**Set the zoom to 50% or 75% when you want to check the overall page layout. Use 150% or 200% when placing or aligning small elements with precision. |
| Validate Binding | The Validate Binding button checks all data fields on the canvas to ensure they are connected to valid data sources and highlights any broken or invalid bindings. Run it before entering **Preview** mode to prevent blank fields or missing data in the report. |
| Full screen (⛶) | The Full Screen button expands the design canvas to fill your browser window, providing more workspace for designing complex reports. Click it again to return to the standard view while keeping all toolbar controls and panels accessible. |
| Scripts (📜) | The Scripts button (the page icon at the right of the toolbar) opens a code editor that replaces the visual canvas. It lets you write custom logic for the report using standard HTML and CSS. Use this when you need behavior that the visual design tools cannot produce on their own. |
| DESIGN / PREVIEW | Switches between editing mode and a live preview of the report. |

#### Menu

Click the three-line icon (☰) at the far left of the toolbar to open the Menu. This panel gives you file management options for your report template.

[![Menu Panel Open](https://voiptools.com/wp-content/uploads/2026/08/report_designer_menu_focus-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/report_designer_menu_focus-scaled.png)
Figure 38: Menu Panel Open

| Option | What it does |
| --- | --- |
| New | Creates a blank report template on the canvas. Any unsaved work on the current report will be lost. |
| New via Wizard… | Opens a step-by-step guide that helps you build a new report by choosing data fields and layout options. A good starting point for first-time users. |
| Open… | Loads an existing report template file from your system. |
| Design in Report Wizard… | Opens the current report in the guided wizard view so you can make changes using the step-by-step interface instead of the free-form canvas. |
| Add Data Source… | Connects a new database or data feed to the report. This is the same as using the **Add Data Source** button in the Field List panel. |
| Localization… | Opens tools for translating the report into other languages. |
| Save… | Saves the current report template. This option appears grayed out if there are no unsaved changes. |
| Save As… | Saves a copy of the report template with a new name. Use this to create variations of an existing report without overwriting the original. |
| Exit | Closes the Report Designer and returns you to the previous screen. |

  💡**Tip**Use **New via Wizard**when building a report for the first time. It walks you through connecting data and arranging columns so you start with a working template rather than an empty canvas.

#### Scripts Toolbar Controls

When Scripts mode is *active*, the toolbar changes to show a set of controls specific to code editing.

[![Scripts Toolbar Controls](https://voiptools.com/wp-content/uploads/2026/08/report_designer_htmltoolbar_focus-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/report_designer_htmltoolbar_focus-scaled.png)
Figure 39: Scripts Toolbar Controls

| Control | What it does |
| --- | --- |
| Cut | Removes the selected code and copies it to the clipboard |
| Copy | Copies the selected code to the clipboard without removing it |
| Paste | Inserts the code on the clipboard at the cursor position |
| Clear (X) | Removes all code from the editor |
| Undo | Reverts the last change made in the editor |
| Redo | Reapplies a change that was undone |
| Element selector dropdown | Lists every element in the report: the Report itself, each band (TopMargin1, Detail1, BottomMargin1), and any elements placed on the canvas such as label1. Select an element here to write a script that targets it |
| Select event dropdown | Lists the events that can trigger your script for the selected element. Choose an event and the editor creates the matching script entry |
| Validate (check mark) | Checks the code in the editor for syntax errors before you apply it. Run this after writing or editing any script to confirm the code is correct. If there are no errors, the check mark stays active |
| Return to Designer | Closes the Scripts editor and returns you to the full visual Design canvas with all tools, panels, and the sidebar restored. Scripts you wrote are saved when you switch back |

 

##### How to Write and Apply a Script

1. **Open Scripts mode** by clicking the Scripts button in the main toolbar.
   [![Scripts Button](https://voiptools.com/wp-content/uploads/2026/08/report_designer_icon_scripts_button_focus-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/report_designer_icon_scripts_button_focus-scaled.png)
   Figure 40: Scripts Button
2. **Select the element** you want to target from the element selector dropdown on the left.

   [![Element Dropdown Options](https://voiptools.com/wp-content/uploads/2026/08/report_designer_scripts_element_dropdown_focus-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/report_designer_scripts_element_dropdown_focus-scaled.png)
   Figure 41: Element Dropdown Options
3. **Select an event** from the Select event dropdown. The editor adds a script block for that event.

   [![Event Dropdown Options](https://voiptools.com/wp-content/uploads/2026/08/report_designer_eventdropdown_focus-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/report_designer_eventdropdown_focus-scaled.png)
   Figure 42: Event Dropdown Options
4. **Write your code** inside the script block in the editor area.

   [![Code Editor Area](https://voiptools.com/wp-content/uploads/2026/08/report_designer_codeeditor_focus-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/report_designer_codeeditor_focus-scaled.png)
   Figure 43: Code Editor Area
5. **Click the Validate button** (✓) to check for errors. Fix any issues flagged before continuing.

   [![Validate Button in Scripts mode](https://voiptools.com/wp-content/uploads/2026/08/report_designer_validate_button_focus-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/report_designer_validate_button_focus-scaled.png)
   Figure 44: Validate Button in Scripts mode
6. **Click Return to Designer** to go back to the visual canvas. Your scripts are saved.

   [![Return to Designer Button](https://voiptools.com/wp-content/uploads/2026/08/report_designer_designer_mode_button-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/report_designer_designer_mode_button-scaled.png)
   Figure 45: Return to Designer Button

## Report Viewer

The **Report Viewer** lets you run, view, and export any report template built in the Report Designer. Set your parameters, click Submit, and the report loads in the preview area ready to print or download.

### Getting to Report Viewer

1. **Click Reports** in the left sidebar to expand the section.
2. **Click Report Viewer.** The viewer opens with a blank preview area and a Select Report dropdown at the top right.

### Select a Report

The first thing to do is choose which report to run. The dropdown groups reports by category so you can find the right one fast.

1. **Click the Select Report dropdown** at the top right of the page.

   [![Select Report Dropdown Options](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Report_Viewer_Select_Report_Dropdown-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Report_Viewer_Select_Report_Dropdown-scaled.png)
   Figure 46: Select Report Dropdown Options
2. **Choose a report** from the list. Reports are grouped under headings such as **Default Reports / Call Reports** and **Default Reports / Queue Reports**.

Once you select a report, the preview area shows **Waiting for parameter values…** and the Preview Parameters panel appears on the right. Fill in the parameters before the report can load.

### Preview Parameters

The **Preview Parameters** panel appears on the right side of the screen when a report is selected. It controls what data the report shows. Fill in all fields before clicking Submit.

[![Preview Parameters Expanded Panel](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Report_Viewer_Report_Selected_Preview_Parameters_Submit_Button-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Report_Viewer_Report_Selected_Preview_Parameters_Submit_Button-scaled.png)
Figure 47: Preview Parameters Expanded Panel

### Report Viewer – Generated Report

[![Generated Report](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Report_Viewer_Overview-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Report_Viewer_Overview-scaled.png)
Figure 48: Generated Report

After a report loads, a toolbar appears at the top of the preview area. The toolbar covers page navigation, zoom, print, export, search, and full screen controls.

### Page Navigation

The navigation controls on the left side of the toolbar let you move between pages of the report.

| Control | What it does |
| --- | --- |
| |◀ (First page) | Jumps to page 1 of the report. |
| ◀ (Previous page) | Goes back one page from where you are now. |
| Page counter dropdown | Shows the current page number and total page count, for example 1 of 3. Click the dropdown arrow to jump to a specific page number without stepping through each one. |
| ▶ (Next page) | Moves forward one page. |
| ▶| (Last page) | Jumps to the final page of the report. |

### Grid View

The grid icon in the toolbar toggles a data table view of the report. When active, the preview switches from the visual page layout to a plain rows-and-columns table of the same data, which is easier to scan for specific values.

1. **Click the grid icon** to switch to data table view. The icon becomes highlighted to show the mode is active.
2. **Click it again** to return to the standard page layout view.

### Edit Report

The edit icon (✏) opens the current report template in the Report Designer. Use it to make layout or data changes to the template without leaving the Report Viewer.

1. **Click the edit icon** in the toolbar. The Report Designer opens with the current report template loaded.
2. **Make your changes** in the designer.
3. **Return to Report Viewer** and run the report again to see the updated output.

### Print

There are two print buttons in the toolbar. They look the same but do different things.

| Button | What it does |
| --- | --- |
| Print ( first icon) | Sends the full report to your printer. All pages print. |
| Print current page ( second icon) | Prints only the page you are currently viewing. Useful when you need just one section of a multi-page report. |

### Export

The export button (⬆) saves the report as a file on your computer. Click the arrow next to it to choose the file format you want.

| Format | Best used for |
| --- | --- |
| PDF | Sharing a read-only version of the report. The layout and formatting are preserved. |
| XLS / XLSX | Opening the report data in Microsoft Excel for further analysis. XLSX is the current Excel format. XLS is the older version. |
| RTF | Opening the report in Microsoft Word or a word processor that supports rich text. |
| DOCX | Opening the report as a Word document in its current format. |
| MHT | Saving the report as a single-file web archive. Opens in a browser. |
| HTML | Saving the report as a web page. Can be opened in any browser or embedded in a site. |
| Text | Exporting plain text with no formatting. Useful for data transfer or log review. |
| CSV | Exporting the data as comma-separated values. Use this to import data into another system or spreadsheet tool. |
| Image | Saving each report page as an image file such as PNG or JPEG. |

## Logs Menu

The **Logs Menu**lets you view the login and logout events of all the sessions along with ‘Date’ and ‘Time’ that is according to the time zone set in the ‘Web Portal’ tab in Settings menu.

[![Logs Menu Overview](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Logs_Overview-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Logs_Overview-scaled.png)
Figure 49: Logs Menu Overview

**Field Definitions**

| **Field** | **Definition** |
| --- | --- |
| **Logs Information Table** | Displays system events and activity records used for monitoring, troubleshooting, and auditing. It helps users review application behavior, track system actions, and identify issues based on the selected log file. |
| **Date/Time** | Displays the date and time when the log event occurred based on the system-generated timestamp. |
| **Type** | Indicates the category or severity level of the log entry to help identify the nature of the event: **INF** = Informational (normal activity), **WRN** = Warning (potential issue), **ERR** = Error (system issue or failure). |
| **Method** | Displays the system component, process, or function where the log event originated. |
| **Message** | Shows detailed information about the recorded event, including actions performed, warnings, errors, or system responses. |
| **Select Log File** | Allows you to select a specific log file to view its recorded events. |
| **Page Size** | Defines the number of log entries displayed per page. |

### Configure 3CX to Automatically Create CDR Files

Besides extracting data directly from the 3CX PostgreSQL database, Exporter efficiently exports Call Detail Records (CDR) as text files. These CDR files encapsulate valuable call information, encompassing participants, durations, and the call chain. While not as extensive as the PostgreSQL database, the CDR files offer a more user-friendly data structure. If the CDR files fulfill your data requirements, it’s advisable to prioritize their use over accessing the PostgreSQL database.

Follow the procedure to configure 3CX to create these CDR files,

1. Log in to the **3CX Management Console** with valid credentials.
2. On the left navigation pane, click the **Advanced**![](https://voiptools.com/wp-content/uploads/2023/03/settings.png) option.

[![Left Side Panel - Advanced Menu](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-Left-Side-Pane-Advanced-menu.png)](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-Left-Side-Pane-Advanced-menu.png)
Figure 50: Left Side Panel – Advanced Menu

1. In the **Advanced Menu**dropdown, click the **CDR**option.

[![Advanced Menu Dropdown - CDR Option](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-CDR-optiion.png)](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-CDR-optiion.png)
Figure 51: Advanced Menu Dropdown – CDR Option

1. In the **CDR Log Type** dropdown, select the**Single File For Each Call**option.

[![CDR Log Type Dropdown](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-CDR-log-type-dropdown-1024x448.png)](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-CDR-log-type-dropdown-1024x448.png)
Figure 52: CDR Log Type Dropdown

1. In the**Manage CDR Output Fields**popup, select *the desired output fields* and click the **OK**button.

[![Select CDR Output Fields](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-cdr-output-fields-popup.png)](https://voiptools.com/wp-content/uploads/2024/02/Screenshot-Exporter-V20-cdr-output-fields-popup.png)
Figure 53: Select CDR Output Fields

1. Once 3CX has been configured to generate CDR files, you must configure Exporter to[**process the files and import the data into SQL or MySQL**.](https://voiptools.com/docs/exporter-v18/#23-toc-title)

> **NOTE**:
>
>
>
> It is important that you configure 3CX to save each call as an individual file.

> **NOTE**:
>
>
>
> Be sure not to remove any fields from the list or change the order of the fields. Exporter expects all the fields to be exported in the default order. Therefore, order is important. Below is a list of all the fields in the proper order.

Once you have successfully configured 3CX to automatically create CDR files, all the CDR data from then on will be exported into the Exporter database.

> **NOTE**:
>
>
>
> Exporter will place the CDR data extracted from the 3CX CDR files into the table named cdr. Click the link to learn how to **[view the 3CX CDR files](https://voiptools.com/docs/exporter-v20/#30-toc-title)**.

## **CDR Records – Output Field Definitions**

The following are the supported output fields and what they mean

| **HISTORYID** | This is the call number – each call has a number, internal to 3CX. It is useful for call tracking. |
| --- | --- |
| **CALLID** | This is the Call ID – the unique identifier of the call. |
| **DURATION** | Call Duration time. |
| **TIME-START** | Call Start time. |
| **TIME-ANSWERED** | Answered time. |
| **TIME-END** | Call terminated time. |
| **REASON-TERMINATED** | Why the call was terminated. |
| **FROM-NO** | Source caller number. |
| **TO-NO** | Destination To Number. |
| **FROM-DN** | Distinguished name of caller – this is 3CX Specific Can be omitted by 3rd party developers. |
| **TO-DN** | Distinguished name of To – Destination – this is 3CX Specific Can be omitted by 3rd party developers. |
| **DIAL-NO** | Dialed number. |
| **REASON-CHANGED** | Billing code dialed after the destination (for example **Sales). |
| **FINAL-NUMBER** | Final Number – the final number which was replaced (In a transfer this will be the final connected number). |
| **FINAL-DN** | The distinguished name of the final number entity – this is 3CX Specific and can be omitted by 3rd party dev. |
| **BILL-CODE** | All endpoints that were involved in the call. |
| **BILL-RATE** | The Cost of the call is calculated with simple proportion/minute. |
| **BILL-COST** | The billing rate matched the prefix of the rate. This is used to apply a cost calculation variance. |
| **BILL-NAME** | The rate name of the billing variance. |
| **CHAIN** | The Distinguished Name of the final number entity – this is 3CX Specific and can be omitted by 3rd party dev. |
| **FROM-TYPE** | Source type |
| **TO-TYPE** | Destination type. |
| **FINAL-TYPE** | Final destination type. |
| **FROM-DISPNAME** | Source Display Name. |
| **TO-DISPNAME** | Destination Display Name. |
| **FINAL-DISPNAME** | Final destination Display Name. |
| **MISSED-QUEUE-CALLS** | The number of missed calls for an extension in a queue. |

# Uploading images in the DN table

Follow the procedure to upload images to the DN table,

1. Open your **3CX Electron Phone**application.
2. In the left side menu, click the **General**tab.
3. Click the **Image Upload** ![](https://voiptools.com/wp-content/uploads/2023/01/file.png) icon to upload an image from your local device.

[![Upload Icon](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-upload-image.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-upload-image.png)
Figure 54: Upload Icon

1. Open your database application and you can see the image added to the extension in the **Pv_Contact_Image** column.

[![Image Added to the Database](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-DN-table-output-1024x424.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-DN-table-output-1024x424.png)
Figure 55: Image Added to the Database

> **NOTE:**
>
>
>
> The **pv_contact_image**column in your database will be visible if there is an image associated with at least one extension in the 3CX Electron Phone application.
>
>
>
> [![No Extension Having Picture](https://voiptools.com/wp-content/uploads/2023/10/screenshot-Exporter-database-without-image-column.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-Exporter-database-without-image-column.png)
> Figure 56: No Extension Having Picture

# View 3CX Database Records

1. Connect to database server.
2. Under the **Object Explorer** navigation pane, expand **Databases**, and then expand **3CX Exporter** and **Tables**to see various tables.
3. Right-click on any table to see the **Right-click menu**.
4. Choose **Select Top 1000 Rows** to view data in the workspace area.

[![View 3CX Records - List of Tables](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-view-3cx-database-records.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-view-3cx-database-records.png)
Figure 57: View 3CX Records – List of Tables

# View Data in Microsoft SQL Server Database

To view the exported data in the Microsoft SQL Server database, install the SQL Server Management Studio and follow the instructions below:

1. Connect to **Microsoft SQL Server** database server with valid credentials.
2. Under the **Object Explorer** navigation pane, expand Databases, and then expand **3CX Exporter** and **Tables**to see the **dbo.cdr** table.

[![dbo.cdr Table](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-dbo.cdr-table.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-dbo.cdr-table.png)
Figure 58: dbo.cdr Table

1. Right-click to open the**Right Click** menu and click on the **Execute**option to view the new CDR Output fields that you added through the 3CX Management Console.

[![New CDR Output Fields Added to the dbo.cdr table in the Database Server](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-CDR-Output-1.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-CDR-Output-1.png)
Figure 59: New CDR Output Fields Added to the dbo.cdr table in the Database Server

## Support Resources Screen

The **Support Resources** screen displays the version number of the application and the contact information of VoIPTools. Click on the link to learn about the **[comprehensive support](https://voiptools.com/docs/exporter-v20/#31-toc-title)**provided by VoIPTools.

- Click the **Support Resources** button on the top right of the application to open the Support Resources screen.

 

[![About Tab](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Support_Resources_Popup-scaled.png)](https://voiptools.com/wp-content/uploads/2026/08/Exporter_Support_Resources_Popup-scaled.png)
Figure 60: About Tab

 

# Need Support?

You get quick answers to most of your inquiries in our online manual. If you prefer direct contact, we offer various support channels, including phone, email, live chat, and our helpful VoIPTools forums.

![](https://voiptools.com/wp-content/uploads/2023/05/24-hours-support-2.png)

## 24/7 Support Availability

Rest assured, our dedicated team is here to assist you around the clock, every day of the year. Whether you're based in the USA or India, we're ready to provide prompt responses to your technical queries.

![](https://voiptools.com/wp-content/uploads/2023/05/windows-log-event.png)

## Windows Event Log for VoIPTools Applications and Services

For troubleshooting any application errors, our Windows Event Log contains a comprehensive list of error messages, warnings, and informative notes related to all our VoIPTools applications and services. It's a valuable resource to help you pinpoint and resolve any issues you may encounter.

![](https://voiptools.com/wp-content/uploads/2023/05/forums.png)

## Join Our Forum Community

Are you looking to collaborate with other VoIPTools customers facing similar challenges? Our forum is the perfect platform to exchange ideas, solutions, and best practices. Join the conversation at: [**https://www.voiptools.com/community/**](https://voiptools.com/blog/)

![](https://voiptools.com/wp-content/uploads/2023/05/live-chat.png)

## Real-Time Live Chat Assistance

Got questions that need immediate answers? Our chat support team is available to assist you in real time. Just click on the Live Chat button located at the lower right corner of our website, and we'll acknowledge your queries right away.

![](https://voiptools.com/wp-content/uploads/2023/05/email-support.png)

## Efficient Email Support

To ensure a thorough understanding of your concerns, email us at ***support@voiptools.com***. Describe your issue in detail, and we'll get back to you within one business day with the support you need.

![](https://voiptools.com/wp-content/uploads/2023/05/phone-support.png)

## Reach Us by Phone

If you prefer to speak with a representative directly, you can reach us at +1 801-642-4655. Our attentive team is available to take your calls from 8:00 AM to 6:00 PM (Central Standard Time).

# Comprehensive support services:

![](https://voiptools.com/wp-content/uploads/2023/05/free-support.png)

## Free Support

If you've purchased our products through a VoIPTools Partner, rest assured that they provide first-level support at no additional cost. Partners have access to 100% free technical assistance and actively participate in the troubleshooting process.

VoIPTools customers enjoy access to our online manuals and receive support through emails (with responses within one business day) and live chat. However, please note that we do not provide remote server login assistance.

![](https://voiptools.com/wp-content/uploads/2023/05/paid-support.png)

## Paid Support

For a more hands-on experience, consider our "Installation Support" package. Our expert support team can log in to your servers, and install and configure all our tools. This comprehensive service includes setting up SQL Server Express and Internet Information Server if necessary. We'll work closely with you to tailor our applications to meet your requirements.

We're committed to providing top-notch support to ensure your VoIPTools experience is smooth and hassle-free. Contact us today, and let us assist you in making the most of our powerful tools!