Predictive Dialers Los Angeles | ProDialers

Search Result

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

   Category: Dialer Tips/Predictive Dialer Tips

   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 ... Sunday, 09 July 2017

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

   Category: Dialer Tips/Predictive Dialer Tips

   ... 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 select the desired format ... Tuesday, 09 May 2017

3. Update all ViCiDial / GoAutoDial Passwords over SSH

   Category: Dialer Tips/Predictive Dialer Tips

   In order to change all phone and agent login passwords for ViCiDial / GoAutoDial over SSH, please use the following SQL query: update vicidial_users set pass='password123',phone_pass='password123' ... Monday, 08 May 2017

4. NEW! ViCiDial + WebRTC Integration

   Category: News/ProDialers

   Imagine using your ViCiDial dialer without the need to install, configure and constantly deal with softphones such as Zoiper, X-lite, Eyebeam and similar. As a custom service, ProDialers can integrate ... Monday, 25 July 2016

5. Updating all user and phone password in ViCiDial from the command line

   Category: Dialer Tips/Predictive Dialer Tips

   To simultaneously update all of the username and phone passwords in ViCiDial, please log in to your MySQL (or PhpMyAdmin, if available) and run the following SQL statements: UPDATE phones set pass='Your_Password',conf_secret='Your_Password' ... Sunday, 10 July 2016

6. Deleting ViCiDial list records with missing information

   Category: Dialer Tips/Predictive Dialer Tips

   ... You can permutate last with first or any other column: DELETE from vicidial_list WHERE list_id='123' AND last_name=''; To run a similar query which would delete all records with a certain string ... Tuesday, 05 July 2016

7. Exporting all Callbacks

   Category: Dialer Tips/Predictive Dialer Tips

   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' ... Thursday, 21 April 2016

8. Resetting only specific call statuses within a specific campaign

   Category: Dialer Tips/Predictive Dialer Tips

   ... callbacks and DNC): update vicidial_list set status='NEW' where list_id in (select list_id from vicidial_lists where campaign_id='4000') and status not in ('DNC','DNCL','CALLBK','CBHOLD','SALE');  ... Monday, 14 March 2016

9. Database Size and Deleting Logs

   Category: Dialer Tips/Predictive Dialer Tips

   ...  To check the size of the asterisk database only, you can run: du -kh /var/lib/mysql/asterisk To delete logs, run the command below: TRUNCATE `vicidial_user_log`;TRUNCATE `vicidial_monitor_log`;TRUNCATE ... Sunday, 21 February 2016

10. ViCiDial / GoAutoDial Suppression List

    Category: Dialer Tips/Predictive Dialer Tips

    ... 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' ... Friday, 19 February 2016

11. Monitor / Barge Problem on GoAutoDial 3.3 / ViCiDial

    Category: Dialer Tips/Predictive Dialer Tips

    GoAutoDial CE 3.3 monitoring and barge function do not work out of the box. To fix this, log in via SSH and run the following commands: For CentOs distros: yum install glibc.i686 -y For Ubuntu ... Friday, 19 February 2016

12. Updating to GoAdmin 3.3

    Category: Dialer Tips/Predictive Dialer Tips

    1. Append the goautodial-testing repo # nano /etc/yum.repos.d/goautodial.repo   2. Update Vicidial to 2.7RC1 # yum -y update Make sure to check the active version: # cat /usr/src/vicidial/version ... Monday, 03 March 2014

13. GoAdmin 3.3 "No Live Calls" Problem

    Category: Dialer Tips/Predictive Dialer Tips

    ... If so, please check the following: That you have updated your Asterisk to 1.8 That you have updated ViciDial to 2.7  ... Monday, 03 March 2014

14. Update GoAutoDial 2.1 CE to 3.0

    Category: Dialer Tips/Predictive Dialer Tips

    1. Backup your data Ideally, export your whole database   2. Check if your running version Your version GOautodial CE 2.1 and your MySQL password is the default "vicidialnow". # cat /etc/vicidialnow-release ... Monday, 03 March 2014

15. Resolving the problem "Extension not found" on ViCiDial

    Category: Dialer Tips/Predictive Dialer Tips

    ... the following command: delete from vicidial_list where length(phone_number)!=10 This will remove any rows from the vicidial_list table containing numbers which are shorter or longer than 10 characters, ... Friday, 14 February 2014

16. Trademarks

    Category: Uncategorised Content

    ProDialers is owned and operated by De Mus, Inc., 3151 Cahuenga Blvd. #244, Los Angeles, CA 90068, USA. All other trademarks (Dell®, GoAutoDial®, ViciDial® etc.) are the property of their respective owners. ... Tuesday, 03 April 2012