Leads not getting picked up from vicidial_hopper

Discussions about development of VICIDIAL and astGUIclient

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

Leads not getting picked up from vicidial_hopper

Postby Pooja » Fri Oct 13, 2017 2:42 am

Hi All,

I have installed Vicidial 2.13-502c with Asterisk 1.8.32.0 and MySql 5.6.37.

When I make a manual call and select call back or upload leads through load new leads, leads are been added in vicidial_hopper but they are not getting picked up from hopper list.

mysql> select * from vicidial_hopper;
+-----------+---------+-------------+--------+------+---------+----------------+-------+----------+----------+--------+------------------+
| hopper_id | lead_id | campaign_id | status | user | list_id | gmt_offset_now | state | alt_dial | priority | source | vendor_lead_code |
+-----------+---------+-------------+--------+------+---------+----------------+-------+----------+----------+--------+------------------+
| 1 | 120 | Bulk | READY | | 997 | 0.00 | | NONE | 0 | S | 568956445 |
| 2 | 119 | Bulk | READY | | 997 | 0.00 | | NONE | 0 | S | 123456789 |
| 3 | 118 | Bulk | READY | | 997 | 0.00 | | NONE | 0 | S | 568956445 |
| 4 | 117 | Bulk | READY | | 997 | 0.00 | | NONE | 0 | S | 123456789 |
| 5 | 116 | Bulk | READY | | 997 | 0.00 | | NONE | 0 | S | 568956445 |
+-----------+---------+-------------+--------+------+---------+----------------+-------+----------+----------+--------+------------------+

I have set campaign -> minimum hopper level = 5

I thought issue was with gmt_offset_now so I tried setting gmt_offset_now as 5.50 manually, still I face the same problem.

Thanks in advance!
Pooja
Pooja
 
Posts: 7
Joined: Thu Jul 06, 2017 6:46 am

Re: Leads not getting picked up from vicidial_hopper

Postby Pooja » Sun Oct 15, 2017 10:43 pm

Hello Guys!

Any updates or suggestions ?
Pooja
 
Posts: 7
Joined: Thu Jul 06, 2017 6:46 am

Re: Leads not getting picked up from vicidial_hopper

Postby mflorell » Mon Oct 16, 2017 5:09 am

Not sure why you posted this in the Development section. Also, you don't give anywhere near enough information for us to help you.
mflorell
Site Admin
 
Posts: 17345
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Leads not getting picked up from vicidial_hopper

Postby Pooja » Mon Oct 16, 2017 5:13 am

Can you please guide me for what more information is required and in which section to post ?
Pooja
 
Posts: 7
Joined: Thu Jul 06, 2017 6:46 am

Re: Leads not getting picked up from vicidial_hopper

Postby mflorell » Mon Oct 16, 2017 6:06 am

How did you install VICIdial?

admin.php version and build?

More detailed explanation of your problem, the campaign you are attempting to dial, and the step-by-step detailed explanation of how you are trying to dial leads in the hopper for the campaign.
mflorell
Site Admin
 
Posts: 17345
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Leads not getting picked up from vicidial_hopper

Postby Pooja » Mon Oct 16, 2017 11:58 pm

Vicidial Installation : https://striker24x7.blogspot.in/2013/04 ... idial.html

admin.php : Copyright (C) 2016 Matt Florell <vicidial@gmail.com> LICENSE: AGPLv2

I have created a separate campaign names "BULK" and have assigned a separate list id 997 to it.

When I upload leads from "load new leads" , leads are been added into vicidial_hopper table but they are not getting picked up(i don't get calls).
And also, I don't get scheduled callsbacks.

Below is the vicidial_hopper table data:

+-----------+---------+-------------+--------+------+---------+----------------+-------+----------+----------+--------+----------------------+
| hopper_id | lead_id | campaign_id | status | user | list_id | gmt_offset_now | state | alt_dial | priority | source | vendor_lead_code |
+-----------+---------+-------------+--------+------+---------+----------------+-------+----------+----------+--------+----------------------+
| 4 | 117 | Bulk | READY | | 997 | 0.0 | | NONE | 0 | S | 10000000000654657469 |
| 5 | 116 | Bulk | READY | | 997 | 0.0 | | NONE | 0 | S | 10000000000654657468 |
+-----------+---------+-------------+--------+------+---------+----------------+-------+----------+----------+--------+----------------------+



Logs of /usr/share/astguiclient/AST_VDhopper.pl --debugX are as below:

----- DEBUG -----


----- SUPER DEBUG -----

TIME DEBUG: 5.50|5.50|0| GMT: 11:25
SELECT list_id FROM vicidial_lists where ( (active='N') or ( (active='Y') and (expiration_date < "2017-10-16") ) );Inactive Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2017-10-16 16:55:16' and status='ACTIVE';|
hopper DNC count: 0
|SELECT count(*) from vicidial_hopper where status='DNC';|
---------------Auto Trim Hopper Enabled For camp---------------------
Leads in Hopper for this Campaign = 0
Hopper Level for this Campaign = 5

---------------Auto Hopper Level Enabled For Bulk---------------------
Number of Agents = 1
Number of Paused Agents = 0
Auto Dial Level = 1.0
Dial Timeout = 60
Dial Timeout Multiplier = 1
Auto Hopper Multipier = 1
Minimum Hopper Level = 1
Auto Hopper Level Adjustment = 1
Final Hopper Level = 1

---------------Auto Trim Hopper Enabled For Bulk---------------------
Leads in Hopper for this Campaign = 2
Hopper Level for this Campaign = 1

CAMPAIGNS TO PROCESSES HOPPER FOR: 2|1


Starting hopper run for Bulk campaign- GMT: 24hours HOPPER: 1 ORDER: UP|N|LEAD_DESCEND

|GMT-DAY-HOUR| |13.00-2-25||12.75-2-10||12.50-1-2355||12.25-1-2340||12.00-1-2325||11.75-1-2310||11.50-1-2255||11.25-1-2240||11.00-1-2225||10.75-1-2210||10.50-1-2155||10.25-1-2140||10.00-1-2125||9.75-1-2110||9.50-1-2055||9.25-1-2040||9.00-1-2025||8.75-1-2010||8.50-1-1955||8.25-1-1940||8.00-1-1925||7.75-1-1910||7.50-1-1855||7.25-1-1840||7.00-1-1825||6.75-1-1810||6.50-1-1755||6.25-1-1740||6.00-1-1725||5.75-1-1710||5.50-1-1655||5.25-1-1640||5.00-1-1625||4.75-1-1610||4.50-1-1555||4.25-1-1540||4.00-1-1525||3.75-1-1510||3.50-1-1455||3.25-1-1440||3.00-1-1425||2.75-1-1410||2.50-1-1355||2.25-1-1340||2.00-1-1325||1.75-1-1310||1.50-1-1255||1.25-1-1240||1.00-1-1225||0.75-1-1210||0.50-1-1155||0.25-1-1140||0.00-1-1125||-0.25-1-1110||-0.50-1-1055||-0.75-1-1040||-1.00-1-1025||-1.25-1-1010||-1.50-1-955||-1.75-1-940||-2.00-1-925||-2.25-1-910||-2.50-1-855||-2.75-1-840||-3.00-1-825||-3.25-1-810||-3.50-1-755||-3.75-1-740||-4.00-1-725||-4.25-1-710||-4.50-1-655||-4.75-1-640||-5.00-1-625||-5.25-1-610||-5.50-1-555||-5.75-1-540||-6.00-1-525||-6.25-1-510||-6.50-1-455||-6.75-1-440||-7.00-1-425||-7.25-1-410||-7.50-1-355||-7.75-1-340||-8.00-1-325||-8.25-1-310||-8.50-1-255||-8.75-1-240||-9.00-1-225||-9.25-1-210||-9.50-1-155||-9.75-1-140||-10.00-1-125||-10.25-1-110||-10.50-1-55||-10.75-1-40||-11.00-1-25||-11.25-1-10||-11.50-0-2355||-11.75-0-2340||-12.00-0-2325||-12.25-0-2310||-12.50-0-2255||-12.75-0-2240|
|SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times,ct_holidays FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|1|0|
hopper READY count: 2
|SELECT count(*) from vicidial_hopper where campaign_id='Bulk' and status='READY';|
Processing GMT for list 997
campaign lists count ACTIVE:1 | TOTAL:1
LIST ID SQL (list_id IN('997')) |SELECT count(*) from vicidial_hopper where campaign_id='Bulk' and status='READY';|
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='Bulk' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where (campaign_id='Bulk' and ((gmt_offset_now NOT IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ));|
no lead filter defined for campaign: Bulk
|NONE|
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('') and ((list_id IN('997'))) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status IN('') and ((list_id IN('997'))) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
NO DIALABLE LEADS FOR THIS CAMPAIGN

SUMMARY: 2 campaigns
camp 0 5 0
Bulk 0 1 2
DONE. Script execution time in seconds: 0

Thanks,
Pooja
Pooja
 
Posts: 7
Joined: Thu Jul 06, 2017 6:46 am

Re: Leads not getting picked up from vicidial_hopper

Postby Pooja » Tue Oct 24, 2017 12:51 am

Any suggestions?
Pooja
 
Posts: 7
Joined: Thu Jul 06, 2017 6:46 am

Re: Leads not getting picked up from vicidial_hopper

Postby mflorell » Tue Oct 24, 2017 4:58 am

"NO DIALABLE LEADS FOR THIS CAMPAIGN"

What dialable statuses did you select in the campaign modify screen?
mflorell
Site Admin
 
Posts: 17345
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Leads not getting picked up from vicidial_hopper

Postby Pooja » Tue Oct 24, 2017 5:02 am

Dialable Statuses selected are : AFTHRS, DROP and NEW.
Pooja
 
Posts: 7
Joined: Thu Jul 06, 2017 6:46 am

Re: Leads not getting picked up from vicidial_hopper

Postby mflorell » Tue Oct 24, 2017 5:04 am

This section of the SQL query shows no selected dial statuses: " status IN('')"
mflorell
Site Admin
 
Posts: 17345
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Leads not getting picked up from vicidial_hopper

Postby Pooja » Tue Oct 24, 2017 5:12 am

Okay got it. Thanks!
Pooja
 
Posts: 7
Joined: Thu Jul 06, 2017 6:46 am

Re: Leads not getting picked up from vicidial_hopper

Postby vijaymuddu » Sat Nov 16, 2019 5:03 am

i am facing same issue leads are showing in hopper also status in campaign are ok NEW list id is also newly created

Leads are shown in hopper but not getting calls when tested

Anybody has faced this issue

Please check
server config: i3,4gb, Centos 6.9 64bit | Version: 2.14b0.5 | Schema: 1528 | revision 2928| Asterisk 1.8.0 | E1-card
Thanks
Vijay Muddu
vijaymuddu
 
Posts: 102
Joined: Mon Jul 14, 2014 9:38 am
Location: India

Re: Leads not getting picked up from vicidial_hopper

Postby williamconley » Tue Nov 26, 2019 3:38 pm

Usually a result of numbers that do not match the dialplan entry of any carrier. Those that do not match a dialplan do not appear in asterisk as calls. Since the AGI script on the first line of every carrier entry is what "attaches" the call to Vicidial and begins logging and managing the call, no diaplan = no attachment and no management. Thus Vicidial has no idea what happened with this call AND does not change the status to "In Progress".
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18977
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Development

Who is online

Users browsing this forum: No registered users and 10 guests