SubPhase 6.6 - Step 2

[D]

We wanted to know under what campaign name were the test leads saved in when we did the Mysql data entry in Sub-Phase 6.6 - Step 2 of Scratch Install? How do we access those leads to make some test calls?

When I created campaigns named "New", TestCamp", or Test - it kept on saying that there were no leads in the hopper. We did edit the phone numbers.

Please advice.


######------ BEGIN Mysql data entry(you can copy and paste this into terminal) #

insert into vicidial_list values('','2004-01-06','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead01','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-06','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead02','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-07','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead03','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-07','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead04','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-07','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead05','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-07','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead06','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-07','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead07','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0')

[mflorell]

Leads are loaded into lists not campaigns. You need to create the list entry in vicidial/admin.php and then assign the list to a campaign.

[D]

Thanks for the prompt response. I did that and now I see that the list has a campaign assigned but it says that it has 0 leads in the dial hopper even though I entered at least 7 leads (following the Scratch Install instructions). Where are all those leads:

LIST ID LIST NAME ACTIVE
101 New Y

This campaign has 1 active lists and 0 inactive lists

This campaign has 1 leads to be dialed in those lists - HIDE

This campaign has 0 leads in the dial hopper


Below is what I enetered using my own telephone numbers:

######------ BEGIN Mysql data entry(you can copy and paste this into terminal) #

insert into vicidial_list values('','2004-01-06','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead01','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-06','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead02','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-07','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead03','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-07','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead04','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-07','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead05','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-07','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead06','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');
insert into vicidial_list values('','2004-01-07','','NEW','','','TEST01','101','TESTCAMP','N','1','7275551212','Mr','Matt','X','lead07','1234 Fake St.','','','Clearwater','FL','','33760','USA','M','1970-01-01','','test@test.com','suprise','comments go here','0');

[mflorell]

The hopper script should run once a minute if you have the entry in your crontab as it should be. What dial status do you have set in the campaign?

If you are still having problems then post the output of this script:
/usr/share/astguiclient/AST_VDhopper.pl --debugX

[D]

We are runnning version 1.1.12 and could not find the file in:

/usr/share/astguiclient/AST_VDhopper.pl
says no such file or directory

and could not run the command /usr/share/astguiclient/AST_VDhopper.pl --debugX


We found the file in:
/home/cron/astguiclient/AST_VDhopper.pl

but when we run home/cron/astguiclient/AST_VDhopper.pl --debugX

It says permission denied. Our Dial Plan Status is set as New - New Leads.

Please advice.

[mflorell]

for 1.1.12 you should run and post results:
/home/cron/astguiclient/AST_VDhopper.pl --debugX

[D]

It says - Permission denied when we run:

/home/cron/astguiclient/AST_VDhopper.pl --debugX

Our Dial Plan Status is set as New - New Leads.

Please advice.

[SuPrSluG]

Either perl is not in your $PATH or you don't have necessary permissions to run that script. A ls -l will give your permissions for that file/directory

[D]

Below is the out that we get when we run: /home/cron/astguiclient/AST_VDhopper.pl --debugX


root@phone:~# /home/cron/astguiclient/AST_VDhopper.pl
--debugX

----- DEBUG -----


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

TIME DEBUG: ||0| GMT: 23:39
SELECT * FROM vicidial_lists where active='N';Inactive
Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM
vicidial_callbacks where callback_time <= '2006-09-12
23:38:59' and status='ACTIVE';|

|GMT-DAY-HOUR|
|13.00-3-1239||12.75-3-1224||12.50-3-1209||12.25-3-1154||12.00-3-1139||11.75-3-1124||11.50-3-1109||11.25-3-1054||11.00-3-1039||10.75-3-1024||10.50-3-1009||10.25-3-954||10.00-3-939||9.75-3-924||9.50-3-909||9.25-3-854||9.00-3-839||8.75-3-824||8.50-3-809||8.25-3-754||8.00-3-739||7.75-3-724||7.50-3-709||7.25-3-654||7.00-3-639||6.75-3-624||6.50-3-609||6.25-3-554||6.00-3-539||5.75-3-524||5.50-3-509||5.25-3-454||5.00-3-439||4.75-3-424||4.50-3-409||4.25-3-354||4.00-3-339||3.75-3-324||3.50-3-309||3.25-3-254||3.00-3-239||2.75-3-224||2.50-3-209||2.25-3-154||2.00-3-139||1.75-3-124||1.50-3-109||1.25-3-54||1.00-3-39||0.75-3-24||0.50-3-9||0.25-2-2354||0.00-2-2339||-0.25-2-2324||-0.50-2-2309||-0.75-2-2254||-1.00-2-2239||-1.25-2-2224||-1.50-2-2209||-1.75-2-2154||-2.00-2-2139||-2.25-2-2124||-2.50-2-2109||-2.75-2-2054||-3.00-2-2039||-3.25-2-2024||-3.50-2-2009||-3.75-2-1954||-4.00-2-1939||-4.25-2-1924||-4.50-2-1909||-4.75-2-1854||-5.00-2-1839||-5.25-2-1824||-5.50-2-1809||-5.75-2-1754||-6.00-2-
1739||-6.25-2-1724||-6.50-2-1709||-6.75-2-1654||-7.00-2-1639||-7.25-2-1624||-7.50-2-1609||-7.75-2-1554||-8.00-2-1539||-8.25-2-1524||-8.50-2-1509||-8.75-2-1454||-9.00-2-1439||-9.25-2-1424||-9.50-2-1409||-9.75-2-1354||-10.00-2-1339||-10.25-2-1324||-10.50-2-1309||-10.75-2-1254||-11.00-2-1239||-11.25-2-1224||-11.50-2-1209||-11.75-2-1154||-12.00-2-1139||-12.25-2-1124||-12.50-2-1109||-12.75-2-1054|
|SELECT * FROM vicidial_call_times where
call_time_id='24hours';|
Starting hopper run for western campaign- GMT: 24hours
HOPPER: 1
hopper DONE cleared: 0
|DELETE from vicidial_hopper where
campaign_id='western' and status IN('DONE');|
hopper GMT BAD cleared: 0
|DELETE from vicidial_hopper where
campaign_id='western' and ((gmt_offset_now IN('99') )
);|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where
campaign_id='western' and status='READY';|
hopper too low (0|1) starting hopper dump
campaign lists count: 0 |
|SELECT list_id FROM vicidial_lists where
campaign_id='western' and active='Y';|
no lead filter defined for campaign: western
|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','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')
) ) ;|
ERROR CANNOT ADD ANY NEW LEADS TO HOPPER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR|
|13.00-3-1239||12.75-3-1224||12.50-3-1209||12.25-3-1154||12.00-3-1139||11.75-3-1124||11.50-3-1109||11.25-3-1054||11.00-3-1039||10.75-3-1024||10.50-3-1009||10.25-3-954||10.00-3-939||9.75-3-924||9.50-3-909||9.25-3-854||9.00-3-839||8.75-3-824||8.50-3-809||8.25-3-754||8.00-3-739||7.75-3-724||7.50-3-709||7.25-3-654||7.00-3-639||6.75-3-624||6.50-3-609||6.25-3-554||6.00-3-539||5.75-3-524||5.50-3-509||5.25-3-454||5.00-3-439||4.75-3-424||4.50-3-409||4.25-3-354||4.00-3-339||3.75-3-324||3.50-3-309||3.25-3-254||3.00-3-239||2.75-3-224||2.50-3-209||2.25-3-154||2.00-3-139||1.75-3-124||1.50-3-109||1.25-3-54||1.00-3-39||0.75-3-24||0.50-3-9||0.25-2-2354||0.00-2-2339||-0.25-2-2324||-0.50-2-2309||-0.75-2-2254||-1.00-2-2239||-1.25-2-2224||-1.50-2-2209||-1.75-2-2154||-2.00-2-2139||-2.25-2-2124||-2.50-2-2109||-2.75-2-2054||-3.00-2-2039||-3.25-2-2024||-3.50-2-2009||-3.75-2-1954||-4.00-2-1939||-4.25-2-1924||-4.50-2-1909||-4.75-2-1854||-5.00-2-1839||-5.25-2-1824||-5.50-2-1809||-5.75-2-1754||-6.00-2-
1739||-6.25-2-1724||-6.50-2-1709||-6.75-2-1654||-7.00-2-1639||-7.25-2-1624||-7.50-2-1609||-7.75-2-1554||-8.00-2-1539||-8.25-2-1524||-8.50-2-1509||-8.75-2-1454||-9.00-2-1439||-9.25-2-1424||-9.50-2-1409||-9.75-2-1354||-10.00-2-1339||-10.25-2-1324||-10.50-2-1309||-10.75-2-1254||-11.00-2-1239||-11.25-2-1224||-11.50-2-1209||-11.75-2-1154||-12.00-2-1139||-12.25-2-1124||-12.50-2-1109||-12.75-2-1054|
|SELECT * FROM vicidial_call_times where
call_time_id='24hours';|
Starting hopper run for Test campaign- GMT: 24hours
HOPPER: 1
hopper DONE cleared: 0
|DELETE from vicidial_hopper where
campaign_id='Test' and status IN('DONE');|
hopper GMT BAD cleared: 0
|DELETE from vicidial_hopper where
campaign_id='Test' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where
campaign_id='Test' and status='READY';|
hopper too low (0|1) starting hopper dump
campaign lists count: 0 |
|SELECT list_id FROM vicidial_lists where
campaign_id='Test' and active='Y';|
no lead filter defined for campaign: Test
|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','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')
) ) ;|
ERROR CANNOT ADD ANY NEW LEADS TO HOPPER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR|
|13.00-3-1239||12.75-3-1224||12.50-3-1209||12.25-3-1154||12.00-3-1139||11.75-3-1124||11.50-3-1109||11.25-3-1054||11.00-3-1039||10.75-3-1024||10.50-3-1009||10.25-3-954||10.00-3-939||9.75-3-924||9.50-3-909||9.25-3-854||9.00-3-839||8.75-3-824||8.50-3-809||8.25-3-754||8.00-3-739||7.75-3-724||7.50-3-709||7.25-3-654||7.00-3-639||6.75-3-624||6.50-3-609||6.25-3-554||6.00-3-539||5.75-3-524||5.50-3-509||5.25-3-454||5.00-3-439||4.75-3-424||4.50-3-409||4.25-3-354||4.00-3-339||3.75-3-324||3.50-3-309||3.25-3-254||3.00-3-239||2.75-3-224||2.50-3-209||2.25-3-154||2.00-3-139||1.75-3-124||1.50-3-109||1.25-3-54||1.00-3-39||0.75-3-24||0.50-3-9||0.25-2-2354||0.00-2-2339||-0.25-2-2324||-0.50-2-2309||-0.75-2-2254||-1.00-2-2239||-1.25-2-2224||-1.50-2-2209||-1.75-2-2154||-2.00-2-2139||-2.25-2-2124||-2.50-2-2109||-2.75-2-2054||-3.00-2-2039||-3.25-2-2024||-3.50-2-2009||-3.75-2-1954||-4.00-2-1939||-4.25-2-1924||-4.50-2-1909||-4.75-2-1854||-5.00-2-1839||-5.25-2-1824||-5.50-2-1809||-5.75-2-1754||-6.00-2-
1739||-6.25-2-1724||-6.50-2-1709||-6.75-2-1654||-7.00-2-1639||-7.25-2-1624||-7.50-2-1609||-7.75-2-1554||-8.00-2-1539||-8.25-2-1524||-8.50-2-1509||-8.75-2-1454||-9.00-2-1439||-9.25-2-1424||-9.50-2-1409||-9.75-2-1354||-10.00-2-1339||-10.25-2-1324||-10.50-2-1309||-10.75-2-1254||-11.00-2-1239||-11.25-2-1224||-11.50-2-1209||-11.75-2-1154||-12.00-2-1139||-12.25-2-1124||-12.50-2-1109||-12.75-2-1054|
|SELECT * FROM vicidial_call_times where
call_time_id='24hours';|
Starting hopper run for TestCamp campaign- GMT:
24hours HOPPER: 1
hopper DONE cleared: 0
|DELETE from vicidial_hopper where
campaign_id='TestCamp' and status IN('DONE');|
hopper GMT BAD cleared: 0
|DELETE from vicidial_hopper where
campaign_id='TestCamp' and ((gmt_offset_now IN('99') )
);|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where
campaign_id='TestCamp' and status='READY';|
hopper too low (0|1) starting hopper dump
campaign lists count: 0 |
|SELECT list_id FROM vicidial_lists where
campaign_id='TestCamp' and active='Y';|
no lead filter defined for campaign: TestCamp
|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','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')
) ) ;|
ERROR CANNOT ADD ANY NEW LEADS TO HOPPER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR|
|13.00-3-1239||12.75-3-1224||12.50-3-1209||12.25-3-1154||12.00-3-1139||11.75-3-1124||11.50-3-1109||11.25-3-1054||11.00-3-1039||10.75-3-1024||10.50-3-1009||10.25-3-954||10.00-3-939||9.75-3-924||9.50-3-909||9.25-3-854||9.00-3-839||8.75-3-824||8.50-3-809||8.25-3-754||8.00-3-739||7.75-3-724||7.50-3-709||7.25-3-654||7.00-3-639||6.75-3-624||6.50-3-609||6.25-3-554||6.00-3-539||5.75-3-524||5.50-3-509||5.25-3-454||5.00-3-439||4.75-3-424||4.50-3-409||4.25-3-354||4.00-3-339||3.75-3-324||3.50-3-309||3.25-3-254||3.00-3-239||2.75-3-224||2.50-3-209||2.25-3-154||2.00-3-139||1.75-3-124||1.50-3-109||1.25-3-54||1.00-3-39||0.75-3-24||0.50-3-9||0.25-2-2354||0.00-2-2339||-0.25-2-2324||-0.50-2-2309||-0.75-2-2254||-1.00-2-2239||-1.25-2-2224||-1.50-2-2209||-1.75-2-2154||-2.00-2-2139||-2.25-2-2124||-2.50-2-2109||-2.75-2-2054||-3.00-2-2039||-3.25-2-2024||-3.50-2-2009||-3.75-2-1954||-4.00-2-1939||-4.25-2-1924||-4.50-2-1909||-4.75-2-1854||-5.00-2-1839||-5.25-2-1824||-5.50-2-1809||-5.75-2-1754||-6.00-2-
1739||-6.25-2-1724||-6.50-2-1709||-6.75-2-1654||-7.00-2-1639||-7.25-2-1624||-7.50-2-1609||-7.75-2-1554||-8.00-2-1539||-8.25-2-1524||-8.50-2-1509||-8.75-2-1454||-9.00-2-1439||-9.25-2-1424||-9.50-2-1409||-9.75-2-1354||-10.00-2-1339||-10.25-2-1324||-10.50-2-1309||-10.75-2-1254||-11.00-2-1239||-11.25-2-1224||-11.50-2-1209||-11.75-2-1154||-12.00-2-1139||-12.25-2-1124||-12.50-2-1109||-12.75-2-1054|
|SELECT * FROM vicidial_call_times where
call_time_id='24hours';|
Starting hopper run for New campaign- GMT: 24hours
HOPPER: 1
hopper DONE cleared: 0
|DELETE from vicidial_hopper where
campaign_id='New' and status IN('DONE');|
hopper GMT BAD cleared: 0
|DELETE from vicidial_hopper where
campaign_id='New' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 1
|SELECT count(*) from vicidial_hopper where
campaign_id='New' and status='READY';|
DONE... Exiting... Goodbye... See you later... Really,
I mean it

[mflorell]

You do not have any lists assigned and active to an campaigns.

[D]

We have List ID 101 assigned to Campain: "New". The output provided earlier does not show it for some reason but it does show up on the GUI. We have more than 1 lead entered under this List ID but it only shows 1 lead in the Lead Hopper eventhough we have not made any calls. Below is what we see:

Why does /home/cron/astguiclient/AST_VDhopper.pl --debugX indidcate that we don't have any lists assigned to any campaigns?

MODIFY A CAMPAIGN'S RECORD: New - Basic View | Detail View | Realtime Screen
Campaign ID: New
Campaign Name: TestCamp
Active: Y
Park Extension: -
Web Form:
Allow Closers: Y
Dial status 1: New - New Lead
Dial status 2:
Dial status 3:
Dial status 4:
Dial status 5:
List Order: Down
Lead Filter:None
Hopper Level: 1
Force Reset of Hopper:
Auto Dial Level: 1 (0 = off)
Script: None
Get Call Launch: NONE

LISTS WITHIN THIS CAMPAIGN: HELP
LIST ID LIST NAME ACTIVE
101 New Y

This campaign has 1 active lists and 0 inactive lists

This campaign has 1 leads to be dialed in those lists - HIDE

This campaign has 1 leads in the dial hopper

Click here to see what leads are in the hopper right now

Click here to see all CallBack Holds in this campaign

[mflorell]

"This campaign has 1 leads in the dial hopper "

You got a lead into the hopper somehow so it must be working at some point.

If the hopper is at the desired hopper level it will not try to insert more leads. Try raising your hopper level and run it again.

[D]

I changed and increased the Hopper level but still the same problem on this campaign. Even created a new campaign and added around a 1,000 records to that list but below is the output (its showing 0 leads in the Hopper and 0 leads to be dialed):

Why does /home/cron/astguiclient/AST_VDhopper.pl --debugX indidcate that we don't have any lists assigned to any campaigns?

MODIFY A CAMPAIGN'S RECORD: New - Basic View | Detail View | Realtime Screen
Campaign ID: Western
Campaign Name: New
Active: Y
Park Extension: -
Web Form:
Allow Closers: Y
Dial status 1: New - New Lead
Dial status 2:
Dial status 3:
Dial status 4:
Dial status 5:
List Order: Down
Lead Filter:None
Hopper Level: 1
Force Reset of Hopper:
Auto Dial Level: 1 (0 = off)
Script: None
Get Call Launch: NONE

LISTS WITHIN THIS CAMPAIGN: HELP
LIST ID LIST NAME ACTIVE
101 New Y

This campaign has 1 active lists and 0 inactive lists

This campaign has 0 leads to be dialed in those lists - HIDE

This campaign has 0 leads in the dial hopper

Click here to see what leads are in the hopper right now

Click here to see all CallBack Holds in this campaign

[mflorell]

Please post the contents of the vicidial_lists table and the vicidial_campaigns table for this campaign.

[D]

Thanks Matt. Below are the contents of the vicidial_lists table and the vicidial_campaigns table:

mysql> SELECT * from vicidial_lists;
+---------+-----------+-------------+--------+
| list_id | list_name | campaign_id | active |
+---------+-----------+-------------+--------+
| 101 | New | New | Y |
| 104 | johny | western | Y |
| 107 | TestData | western | Y |
+---------+-----------+-------------+--------+
3 rows in set (0.03 sec)


mysql> SELECT * from vicidial_campaigns;
+-------------+---------------+--------+---------------+---------------+---------------+---------------+---------------+------------+----------+----------------+------------------+---------------+--------------+-----------------+-----------------+-----------------+---------------+--------------+-------------+--------------+---------------------+--------------------+--------------------+-----------------------+-----------------+-----------------+------------------+-----------------+-----------------+-------------------+-----------------+-------------------+--------------------+---------------------+----------------+-------------------+---------------------+-------------------+------------------------+----------------+----------------+------------------+------------------+
| campaign_id | campaign_name | active | dial_status_a | dial_status_b
| dial_status_c | dial_status_d | dial_status_e | lead_order |
park_ext | park_file_name | web_form_address | allow_closers |
hopper_level | auto_dial_level | next_agent_call | local_call_time |
voicemail_ext | dial_timeout | dial_prefix | campaign_cid |
campaign_vdad_exten | campaign_rec_exten | campaign_recording |
campaign_rec_filename | campaign_script | get_call_launch |
am_message_exten | amd_send_to_vmx | xferconf_a_dtmf |
xferconf_a_number | xferconf_b_dtmf | xferconf_b_number |
alt_number_dialing | scheduled_callbacks | lead_filter_id |
drop_call_seconds | safe_harbor_message | safe_harbor_exten |
display_dialable_count | wrapup_seconds | wrapup_message |
closer_campaigns | use_internal_dnc |
+-------------+---------------+--------+---------------+---------------+---------------+---------------+---------------+------------+----------+----------------+------------------+---------------+--------------+-----------------+-----------------+-----------------+---------------+--------------+-------------+--------------+---------------------+--------------------+--------------------+-----------------------+-----------------+-----------------+------------------+-----------------+-----------------+-------------------+-----------------+-------------------+--------------------+---------------------+----------------+-------------------+---------------------+-------------------+------------------------+----------------+----------------+------------------+------------------+
| western | western | Y | NEW |
| | | | DOWN |
| parkgsm | | Y | 1000 |
1 | random | 24hours | |
60 | 9 | 0000000000 | 8365 | 8309
| ONDEMAND | FULLDATE_CUSTPHONE |
| NONE | | N |
| | | | N
| N | NONE |
5 | N | 8307 | Y
| 0 | Wrapup Call | | N
|
| Test | Test01 | Y | NEW |
| | | | DOWN |
| | | Y | 1 |
1 | random | 24hours | |
60 | x | 0000000000 | 8365 | 8309
| ONDEMAND | FULLDATE_CUSTPHONE |
| NONE | | N |
| | | | N
| N | NONE |
5 | N | 8307 | Y
| 0 | Wrapup Call | | N
|
| TestCamp | TestCamp | Y | NEW |
| | | | DOWN |
| | | Y | 1 |
0 | random | 24hours | |
60 | x | 0000000000 | 8365 | 8309
| ONDEMAND | FULLDATE_CUSTPHONE |
| NONE | | N |
| | | | N
| N | NONE |
5 | N | 8307 | Y
| 0 | Wrapup Call | | N
|
| New | TestCamp | Y | NEW |
| | | | DOWN |
| | | Y | 1000 |
1 | random | 24hours | |
60 | x | 0000000000 | 8365 | 8309
| ONDEMAND | FULLDATE_CUSTPHONE |
| NONE | | N |
| | | | N
| N | NONE |
5 | N | 8307 | Y
| 0 | Wrapup Call | | N
|
+-------------+---------------+--------+---------------+---------------+---------------+---------------+---------------+------------+----------+----------------+------------------+---------------+--------------+-----------------+-----------------+-----------------+---------------+--------------+-------------+--------------+---------------------+--------------------+--------------------+-----------------------+-----------------+-----------------+------------------+-----------------+-----------------+-------------------+-----------------+-------------------+--------------------+---------------------+----------------+-------------------+---------------------+-------------------+------------------------+----------------+----------------+------------------+------------------+
4 rows in set (0.04 sec)

[mflorell]

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

[D]

We had uploaded around 800 leads in List ID 103 but it only shows 1 lead?


mysql> SELECT count(*),status,called_since_last_reset,list_id from
vicidial_list group by status,called_since_last_reset,list_id;
+----------+--------+-------------------------+---------+
| count(*) | status | called_since_last_reset | list_id |
+----------+--------+-------------------------+---------+
| 1 | NEW | N | 101 |
| 1 | NEW | N | 102 |
| 1 | NEW | N | 103 |
| 26 | NEW | N | 107 |
+----------+--------+-------------------------+---------+
4 rows in set (0.08 sec)

[enjay]

when you upload does it show that 800 processed cleanly. If I remember correctly it will run through the loader and while it may make it through the first one if the second entry has errors it will crap out there.

make sure they are in proper format (or try the lead loader list beta) from mantis.

-enjay