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.

customize call reports?

Discussion in '3CX Phone System - General' started by EcK, Feb 5, 2018.

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

    EcK

    Joined:
    Feb 5, 2018
    Messages:
    15
    Likes Received:
    0
    Greetings,

    I am running in something like an automation problem. At the moment we use a normal Call Report.
    Extension satistic report, daily frequency and custom range (current week).

    The idea is to send out the full report of the last week on monday.
    On tuesday we get the report from monday.
    On wednesday we get the report including monday and tuesday together.
    On thursday we get the report including monday, tuesday and wednesday together and so on.

    That is what we need and also the output we want.

    The only thing is, we need to change the custom range every week and we are searching for a possibility to automate this step.

    Adding a new option instead of "last week" to "current week" would also work.

    Is there any known possibility to add something like that? Is there any workaround with "3CX Call Flow Designer" to get a report like that?
     
  2. voiptoys

    voiptoys Active Member

    Joined:
    Feb 13, 2013
    Messages:
    893
    Likes Received:
    154
    There really isn't a way to create custom reports in 3CX unless you can get the call detail records into a database. Your options are (1) make a TCP socket connection to 3CX, which in my view has too much potential for losing data if your socket connection is interrupted, or (2) parse the CDR text files and put the data into a separate database (see: "Settings --> CDR Settings" in the 3CX Management Console) or, (3) Export the data using a tool like 3CX Exporter (https://www.VoIPTools.com). All of these choices simply collect the data and store it in a database, separate from the 3CX database, so you can build your own reports using your preferred report generation tool. Scheduling the the generation and delivery of reports is yet another task to be addressed. It's all possible to do, but it's going to require some application development.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    EcK likes this.
Thread Status:
Not open for further replies.