abandoned calls report

[ZeeTech]

Need to know how to pull call records for drop and abandoned calls for an inbound campaign.

I already checked in reports –> Export Calls Report and selected my in-group but only connected calls are reflecting in this report
I have following setup in vici.
(Campaign ID - Upsells1 type INBOUND_MAN)
Setup an in-group (in-group ID UpsellsIB) and define DID with following parameters.
- DID Number = 512956
- DID Route = IN_GROUP
- In-Group Call Handle Method = CIDLOOKUP
- In-Group Agent Search Method = LB
- In-Group Campaign ID = Upsells1

Defined following dial pattern in extension.conf
; upsell is the context defined in carrier peer settings.
[upsell]
exten => 13103621778,1,Answer
exten => 13103621778,1,Wiat(2)
exten => 13103621778,n,Playback(thank-you-for-calling)
exten => 13103621778,n,AGI(agi-VDAD_ALL_inbound.agi,CIDLOOKUP-----LB-----UpsellsIB-----512956-----Closer-----park----------999-----1-----Upsells1)
exten => 13103621778,n,Hangup
Call are landing successfully, agents are taking call without any issues, i just facing problem to generate abandoned calls report based on CLI numbers.
Please help.

VERSION: 2.4-309a | BUILD: 110430-1642 | Asterisk 1.4.39.1-vici | Single Server| No Digium/Sangoma Hardware | No Extra Software After Installation

[williamconley]

you'll have to pull this report directly via mysql. or you'll have to generate a report that also includes outbound calls. the export calls reporting system is a bit flawed. try generating a report that shows ALL calls for a single day. You will note that some of these calls have a "name" field of Inbound no agent. But if you try to filter to get only those calls, the report generator refuses because there are no outbound calls. So generate the larger report and ignore the records that do not have inbound no agent in the name field. Not perfect, but possibly easier than generating your own mysql/php reporter to accomplish the same task.

[ZeeTech]

Dear, I don’t get how to generate a report that shows ALL calls for a single day, if I select campaign in ‘Export Calls Report’ it shows “There are no outbound calls during this time period for these parameters” so please guide me how to generate a report that show all calls and I can filter required records.
Secondly I just try to pull call stats from ‘Inbound DID Report’ but it show 0 call hit on this DID however ‘Inbound Report’ shows correct number of call hit to that particular in-group and show correct number of calls answers and abandoned calls, so I bit confused that might be I have some configuration error during DID setup,
Please refer me to the mysql table that holds all inbound records so I can at least verify either my configuration are up to the mark and DB is logging all required information or not.
I also did a simple select query on ‘vicidial_did_log’ table but there is no record
Please advice.

[williamconley]

Dear, I don’t get how to generate a report that shows ALL calls for a single day, if I select campaign in ‘Export Calls Report’ it shows “There are no outbound calls during this time period for these parameters” so please guide me how to generate a report that show all calls and I can filter required records.
Secondly I just try to pull call stats from ‘Inbound DID Report’ but it show 0 call hit on this DID however ‘Inbound Report’ shows correct number of call hit to that particular in-group and show correct number of calls answers and abandoned calls, so I bit confused that might be I have some configuration error during DID setup,
Please refer me to the mysql table that holds all inbound records so I can at least verify either my configuration are up to the mark and DB is logging all required information or not.
I also did a simple select query on ‘vicidial_did_log’ table but there is no record
Please advice.

if you select everything in the export calls report, you'll get all calls for a day. as long as there is at least one outbound call for the day all calls will show. do not omit anything (all lists, all campaigns ... everything included).

[ZeeTech]

It doesn't show the required data however i get the required information directly from DB.

SELECT * FROM vicidial_closer_log where campaign_id='Upsell_IB' and status = 'DROP' and call_date like '2013-04%';

Thanks much!