Carrier CDR consolidation

Any and all non-support discussions

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

Carrier CDR consolidation

Postby Vince-0 » Thu Oct 01, 2015 3:58 pm

I'm trying to compare carrier CDRs with Vici because we have a way higher than normal bill (double the amount of live agents.)

I realise that the seconds may differ slightly for each call, especially because the Vicidial carrier trunk is connected via a FreePBX to get to the carrier (legacy reasons)
I'd like to sum the total length_in_min in vicidial_log table to get some indication of talk time from Vicidial.

Do I need to exclude inbound calls somehow?
How can I best consolidate CDRs with the carrier's?

Thanks,
Vin.
Vince-0
 
Posts: 272
Joined: Fri Mar 02, 2012 4:27 pm
Location: South Africa

Re: Carrier CDR consolidation

Postby mflorell » Fri Oct 02, 2015 4:42 am

Asterisk CDRs have never been that accurate unfortunately. As for Vicidial, if you only want outbound calls, those are in the vicidial_log table, and inbound calls are in the vicidial_closer_log table.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Carrier CDR consolidation

Postby Vince-0 » Fri Oct 02, 2015 4:53 am

Thanks Matt, explains a lot.
Vince-0
 
Posts: 272
Joined: Fri Mar 02, 2012 4:27 pm
Location: South Africa

Re: Carrier CDR consolidation

Postby nandotech » Mon Oct 12, 2015 11:22 pm

Personally, I always fall back to the carrier log and take that as the final word.

By that time, I've already paid them--after all. ;)

edit:

and by carrier log, I mean the CDR reports pulled directly from my different carriers.
Otherwise I do also have an SBC that logs outbound calling, but not inbound :)
NandoTech, Inc | Software Developers and Telephony Solution Experts
ViciDIAL Hosting | Full Custom Installations | CRM Integrations | Support & Training
www.nandotech.com | 561-757-7187 | info@nt-x.com
For awesome VoIP/SIP Trunking: Arctele Communications, Inc
nandotech
 
Posts: 30
Joined: Fri Oct 02, 2015 9:37 am


Return to General Discussion

Who is online

Users browsing this forum: RBecker and 48 guests