ViciDial NANPA data

All installation and configuration problems and questions

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

ViciDial NANPA data

Postby ajax1515 » Mon Dec 18, 2017 9:51 am

I noticed that the table vicidial_nanpa_prefix_codes, seems not to be populated by default. Currently we use NANPA data from zip-codes.com to populate data in some of our other systems outside of ViciDial, I was wondering if ViciDial had anything they would recommend for getting this data?
ViciBox v.7.0.2-160325
VICIDIAL-VERSION: 2.12-550a BUILD: 160414-1013
Asterisk 11.22.0-vici
1 Database Server
MariaDB 10.1.6
2 Web Servers
Multiple Dial Servers
ajax1515
 
Posts: 70
Joined: Wed Sep 23, 2015 11:23 am

Re: ViciDial NANPA data

Postby ajax1515 » Mon Dec 18, 2017 9:57 am

In addition, we also have a need to load some 1-800 numbers into the list, which obviously fail if the NANPA check is being used... Would the best way to ensure those leads get in be to simply NOT pass the check_nanpa_prefix='y' flag to the non_agent_api when adding the lead, or would it be better to manually add the 800 numbers into the nanpa_codes table, or something else?
ViciBox v.7.0.2-160325
VICIDIAL-VERSION: 2.12-550a BUILD: 160414-1013
Asterisk 11.22.0-vici
1 Database Server
MariaDB 10.1.6
2 Web Servers
Multiple Dial Servers
ajax1515
 
Posts: 70
Joined: Wed Sep 23, 2015 11:23 am

Re: ViciDial NANPA data

Postby mflorell » Mon Dec 18, 2017 6:42 pm

The NANPA list is available here:
http://www.vicidial.org/store.php

It is more than just the list of NANPA prefix codes, it also has the timezone and DST information for each of the prefixes. The source of this information is not free, which is why we have to charge for the data.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: ViciDial NANPA data

Postby ajax1515 » Thu Dec 21, 2017 11:31 am

Right that's what I had assumed, Thank you Matt!
ViciBox v.7.0.2-160325
VICIDIAL-VERSION: 2.12-550a BUILD: 160414-1013
Asterisk 11.22.0-vici
1 Database Server
MariaDB 10.1.6
2 Web Servers
Multiple Dial Servers
ajax1515
 
Posts: 70
Joined: Wed Sep 23, 2015 11:23 am

Re: ViciDial NANPA data

Postby ajax1515 » Thu Dec 21, 2017 11:38 am

Matt,

Could you also give me a quick response to this question:

"In addition, we also have a need to load some 1-800 numbers into the list, which obviously fail if the NANPA check is being used... Would the best way to ensure those leads get in be to simply NOT pass the check_nanpa_prefix='y' flag to the non_agent_api when adding the lead, or would it be better to manually add the 800 numbers into the nanpa_codes table, or something else?"

Thanks!
ViciBox v.7.0.2-160325
VICIDIAL-VERSION: 2.12-550a BUILD: 160414-1013
Asterisk 11.22.0-vici
1 Database Server
MariaDB 10.1.6
2 Web Servers
Multiple Dial Servers
ajax1515
 
Posts: 70
Joined: Wed Sep 23, 2015 11:23 am

Re: ViciDial NANPA data

Postby mflorell » Fri Dec 22, 2017 5:27 am

It's really up to you, either would work.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 107 guests