Page 1 of 1

No Leads To Be Dialed

PostPosted: Mon Aug 17, 2009 1:28 am
by benomg
Hi there,
I've just finished testing using the default campaigns/users/groups and I've now added my own. The problem is that the campaign shows "This campaign has 0 leads to be dialed". I guess there must be some rookie error as I've seen a few post like this except without a solution. Here is my debug and sql results. Can you please tell me what might be wrong?

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

TIME DEBUG: 10.00|10.00|0| GMT: 06:17
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 4
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('999','998','102','103');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2009-08-17 16:17:14' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0

|GMT-DAY-HOUR| |13.00-1-1917||12.75-1-1902||12.50-1-1847||12.25-1-1832||12.00-1-1817||11.75-1-1802||11.50-1-1747||11.25-1-1732||11.00-1-1717||10.75-1-1702||10.50-1-1647||10.25-1-1632||10.00-1-1617||9.75-1-1602||9.50-1-1547||9.25-1-1532||9.00-1-1517||8.75-1-1502||8.50-1-1447||8.25-1-1432||8.00-1-1417||7.75-1-1402||7.50-1-1347||7.25-1-1332||7.00-1-1317||6.75-1-1302||6.50-1-1247||6.25-1-1232||6.00-1-1217||5.75-1-1202||5.50-1-1147||5.25-1-1132||5.00-1-1117||4.75-1-1102||4.50-1-1047||4.25-1-1032||4.00-1-1017||3.75-1-1002||3.50-1-947||3.25-1-932||3.00-1-917||2.75-1-902||2.50-1-847||2.25-1-832||2.00-1-817||1.75-1-802||1.50-1-747||1.25-1-732||1.00-1-717||0.75-1-702||0.50-1-647||0.25-1-632||0.00-1-617||-0.25-1-602||-0.50-1-547||-0.75-1-532||-1.00-1-517||-1.25-1-502||-1.50-1-447||-1.75-1-432||-2.00-1-417||-2.25-1-402||-2.50-1-347||-2.75-1-332||-3.00-1-317||-3.25-1-302||-3.50-1-247||-3.75-1-232||-4.00-1-217||-4.25-1-202||-4.50-1-147||-4.75-1-132||-5.00-1-117||-5.25-1-102||-5.50-1-47||-5.75-1-32||-6.00-1-17||-6.25-1-2||-6.50-0-2347||-6.75-0-2332||-7.00-0-2317||-7.25-0-2302||-7.50-0-2247||-7.75-0-2232||-8.00-0-2217||-8.25-0-2202||-8.50-0-2147||-8.75-0-2132||-9.00-0-2117||-9.25-0-2102||-9.50-0-2047||-9.75-0-2032||-10.00-0-2017||-10.25-0-2002||-10.50-0-1947||-10.75-0-1932||-11.00-0-1917||-11.25-0-1902||-11.50-0-1847||-11.75-0-1832||-12.00-0-1817||-12.25-0-1802||-12.50-0-1747||-12.75-0-1732|
|SELECT * FROM vicidial_call_times where call_time_id='9am-9pm';|
LocalCallTime No-Call Gap: |43200|2100(21 00)|0900(09 00)|1|0|
Starting hopper run for 000358 campaign- GMT: 9am-9pm HOPPER: 5 ORDER: DOWN
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='000358' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='000358' and ((gmt_offset_now IN('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','99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='000358' and status='READY';|
hopper too low (0|5) starting hopper dump
campaign lists count: 2 | '104','358'
|SELECT list_id FROM vicidial_lists where campaign_id='000358' and active='Y';|
no lead filter defined for campaign: 000358
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('104','358') 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','-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('104','358') 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','-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

(7, 101, 'NEW', 'N'),
(1, 102, 'A', 'Y'),
(3, 102, 'N', 'Y'),
(2, 102, 'NA', 'Y'),
(28, 102, 'NEW', 'Y'),
(175, 102, 'NEW', 'N'),
(2, 102, 'NI', 'Y'),
(1, 103, 'NEW', 'Y'),
(1, 104, 'A', 'Y'),
(51, 104, 'AA', 'Y'),
(6, 104, 'CALLBK', 'Y'),
(10, 104, 'DROP', 'Y'),
(2, 104, 'ERI', 'Y'),
(9, 104, 'N', 'Y'),
(3, 104, 'NA', 'Y'),
(4, 104, 'NEW', 'Y'),
(16, 104, 'NI', 'Y'),
(2, 104, 'SALE', 'Y'),
(1, 104, 'XFER', 'Y'),
(670, 356, 'NEW', 'N'),
(548, 358, 'NEW', 'N'),
(60000, 999, 'NEW', 'N');

PostPosted: Mon Aug 17, 2009 1:36 am
by benomg
There's that rookie mistake. The time offset. Can there be an override for this in the list upload? I'm not sure how it came up with -4 when I'm in +10.

PostPosted: Mon Aug 17, 2009 5:30 am
by mflorell
When you loaded your list what did you put in the phone code override field, or int he phone_code field of your list entries?

What country are you calling?

same problem in my campaign: This campaign has 0 leads

PostPosted: Wed Aug 26, 2009 5:49 am
by ameferdo
iam living in france sorry for my english.
I loaded leads in my list, i create campagn and i can see my LIST ID at the below of my campagn but i can not log in agent section because i have " This campaign has 0 leads in the dial hopper" can you help me please?

PostPosted: Wed Aug 26, 2009 11:04 am
by barbw
I had this same problem.

What I did was Edit the LIST that belongs to the campaign and set the field called "RESET Lead-Called-Status for this List" to YES and then saved. It took about a minute, but this forced the leads into the hopper.

I'm new to vicidialer but this worked for me and I'm not sure why I have to do this..but it worked.

PostPosted: Thu Aug 27, 2009 4:28 am
by ameferdo
Thanks for your help. know i have 4 leads in my hopper but now if i want to log again in agent section i have "Sorry, there are no available sessions" but i create user
User Number: 7777
Password: 1234
Full Name:
User Level: 9
User Group: AGENTS
Phone Login: toto
Phone Pass: toto
Active: Y
CAMPAGN rank
Testcamp 1

Why can i not login in agent session ??? please help me

PostPosted: Thu Aug 27, 2009 8:43 am
by mflorell
Did you change the server IP of your machine?

How did you install ViciDial?

RE

PostPosted: Thu Aug 27, 2009 10:13 am
by ameferdo
I have not change my adress IP. I am working on the same server. The vicidial was installed with succes. Do you want that i reinstall vicidial? what is the reason of this session available? thanx for your help