How to create a ViCiDial Suppression List

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.