Creating a suppression list can be very useful when ordering new data / lists from data providers, helping you avoid purchasing duplicates.
To create a suppression list, login via SSH and run the following commands:
mysql -uroot -p
When prompted, enter your password. The default for GoAutoDial is vicidalnow, ViciBox – blank.use asterisk;
SELECT distinct phone_number INTO OUTFILE ‘/var/www/html/vicidial/suppression.zip’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\r\n’ FROM vicidial_list;
If you would like to create a suppression list for a single campaign only (in this example, campaign 1234, pelase run the following query instead:
SELECT distinct phone_number INTO OUTFILE ‘/var/www/html/vicidial/suppression.zip’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\r\n’ FROM vicidial_list WHERE list_id in (SELECT list_id from vicidial_lists WHERE campaign_id=1234);
When the command has finished, open your browser and navigate to http://your-dialer-ip/vicidial/suppression.zip and download the file.
Rename the file from .zip to .csv.