i want to make cdr report

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

i want to make cdr report

Postby rajnishs91 » Sat May 26, 2018 6:58 am

Hi All,

I want to make cdr report using vicidial mysql database . Please guide me how to proper CDR with disposition of call


Thanks
Rajnish kumar
rajnishs91
 
Posts: 27
Joined: Tue Apr 10, 2018 6:05 am

Re: i want to make cdr report

Postby rajnishs91 » Tue May 29, 2018 1:51 pm

Please help . I am not able to find out CDR report specially when agent talk with caller number in survey call
rajnishs91
 
Posts: 27
Joined: Tue Apr 10, 2018 6:05 am

Re: i want to make cdr report

Postby blackbird2306 » Tue May 29, 2018 5:18 pm

What do you mean by CDR? Do you mean CDR report relating to your carrier billing time or only a list with information (status, call time, lead id ...) about your calls?

Carrier CDR (these values are not 100 % reliable):
Reports --> Admin Utilities (at the bottom) --> "Export Calls Report Carrier" or "Carrier Log Report"

Calling report:
Reports --> Export Calls Report
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 316
Joined: Mon Jun 23, 2014 5:31 pm

Re: i want to make cdr report

Postby rajnishs91 » Tue May 29, 2018 11:44 pm

Hi Blackbird,

I mean that i am looking for mysql table in which CDR information is stored so that i cam make custom cdr that will include carrire rate price . I have checked call_log table . But call_log table is not provide data according to carrirer cdr charge.


Thanks
Rajnish kumar
rajnishs91
 
Posts: 27
Joined: Tue Apr 10, 2018 6:05 am

Re: i want to make cdr report

Postby blackbird2306 » Wed May 30, 2018 4:17 am

Take a look at these files (very helpful):
AST_carrier_log_report.php
call_report_export_carrier.php

Interesting tables for your project are:
vicidial_carrier_log
vicidial_log

But again: These values are not 100% reliable and only provide approximate information!
Vicibox 6.0.2 from Vicibox_v.6.0.x86_64-6.0.2.iso | Vicidial 2.12-560a build: 160617-1427 | Asterisk 1.8.32.3
blackbird2306
 
Posts: 316
Joined: Mon Jun 23, 2014 5:31 pm

Re: i want to make cdr report

Postby rajnishs91 » Wed May 30, 2018 7:00 am

Thanks It helps me a lot
rajnishs91
 
Posts: 27
Joined: Tue Apr 10, 2018 6:05 am


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 12 guests