Op3r

A lot of people doesn’t have any clue about predictive dialer. VICIDIAL is now a predictive dialer too. It has algorithms to do just that.

I took a liberty of lifting the wikipedia article on Predictive dialer.

Here’s The full article.

Predictive dialer
From Wikipedia, the free encyclopedia
Jump to: navigation, search

A predictive dialer is a computerized system that automatically dials batches of telephone numbers for connection to agents assigned to sales or other campaigns. Predictive dialers are widely used in call centers.

More…

You probably have a lot of logs and uploaded a lot of leads when using VICIDIAL. Then all of a sudden your you had a power outage or VICIDIAL is suddenly acting strange. Or you got your database corrupted. What to do?

It’s easy!

We repair and optimize the VICIDIAL mysql database! Here’s how.

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

Now it will ask you for a password, if you are using vicidialNOW the default root password is vicidialnow. If you are using vicibox, the password is the one you have set. For everything else, you are on your own.

Ok so you have lost your Web Admin manager’s password and you can’t login to the VICIDIAL web admin anymore. Don’t fret here’s how.

Login to your mysql database.

mysql -ucron -p1234 asterisk

Once in, you search for it like this

mysql> select * from vicidial_users where user='admin';

It will output this
+---------+-------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+
| user_id | user | pass | full_name | user_level | user_group | phone_login | phone_pass | delete_users | delete_user_groups | delete_lists | delete_campaigns | delete_ingroups | delete_remote_agents | load_leads | campaign_detail | ast_admin_access | ast_delete_phones | delete_scripts | modify_leads | hotkeys_active | change_agent_campaign | agent_choose_ingroups | closer_campaigns | scheduled_callbacks | agentonly_callbacks | agentcall_manual | vicidial_recording | vicidial_transfers | delete_filters | alter_agent_interface_options | closer_default_blended | delete_call_times | modify_call_times | modify_users | modify_campaigns | modify_lists | modify_scripts | modify_filters | modify_ingroups | modify_usergroups | modify_remoteagents | modify_servers | view_reports | vicidial_recording_override | alter_custdata_override | qc_enabled | qc_user_level | qc_pass | qc_finish | qc_commit | add_timeclock_log | modify_timeclock_log | delete_timeclock_log | alter_custphone_override | vdc_agent_api_access | modify_inbound_dids | delete_inbound_dids |
+---------+-------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+
| 1 | admin | vicidialnow | Admin | 9 | ADMIN | NULL | NULL | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | NULL | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | DISABLED | NOT_ACTIVE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | NOT_ACTIVE | 0 | 0 | 0 |
+---------+-------+-------------+-----------+------------+------------+-------------+------------+--------------+--------------------+--------------+------------------+-----------------+----------------------+------------+-----------------+------------------+-------------------+----------------+--------------+----------------+-----------------------+-----------------------+------------------+---------------------+---------------------+------------------+--------------------+--------------------+----------------+-------------------------------+------------------------+-------------------+-------------------+--------------+------------------+--------------+----------------+----------------+-----------------+-------------------+---------------------+----------------+--------------+-----------------------------+-------------------------+------------+---------------+---------+-----------+-----------+-------------------+----------------------+----------------------+--------------------------+----------------------+---------------------+---------------------+
1 row in set (0.00 sec)


There you go!

Enjoy.

Ok so you are pretty stucked with a 2.0.4 version of VICIDIAL. You want something new and shiny Predictive Dialer for your center. Here’s how.

First let’s download VICIDIAL 2.0.5 rc2. This is the latest VICIDIAL version. Let’s do this.

Create a directory for your new VICIDIAL install.

Then let’s download VICIDIAL.

wget http://downloads.sourceforge.net/sourceforge/astguiclient/astguiclient_2.0.5.1rc1.zip?use_mirror=nchc

Unzip it
unzip astguiclient astguiclient_2.0.5.1rc1.zip

Before we do anything let’s back up our asterisk folder!

tar cvf asterisk.backup.tar /etc/asterisk

Due to recent changes in the database we also need to back up our mysql database in case something went really wrong. This will backup all your VICIDIAL database and non VICIDIAL databases.

mysqldump --all-databases> alldatabases.sql

For more hardcore and you are feeling hardcore, you can go get the mysql var folder and just save it to another computer.

Now we are almost ready right? But not yet. Let’s install the cpan module added also.

perl -MCPAN -e shell

Install Switch
install Switch

Ok so we now have the the Switch perl module let’s upgrade the database

mysql
use asterisk
\. /thelocation/oftheastguiclientfolder/extras/upgrade_2.0.5.sql

This will take some time if you are using VICIDIAL long enough to accumulate a lot of logs and loaded a lot of leads. After it’s done type quit.

Ok so we have upgrade VICIDIAL database now. Let’s try to upgrade VICIDIAL now.

perl install.pl‘

Press enter to the questions. Then that’s it! you now have upgraded your VICIDIAL 2.0.4 to VICIDIAL 2.0.5.

Remember to get the Manual from www.eflo.net/store.php and read it before asking a lot of questions!

If you need help, Im available for consulting too. Just click on the contact button of my blog.