DNC List

Any and all non-support discussions

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

DNC List

Postby iboam » Fri Jul 15, 2016 4:03 pm

There is anyway i can use a list as DNC or upload a csv file to the SYSTEM_INTERNAL - INTERNAL DNC LIST ??
ViciBox: 11 | VERSION: 2.14-897a BUILD: 230927-0857 | Clusters: 1 DB-WEB-ASTX | SSL | WebRTC | Wallboard | DNC Nightly Scrubber
iboam
 
Posts: 257
Joined: Mon Feb 08, 2016 2:35 pm

Re: DNC List

Postby mflorell » Fri Jul 15, 2016 6:48 pm

mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: DNC List

Postby williamconley » Sun Jul 17, 2016 10:33 pm

iboam wrote:There is anyway i can use a list as DNC or upload a csv file to the SYSTEM_INTERNAL - INTERNAL DNC LIST ??

Beware: DNC lists are not to be huge. They will bog down the system! Do not attempt to load the National DNC list into your Vicidial server. (We have a nightly runner script that allows you to do this after hours without bogging down the system if that's what you're looking for.)

That being said: Add a single lead to the Internal or Campaign DNC of which you speak. Then have a look at phpMyAdmin or mysql and dump the vicidial_dnc or vicidial_campaign_dnc tables and see how it landed. At that point, populating the leads from phpMyAdmin or mysql at the command line can be handled many ways. Depending on the format you already have the list. You can also add a fairly decent amount directly in the "Lists -> Add-Delete DNC Number" link. That's a Text Field. I don't know what the limit is, but it's gonna be pretty big. 8-) (and with adjusted php.ini settings, could be bigger, in theory).
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
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: DNC List

Postby iboam » Sun Jul 17, 2016 11:24 pm

I would like to upload dnc list from the do not call just for the area codes i usually dial.

In this case (We have a nightly runner script that allows you to do this after hours without bogging down the system if that's what you're looking for.) what is a solution ??
ViciBox: 11 | VERSION: 2.14-897a BUILD: 230927-0857 | Clusters: 1 DB-WEB-ASTX | SSL | WebRTC | Wallboard | DNC Nightly Scrubber
iboam
 
Posts: 257
Joined: Mon Feb 08, 2016 2:35 pm

Re: DNC List

Postby williamconley » Mon Jul 18, 2016 12:21 am

Any area code National DNC list is too large and will bring down the server. That would constitute comparing millions of records in one table to millions of records in another ... Every time the system loads a lead into the dialer. Crash and burn. LOL

You should scrub the leads externally before bringing them into the Vicidial system.

That being said: If you don't have a method to manage this already, we have this product available and have installed it many times for almost every version of Vicidial over the years:

Vicidial NDNC Nightly Checker -> http://catalog.poundteam.com/product_in ... cts_id=612

The default configuration includes locking the server so it will refuse to dial area codes that you have not loaded. So the areas you don't own, you can't accidentally dial. Those leads will have the status of "NO_DNC" to avoid being dialed entirely.

You download the lists for each state or area code from the National DNC. You upload the lists into the system. Then you forget about it (it'll run overnight). In the morning, any leads that became DNC will have a status of "NDNC".

Any leads that were loaded during the day will be "NO_DNC" when they are loaded. Overnight, they will be scrubbed and changed to "NEW" or "NDNC" (if they are in the DNC) or remain "NO_DNC" if they are in an area code you have not loaded.

It is possible to add "NO_DNC" to your system to dial leads that are not scrubbed, but it's not a good idea. Best to just not dial the areas you have not yet purchased.
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
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: DNC List

Postby iboam » Mon Jul 18, 2016 9:21 am

Thanks everyone i just found vicidial_dnc table @ asterisk database ... thanks for your help !!!!
ViciBox: 11 | VERSION: 2.14-897a BUILD: 230927-0857 | Clusters: 1 DB-WEB-ASTX | SSL | WebRTC | Wallboard | DNC Nightly Scrubber
iboam
 
Posts: 257
Joined: Mon Feb 08, 2016 2:35 pm

Re: DNC List

Postby williamconley » Mon Jul 18, 2016 10:54 am

Be sure to make a backup copy of your present list before adding millions of leads to it. You may need to empty it and put those leads back. And be sure to post the results of your experiment upon completion. 8-)
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
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

DNC Import Result

Postby iboam » Mon Jul 18, 2016 12:04 pm

i just imported the DNC list with 387798 records to vicidial_dnc using Navicat for MySQL, then i ran a query

Code: Select all
UPDATE vicidial_dnc SET phone_number = REPLACE(phone_number,",","") WHERE phone_number is not NULL;

Affected rows: 387798
Time: 21.214ms

Done
ViciBox: 11 | VERSION: 2.14-897a BUILD: 230927-0857 | Clusters: 1 DB-WEB-ASTX | SSL | WebRTC | Wallboard | DNC Nightly Scrubber
iboam
 
Posts: 257
Joined: Mon Feb 08, 2016 2:35 pm

Re: DNC List

Postby williamconley » Mon Jul 18, 2016 1:03 pm

300k is fairly small. You might get away with that one. Keep an eye on your MySQL server for slow queries. And of course, if the dialer becomes "sluggish" ...
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
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: DNC List

Postby iboam » Mon Jul 18, 2016 1:39 pm

I just add another 1198536 records and runs fine
ViciBox: 11 | VERSION: 2.14-897a BUILD: 230927-0857 | Clusters: 1 DB-WEB-ASTX | SSL | WebRTC | Wallboard | DNC Nightly Scrubber
iboam
 
Posts: 257
Joined: Mon Feb 08, 2016 2:35 pm

Re: DNC List

Postby williamconley » Mon Jul 18, 2016 2:17 pm

Keep us apprised of where it breaks down. Be sure you can "go back".

How many leads do you have in your system total, and how many in your Hopper (total of all hoppers)?
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
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: DNC List

Postby iboam » Mon Jul 18, 2016 2:19 pm

Now no to much DIALABLE LEADS: 5659 / Hopper 201
ViciBox: 11 | VERSION: 2.14-897a BUILD: 230927-0857 | Clusters: 1 DB-WEB-ASTX | SSL | WebRTC | Wallboard | DNC Nightly Scrubber
iboam
 
Posts: 257
Joined: Mon Feb 08, 2016 2:35 pm

Re: DNC List

Postby williamconley » Mon Jul 18, 2016 2:27 pm

Not "dialable". How many leads in the vicidial_list table. Not "hopper level" or "hopper for this campaign", but entries in the vicidial_hopper table. These numbers speak to the scale of your system.
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
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: DNC List

Postby iboam » Mon Jul 18, 2016 2:31 pm

The total of leads is 41495
ViciBox: 11 | VERSION: 2.14-897a BUILD: 230927-0857 | Clusters: 1 DB-WEB-ASTX | SSL | WebRTC | Wallboard | DNC Nightly Scrubber
iboam
 
Posts: 257
Joined: Mon Feb 08, 2016 2:35 pm

Re: DNC List

Postby williamconley » Mon Jul 18, 2016 2:34 pm

OK: That explains it a bit. Most rooms would have a couple million leads, and 50k in the DNC. You have 50k leads and a couple million in the DNC. Backwards but functional. But when you start to push up the leads to a few hundred K ... 8-)
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
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: DNC List

Postby iboam » Mon Jul 18, 2016 2:36 pm

Yes i used to have billions of leads but this a new server 8)
ViciBox: 11 | VERSION: 2.14-897a BUILD: 230927-0857 | Clusters: 1 DB-WEB-ASTX | SSL | WebRTC | Wallboard | DNC Nightly Scrubber
iboam
 
Posts: 257
Joined: Mon Feb 08, 2016 2:35 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 44 guests