cdr

  1. CDR Active Connection -- Stops working

    Hi, I have setup CDR with Active mode for 3CX hosted environment. The port on the server is active and listening, CDR works and then stops after sometime or may be after inactivity? I don't see any issue on the server side as its listening and active. Please assist. Version 20.0 Update 8 (Build...
  2. ArneDery

    Add main department membership to CDR (align with “Call Cost by Extension Dept/Group”)

    Add main department membership to CDR (align with “Call Cost by Extension Dept/Group”) Request Please add the main department membership of involved internal parties to CDR output (file/TCP and reporting SQL) so the built‑in Call Cost by Extension Dept/Group report can be produced directly from...
  3. CDR 2.0 data format issue with current socket tool

    My setup: on-premise, 8 SC Enterprise, Version 20.0 Update 6 (Build 724 Release) ** With v18, I had been been using a third party software Advanced PBX Data Logger by AGGSoft (100$ one-off fee). This software runs a socket and writes cdr entries real-time as it receives them from 3CX to, for...
  4. Would be great to have "waited_time_in_queue" in CDR

    Dear 3CX team, I suppose it's not specific to on-premise, but it would be great to have "waited_time_in_queue" in CDR. We have got it in call report, but CDR goes directly in our database while call reports don't. Regards,
  5. JamieLewisIBT

    Display the outbound caller ID in the Call Reports Report

    We have a customer who need to know what caller id was displayed, this will also be good for diagnostics.
  6. Call Accounting / CDR storage limits

    I have a customer with a specific requirement to pull call records going back 3 years. Are there any limits to how call records are stored?
  7. ronenba

    Reporting - Empty

    i setup report to be sent every first of every month includes all calls for extension when i get the report it is always empty what i am missing ? when i check in the call log i see call ( cannot search for a month) I setup for the last month / last 30 days / custom all of the report showed...
  8. CDR in UTC

    Hello! I found this information that the CDR is always in UTC and there is no way to configure it in the 3cx, only at the other side, but it's a 5 year old question. Does this still aply? https://www.3cx.com/community/threads/cdr-dates-an-hour-behind.51486/
  9. CDR after license change

    Hello, a customer would like to recover the last year of calls history from his PBX. He's now on the standard version and he's unable to make any report. If I move him to a pro version is it possible to read the historical data or they're loss forever? With regards, Francesco
  10. How does myphone_callhistory_v14 link to callcent_queuecalls

    We are working on an integration to pull call logs, however I can't find a column that contains a unique identifier that exists in both callcent_queuecalls and myphone_callhistory_v14. Call Logs have call_id which is a sequential number but queuecalls have a call_history_id, how do I get the...
  11. ronenba

    Reporting

    Trying to create a new report per extension to see outgoing calls for example only outgoing calls for extension 150, would like to see how min this extension making for outgoing calls and to calculate the cost for this extension when going to report the options are: Call log and CDR when...
  12. Best CDR Central server in order to receive the CDR ?

    Hello 3CX guys, 3CX CDR can send call data records to a CDR Central server. At my compagny, we search the best CDR Central server in order to receive call data records from 3CX server. Please, could you advise us ? I thank you in advance. Regards,
  13. Cinosarge

    Is there a Windows API?

    Here it is said: What does it refer to? Some software one can use to integrate with a third party app on the same machine? Just a software to receive calls and notifications? Or it just refers to the CRM integration template and CDRs? Thanks in advance!
  14. virtualteco

    CDR active socket

    someone has configured the cdr in active socket, what software do you use to receive the records?
  15. Example to Call Flow to collect the call details at the end of the call and send to database or webservice

    Any Example to Call Flow to collect the call details at the end of the call and send them to a database or web service I know there are components for both database and web service in the Call Flow Designer. What I don't know is what are the possible fields related to the call are available...
  16. CDR records into MySQL

    I've seen a few people trying to get their CDR records into a MySQL database. We were looking to do the same so I've knocked-up and open sourced a simple node.js application to do just that. It's my first node.js application so if you know how to do it better than I do then I'd love your...
  17. CDR / Power BI / MYSQL or PostgreSQL

    Hi all, Needing some help here. Im looking to build dashboards for my clients using Power BI and need the CDR sent to my SQL server as the first step. I’ve tried setting this up via CDR and sending to my database but whatever i do, I can’t get the active connection working. Environment setup...
  18. g.fiszt

    API - Wallboard

    Hello everyone! My company uses the wallboard to manage the team, but it doesn't show all the information they need. So, we want to create our own dashboard, collecting the information through an API or something like that, to show users status, SLA and etc. So far I've seen some old posts...
  19. Busy tone + Call logs - Best Practice

    Hey Guys, I've been searching through the forums on this but I just want to know what best practice here is. The problem: When users call and there is an issue with the call the call simply hangs up with no sound which confuses them as they are used to an engaged sound or various other things...
  20. NicholasBarnes

    Passing data in custom SIP headers

    We have our own interconnects, multiple wholesalers and have written our own billing platform - all our and our customers' 3CX boxes create SIP trunks back to our SIP routers. Everything is under our control. Our billing system is capable of using custom SIP headers to allow billing to be...