Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

Special Call Report

Discussion in '3CX Phone System - General' started by Jarret, Apr 1, 2018.

Thread Status:
Not open for further replies.
  1. Jarret

    Joined:
    Apr 1, 2018
    Messages:
    4
    Likes Received:
    0
    I have three national numbers: A, B and C. The calls coming to these numbers are directed to one, common queue. I would like to create three separate reports with an incoming call list for each of the numbers (for A, B and C) and another report with statistics showing the number of incoming calls to each of the above numbers. Is it possible to create such reports and if so, how can I do this?
     
  2. voiptoys

    voiptoys Active Member

    Joined:
    Feb 13, 2013
    Messages:
    893
    Likes Received:
    154
    Configure 3CX to generate the CDR text files, then parse these files into a database. Once the data is in a database, you can create the reports you need. If you need help parsing the CDR files, consider our Exporter tool.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Jarret

    Joined:
    Apr 1, 2018
    Messages:
    4
    Likes Received:
    0
    1) There is probably a file containing all information about incoming and outgoing calls, ways of routing connections and many other additional events. Can I have access to a file containing this information? Where this file are located?

    2) Is it possible to extract information from the file described in the above using the CDR file? I mean, if the system has been running for a year and today I will enable the generation of a CDR file, will the CDR file contain information about events from before today? Whether however will only this information appear in the file that will arise after the inclusion date of generating the CDR file?

    3) I have enabled the generation of a CDR file, but my national number (A, B or C – “source line”) doesn’t have own field. The field containing - among others - my national number has the form: "src_line:src_number". Does this mean that there is no separate field in the CDR file containing only my national number (A, B or C)?
     
Thread Status:
Not open for further replies.