by williamconley » Fri Mar 14, 2014 9:29 am
The challenge with that in the US is that it is impossible to put all of the NDNC into a single table, and certainly impossible to run a join query against two tables with that many records in each.
We split the NDNC tables by area code and then run an "area code walk" process to check in sequence. This is also handy as it allows us to segregate the numbers the same way the NDNC does (and the client purchases NDNC lists in the same method). Which makes it possible to block dialing entirely on area codes the client does not own the NDNC for ... thus saving some hefty lawsuits. Not to mention this gives the client the ability to demonstrate compliance (without saying "but bob said he checked them" which inevitably results in a stupid-large fine).
And since this is a "one-stop-shop", the client doesn't need to pre-wash in any way OR take Bob's word for it. Nor does the client need to 'manipulate' the list(s). All they do is download a ZIP for each area code or state from the NDNC site, upload that ZIP (unchanged) to Vicidial monthly. Leads will not be dialed until scrubbed. NDNC leads will not be dialed ever. No matter how big the NDNC gets. Period.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294