Skip to content

Support@VoIPTools.com

+1 801 642 4655

24/7 Support

  • Home
  • Tools
    • Features
    • Downloads
    • Manuals
  • Hosting
  • Partners
  • Webinars
  • Contact Us
  • Blog
  • My Account
Menu
  • Home
  • Tools
    • Features
    • Downloads
    • Manuals
  • Hosting
  • Partners
  • Webinars
  • Contact Us
  • Blog
  • My Account
Demos
Purchase
×

Tools

  • Protected: 3CX Contact Sync
  • 3CX Queue Notifier (Client) V18
  • Auto Voicemail V18
  • 3CX Barge Messages
  • Caller ID V18
  • Call Router V18
  • Competitive Wallboard V18
  • Custom Presence V18
  • Enhanced Billing Codes V18
  • Exporter V18
  • Hosted Billing V18
  • Monitor V18
  • On Call Manager V18
  • Emergency Notifier V18
  • Power Dialer V18
  • Profile Manager V18
  • Queue Notifier (Server) V18
  • Queues Wallboard V18
  • Reception Console V18
  • Recording Beep V18
  • Do Not Call V18
  • Recording Manager V18
  • Auto Call Back V18
  • Auto Self ID V18
  • Auto Logout V18
  • Auto Call Back V18
  • Surveyor V18
  • Audio Scheduler V18
  • Agent Greeting V18
  • Active Directory Sync V18
  • Survey Creator V18
  • Voicemail Manager V18
  • Wrapup Codes V18 (Server)
  • Click-to-Call V18
  • Holiday Importer V18
  • Wrapup Codes V18 (client)
  • PRE-RELEASE MANUALS
    • Recording Beep V18

3CX Relay

  • VoIPTools Relay – Beta Version
  • Relay V18 (Windows) JWT
  • Relay V18 (Windows) SP5
  • Relay V18 (Linux) JWT
  • Relay V18 (Linux) SP5
  • Home
  • Docs
  • Tools
  • Exporter 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? #

SIMPLIFIED CUSTOM REPORTINGDiscover 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.
REMOTE CDR ACCESSAccessing 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.
EFFORTLESS DATABASE SYNCAchieve 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.
EASY ARCHIEVINGEfficiently 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. During installation, specify your preferred export frequency, and let the tool handle the remaining tasks. Additionally, 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 2014 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.
  • 3CX Relay Service
  • Installation on a domain controller may require additional assistance

Installation overview #

DOWNLOAD SOFTWAREYou can order 3CX Exporter online at https://www.voiptools.com.  Your order confirmation email will include your license key and a link to download the software.
INSTALL PREREQUISITESThere are a number of prerequisites that must be installed prior to installing the 3CX Exporter. These prerequisites include Microsoft Internet Information Server (IIS) and Microsoft SQL Server
INSTALL 3CX EXPORTERThis 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
REGISTER YOUR SOFTWAREYou 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.

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

  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.
Figure 1: Windows Defender Screen
  1. Click the Run Anyway option to start the installation.
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 install 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.
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.
Figure 4: Select Prerequisites to Install

The installer will download and install the selected applications.

Figure 5: Prerequisites Installation in progress
  1. If you have selected to install “SQL Server Express”, the Microsoft SQL Server License Terms page will display. Click Accept to acknowledge the license terms and continue.
Figure 6: SQL Server Express: Accept License Terms
  1. In the next window, the Media Location field displays the SQL Server Media target location. If required, you can browse to change the location. Click Install to begin the installation of SQL Server Express.
Figure 7: SQL Server Express: Target Location
  1. Once the prerequisites are installed successfully, click Close.
Figure 8: SQL Server Express: Installed Successfully
  1. Microsoft SQL Server Management Studio begins to install. Once the installation is complete, click Next
Figure 9: Microsoft SQL Server Management Studio: Installation in progress
  1. In the confirmation message box, click Yes to reboot the computer.

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.
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.
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 8801 in the Relay Port field.
  3. Enter the public key you took from VoIPTools Relay services in the Public Key text area.
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.
Figure 14: Test Relay success message box

Step 5: Installing 3CX Exporter #

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

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

Figure 16: Installation of ‘3CX Exporter’ in Progress
  1. Once the installation is complete, check Launch 3CX Exporter check box and then click Finish. The 3CX Exporter configuration screen opens. If you want to simply close the installer without opening the configuration screen, then simply uncheck Launch 3CX Exporter check box and then click Finish
Figure 17: 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 AssistanceIn the unfortunate event of a lost license key, registering with VoIPTools lets us provide you with a replacement key promptly.
Product Updates and RemindersBy 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.

Follow the procedure to register your software,

  1. Click the 3CX Exporter desktop icon that is created when you install the application.
  2. Click the License tab and enter registration information.
  3. Click Register to complete the registration of your software.
Figure 18: Register Software

3CX Exporter Settings #

The 3CX Exporter Settings configuration screen enables you to register software, setup the database, set export frequency value, get 3CX Settings, and start/stop 3CX Exporter service.

SQL tab #

The SQL tab enables you to setup the database.

  1. In the SQL tab, select the radio button of the appropriate server.
  2. For MySQL Server, the database will be automatically setup based on the credentials provided.
Figure 19: Setup Database
  1. For SQL Server, click Setup. In the Connection Properties dialog box, enter the SQL server name. If using the free SQL Express edition, the default SQL Instance name is SQLExpress.
    1. In the Connection Properties dialog box, enter the SQL server name. If using the free SQL Express edition, the default SQL Instance name is SQLExpress.
Figure 20: Connection Properties

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 the login credentials following the steps
  • If using Windows integrated security, select Use Windows Authentication. The VoIPTools installer will create a local windows user name as “VoIPToys” and will give sufficient rights to this user to create / update the SQL database.
Figure 21: Windows Authentication
  • If SQL Server authentication is desired, select Use SQL Server Authentication. Be sure to select a SQL Login that has sufficient permissions to alter the database and create SQL objects. Enter the User name and Password, and select appropriate database value from the Select or enter a database name drop down.
Figure 22: SQL Server Authentication

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.

    1. Click Test Connection button to confirm you can connect to SQL.
    2. Click OK to close the test results dialog

Export tab #

In the Export screen, you can setup the exporting of tables. From here, you can select and export the desired tables from the list. Exporting of tables from ‘3CX DB’ to ‘Exporter DB’ will take place in 3 scenarios:

  • Based on the setup export frequency
  • When you click Export button
  • When you start 3CX Exporter service.
Figure 23: Setup Export Frequency

Instructions

  1. In the Export tab, set Export frequency (in seconds) value. This is the frequency for automatic synchronizing of updates from 3CX database to Exporter database.
  2. Check the desired export tables that you want to delete.
  3. Click Save to save the settings.

CDR Settings tab #

Enter Domain Name, User Name and Password if the 3CX Exporter and PBX are on different servers, so that the web server (IIS) can access the Call Detail Records (CDR) and update the database.

  1. To process CDR files, check Process CDR Files check box.
  2. In the CDR Settings section, and in the Cdr Path field, enter the path where the cdr files should be stored in 3CX Console.
  3. In the Delete Policy section, check the Delete processed CDRs older than check box if you want to enable the delete policy.<.p>
  4. In the Days field, enter the number of days so that the processed cdr files older than the specified number of days will be deleted automatically at the scheduled Delete at timing.
  5. In the Delete at time box, enter the time using up and down arrows so that the scheduler will delete the processed cdr files older than specified number of days at the scheduled time.
Figure 24: Configure CDR Settings

Call Detail Records (CDR) Files #

In addition to exporting data directly from the 3CX PostgreSQL database, Exporter can also export Call Detail Records (CDR) created by 3CX as text files. Instructions for configuring 3CX to create these optional files are outlined below. The CDR files contain useful information about every phone call including participants, duration, the call chain, etc. While the CDR files do not include the same level of detail available in the PostgreSQL database, the data structure is far easier to understand. If the CDR files contain all the information you need, it is recommended that you utilize the CDR files rather than accessing the PostgreSQL database.

Configure 3CX to Automatically Create CDR Files #

  1. Log in to 3CX Management Console with valid credentials.
  2. On the left navigation pane, select Reports from the menu.
  3. In the Reports dropdown, select the $CDR icon to display the CDR Settings screen.
Figure 25: Settings menu
  1. Check the Generate CDR checkbox.
Figure 26: Generate CDR box
  1. Select Separate files for each call from the combo box.

NOTE:

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

Figure 27: Configure 3CX to automatically create CDR files
  1. Under Configure CDR Output fields section, click Add CDR button.
Figure 28: 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.
Figure 29: Select CDR output field

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.

Figure 30: Default Order of CDR Fields

  1. 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.
Figure 31: CDR Settings – Generate CDR

CDR Records – Output Field Definitions #

The following are the supported output fields and what they mean:

HISTORYIDThis is the call number – each call has a number, internal to 3CX. It is useful for call tracking.
CALLIDThis is the Call ID – the unique identifier of the call.
DURATIONCall Duration time.
TIME-STARTCall Start time.
TIME-ANSWEREDAnswered time.
TIME-ENDCall terminated time.
REASON-TERMINATEDWhy the call was terminated.
FROM-NOSource caller number.
TO-NODestination To Number.
FROM-DNDistinguished name of caller – this is 3CX Specific Can be omitted by 3rd party developers.
TO-DNDistinguished name of To – Destination – this is 3CX Specific Can be omitted by 3rd party developers.
DIAL-NODialed number.
REASON-CHANGEDThe Reason why a change occurred in a call – example in a transfer you will see “ReplacedDst” which means that the destination was replaced with something else.
FINAL-NUMBERFinal Number – the final number which was replaced (In a transfer this will be the final connected number).
FINAL-DNThe Distinguished name of the final number entity – this is 3CX Specific and can be omitted by 3rd party dev.
BILL-CODEBilling code dialed after the destination (for example: **Sales).
BILL-RATEThe billing rate that matched the prefix of the rate. This is used to apply a cost calculation variance.
BILL-COSTThe Cost of the call calculated with simple proportion / minute.
BILL-NAMEThe rate name of the billing variance.
CHAINAll endpoints which were involved in the call.
FROM-TYPESource type
TO-TYPEDestination type.
FINAL-TYPEFinal destination type.
FROM-DISPNAMESource Display Name.
TO-DISPNAMEDestination Display Name.
FINAL-DISPNAMEFinal destination Display Name.
MISSED-QUEUE-CALLSThe number of missed calls for an extension in a queue.

Configure Exporter to Process CDR Files #

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.

NOTE:

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

  1. Start 3CX Exporter service.
  2. Select the CDR Settings tab.
Figure 32: CDR Settings Screen
  1. Select the Process CDR Files check box
  2. Press Save to save your changes
  3. When asked whether to restart the service, chose Yes to restart the Exporter service

NOTE:

Exporter will place the CDR data extracted from the 3CX CDR files into the table named cdr.

View 3CX Database Records #

  1. Connect to database server.
  2. Under Object Explorer navigation pane, expand Databases, and then expand 3CX Exporter and Tables to see various tables.

Figure 33: Object Explorer

  1. Right click on any table to see the right click menu.
  2. Choose Select Top 1000 Rows to view data in the workspace area.

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 Object Explorer navigation pane, expand Databases, and then expand 3CX Exporter and Tables to see dbo.cdr table. You will see that the new CDR Output fields that you just added through 3CX Management Console are now added to the dbo.cdr table in the database server./p>

Figure 34: New CDR Output fields added to 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.

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.

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.

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/

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.

Efficient Email Support #

To ensure a thorough understanding of your concerns, feel free to 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.

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

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.

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 for you. 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 best meet your specific 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!

What are your Feelings
Still stuck? How can we help?

How can we help?

Updated on September 19, 2023
Enhanced Billing Codes V18Hosted Billing V18

Powered by BetterDocs

Table of Contents
  • Introduction
    • What is 3CX Exporter?
    • Why 3CX Exporter?
    • How to use 3CX Exporter?
  • Prerequisites
  • Installation overview
  • Step-by-step Installation Procedure
    • Step 1:  Download ‘3CX Exporter’.  
    • Step 2:  Install Prerequisites
    • Step 3: Start the installation process
    • Step 4: Test Relay Settings
    • Step 5: Installing 3CX Exporter
    • Step 7: Register your Software
  • 3CX Exporter Settings
    • SQL tab
    • Export tab
    • CDR Settings tab
  • Call Detail Records (CDR) Files
    • Configure 3CX to Automatically Create CDR Files
    • CDR Records – Output Field Definitions
    • Configure Exporter to Process CDR Files
  • View 3CX Database Records
  • View Data in Microsoft SQL Server Database
Logo - 3CX Platinum Partner
Logo - 3CX Advanced Certified

Navigation

  • Tools
  • Subscribe
  • Contact
  • Support
  • Product Downloads
  • Product Manuals
  • My Account
  • Partner Sign Up

Contact Us

  • Support@VoIPTools.com
  • Billing@VoIPTools.com
  • Live Chat
  • +1 801 642 4655
  • 4464 Glenwillow Dr. Batavia, OH 45103
Logo - 3CX Platinum Partner
Logo - 3CX Advanced Certified

COPYRIGHT © 2022 VOIPTOOLS. ALL RIGHTS RESERVED | PRIVACY | TERMS OF USE 

Cleantalk Pixel
×
×

Cart