Any and all non-support discussions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by 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: 30
- Joined: Tue Apr 10, 2018 6:05 am
by 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: 30
- Joined: Tue Apr 10, 2018 6:05 am
by 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: 409
- Joined: Mon Jun 23, 2014 5:31 pm
by 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: 30
- Joined: Tue Apr 10, 2018 6:05 am
by 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: 409
- Joined: Mon Jun 23, 2014 5:31 pm
by rajnishs91 » Wed May 30, 2018 7:00 am
Thanks It helps me a lot
-
rajnishs91
-
- Posts: 30
- Joined: Tue Apr 10, 2018 6:05 am
by carpenox » Sat Dec 16, 2023 8:38 am
Alma Linux 9.4 | SVN Version: 3890 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
-
carpenox
-
- Posts: 2426
- Joined: Wed Apr 08, 2020 2:02 am
- Location: St Petersburg, FL
-
Return to General Discussion
Who is online
Users browsing this forum: No registered users and 34 guests