VoIPTools Exporter

Automate Call Detail Records

VoIPTools Exporter

With 3CX Exporter you can automatically process 3CX generated Call Detail Records (CDR) or export 3CX's internal PostgreSQL database, to either Microsoft SQL server or MySQL. This small Windows service runs automatically in the background to keep your external database in sync with the data in 3CX.

We created Exporter to make it EASY to get all the information you need to generate custom reports. Exporter can import 3CX CDR files, or PostgreSQL data, into SQL in near real-time.

Matthew Orr- founder: VoIPTools LLC
product-image

CORE FEATURES

The best solutions for your company

icon

Create Custom Reports

Moving Call Detail Records from 3CX to SQL Server or MySQL allows you to use the tools you already know to create custom reports.

icon

Archive Call Records

With 3CX Exporter it's easy to archive call records.

icon

Import 3CX CDR files or PostgreSQL data into SQL

Regardless of the information you need, Exporter can get it into SQL for your custom reports or custom integrations.

icon

Export queue statistics

You can export other tables too including queue statistics, and much more...

icon

Support for SQL Server and MySQL

With 3CX Exporter you can automate the export of Call Detail Records (CDR) from 3CX's internal PostgreSQL database to either Microsoft SQL server or MySQL.

icon

Runs Automatically in the Background

This small Windows service runs automatically in the background to keep your external database in sync with the data in 3CX.

Some of the benefits

icon

Reduces the Demands on your 3CX Server

Moving Call Detail Records from 3CX to SQL Server or MySQL reduces the demands on your 3CX server. Think of how much better your 3CX server will be able to run!

icon

Save Time

With 3CX Exporter, reporting data, moving call detail records and much more will become faster, thus saving you time!

icon

Simple to Use

With 3CX Exporter many useful functions on your 3CX server will become incredibly easy. Gathering your information will be easy and run automatically.

REQUEST A DEMO
image

FIND OUT MORE

More details about the feature

 3CX Exporter by VoIPTools

 

New!  You can import 3CX CDR files into Microsoft SQL or MySQL

With 3CX Exporter you can automate the export of Call Detail Records (CDR) from 3CX’s internal PostgreSQL database to either Microsoft SQL server or MySQL.  This small Windows service runs automatically in the background to keep your external database in sync with the data in 3CX.

Moving Call Detail Records from 3CX to SQL Server or MySQL reduces the demands on your 3CX server, and allows you to use the tools you already know to create custom reports.  With 3CX Exporter it’s easy to archive call records too.

You are not just limited to call history records… you can export other tables too including extensions, queue statistics, and much more…

 

Requirements

  • 3CX Version 14 – 15.5
  • Windows 7 – 10, Windows Server 2008 R2 – 2016 64 bit,
  • SQL Server 2008 Express and above or MySQL 5.5 and above
  • .Net 4.7.1
  • Installation on a domain controller may require additional assistance

Revisions

Version 15.5

Version 15.5.48  February 28, 2018

  • Added ability to import 3CX CDR files into SQL

Version 15.5.45  November 7, 2017

  • Added code to recover from failed SQL connection

Version 15

Version 15.0.40  January 24, 2017

  • Added support for latest controls
  • Improved users SQL script
  • Fixed issue with custom database names
  • Fixed error during initial setup

Version 15.0.26  July 29, 2016

  • Added support for 3CX V15
  • Added support for Relay version 3.0.55
  • Added support for SQL Server 2016
  • Made table changes for 3CX V15

Version 14

Version 14.0.9  November 25, 2015

  • Added support for 3CX V14
  • Added ability to select tables to truncate and synchronize changed records
  • Refactored code
  • Minor bug fixes

Version 12.5

version 12.5.6 August 5, 2015

  • Added additional tables for export
  • Added installer ability to create remote SQL logins with integrated security
  • Added installer ability to set credentials for Windows service
  • Improved SQL and PostgreSQL processing
  • Fixed potential memory leak

Version 2.5.1 March 12, 2015

  • Added support for 3CX Version 12.5
  • Added the ability to select which tables to export
  • Added ability to persist settings during upgrades
  • Added auto table creation feature
  • Created a new improved installer

Version 12.0

Version 12.0.5  August 5, 2015

  • Synchronized with 12.5 version

 

Version 2.3.5 March 12, 2015

  • Synchronized with 12.5 version
  • Added the ability to select which tables to export
  • Added ability to persist settings during upgrades
  • Added auto table creation feature
  • Created a new improved installer

Version 2.3.4 January 8, 2014

  • Added chat tables
  • Added improved Windows service control
  • Improved configuration program
  • Installation bug fixes

Version 2.3.2 August 7, 2014

  • Added support for very large datasets
  • Added UI to manage scheduling frequency
  • Set export to run at startup of service
  • UI modifications

Version 2.3.1 July 14, 2014

  • Added support for MySQL
  • Removed need for Windows scheduled task
  • Added the ability to schedule frequency in application setting

Version 2.0.0.1 December 11, 2013

  • Added additional tables for export
  • Updated controls
  • Enhanced installer
  • Refactored / Optimized code
  • Bug fixes

Version 1.5.5.0  December 17, 2012

  • Refactored code
  • Parameterized SQL queries
  • Added new table field introduced in 3CX V11
  • Miscellaneous code enhancements

Version 1.5.0.0

  • New Installer
  • Added installer created sample scheduled task
  • Added support for logging in custom Windows Event log
  • Added licensing

Version 1.0.0.4

  • Public release

FAQ’S & KNOWLEDGEBASE

Anything unclear?

Need more info? Check out our knowledgebase

You can set it to import once a day, or every few seconds. It's up to you.

With a little help from VoIPTools support, YES!

Sure. We can help you build custom reports. Or you can build reports yourself using whatever reporting too you prefer.

Yes, you can get access to Extensions, chat logs, just to name a few options.

The structure of call data in the 3CX database is pretty complicated. The data structure of the CDR files is fairly simple and may be easier to use if they contain the information you need.

3CX doesn't support accessing the PostgreSQL database directly. Unfortunately, if you want to build custom reports, there are only two sources of data (1) the optional CDR files 3CX can create, or (2) direct access to the PostgreSQL database.

If you can get what you need from the CDR files, that is the recommended approach. But if you need more information than is available in the CDR files, the only choice is to get the data from PostgreSQL. You cannot get the data via any of the 3CX APIs.

Exporter has been in use around the world for more than 7 years, without any known issues. While 3CX won't endorse any product that accesses the PostgreSQL database, they know about Exporter and it hasn't been a issue.