---
title: Exporter V18
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-v18/"
updated: "2024-10-15"
category: "Tools - V18"
---

# Exporter V18

# 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 efficiently 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. Effortlessly 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** | Accessing CDR files from a cloud-hosted 3CX server can be challenging. Fortunately, our Exporter provides a simplified solution by utilizing our Relay. This enables you to easily access CDR files remotely, 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 automatically in the background, ensuring that your data stays consistently up-to-date. |
| ![](https://voiptools.com/wp-content/uploads/2023/01/easy-archieving-2.png) | **EASY ARCHIEVING** | Efficiently archive historical information using 3CX Exporter. Effectively 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. Additionally, 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:**

- 3CX Version V18
-  Windows 10 or above
- Microsoft SQL Server 2016 or above (Including the free SQL Express edition), or MYSQL
- Windows Server 2012 (64-bit) or above
- .Net 4.7.2
- 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/).
- 3CX Relay Service
- Static IP for VoIPTools and 3CX servers
- Installation on a domain controller may require additional assistance

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **NOTE**:
>
>
>
> You need a Static IP for both VoIPTools and 3CX servers 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.

# Installation overview

| ![](https://voiptools.com/wp-content/uploads/2023/01/1-2.png) | **[DOWNLOAD SOFTWARE](https://voiptools.com/docs/exporter-v18/#7-toc-title)** | 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/2023/01/2.png) | **[INSTALL PREREQUISITES](https://voiptools.com/docs/exporter-v18/#8-toc-title)** | Several prerequisites must be installed before installing the 3CX Exporter. These prerequisites include Microsoft Internet Information Server (IIS) and Microsoft SQL Server |
| ![](https://voiptools.com/wp-content/uploads/2023/01/3.png) | **[INSTALL 3CX EXPORTER](https://voiptools.com/docs/exporter-v18/#9-toc-title)** | 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/2023/01/4.png) | [**REGISTER YOUR SOFTWARE**](https://voiptools.com/docs/exporter-v18/#12-toc-title) | You must register your license key to activate 3CX Exporter. Your license key is included in your order confirmation email, and can also be found in your order history on our website. |

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **NOTE**:
>
>
>
> While installing SQL Server, ensure the following,
>
>
>
> - Uninstall the previous versions of SQL Management Studio manually before installing the new version.
> - *Install it in “Mixed Mode” to include SQL Authentication, and install SQL Management Studio*

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **NOTE**:
>
>
>
> - 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’.  **

1. Find the software download link in the **Order Confirmation Email**, or you can find it in your order history on our website and download the 3CX Exporter application.
2. In the**Microsoft Defender SmartScreen**, click the**More Info** option.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-1.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-1.png)
***Figure 1: Windows Defender Screen***

1. Click the **Run Anyway** option to start the installation.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-More-info-screen.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-More-info-screen.png)
**Figure 2: Windows Defender - More Info screen**

## **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 .NET Framework (Web Installer), 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.**

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-2.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-2.png)
***Figure 3: 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.

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

The installer will download and install the selected applications.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-4.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-4.png)
***Figure 5: 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.

[![](https://voiptools.com/wp-content/uploads/2024/03/1.png)](https://voiptools.com/wp-content/uploads/2024/03/1.png)
***Figure 6: 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.

[![](https://voiptools.com/wp-content/uploads/2024/03/2.png)](https://voiptools.com/wp-content/uploads/2024/03/2.png)
***Figure 7: SQL Server Express: Target Location***

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

![](https://voiptools.com/wp-content/uploads/2024/03/3.png)
Figure: SQL Server Installation In Progress

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

[![](https://voiptools.com/wp-content/uploads/2024/03/4.png)](https://voiptools.com/wp-content/uploads/2024/03/4.png)
***Figure 8: SQL Server Express: Installed Successfully***

Microsoft SQL Management Studio installation is in progress. This may take several minutes to complete.

[![](https://voiptools.com/wp-content/uploads/2024/08/screenshot-OCM-SQL-Server-Management-Studio-Version-20.2.png)](https://voiptools.com/wp-content/uploads/2024/08/screenshot-OCM-SQL-Server-Management-Studio-Version-20.2.png)
***Figure 9: Microsoft SQL Server Management Studio: Installation in progress***

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

![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-reboot-your-computer.png)
Figure 10: 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/2023/02/Screenshot-Exporter-6.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-6.png)
***Figure 11:* *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 12: 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/2023/02/Screenshot-Exporter-8.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-8.png)
***Figure 13: 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 14: 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/2023/10/screenshot-exporter-SQL-database.png)
Figure 15: Configuring SQL database

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

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

#### 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)
Figure 17: 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)
Figure 18: 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.*

### 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)
Figure 18: 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)
Figure 19: 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.*

## **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 20: 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 21: Installation of ‘3CX Exporter’ in Progress***

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

[![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-installaiton-complete.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-installaiton-complete.png)
***Figure 22: Installation Complete***

## Step 7: Register your Software

To ensure the authorization of your license key, it is necessary to complete the registration process. By registering with VoIPTools, you gain access to a range of benefits:

| **Key Replacement Assistance** | In the unfortunate event of a lost license key, registering with VoIPTools lets us provide you with a replacement key promptly. |
| --- | --- |
| **Product Updates and Reminders** | By registering, you will receive timely notifications from VoIPTools regarding any product updates. Additionally, we will send reminders when your key is nearing its renewal date, ensuring uninterrupted access to our services.s |

1. Double-click the **3CX Exporter Icon** ![](https://voiptools.com/wp-content/uploads/2023/01/Config-to-Web-image-1.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.

![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-login-page.png)
Figure 23: 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/11/screenshot-exporter-login-view.png)
> Figure 24: User Login Restriction

1. Enter *your license*in the **License**Key field and other mandatory pieces of information and click the **Register** ![](https://voiptools.com/wp-content/uploads/2023/01/key.png)button to complete your software registration.

[![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-LICENSE-PAGE-1024x855.png)](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-LICENSE-PAGE.png)
Figure 24: Register Software

You will get a Success message box when your registration is successful. Now you can view the **Settings** tab in the left side panel.

![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-Success-Message-box-1024x495.png)
Figure 25: Success Message Box

> ![](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.

![](https://voiptools.com/wp-content/uploads/2024/10/fig-26-overview-edited-1024x542.png)
Figure 26: Overview

| ![](https://voiptools.com/wp-content/uploads/2024/09/number-one.png) | **Left Side Panel** | Let you make changes to the Exporter application or register your software with a valid license key. |
| --- | --- | --- |
| ![](https://voiptools.com/wp-content/uploads/2024/09/number-two.png) | **Settings Sections** | You can configure the Exporter settings by expanding the sections. |
| ![](https://voiptools.com/wp-content/uploads/2024/09/number-three.png) | **Processing Table** | Displays the current table being exported, providing real-time progress updates and ensuring efficient monitoring of large data exports. |
| ![](https://voiptools.com/wp-content/uploads/2024/09/number-four.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/2024/09/number-five.png) | **Restart Button** | Once you have made the changes to the Exporter settings, click the **Restart**![](https://voiptools.com/wp-content/uploads/2023/01/refresh-1.png) button to apply your changes. |
| ![](https://voiptools.com/wp-content/uploads/2024/09/number-six.png) | **[Support Resources Button](https://voiptools.com/docs/exporter-v18/#25-toc-title)** | The **Support Resources**tab gives you general information about the software and the VoIPTools company. |

## Settings Menu

The Settings menu has Four different sections, each with a specific purpose:

| **Section Name** | **Purpose of the section** |
| --- | --- |
| **[Export Frequency](https://voiptools.com/docs/exporter-v18/#21-toc-title)** | Ensures timely synchronization of data from your 3CX database to the Exporter database. |
| **[Export Tables](https://voiptools.com/docs/exporter-v18/#22-toc-title)** | Grants control over which data tables are exported to your database. |
| **[CDR Settings](https://voiptools.com/docs/exporter-v18/#23-toc-title)** | Streamlines Call Detail Record (CDR) file management, automating processes and saving resources. |
| **[Delete Policy](https://voiptools.com/docs/exporter-v18/#24-toc-title)** | Allows you to configure the automated deletion of older CDR files, optimizing data storage and system efficiency. |

### Processing Table:

The **Processing Table** displays the real-time updates on the status of data being exported from 3CX to external databases such as Microsoft SQL Server or MySQL. This feature helps users monitor which table is currently being processed and ensures visibility over the export progress.

#### Purpose of the Processing Table Feature:

| **Displays the active table being processed** | For example, if there are 30,000 records in the "Call Process" table, the exporter will complete the processing of all 30,000 records before moving to the next table. |
| --- | --- |
| **Shows which table is currently being exported** | The current table in process is visible, allowing users to see the table in progress. |
| **Frequency of updates** | Export operations now have a desired frequency interval between tables. After each table is processed, the exporter waits for a set interval before processing the next table. |
| **Real-time monitoring**: | Users can check which table is actively being processed and ensure that exports are happening smoothly without bottlenecks or delays. |

![](https://voiptools.com/wp-content/uploads/2024/10/screenshot-Exporter-V18-fig-26-processing-table-1024x482.png)
Figure 27: Processing Table

### 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).

![](https://voiptools.com/wp-content/uploads/2024/10/screenshot-Exporter-V18-Fig-27-export-frequency-1024x284.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-v18/#21-toc-title)** section.

![](https://voiptools.com/wp-content/uploads/2024/10/screenshot-Exporter-V18-fig-29-export-tables.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-v18/#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-v18/#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-v18/#24-toc-title)**.

![](https://voiptools.com/wp-content/uploads/2024/10/screenshot-Exporter-V18-fig-30-CDR-settings.png)
Figure 30: CDR Settings Section

### Delete Policy Section

The Delete Policy section lets you configure the automatic deletion of processed CDR (Call Detail Record) files that are older than a specified number of days at a scheduled time. This allows for the management and maintenance of CDR data, ensuring that older records are regularly removed to free up storage space and maintain system efficiency.

Follow the procedure to configure the delete policy for the CDR files,

1. In the **Settings**menu, expand the **Delete Policy**section.
2. Check the **Delete processed CDRs older than** the check box to enable the delete policy.
3. In the **Days** field, enter *the number of days*to delete the the processed CDR files older than the specified number of days automatically at the scheduled Delete At time.
4. In the **Delete at** time box, enter the time using the up and down arrows to delete the processed CDR files older than the specified number of days at the scheduled time.

[![](https://voiptools.com/wp-content/uploads/2024/10/screenshot-Exporter-V18-fig-31-delete-policy-1024x634.png)](https://voiptools.com/wp-content/uploads/2024/10/screenshot-Exporter-V18-fig-31-delete-policy.png)
Figure 31: Delete Policy Section

## Support Resources Screen

The S**upport 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-v18/#38-toc-title)**provided by VoIPTools.

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

![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-about-tab-1.png)
Figure 33: Support Resources button

The following image shows the Support Resources screen,

![](https://voiptools.com/wp-content/uploads/2024/10/screenshot-Exporter-V18-fig-32-about-tab-1.png)
Figure: Support Resources Screen

# 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, select **Reporting**from the menu.
3. In the **Reporting**dropdown, select the **$CDR** icon to display the **CDR Settings** screen.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-3CX-console-management-cdr-settings-1024x448.jpg)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-3CX-console-management-cdr-settings.jpg)
*Figure 34: Settings menu*

1. Check the **Generate CDR** checkbox.

[![](https://voiptools.com/wp-content/uploads/2023/02/cdr-2-Copy-1024x485.png)](https://voiptools.com/wp-content/uploads/2023/02/cdr-2-Copy.png)
*Figure 35: Generate CDR box*

1. Select **Separate files for each call** from the combo box.

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **NOTE**:
>
>
>
> It is important that you configure 3CX to save each call as an individual file.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-Select-how-logs-are-generated-list-1024x486.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-Select-how-logs-are-generated-list.png)
*Figure 36: Configure 3CX to automatically create CDR files*

1. Under the Configure CDR Output fields section, click the **Add CDR** button.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-Add-CDR-1024x387.jpg)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-Add-CDR.jpg)
*Figure 37: Add CDR*

1. In the **Select CDR Output fields to add** pop-up, you can see a list of CDR Output fields that need to be added to the CDR table.
2. Select all the fields by holding down the shift button and clicking on each field, then press **OK **to add all the fields.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-Select-CDR-field-to-add-1024x486.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-Select-CDR-field-to-add.png)
Figure 38: Select the CDR output field

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **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.

1. Scroll down to confirm all the new CDR Output fields are added to the list. To know the list of supported output fields and what they mean, [**click here**](https://voiptools.com/docs/exporter-v18/#27-toc-title).
2. Once you have added all the CDR fields, Scroll up to the top of the screen. Next to **CDR Settings**, press **OK** to save your changes.

[![](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-Save-CDR-1024x590.png)](https://voiptools.com/wp-content/uploads/2023/02/Screenshot-Exporter-Save-CDR.png)
*Figure 39: CDR Settings – Generate CDR*

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)

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.

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **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-v18/#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.

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

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

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

> ![](https://voiptools.com/wp-content/uploads/2023/01/notes-icon.png) **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.
>
>
>
> ![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-Exporter-database-without-image-column.png)
> Figure 42: 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.

![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-view-3cx-database-records.png)
Figure 43: 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.

![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-dbo.cdr-table.png)
Figure 44: 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.

![](https://voiptools.com/wp-content/uploads/2023/10/screenshot-exporter-CDR-Output-1.png)
Figure 45: New CDR Output fields added to the dbo.cdr table in the database server

# 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!
