Import bulk DNC using Mysql Workbench?
Posted: Mon May 06, 2019 9:05 amWe do have a lot DNC, is it possible to have a lot of DNC to be imported via the mysql Workbench app?
1) Yes. Very simple. We use phpMyAdmin instead, or mysql from the linux CLI. But any MySQL client will do.
2) Don't do it if you are loading a national DNC list or something similar. You'll overload your system. Vicidial is meant to have National DNC leads removed Before loading them into Vicidial. PoundTeam.com has an installable app for performing this task inside a Vicidial server (nightly NDNC check) to avoid "download, check, reupload" or anything similar. The app requires uploading your telemarketer.donotcall.gov ZIP files directly into an interface every 30 days and then washes your lists nightly against that data. It also blocks dialing lists until they have been checked and allows immediate check while on a BREAK since the checking of even only 50k leads agains 700M NDNC records ... is intensive.
If you're interested: http://catalog.poundteam.com/product_in ... cts_id=612
Alternately, of course, all you need to do is perform a 1:1 check for your leads against the NDNC nightly. They are in the "vicidial_list" table and the phone numbers are in a field named "phone_numbers". If you get a match: change "status" to "NDNC" from whatever it was and that lead will no longer be eligible to load into the hopper for dialing (since there is no NDNC in the status list of Vicidial to add to the "dial status" list of a campaign).