How to Dialing as per time zone

[austin.rock9]

I wan to dial vicidial with as per time zone. When i put local time as 24 hours than leads are coming in hopper but when i put it to 9-9 than no such leads in hoper.

I have also set the ntp time as per scratch and also the following command /usr/share/astguiclient/ADMIN_area_code_populate.pl

What could be wrong pls. guide me.

[Op3r]

check your leads. and also what states are you trying to call from? if i remember correctly VICIDIAL takes the area code for its timezone or something .

for more full information check out the Manager's Manual.

[enjay]

make sure to run the GMT offset script also..

[mflorell]

SELECT count(*) from vicidial_phone_codes;

Do you have phone_code populated in your vicidial_list table?

[austin.rock9]

mysql> SELECT count(*) from vicidial_phone_codes;
+----------+
| count(*) |
+----------+
| 3042 |
+----------+
1 row in set (0.00 sec)


- /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl

I had run the above mention script.. I am running mixed pst est mst cst all zones. I also have 1 in my phone code. Also wht all things do i need to chk in my leads..

Also wrong time is coming on the agent web pages.. From where should the time come from agents screen. ?

Pls guide me ...

THanks.

[austin.rock9]

[root@localhost ~]# /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl
no command line options set

- process runtime (5 sec) (0.0833333333333333 minutes)


Output is above

Also the system time is [root@localhost cron]# date
Fri Feb 2 00:13:13 IST 2007

But agent is getting the time on their screen as FEB 01 7:13:49 PM

[mflorell]

Looks like you populated the phone codes table 3 times. delete everything in the table and rerun the populate script only once.

What is the phone's gmt_offset set to?(phones table)

What is the servers' GMT offsetset to?(servers table)

Do you have phone_code populated int he vicidial_list table?

[austin.rock9]

Phone Local GMT is 0 for all and -5 for only two users...


Server local GMT is -5

Also phone_code is set to 1 in the vicidial_list table.



Now
mysql> SELECT count(*) from vicidial_phone_codes;
+----------+
| count(*) |
+----------+
| 1014 |
+----------+
1 row in set (0.00 sec)



Pls. tell me wht should it do now....

Thanks

[mflorell]

What time zone is your Linux server set to?

[austin.rock9]

[root@localhost cron]# date
Fri Feb 2 00:13:13 IST 2007


Is this sufficient info. or should i send u some more tell me if u need anything ......Thanks...

[mflorell]

What is GMT at the time that "date" was generated?

What time zone are your leads in?

[austin.rock9]

At that time it was GMT +5:30 when i mention the above date

[austin.rock9]

STill i m facing this problem

[rudra_ach]

STill i m facing this problem

chk out the time zone you set in vicidial server page.If you are residing in India need to set 5.70 for example.You need to set this according to your country.Also set the same time zone with with phones.

These settings worked for me.

[austin.rock9]

HI timing i have configure with ntp so no prob. with it. But when in campaign i put 9-9 instead of 24hours the leads in hopper went off...Tell me what should i do than.

Thanks

[mflorell]

The GMT adjust script and the hopper script depend on your server being set to your local time with the same setting being in your servers table, if those are set correctly then only the leads for customers that are in the time range you set in the time range(9am-9pm) will be loaded in the hopper.

[austin.rock9]

Thanks.

Than what should i do to set it equally....

[austin.rock9]

HI,

Now after doing some changes on server, leads are coming in dial & also in hopper. But when i am putting 9-9 dialing all the leads of -6, -5, -8 are coming.

I only want -6 to come because we need to dial only LA at this time. Pls let me know wht could be the problem.

# date
Thu Feb 22 20:08:18 IST 2007

GMT is -5 in my server table.

Below is the output of my : /home/cron/AST_VDhopper.pl --debugX



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

----- DEBUG -----


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

TIME DEBUG: -5.00|-5.00|0| GMT: 00:49
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 7
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('102','105','104','103','1000','101','106');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2007-02-22 19:49:44' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 3|2

|GMT-DAY-HOUR| |13.00-5-1349||12.75-5-1334||12.50-5-1319||12.25-5-1304||12.00-5-1249||11.75-5-1234||11.50-5-1219||11.25-5-1204||11.00-5-1149||10.75-5-1134||10.50-5-1119||10.25-5-1104||10.00-5-1049||9.75-5-1034||9.50-5-1019||9.25-5-1004||9.00-5-949||8.75-5-934||8.50-5-919||8.25-5-904||8.00-5-849||7.75-5-834||7.50-5-819||7.25-5-804||7.00-5-749||6.75-5-734||6.50-5-719||6.25-5-704||6.00-5-649||5.75-5-634||5.50-5-619||5.25-5-604||5.00-5-549||4.75-5-534||4.50-5-519||4.25-5-504||4.00-5-449||3.75-5-434||3.50-5-419||3.25-5-404||3.00-5-349||2.75-5-334||2.50-5-319||2.25-5-304||2.00-5-249||1.75-5-234||1.50-5-219||1.25-5-204||1.00-5-149||0.75-5-134||0.50-5-119||0.25-5-104||0.00-5-49||-0.25-5-34||-0.50-5-19||-0.75-5-4||-1.00-4-2349||-1.25-4-2334||-1.50-4-2319||-1.75-4-2304||-2.00-4-2249||-2.25-4-2234||-2.50-4-2219||-2.75-4-2204||-3.00-4-2149||-3.25-4-2134||-3.50-4-2119||-3.75-4-2104||-4.00-4-2049||-4.25-4-2034||-4.50-4-2019||-4.75-4-2004||-5.00-4-1949||-5.25-4-1934||-5.50-4-1919||-5.75-4-1904||-6.00-4-1849||-6.25-4-1834||-6.50-4-1819||-6.75-4-1804||-7.00-4-1749||-7.25-4-1734||-7.50-4-1719||-7.75-4-1704||-8.00-4-1649||-8.25-4-1634||-8.50-4-1619||-8.75-4-1604||-9.00-4-1549||-9.25-4-1534||-9.50-4-1519||-9.75-4-1504||-10.00-4-1449||-10.25-4-1434||-10.50-4-1419||-10.75-4-1404||-11.00-4-1349||-11.25-4-1334||-11.50-4-1319||-11.75-4-1304||-12.00-4-1249||-12.25-4-1234||-12.50-4-1219||-12.75-4-1204|
|SELECT * FROM vicidial_call_times where call_time_id='9am-5pm';|
|SELECT * from vicidial_state_call_times where state_call_time_id='alabama';|
|SELECT * from vicidial_state_call_times where state_call_time_id='illinois';|
|SELECT * from vicidial_state_call_times where state_call_time_id='indiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='kentucky';|
|SELECT * from vicidial_state_call_times where state_call_time_id='louisiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='massachuse';|
|SELECT * from vicidial_state_call_times where state_call_time_id='mississipp';|
|SELECT * from vicidial_state_call_times where state_call_time_id='nebraska';|
|SELECT * from vicidial_state_call_times where state_call_time_id='nevada';|
|SELECT * from vicidial_state_call_times where state_call_time_id='pennsylvan';|
|SELECT * from vicidial_state_call_times where state_call_time_id='rhodeislan';|
|SELECT * from vicidial_state_call_times where state_call_time_id='sdakota';|
|SELECT * from vicidial_state_call_times where state_call_time_id='tennessee';|
|SELECT * from vicidial_state_call_times where state_call_time_id='texas';|
|SELECT * from vicidial_state_call_times where state_call_time_id='utah';|
|SELECT * from vicidial_state_call_times where state_call_time_id='washington';|
|SELECT * from vicidial_state_call_times where state_call_time_id='wyoming';|
Starting hopper run for BhartiR campaign- GMT: 9am-5pm HOPPER: 50
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='BhartiR' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='BhartiR' and ((gmt_offset_now IN('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','99') and state NOT IN('AL','IL','IN','KY','LA','MA','MS','NE','NV','PN','RI','SD','TN','TX','UT','WA','WY')) or (state='AL' and gmt_offset_now IN('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','99')) or (state='IL' and gmt_offset_now IN('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','99')) or (state='IN' and gmt_offset_now IN('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','99')) or (state='KY' and gmt_offset_now IN('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','99')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) or (state='NE' and gmt_offset_now IN('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','99')) or (state='NV' and gmt_offset_now IN('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','99')) or (state='PN' and gmt_offset_now IN('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','99')) or (state='RI' and gmt_offset_now IN('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','99')) or (state='SD' and gmt_offset_now IN('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','99')) or (state='TN' and gmt_offset_now IN('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','99')) or (state='TX' and gmt_offset_now IN('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','99')) or (state='UT' and gmt_offset_now IN('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','99')) or (state='WA' and gmt_offset_now IN('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','99')) or (state='WY' and gmt_offset_now IN('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','99')) );|
hopper READY count: 50
|SELECT count(*) from vicidial_hopper where campaign_id='BhartiR' and status='READY';|

|GMT-DAY-HOUR| |13.00-5-1349||12.75-5-1334||12.50-5-1319||12.25-5-1304||12.00-5-1249||11.75-5-1234||11.50-5-1219||11.25-5-1204||11.00-5-1149||10.75-5-1134||10.50-5-1119||10.25-5-1104||10.00-5-1049||9.75-5-1034||9.50-5-1019||9.25-5-1004||9.00-5-949||8.75-5-934||8.50-5-919||8.25-5-904||8.00-5-849||7.75-5-834||7.50-5-819||7.25-5-804||7.00-5-749||6.75-5-734||6.50-5-719||6.25-5-704||6.00-5-649||5.75-5-634||5.50-5-619||5.25-5-604||5.00-5-549||4.75-5-534||4.50-5-519||4.25-5-504||4.00-5-449||3.75-5-434||3.50-5-419||3.25-5-404||3.00-5-349||2.75-5-334||2.50-5-319||2.25-5-304||2.00-5-249||1.75-5-234||1.50-5-219||1.25-5-204||1.00-5-149||0.75-5-134||0.50-5-119||0.25-5-104||0.00-5-49||-0.25-5-34||-0.50-5-19||-0.75-5-4||-1.00-4-2349||-1.25-4-2334||-1.50-4-2319||-1.75-4-2304||-2.00-4-2249||-2.25-4-2234||-2.50-4-2219||-2.75-4-2204||-3.00-4-2149||-3.25-4-2134||-3.50-4-2119||-3.75-4-2104||-4.00-4-2049||-4.25-4-2034||-4.50-4-2019||-4.75-4-2004||-5.00-4-1949||-5.25-4-1934||-5.50-4-1919||-5.75-4-1904||-6.00-4-1849||-6.25-4-1834||-6.50-4-1819||-6.75-4-1804||-7.00-4-1749||-7.25-4-1734||-7.50-4-1719||-7.75-4-1704||-8.00-4-1649||-8.25-4-1634||-8.50-4-1619||-8.75-4-1604||-9.00-4-1549||-9.25-4-1534||-9.50-4-1519||-9.75-4-1504||-10.00-4-1449||-10.25-4-1434||-10.50-4-1419||-10.75-4-1404||-11.00-4-1349||-11.25-4-1334||-11.50-4-1319||-11.75-4-1304||-12.00-4-1249||-12.25-4-1234||-12.50-4-1219||-12.75-4-1204|
|SELECT * FROM vicidial_call_times where call_time_id='9am-9pm';|
RECYCLE: |DISHNET|NA|120|5|2007-02-22 19:47:44|
RECYCLE: |DISHNET|A|120|5|2007-02-22 19:47:44|
RECYCLE SQL: |( ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4')) and (status='NA') and (modify_date < "2007-02-22 19:47:44") ) or ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4')) and (status='A') and (modify_date < "2007-02-22 19:47:44") ) )|
Starting hopper run for DISHNET campaign- GMT: 9am-9pm HOPPER: 100
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='DISHNET' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='DISHNET' and ((gmt_offset_now IN('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','99') ) );|
hopper READY count: 100
|SELECT count(*) from vicidial_hopper where campaign_id='DISHNET' and status='READY';|

|GMT-DAY-HOUR| |13.00-5-1349||12.75-5-1334||12.50-5-1319||12.25-5-1304||12.00-5-1249||11.75-5-1234||11.50-5-1219||11.25-5-1204||11.00-5-1149||10.75-5-1134||10.50-5-1119||10.25-5-1104||10.00-5-1049||9.75-5-1034||9.50-5-1019||9.25-5-1004||9.00-5-949||8.75-5-934||8.50-5-919||8.25-5-904||8.00-5-849||7.75-5-834||7.50-5-819||7.25-5-804||7.00-5-749||6.75-5-734||6.50-5-719||6.25-5-704||6.00-5-649||5.75-5-634||5.50-5-619||5.25-5-604||5.00-5-549||4.75-5-534||4.50-5-519||4.25-5-504||4.00-5-449||3.75-5-434||3.50-5-419||3.25-5-404||3.00-5-349||2.75-5-334||2.50-5-319||2.25-5-304||2.00-5-249||1.75-5-234||1.50-5-219||1.25-5-204||1.00-5-149||0.75-5-134||0.50-5-119||0.25-5-104||0.00-5-49||-0.25-5-34||-0.50-5-19||-0.75-5-4||-1.00-4-2349||-1.25-4-2334||-1.50-4-2319||-1.75-4-2304||-2.00-4-2249||-2.25-4-2234||-2.50-4-2219||-2.75-4-2204||-3.00-4-2149||-3.25-4-2134||-3.50-4-2119||-3.75-4-2104||-4.00-4-2049||-4.25-4-2034||-4.50-4-2019||-4.75-4-2004||-5.00-4-1949||-5.25-4-1934||-5.50-4-1919||-5.75-4-1904||-6.00-4-1849||-6.25-4-1834||-6.50-4-1819||-6.75-4-1804||-7.00-4-1749||-7.25-4-1734||-7.50-4-1719||-7.75-4-1704||-8.00-4-1649||-8.25-4-1634||-8.50-4-1619||-8.75-4-1604||-9.00-4-1549||-9.25-4-1534||-9.50-4-1519||-9.75-4-1504||-10.00-4-1449||-10.25-4-1434||-10.50-4-1419||-10.75-4-1404||-11.00-4-1349||-11.25-4-1334||-11.50-4-1319||-11.75-4-1304||-12.00-4-1249||-12.25-4-1234||-12.50-4-1219||-12.75-4-1204|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for BhratiT campaign- GMT: 24hours HOPPER: 1
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='BhratiT' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='BhratiT' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='BhratiT' and status='READY';|
hopper too low (0|1) starting hopper dump
campaign lists count: 0 | ''
|SELECT list_id FROM vicidial_lists where campaign_id='BhratiT' and active='Y';|
no lead filter defined for campaign: BhratiT
|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') ) ) ;|
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','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
DONE. Script execution time in seconds: 0

----- DEBUG -----


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

TIME DEBUG: -5.00|-5.00|0| GMT: 01:09
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 7
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('102','105','104','103','1000','101','106');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2007-02-22 20:09:58' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 3|2

|GMT-DAY-HOUR| |13.00-5-1409||12.75-5-1354||12.50-5-1339||12.25-5-1324||12.00-5-1309||11.75-5-1254||11.50-5-1239||11.25-5-1224||11.00-5-1209||10.75-5-1154||10.50-5-1139||10.25-5-1124||10.00-5-1109||9.75-5-1054||9.50-5-1039||9.25-5-1024||9.00-5-1009||8.75-5-954||8.50-5-939||8.25-5-924||8.00-5-909||7.75-5-854||7.50-5-839||7.25-5-824||7.00-5-809||6.75-5-754||6.50-5-739||6.25-5-724||6.00-5-709||5.75-5-654||5.50-5-639||5.25-5-624||5.00-5-609||4.75-5-554||4.50-5-539||4.25-5-524||4.00-5-509||3.75-5-454||3.50-5-439||3.25-5-424||3.00-5-409||2.75-5-354||2.50-5-339||2.25-5-324||2.00-5-309||1.75-5-254||1.50-5-239||1.25-5-224||1.00-5-209||0.75-5-154||0.50-5-139||0.25-5-124||0.00-5-109||-0.25-5-54||-0.50-5-39||-0.75-5-24||-1.00-5-9||-1.25-4-2354||-1.50-4-2339||-1.75-4-2324||-2.00-4-2309||-2.25-4-2254||-2.50-4-2239||-2.75-4-2224||-3.00-4-2209||-3.25-4-2154||-3.50-4-2139||-3.75-4-2124||-4.00-4-2109||-4.25-4-2054||-4.50-4-2039||-4.75-4-2024||-5.00-4-2009||-5.25-4-1954||-5.50-4-1939||-5.75-4-1924||-6.00-4-1909||-6.25-4-1854||-6.50-4-1839||-6.75-4-1824||-7.00-4-1809||-7.25-4-1754||-7.50-4-1739||-7.75-4-1724||-8.00-4-1709||-8.25-4-1654||-8.50-4-1639||-8.75-4-1624||-9.00-4-1609||-9.25-4-1554||-9.50-4-1539||-9.75-4-1524||-10.00-4-1509||-10.25-4-1454||-10.50-4-1439||-10.75-4-1424||-11.00-4-1409||-11.25-4-1354||-11.50-4-1339||-11.75-4-1324||-12.00-4-1309||-12.25-4-1254||-12.50-4-1239||-12.75-4-1224|
|SELECT * FROM vicidial_call_times where call_time_id='9am-5pm';|
|SELECT * from vicidial_state_call_times where state_call_time_id='alabama';|
|SELECT * from vicidial_state_call_times where state_call_time_id='illinois';|
|SELECT * from vicidial_state_call_times where state_call_time_id='indiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='kentucky';|
|SELECT * from vicidial_state_call_times where state_call_time_id='louisiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='massachuse';|
|SELECT * from vicidial_state_call_times where state_call_time_id='mississipp';|
|SELECT * from vicidial_state_call_times where state_call_time_id='nebraska';|
|SELECT * from vicidial_state_call_times where state_call_time_id='nevada';|
|SELECT * from vicidial_state_call_times where state_call_time_id='pennsylvan';|
|SELECT * from vicidial_state_call_times where state_call_time_id='rhodeislan';|
|SELECT * from vicidial_state_call_times where state_call_time_id='sdakota';|
|SELECT * from vicidial_state_call_times where state_call_time_id='tennessee';|
|SELECT * from vicidial_state_call_times where state_call_time_id='texas';|
|SELECT * from vicidial_state_call_times where state_call_time_id='utah';|
|SELECT * from vicidial_state_call_times where state_call_time_id='washington';|
|SELECT * from vicidial_state_call_times where state_call_time_id='wyoming';|
Starting hopper run for BhartiR campaign- GMT: 9am-5pm HOPPER: 50
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='BhartiR' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='BhartiR' and ((gmt_offset_now IN('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','99') and state NOT IN('AL','IL','IN','KY','LA','MA','MS','NE','NV','PN','RI','SD','TN','TX','UT','WA','WY')) or (state='AL' and gmt_offset_now IN('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','99')) or (state='IL' and gmt_offset_now IN('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','99')) or (state='IN' and gmt_offset_now IN('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','99')) or (state='KY' and gmt_offset_now IN('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','99')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) or (state='NE' and gmt_offset_now IN('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','99')) or (state='NV' and gmt_offset_now IN('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','99')) or (state='PN' and gmt_offset_now IN('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','99')) or (state='RI' and gmt_offset_now IN('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','99')) or (state='SD' and gmt_offset_now IN('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','99')) or (state='TN' and gmt_offset_now IN('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','99')) or (state='TX' and gmt_offset_now IN('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','99')) or (state='UT' and gmt_offset_now IN('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','99')) or (state='WA' and gmt_offset_now IN('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','99')) or (state='WY' and gmt_offset_now IN('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','99')) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='BhartiR' and status='READY';|
hopper too low (0|50) starting hopper dump
campaign lists count: 1 | '300'
|SELECT list_id FROM vicidial_lists where campaign_id='BhartiR' and active='Y';|
no lead filter defined for campaign: BhartiR
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW','','','','') and list_id IN('300') 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','-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') and state NOT IN('AL','IL','IN','KY','LA','MA','MS','NE','NV','PN','RI','SD','TN','TX','UT','WA','WY')) or (state='AL' 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','-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')) or (state='IL' 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','-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')) or (state='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','-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')) or (state='KY' 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','-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')) or (state='LA' 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','-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')) or (state='MA' 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','-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')) or (state='MS' 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','-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')) or (state='NE' 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','-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')) or (state='NV' 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','-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')) or (state='PN' 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','-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')) or (state='RI' 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.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')) or (state='SD' 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','-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')) or (state='TN' 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','-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')) or (state='TX' 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','-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')) or (state='UT' 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','-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')) or (state='WA' and gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.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')) or (state='WY' 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','-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('300') 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','-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') and state NOT IN('AL','IL','IN','KY','LA','MA','MS','NE','NV','PN','RI','SD','TN','TX','UT','WA','WY')) or (state='AL' 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','-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')) or (state='IL' 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','-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')) or (state='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','-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')) or (state='KY' 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','-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')) or (state='LA' 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','-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')) or (state='MA' 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','-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')) or (state='MS' 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','-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')) or (state='NE' 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','-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')) or (state='NV' 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','-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')) or (state='PN' 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','-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')) or (state='RI' 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.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')) or (state='SD' 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','-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')) or (state='TN' 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','-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')) or (state='TX' 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','-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')) or (state='UT' 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','-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')) or (state='WA' and gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.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')) or (state='WY' 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','-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

|GMT-DAY-HOUR| |13.00-5-1409||12.75-5-1354||12.50-5-1339||12.25-5-1324||12.00-5-1309||11.75-5-1254||11.50-5-1239||11.25-5-1224||11.00-5-1209||10.75-5-1154||10.50-5-1139||10.25-5-1124||10.00-5-1109||9.75-5-1054||9.50-5-1039||9.25-5-1024||9.00-5-1009||8.75-5-954||8.50-5-939||8.25-5-924||8.00-5-909||7.75-5-854||7.50-5-839||7.25-5-824||7.00-5-809||6.75-5-754||6.50-5-739||6.25-5-724||6.00-5-709||5.75-5-654||5.50-5-639||5.25-5-624||5.00-5-609||4.75-5-554||4.50-5-539||4.25-5-524||4.00-5-509||3.75-5-454||3.50-5-439||3.25-5-424||3.00-5-409||2.75-5-354||2.50-5-339||2.25-5-324||2.00-5-309||1.75-5-254||1.50-5-239||1.25-5-224||1.00-5-209||0.75-5-154||0.50-5-139||0.25-5-124||0.00-5-109||-0.25-5-54||-0.50-5-39||-0.75-5-24||-1.00-5-9||-1.25-4-2354||-1.50-4-2339||-1.75-4-2324||-2.00-4-2309||-2.25-4-2254||-2.50-4-2239||-2.75-4-2224||-3.00-4-2209||-3.25-4-2154||-3.50-4-2139||-3.75-4-2124||-4.00-4-2109||-4.25-4-2054||-4.50-4-2039||-4.75-4-2024||-5.00-4-2009||-5.25-4-1954||-5.50-4-1939||-5.75-4-1924||-6.00-4-1909||-6.25-4-1854||-6.50-4-1839||-6.75-4-1824||-7.00-4-1809||-7.25-4-1754||-7.50-4-1739||-7.75-4-1724||-8.00-4-1709||-8.25-4-1654||-8.50-4-1639||-8.75-4-1624||-9.00-4-1609||-9.25-4-1554||-9.50-4-1539||-9.75-4-1524||-10.00-4-1509||-10.25-4-1454||-10.50-4-1439||-10.75-4-1424||-11.00-4-1409||-11.25-4-1354||-11.50-4-1339||-11.75-4-1324||-12.00-4-1309||-12.25-4-1254||-12.50-4-1239||-12.75-4-1224|
|SELECT * FROM vicidial_call_times where call_time_id='9am-9pm';|
RECYCLE: |DISHNET|NA|120|5|2007-02-22 20:07:58|
RECYCLE: |DISHNET|A|120|5|2007-02-22 20:07:58|
RECYCLE SQL: |( ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4')) and (status='NA') and (modify_date < "2007-02-22 20:07:58") ) or ( (called_since_last_reset IN('Y','Y1','Y2','Y3','Y4')) and (status='A') and (modify_date < "2007-02-22 20:07:58") ) )|
Starting hopper run for DISHNET campaign- GMT: 9am-9pm HOPPER: 100
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='DISHNET' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='DISHNET' and ((gmt_offset_now IN('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','99') ) );|
hopper READY count: 101
|SELECT count(*) from vicidial_hopper where campaign_id='DISHNET' and status='READY';|

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


Thanks.

[austin.rock9]

#/home/cron/ADMIN_adjust_GMTnow_on_leads.pl --debug

-----DEBUGGING -----

STARTING TIME ZONE DAYLIGHT SAVING TIME CALCULATION SCRIPT



SEED TIME 1172156295 : 2007-02-22 20:28:15 LOCAL GMT OFFSET NOW: -5.00
- Unique Country dial codes found: 1
- GMT postal codes records: 208750

RUNNING LOOP FOR COUNTRY CODE: 1
Postal Updates:
Area Code Updates: 0

DONE

- process runtime (7 sec) (0.116666666666667 minutes)

[mflorell]

First of all you have WAY too many postal code records, wipe out your postal code and phone codes tables and reimport them so you only have the records in there once.

Secondly, do you have a phone_code in the vicidial_list table? If so, what is it?

[austin.rock9]

AFter wiping out how can i get the data back in both of the tables...I have 1 in the phone_code in vicidial_list table..

THanks

[mflorell]

From the SCRATCH_INSTALL doc:

run this command from command line:
- /usr/share/astguiclient/ADMIN_area_code_populate.pl

[aster1]

I have a question .. In a 24 hour campaign .. does it matter whats the time zone set on server or on leads ?? ( or local server time tab in campaign screen ) ?

[mflorell]

That is true, but what country are you in that you can call people at any time of the day or night?

[aster1]

lol .. i asked bcoz i made a thread before that vicidial is showing calls ringing in campaign interface but there's no call made in asterisk ... I did some changes which i dont remember properly and it started working again and i wasnt able to pinpoint the problem .. It happened again yesterday and i changed the "Local server time " in campaign menu and also the server time to gmt +5:30 ( it was set wrong b4r ) in phones-->servers tab .. and it started working .. this time i was sure i didnt make any changes to dialplan and it started working and is still working fine from last 2 days .. so out of curiousity i asked this question