CDR Reporting

[tneuhaeusler]

Morning,

After reading the CDR documentation: https://www.3cx.com/docs/cdr-call-data-records/, I've been exploring using the Passive Socket/ Active Socket method. I was going to utilize Python to configure. Can anyone provide example code of how you got this to work? I've explored both methods and can't seem to obtain the data as the documentation isn't robust.

Thank you,

Tanner

 

[VoIPTools]

Personally, I have been a strong advocate for NOT using the IP socket approach. As you have noted, you have to create an IP socket connection that is robust, and can auto-reconnect on failure. Herein lies the problem. Any transactions that take place while your connection is down, for any reason (application failure, updates, network outage, etc.) will be lost forever. The safer approach is to have 3CX create a file for each call, and process the files. That way, if your application goes down, you can simply start again and process any new files, and optionally have a backup if there is any question about what the original source data was...

 

[tneuhaeusler]

Personally, I have been a strong advocate for NOT using the IP socket approach. As you have noted, you have to create an IP socket connection that is robust, and can auto-reconnect on failure. Herein lies the problem. Any transactions that take place while your connection is down, for any reason (application failure, updates, network outage, etc.) will be lost forever. The safer approach is to have 3CX create a file for each call, and process the files. That way, if your application goes down, you can simply start again and process any new files, and optionally have a backup if there is any question about what the original source data was...

Thanks for the reply. How do you create a file for each call? All the reporting I found sends the report as a link to e-mail, which I can't automatically process.

 

[VoIPTools]

In your 3CX management console, go to Settings --> CDR. There you can specify which fields you want included (I choose all fields), and whether to create one file that contains multiple phone calls, or a separate file for each call. I choose a separate file for each call.

 

[techcare]

In your 3CX management console, go to Settings --> CDR. There you can specify which fields you want included (I choose all fields), and whether to create one file that contains multiple phone calls, or a separate file for each call. I choose a separate file for each call.

Do you clear the call files after they are imported? Otherwise there could be an insane amount of them.

A slight hijack. Is CDR still operational in v20? Or is this only available in v20.1?

All it says is "Note: Do not upgrade yet if your setup requires Scheduled Reports, this feature will be included in Update 1."

Found it: Admin > Advancded > CDR. Was looking in the Call Logs for some reason.