Automate Call Detail Records
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
The best solutions for your company
Moving Call Detail Records from 3CX to SQL Server or MySQL allows you to use the tools you already know to create custom reports.
Regardless of the information you need, Exporter can get it into SQL for your custom reports or custom integrations.
You can export other tables too including queue statistics, and much more...
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.
Some of the benefits
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!
With 3CX Exporter, reporting data, moving call detail records and much more will become faster, thus saving you time!
With 3CX Exporter many useful functions on your 3CX server will become incredibly easy. Gathering your information will be easy and run automatically.
FIND OUT MORE
More details about the feature
- 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
FAQ’S & KNOWLEDGEBASE
Need more info? Check out our knowledgebase
Yes, we can!
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.