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

[Yennick]

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 ,

 

[mariosM_3CX]

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/

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

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.