Search

Search Keyword vicidial Total: 16 results found.

Search Again

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

Search Again

Search Parameters

Search Only: