Page 1 of 1

i want to make cdr report

PostPosted: Sat May 26, 2018 6:58 am
by rajnishs91
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

Re: i want to make cdr report

PostPosted: Tue May 29, 2018 1:51 pm
by rajnishs91
Please help . I am not able to find out CDR report specially when agent talk with caller number in survey call

Re: i want to make cdr report

PostPosted: Tue May 29, 2018 5:18 pm
by blackbird2306
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

Re: i want to make cdr report

PostPosted: Tue May 29, 2018 11:44 pm
by rajnishs91
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

Re: i want to make cdr report

PostPosted: Wed May 30, 2018 4:17 am
by blackbird2306
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!

Re: i want to make cdr report

PostPosted: Wed May 30, 2018 7:00 am
by rajnishs91
Thanks It helps me a lot

Re: i want to make cdr report

PostPosted: Sat Dec 16, 2023 8:38 am
by carpenox