3CX CDR Log Active Passive Socket

[KyleKSIP]

Hello,

We have an on-premise Linux deployment of 3CX. What is the easiest way to get the CDR logs to a windows workstation folder so that custom scripts we have created can parse the logs? what mode should I put 3cx in (Active/Passive)? and what software do I need to run on the destination (Windows workstation) to either fetch/receive those files?

 

[Cjay]

I have created a couple of Windows based tools for capturing/processing 3CX CDRs which you might find useful:

• CallVitesse - which captures/buffers/saves CDRs from 3CX sent over a network (TCP) connection [either Active or Passive socket mode]. This is free software.
• CallSequitur - which connects with CallVitesse and provides the CDR display/analysis functions.

So if all you want to do is capture CDRs into a text file on another computer then CallVitesse will do this for you. CallVitesse runs on a PC and connects with the 3CX CDR TCP socket in either of the 2 supported modes (for an on-prem 3CX then passive mode should be fine). You can capture CDRs and save to text files in one of 3 modes depending on your needs: Single File for all calls mode, Separate Files for each call with 3CX file naming convention or Separate Files for each call with simple sequential naming.

CallSequitur is for live monitoring your PBX activity, showing details of calls as they are completed along with analysis of other related factors like simultaneous (concurrent) call levels, average ring/talk times plus lots more (though for anything other than basic call volume analysis you would need an unlock key, a low-cost one-time purchase).

[If you only need to capture CDRs into text file(s) using CallVitesse then you don't have to install/run CallSequitur - unless you want the ability to view your call data - so disable the buffering process for CallSequitur with the 'No CallSequitur' command in the CallVitesse config file]

If you are interested then you can find the latest versions of the installer files along with full documentation for each program here.

 

[VoIPTools]

I have long suggested that using the IP socket approach is a recipe for losing data. If your socket goes down for any reason, you will lose call data and there is no way to recover the missing data. If there was no other option, then perhaps an IP socket connection is better than nothing, but there are other options.

If you want to be sure that you get ALL the call records, and be able to "catch-up" if your service goes down, then using the file approach is the ONLY way to go. I would recommend the one-file-one-call approach to generating CDR files in 3CX.

So, the next question is how do you get the files, or the data they contain, from the Linux server to a Windows server? Setting up a FTP server on your Linux box will get you access to the files whether your server is hosted or on-prem. A quick google of "how to automate the download of files from an FTP server" generates many results. One of those tools should work for you.

And of course there is also our 3CX Exporter tool. Exporter is not an FTP server solution, but it does automatically detect new CDR files in real-time, parses the data contained in the files, and replicates the data to SQL / MySQL instantly. It can also "catch-up" if the Exporter service was turned off for any reason. This ensures that you get ALL the call days 100% of the time.