Export CDR and read these files

[fabio.abbiati]

Hi All,

I have a 3CX v18.0 (Build 461) self-hosted on a Debian visrual machine.
I'm trying to activate the CDR because I need to access to the call log once a day.

In "Reportint -> CDR" I activated "Generate CDR".

If I select "Single file for all calls" or "Separate files for each calls", where I can find (I think into Debian machine) these files? Which path?

Intead, if I want to save these file on a remote Windows machine, how I must configure my system?
"CDR service is a server / Active socket" or "CDR service is a client / Passive socket" ?
And which values I need to put into two fields?

Thanks in advance
Fabio

 

[VoIPTools]

Fabio,

The CDR files are saved at: /var/lib/3cxpbx/Instance1/Data/Logs/CDRLogs. While you cannot change the path where the files are stored, you could write a cron job to move the files on a scheduled basis. You will not be able to save the files on a remote Windows server without using a 3rd party tool, or writing code yourself. This is not a feature built into 3CX.

You can use the IP socket approach, but as self-serving as this may be, I do not recommend this approach for one very specific reason -- if your socket client, or internet connection goes down AT ALL you will likely miss data and this data cannot be resent. The data is gone.

My recommended approach is to configure CDR to create one file per call. Then use a 3rd party tool like FileZilla to move the files from your Linux server to the Windows server. Using the file approach ensures the data is never lost, and you can always "catch up" if your service goes down because the files will still be there waiting to be processed.

Note: I will point out that the IP Socket approach is the only option available if you are hosting your phone system with 3CX.

If you want a fully automated approach, you may want to take a look at our 3CX Exporter tool. With Exporter, you install our Relay application on the 3CX server (Windows or Linux), and Exporter on your Windows server. Exporter can both receive CDR events in real-time, and request historical CDR data from our Relay. Exporter will automatically save the data to either SQL Server or MySQL. Exporter utilizes the file approach to ensure you always get ALL the data even if Exporter has been turned off at any time -- it simply starts the replication process where if left off.

Finally, if the CDR data does not contain all the data you need, Exporter can also replicate all the same data 3CX uses to generate their built-in reports. So, you are not limited to only CDR data.