if someone speak german please lett me know this.
I have got some Problems to load leads into the Dial Hopper.
Loading Leads is no Problem. The List menu show me leads to dial.
But Dial Hopper only 1.
I don´t know how i can put the leads into the Dial Hopper
I looked in the Mysql DB and all Leads load in vicidial_lists tabelle...
in the hopper ist list is no dates
I run fpr debugging but there it seems to be no mistakes....
/usr/share/astguiclient/AST_VDhopper.pl --debugX
- Code: Select all
h1468110:~# /usr/share/astguiclient/AST_VDhopper.pl --debugX
----- DEBUG -----
----- SUPER DEBUG -----
h1468110:~# /usr/share/astguiclient/AST_VDhopper.pl --debugX
----- DEBUG -----
----- SUPER DEBUG -----
TIME DEBUG: 1.00|1.00|0| GMT: 22:30
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2009-03-07 23 :30:07' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 2|1
|GMT-DAY-HOUR| |13.00-0-1130||12.75-0-1115||12.50-0-1100||12.25-0-1045||12.00-0-1030||11. 75-0-1015||11.50-0-1000||11.25-0-945||11.00-0-930||10.75-0-915||10.50-0-900||10.25-0-845||10.0 0-0-830||9.75-0-815||9.50-0-800||9.25-0-745||9.00-0-730||8.75-0-715||8.50-0-700||8.25-0-645||8 .00-0-630||7.75-0-615||7.50-0-600||7.25-0-545||7.00-0-530||6.75-0-515||6.50-0-500||6.25-0-445| |6.00-0-430||5.75-0-415||5.50-0-400||5.25-0-345||5.00-0-330||4.75-0-315||4.50-0-300||4.25-0-24 5||4.00-0-230||3.75-0-215||3.50-0-200||3.25-0-145||3.00-0-130||2.75-0-115||2.50-0-100||2.25-0- 45||2.00-0-30||1.75-0-15||1.50-0-0||1.25-6-2345||1.00-6-2330||0.75-6-2315||0.50-6-2300||0.25-6 -2245||0.00-6-2230||-0.25-6-2215||-0.50-6-2200||-0.75-6-2145||-1.00-6-2130||-1.25-6-2115||-1.5 0-6-2100||-1.75-6-2045||-2.00-6-2030||-2.25-6-2015||-2.50-6-2000||-2.75-6-1945||-3.00-6-1930|| -3.25-6-1915||-3.50-6-1900||-3.75-6-1845||-4.00-6-1830||-4.25-6-1815||-4.50-6-1800||-4.75-6-17 45||-5.00-6-1730||-5.25-6-1715||-5.50-6-1700||-5.75-6-1645||-6.00-6-1630||-6.25-6-1615||-6.50- 6-1600||-6.75-6-1545||-7.00-6-1530||-7.25-6-1515||-7.50-6-1500||-7.75-6-1445||-8.00-6-1430||-8 .25-6-1415||-8.50-6-1400||-8.75-6-1345||-9.00-6-1330||-9.25-6-1315||-9.50-6-1300||-9.75-6-1245 ||-10.00-6-1230||-10.25-6-1215||-10.50-6-1200||-10.75-6-1145||-11.00-6-1130||-11.25-6-1115||-1 1.50-6-1100||-11.75-6-1045||-12.00-6-1030||-12.25-6-1015||-12.50-6-1000||-12.75-6-945|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for ep01 campaign- GMT: 24hours HOPPER: 1
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='ep01' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='ep01' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 1
|SELECT count(*) from vicidial_hopper where campaign_id='ep01' and status='READY';|
|GMT-DAY-HOUR| |13.00-0-1130||12.75-0-1115||12.50-0-1100||12.25-0-1045||12.00-0-1030||11. 75-0-1015||11.50-0-1000||11.25-0-945||11.00-0-930||10.75-0-915||10.50-0-900||10.25-0-845||10.0 0-0-830||9.75-0-815||9.50-0-800||9.25-0-745||9.00-0-730||8.75-0-715||8.50-0-700||8.25-0-645||8 .00-0-630||7.75-0-615||7.50-0-600||7.25-0-545||7.00-0-530||6.75-0-515||6.50-0-500||6.25-0-445| |6.00-0-430||5.75-0-415||5.50-0-400||5.25-0-345||5.00-0-330||4.75-0-315||4.50-0-300||4.25-0-24 5||4.00-0-230||3.75-0-215||3.50-0-200||3.25-0-145||3.00-0-130||2.75-0-115||2.50-0-100||2.25-0- 45||2.00-0-30||1.75-0-15||1.50-0-0||1.25-6-2345||1.00-6-2330||0.75-6-2315||0.50-6-2300||0.25-6 -2245||0.00-6-2230||-0.25-6-2215||-0.50-6-2200||-0.75-6-2145||-1.00-6-2130||-1.25-6-2115||-1.5 0-6-2100||-1.75-6-2045||-2.00-6-2030||-2.25-6-2015||-2.50-6-2000||-2.75-6-1945||-3.00-6-1930|| -3.25-6-1915||-3.50-6-1900||-3.75-6-1845||-4.00-6-1830||-4.25-6-1815||-4.50-6-1800||-4.75-6-17 45||-5.00-6-1730||-5.25-6-1715||-5.50-6-1700||-5.75-6-1645||-6.00-6-1630||-6.25-6-1615||-6.50- 6-1600||-6.75-6-1545||-7.00-6-1530||-7.25-6-1515||-7.50-6-1500||-7.75-6-1445||-8.00-6-1430||-8 .25-6-1415||-8.50-6-1400||-8.75-6-1345||-9.00-6-1330||-9.25-6-1315||-9.50-6-1300||-9.75-6-1245 ||-10.00-6-1230||-10.25-6-1215||-10.50-6-1200||-10.75-6-1145||-11.00-6-1130||-11.25-6-1115||-1 1.50-6-1100||-11.75-6-1045||-12.00-6-1030||-12.25-6-1015||-12.50-6-1000||-12.75-6-945|
|SELECT * FROM vicidial_call_times where call_time_id='9am-9pm';|
Starting hopper run for epstart campaign- GMT: 9am-9pm HOPPER: 1
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='epstart' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='epstart' and ((gmt_offset_now IN('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','99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='epstart' and status='READY';|
hopper too low (0|1) starting hopper dump
campaign lists count: 0 | ''
|SELECT list_id FROM vicidial_lists where campaign_id='epstart' and active='Y';|
no lead filter defined for campaign: epstart
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW' ) and list_id IN('') 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','-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.2 5','-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('') 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','-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.2 5','-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
DONE. Script execution time in seconds: 0
h1468110:~#
i hope u can help me...
Greats
M. Bodewig
[/code]