Time Zonez questions Part II

[lmora]

it comes from here

Sorry, I can't paste the remaining of the result I guess because is too long.

But I'm pasting one segment of the city that is presenting the issue.

City 1. Monterrey

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "810%" ;|
PROCESSING THIS LINE: 52 MEX 811 -6 Y FSA-LSO Monterrey, N.L. y Zonas Conurb

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "811%" ;|
First Sunday April to Last Sunday October
DST: 0

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "811%" and (gmt_offset_now != '-6' or gmt_offset_now IS NULL) ;|
ALL GMT ALREADY CORRECT FOR : 52 811 -6
PROCESSING THIS LINE: 52 MEX 812 -6 Y FSA-LSO Monterrey, N.L. y Zonas Conurb

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "812%" ;|
First Sunday April to Last Sunday October
DST: 0

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "812%" and (gmt_offset_now != '-6' or gmt_offset_now IS NULL) ;|
ALL GMT ALREADY CORRECT FOR : 52 812 -6
PROCESSING THIS LINE: 52 MEX 813 -6 Y FSA-LSO Monterrey, N.L. y Zonas Conurb

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "813%" ;|
PROCESSING THIS LINE: 52 MEX 814 -6 Y FSA-LSO Monterrey, N.L. y Zonas Conurb

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "814%" ;|
PROCESSING THIS LINE: 52 MEX 815 -6 Y FSA-LSO Monterrey, N.L. y Zonas Conurb

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "815%" ;|
PROCESSING THIS LINE: 52 MEX 816 -6 Y FSA-LSO Monterrey, N.L. y Zonas Conurb

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "816%" ;|
PROCESSING THIS LINE: 52 MEX 817 -6 Y FSA-LSO Monterrey, N.L. y Zonas Conurb

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "817%" ;|
First Sunday April to Last Sunday October
DST: 0

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "817%" and (gmt_offset_now != '-6' or gmt_offset_now IS NULL) ;|
ALL GMT ALREADY CORRECT FOR : 52 817 -6
PROCESSING THIS LINE: 52 MEX 818 -6 Y FSA-LSO Monterrey, N.L. y Zonas Conurb

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "818%" ;|
First Sunday April to Last Sunday October
DST: 0

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "818%" and (gmt_offset_now != '-6' or gmt_offset_now IS NULL) ;|
ALL GMT ALREADY CORRECT FOR : 52 818 -6
PROCESSING THIS LINE: 52 MEX 819 -6 Y FSA-LSO Monterrey, N.L. y Zonas Conurb

City 2. Culiacán

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "665%" ;|
PROCESSING THIS LINE: 52 MEX 667 SIN -7 Y FSA-LSO Culiacán, Sin.j

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "667%" ;|
First Sunday April to Last Sunday October
DST: 0

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "667%" and (gmt_offset_now != '-7' or gmt_offset_now IS NULL) ;|
ALL GMT ALREADY CORRECT FOR : 52 667 -7

City 3.

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "614%" ;|
First Sunday April to Last Sunday October
DST: 0

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "614%" and (gmt_offset_now != '-7' or gmt_offset_now IS NULL) ;|
ALL GMT ALREADY CORRECT FOR : 52 614 -7

[mflorell]

I don't see 228 or 656 anywhere in this output.

[lmora]

Here they are:

228

PROCESSING THIS LINE: 52 MEX 228 -6 Y FSA-LSO Jalapa, Ver.bze

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "228%" ;|
First Sunday April to Last Sunday October
DST: 0

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "228%" and (gmt_offset_now != '-6' or gmt_offset_now IS NULL) ;|
ALL GMT ALREADY CORRECT FOR : 52 228 -6

656

PROCESSING THIS LINE: 52 MEX 656 CHIH -7 Y FSA-LSO Ciudad Juárez, Chih.

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "656%" ;|
First Sunday April to Last Sunday October
DST: 0

|select count(*) from vicidial_list where phone_code='52' and phone_number LIKE "656%" and (gmt_offset_now != '-7' or gmt_offset_now IS NULL) ;|
ALL GMT ALREADY CORRECT FOR : 52 656 -7

[mflorell]

post results of this query:

select count(*),phone_code,gmt_offset_now from vicidial_list where phone_number LIKE "656%" group by phone_code,gmt_offset_now;

[lmora]

I did a minor change in the phone_number since they are preceded by 01.
Also I ran the query for those phone numbers that start with 0181 and 01228 too.

Queries run:
select count(*),phone_code,gmt_offset_now
from vicidial_list
where phone_number LIKE "01656%"
group by phone_code,gmt_offset_now;

select count(*),phone_code,gmt_offset_now
from vicidial_list
where phone_number LIKE "01228%"
group by phone_code,gmt_offset_now;

select count(*),phone_code,gmt_offset_now
from vicidial_list
where phone_number LIKE "0181%"
group by phone_code,gmt_offset_now;


Results 01656:

Code: Select all

count(*),phone_code,gmt_offset_now
1,,0
6637,52,-6
9,52,0


Results 0181:

Code: Select all

count(*),phone_code,gmt_offset_now
1,1,0
3126,52,-7
260729,52,-5
141,52,0

Results 01228:

Code: Select all

count(*),phone_code,gmt_offset_now
4615,52,-5
16,52,0

I found out that the records with 0 gmt_offset_now value are new referrals entered by operators. (all of them have 998 in list_id). I guess that might be a bug, isn't it?

[mflorell]

Nope, no bugs, the adjust GMT script should take care of them.

The system was not written with a prefix of 0 in mind which is probably why you are having problems.

[lmora]

ok, I'll remove the 01 from the phone numbers at vicidial_list and attach it in my dialplan instead.

does the script /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl would be enough to correct the GMT offset value?


Rgds

[mflorell]

That should be enough.

[lmora]

I corrected the errors in gmt_offset_now value by:
1. Removing the 01 prefix in the all phone numbers at vicidial_list
2. Running the script /usr/share/astguiclient/ADMIN_adjust_GMTnow_on_leads.pl --debugX

so thanks Matt for your support.


I still have a question regarding callbacks and timezones, could it be possible that the time set to call back be interpreted by ViciDial as the customer's time in case they are in different timezone instead of local time?

Rgds

[mflorell]

Thanks for posting your solution.

As for Callbacks, they only work on server time, not customer time. I'm sure that could be possible with some programming, but it would probably take a while.