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.

Project school : Making a webpage with calls logs + Count how many calls each phone takes

Discussion in '3CX Phone System - General' started by Yennick, Feb 27, 2018.

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

    Joined:
    Feb 15, 2018
    Messages:
    4
    Likes Received:
    0
    Hello ,
    Me and my friends need to make a project surounding 3 cx for a company.
    We need to make a webpage that shows them all the call logs like waiting time averages , call duration , amount of dropped calls etc plus a counter that shows how many calls a worker takes each day.

    We already looked up info on this and saw CDR that put call logs in a txtfile but the company doesn't want it that way . They want that the webpage refreshes directly and that they can find history of those call logs in a database.
    Is there a way to do this ?

    and we didn't find a way to check how many calls each phone takes a day . can we find this somewhere?

    any help is welcome ( like links to info )
    thanks ,
     
  2. mariosM_3CX

    mariosM_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Nov 1, 2017
    Messages:
    406
    Likes Received:
    40
    Hello @Yennick

    You can configure the PBX to output the CDRs either in file(s) or to a socket.
    In your case that you want to dynamically refresh the web page, it might be easier to output to a socket and then directly into your database. Then from the database, you can query as you like and present it in the web page.

    You'll need to play a bit with CDR and see which fields you may need in order to extract the info that you want. Check the following guide on how to set the PBX to output CDRs and what each field represents. https://www.3cx.com/docs/cdr-call-data-records/

    Note that there is not such detail in the CDRs. You'll need to extract it by querying the database(that you'll store the CDR in). PBX will merely output a record after each call is ended and will contain details only for that specific call.
     
Thread Status:
Not open for further replies.