Blog

How to export callbacks from ViCiDial

In order to export all callbacks (CBHOLD) from the entire dialer, please log into the MySQL and run the following query: SELECT * FROM `vicidial_list` WHERE `status`=’CBHOLD’ INTO OUTFILE ‘/var/www/html/vicidial/cbholds.zip’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘rn’ After that, navigate to http://your-dialer-addres/vicidial/cbholds.zip, download and rename the file from .ZIP to […]

How to export callbacks from ViCiDial Read More »

How to export leads with certain disposition only from ViCiDial / GoAutoDial using PHPMyAdmin

To export only leads with a specific disposition (in this example SALE) from only certain campaigns (in this example 1000, 2000), please log in to PHPMyAdmin and run the following SQL: select * from vicidial_list where status=”SALE” and list_id in (select list_id from vicidial_lists where campaign_id=1000 or campaign_id=2000) Click on the Export button on the bottom and

How to export leads with certain disposition only from ViCiDial / GoAutoDial using PHPMyAdmin Read More »

How to export all leads from specific certain cities from the entire database / dialer

Just run the following from your MySQL / MariaDB console: SELECT first_name,last_name,address1,city,postal_code,phone_number FROM vicidial_list WHERE list_id in (select list_id from vicidial_lists) and city in (‘X’,’Y’,’Z’) INTO OUTFILE ‘/tmp/cities.csv’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘n’

How to export all leads from specific certain cities from the entire database / dialer Read More »

Installing Fail2Ban on a CentOS server

If you are running a predictive dialer (or any kind of Asterisk server) or a web hosting server, you have probably experienced often hacker/lamer brute force attempts. These attacks can be easily blocked by implementing optimal server configuration, using a good Firewall (i.e. SonicWall, PfSense, Tomato) etc. A very useful method of blocking brute force attacks is installing Fail2Ban, which

Installing Fail2Ban on a CentOS server Read More »