vicidial.org

Posted: **Wed Jun 06, 2007 8:07 am**

Hi,

I am trying to install vicidial on a fedora 5 pc with asterisk 1.4.2. The problem is that when an agent logs in there is a message "Sorry, there are no leads in the hopper for this campaign"
the output of the command:
/usr/share/astguiclient/AST_VDhopper.pl --debugX is:

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

TIME DEBUG: -5|-4|1| GMT: 18:57
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2007-06-06 14:57:21' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0

|GMT-DAY-HOUR| |13.00-4-757||12.75-4-742||12.50-4-727||12.25-4-712||12.00-4-657||11.75-4-642||11.50-4-627||11.25-4-612||11.00-4-557||10.75-4-542||10.50-4-527||10.25-4-512||10.00-4-457||9.75-4-442||9.50-4-427||9.25-4-412||9.00-4-357||8.75-4-342||8.50-4-327||8.25-4-312||8.00-4-257||7.75-4-242||7.50-4-227||7.25-4-212||7.00-4-157||6.75-4-142||6.50-4-127||6.25-4-112||6.00-4-57||5.75-4-42||5.50-4-27||5.25-4-12||5.00-3-2357||4.75-3-2342||4.50-3-2327||4.25-3-2312||4.00-3-2257||3.75-3-2242||3.50-3-2227||3.25-3-2212||3.00-3-2157||2.75-3-2142||2.50-3-2127||2.25-3-2112||2.00-3-2057||1.75-3-2042||1.50-3-2027||1.25-3-2012||1.00-3-1957||0.75-3-1942||0.50-3-1927||0.25-3-1912||0.00-3-1857||-0.25-3-1842||-0.50-3-1827||-0.75-3-1812||-1.00-3-1757||-1.25-3-1742||-1.50-3-1727||-1.75-3-1712||-2.00-3-1657||-2.25-3-1642||-2.50-3-1627||-2.75-3-1612||-3.00-3-1557||-3.25-3-1542||-3.50-3-1527||-3.75-3-1512||-4.00-3-1457||-4.25-3-1442||-4.50-3-1427||-4.75-3-1412||-5.00-3-1357||-5.25-3-1342||-5.50-3-1327||-5.75-3-1312||-6.00-3-1257||-6.25-3-1242||-6.50-3-1227||-6.75-3-1212||-7.00-3-1157||-7.25-3-1142||-7.50-3-1127||-7.75-3-1112||-8.00-3-1057||-8.25-3-1042||-8.50-3-1027||-8.75-3-1012||-9.00-3-957||-9.25-3-942||-9.50-3-927||-9.75-3-912||-10.00-3-857||-10.25-3-842||-10.50-3-827||-10.75-3-812||-11.00-3-757||-11.25-3-742||-11.50-3-727||-11.75-3-712||-12.00-3-657||-12.25-3-642||-12.50-3-627||-12.75-3-612|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for 100 campaign- GMT: 24hours HOPPER: 50
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='100' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='100' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='100' and status='READY';|
hopper too low (0|50) starting hopper dump
campaign lists count: 1 | '100'
|SELECT list_id FROM vicidial_lists where campaign_id='100' and active='Y';|
no lead filter defined for campaign: 100
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('100') 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 where called_since_last_reset='N' and status IN('NEW') and list_id IN('100') 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
ERROR CANNOT ADD ANY LEADS TO HOPPER

can you provide me with some workaround for this problem?

Regards
Vasilis Manolopoulos

Posted: **Wed Jun 06, 2007 8:54 pm**

Please post results of this query in MySQL:

SELECT count(*),list_id,status,called_since_last_reset,gmt_offset_now from vicidial_list group by list_id,status,called_since_last_reset,gmt_offset_now;

Posted: **Thu Jun 07, 2007 2:36 am**

Thx for the immediate reply mflorell!

Here is the result of the query:

SELECT count(*),list_id,status,called_since_last_reset,gmt_offset_now from vicidial_list group by list_id,status,called_since_last_reset,gmt_offset_now;
+----------+---------+--------+-------------------------+----------------+
| count(*) | list_id | status | called_since_last_reset | gmt_offset_now |
+----------+---------+--------+-------------------------+----------------+
| 39 | 107 | NEW | N | -4.00 |
| 6 | 129 | NEW | N | -7.00 |
| 6 | 129 | NEW | N | -6.00 |
| 9 | 129 | NEW | N | -5.00 |
| 9 | 129 | NEW | N | -4.00 |
| 3 | 129 | NEW | N | 1.00 |
| 3 | 129 | NEW | N | 9.50 |
| 3 | 129 | NEW | N | 10.00 |
+----------+---------+--------+-------------------------+----------------+
8 rows in set (0.11 sec)

Posted: **Thu Jun 07, 2007 7:07 am**

Ok problem solved . Thx for helping.

Posted: **Wed Sep 26, 2007 11:53 am**

If you don't mind me butting in, I am having a simular problem. My phone rings and puts me in 8600051. You are the only caller in this conf... asterisk -rvvvvv.... does not show any attempt to dial an outside number.

here is my output

Code: Select all: +----------+---------+--------+-------------------------+----------------+ | count(*) | list_id | status | called_since_last_reset | gmt_offset_now | +----------+---------+--------+-------------------------+----------------+ | 4 | 1 | NEW | N | -4.00 | | 1 | 102 | N | Y | -4.00 | | 5 | 102 | NEW | Y | -4.00 | +----------+---------+--------+-------------------------+----------------+

There is only one list (102).

Code: Select all: # /usr/share/astguiclient/AST_VDhopper.pl --debug ----- DEBUG ----- TIME DEBUG: -5|-4|1| GMT: 16:47 SELECT * FROM vicidial_lists where active='N';Inactive Lists: 0 CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2007-09-26 12:47:52' and status='ACTIVE';| CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0 Starting hopper run for 02 campaign- GMT: 24hours HOPPER: 5 hopper DONE cleared: 0E0 hopper GMT BAD cleared: 0E0 hopper READY count: 0 hopper too low (0|5) starting hopper dump campaign lists count: 1 | '102' no lead filter defined for campaign: 02 leads to call count: 0 NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER ERROR CANNOT ADD ANY LEADS TO HOPPER DONE. Script execution time in seconds: 0

Posted: **Wed Jul 16, 2008 5:02 am**

I have similiar problem:

I use manual dial, when i dial some numbers, i got popup window:

Code: Select all: <10.0.0.3> No more leads in the hopper for campaign: LAP

and 'dial next number' button is not clickable.

Code: Select all: mysql> SELECT count(*),list_id,status,called_since_last_reset,gmt_offset_now from vicidial_list group by list_id,status,called_since_last_reset,gmt_offset_now; +----------+---------+--------+-------------------------+----------------+ | count(*) | list_id | status | called_since_last_reset | gmt_offset_now | +----------+---------+--------+-------------------------+----------------+ | 2 | 1000 | CBHOLD | Y | 2.00 | | 1 | 1000 | DROP | Y | 2.00 | | 12 | 1000 | N | Y | 2.00 | | 7 | 1000 | NA | Y | 2.00 | | 3 | 1000 | NEW | Y | 2.00 | | 78 | 1000 | NEW | N | 2.00 | | 9 | 1000 | Nieode | Y | 2.00 | +----------+---------+--------+-------------------------+----------------+ 7 rows in set (0.01 sec)

Code: Select all: /usr/share/astguiclient/AST_VDhopper.pl --debug ----- DEBUG ----- TIME DEBUG: 0.00|1|1| GMT: 10:19 SELECT * FROM vicidial_lists where active='N';Inactive Lists: 0 CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2008-07-16 11:19:01' and status='ACTIVE';| CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0 Starting hopper run for lap campaign- GMT: 24hours HOPPER: 1 hopper DONE cleared: 0E0 hopper GMT BAD cleared: 0E0 hopper READY count: 0 hopper too low (0|1) starting hopper dump campaign lists count: 2 | '999','1000' no lead filter defined for campaign: lap leads to call count: 77 NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER Getting Leads to add to hopper NO RECYCLE-LEADS INTO HOPPER DEFINED lead call order: order by lead_id asc Adding to hopper: 1 DONE with this campaign DONE. Script execution time in seconds: 1

Posted: **Wed Jul 16, 2008 6:52 am**

This is fixed in 2.0.4.1rc3:

http://www.eflo.net/VICIDIALforum/viewtopic.php?t=5852