Add LARGE DNC List

[udfxrookie]

How do I import a DNC list that is 400MB? I have a huge file and need to import it for a system wide DNC, but it freezes the web page, etc.... any other way to add this file?

[mcargile]

Don't.

The vicidial DNC list was not designed to scrub your leads against. It was designed so that when your agents get told to put a number on the company DNC list they do not get called back. If you put that many numbers in the vicidial DNC list your system will come to a halt. Every single number loaded into the hopper will have to scan through 400 megs of phone numbers before it can be dialed.

You should be prescrubbing your leads before loading them into vicidial.

[williamconley]

the vicidial dnc table should never have multiple megabytes loaded into it. it is not a "state" or "federal" dnc list, it is a COMPANY dnc list.

we have an add-on to allow scrubbing leads within vicidial (using an external database). it washes the existing leads nightly and/or washes them before allowing them to be dialed (importing with a status other than "NEW" and after washing them will change status to NEW for good leads and NDNC for bad leads).

[alo]

we have an add-on to allow scrubbing leads within vicidial (using an external database). it washes the existing leads nightly and/or washes them before allowing them to be dialed (importing with a status other than "NEW" and after washing them will change status to NEW for good leads and NDNC for bad leads).

I know this is an older post so I hope you notice it, but I was wondering if you would be able to provide more information about this add-on you have William. It sounds like the perfect solution to our problem.

how are you accomplishing this Scrubbing from the external database?

Any information is greatly appreciated

Thank you.

[williamconley]

We break down the database to a single table for each area code. When we run a check, we grab the area code for each number and check in the appropriate table, or we grab a group of numbers sharing an area code and check them all at once. This keeps each table down to a reasonable size and speeds the checking process dramatically.

Oh: And NONE of this data is stored in the same database as the Vicidial database (which is ordinarily named "asterisk"). It is in a completely different database, perhaps even on a different server ... but that can cause issues when attempting multiple lead checks as two databases on different servers will not communicate as quickly as two databases on the same server.

We install the system for $300 for those who request it, which includes an update to the version of Vicidial in use by that client.

At present the system will accept single area code files or state files. We have not yet built an importer for "all at once" (the Big File). Of course, this is all designed to import the NDNC files downloaded from donotcall.gov (without alteration, just download the file from the Fed and upload it into the Vicidial NDNC menu added to your box ... and the rest is automated).

We can also obviously add custom import routines for other purposes, and we have for a couple clients but those are for single-shot uses based on a data format that nobody else uses and not helpful for General Public at all.