Toll-Free number time zones and call times

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Toll-Free number time zones and call times

Postby bronson » Thu Oct 28, 2021 3:47 am

How does Vicidial determine the time zone for toll-free numbers (800, 888, 877, etc), assuming there are no other completed fields such as city/state/zip?
bronson
 
Posts: 96
Joined: Thu Oct 14, 2021 10:34 am

Re: Toll-Free number time zones and call times

Postby mflorell » Thu Oct 28, 2021 6:22 am

Since toll-free numbers in North America(NANPA) are not tied to any geographic area, they are not defined in a time zone, they are left at 0. If you want to define one, you can insert the following records into the database directly(shown below is EST, with DST enabled):


Code: Select all
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='800',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='833',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='844',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='855',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='866',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='877',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='888',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='822',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='880',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='881',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='882',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='883',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='884',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='885',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='886',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='887',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
INSERT INTO vicidial_phone_codes SET country_code='1',country='USA',areacode='889',state='NY',GMT_offset='-5',DST='Y',DST_range='SSM-FSN',geographic_description='Toll Free',tz_code='EST',php_tz='America/New_York';
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Toll-Free number time zones and call times

Postby bronson » Thu Oct 28, 2021 9:39 am

mflorell wrote:Since toll-free numbers in North America(NANPA) are not tied to any geographic area, they are not defined in a time zone, they are left at 0.


Ok, so how does the dialer treat toll-free numbers when adding to the hopper in regards to the "Local Call Time" settings? For example, if the call time is set for 9:00 am to 5:00 pm, does the dialer just ignore toll-free numbers or will they be dialed?
bronson
 
Posts: 96
Joined: Thu Oct 14, 2021 10:34 am

Re: Toll-Free number time zones and call times

Postby mflorell » Thu Oct 28, 2021 9:48 am

If you haven't loaded the above phone_codes entries, then they are treated as having a '0' value in the gmt_offset_now field, which would be GMT, which is 4-5 hours off of Eastern time in the USA.
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Toll-Free number time zones and call times

Postby bronson » Thu Oct 28, 2021 10:16 am

mflorell wrote:If you haven't loaded the above phone_codes entries, then they are treated as having a '0' value in the gmt_offset_now field, which would be GMT, which is 4-5 hours off of Eastern time in the USA.


ok, got it, thanks!
bronson
 
Posts: 96
Joined: Thu Oct 14, 2021 10:34 am


Return to Support

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 102 guests