Toll-Free number time zones and call times
Posted: 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?
VICIDIAL astGUIclient discussion forum
http://forum.eflo.net/VICIDIALforum/
http://forum.eflo.net/VICIDIALforum/viewtopic.php?f=4&t=41106
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 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.
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.