vicidial.org

in scratch installation there is subphase 6.6 when adding test leads to the vicidial database.
there are e delimited file of leads placed in the /usr /share/astguiclient/vicidial/lead_in/ directory .......
i not find this delimited file, how can i create it and why.
other think i create a leads in mysql database but when i make http://my @ ip/agc/vicidial.php i have this message "Sorry, there are no leads in the hopper for this campaign " where is the error please thanks

A lead is a customer information record. The Lead Loader can be used to import records to VICIDIAL from a Leads file.

A Leads file is a text-based file that is pipe-delimited or tab-delimited. The following fields must be present in a Leads file and is displayed in the order it should appear in the Leads file.

Code: Select all

1   Vendor Lead Code (Vendor ID)
2   Source ID (internal use)
3   List ID (ID of the list into which the leads will be imported to)   
4   Phone Code (prefix for phone numbers, e.g. 1 for US, 44 for UK, etc.
5   Phone Number
6   Title (E.g. Mr., Ms., Mrs, etc.)
7   First Name
8   Middle Initial
9   Last Name
10   Address Line 1
11   Address Line 2
12   Address Line 3
13   City
14   State
15   Province
16   Postal Code
17   Country Code
18   Gender   “M” / “F”
19   Date of Birth (YYYY-MM-DD)
20   Alternate Phone
21   Email Address
22   Security Phrase
23   Comments


The following is a sample record extracted from a Leads file:

Code: Select all

100100|10100|999|09|0121231234|Mr|John||Doe|1 Short Street|Brooklyn||Pretoria||Gauteng|0012|ZA|M|1980-06-15|0121231235|JohnDoe@Email.com|nothing|Comments


Multiple records can be stored into a Leads file using new lines to separate the records.

Phone numbers like “(012) 441-1700” will automatically be converted to digit-only numbers like “0124411700”.

To use VICIDIAL’s Leads Loader:
STEP 1: Click on the LISTS tab in VICIDIAL ADMIN
STEP 2: Click on the “LOAD NEW LEADS” link.
STEP 3: Click on the “Browse…” button and select the Leads file to import.
STEP 4: Optionally enter the List ID of the VICIDIAL list into which the leads must be imported. Leave this field blank to use the Leads File’s List ID field.
STEP 5: Select a “Lead Duplicate Check” option. This specifies how VICIDIAL should handle duplicate Leads.
STEP 6: Select a “Lead Timezone Lookup” option.
STEP 7: Click on the SUBMIT button.
The “START OVER” button will reset the fields and allow another Leads File to be imported.

i have this message "Sorry, there are no leads in the hopper for this campaign " where is the error please thanks

Check the following:
- Are at least one list assigned to the current campaign?
- Does this list contain any leads?
- What are the statuses of these leads in the list? Does it match with the “Dial statuses” of the campaign?
- In the “Detail View” of the VICIDIAL ADMIN campaign screen: Are the LEAD RECYCLING (at the bottom of the page) configured correctly?
- Is the “Hopper Level” high enough?
- Did you attempt a “Force Reset of Hopper”?
- Did you attempt a “Reset Lead-Called-Status for this list” on the campaign’s list (VICIDIAL ADMIN List screen)?
- If your campaign do not need to dial a list, create a campaign that’s name starts with “CLOSER”, for example CLOSER0, CLOSERabc, CLOSER_01 etc.

Hi,

you need to load leads from the vicidal campaign. create lists and upload the leads. please take note the format.

hakimabouchaib

Next time please give it a proper topic description.

For your problem have you read the Manager's Manual that can be purchased and downloaded at http://www.eflo.net?

also when you installed VICIDIAL if you followed the scratch install on the mysql part you need to create a list on the manager's interface and if I remember correctly you need to create a list id 101. so that list id can associate with the sample list that was created when you followed the scratch install.

caspar wrote:A lead is a customer information record. The Lead Loader can be used to import records to VICIDIAL from a Leads file.

A Leads file is a text-based file that is pipe-delimited or tab-delimited. The following fields must be present in a Leads file and is displayed in the order it should appear in the Leads file.

Code: Select all

1   Vendor Lead Code (Vendor ID)
2   Source ID (internal use)
3   List ID (ID of the list into which the leads will be imported to)   
4   Phone Code (prefix for phone numbers, e.g. 1 for US, 44 for UK, etc.
5   Phone Number
6   Title (E.g. Mr., Ms., Mrs, etc.)
7   First Name
8   Middle Initial
9   Last Name
10   Address Line 1
11   Address Line 2
12   Address Line 3
13   City
14   State
15   Province
16   Postal Code
17   Country Code
18   Gender   “M” / “F”
19   Date of Birth (YYYY-MM-DD)
20   Alternate Phone
21   Email Address
22   Security Phrase
23   Comments


The following is a sample record extracted from a Leads file:

Code: Select all

100100|10100|999|09|0121231234|Mr|John||Doe|1 Short Street|Brooklyn||Pretoria||Gauteng|0012|ZA|M|1980-06-15|0121231235|JohnDoe@Email.com|nothing|Comments


Multiple records can be stored into a Leads file using new lines to separate the records.

Phone numbers like “(012) 441-1700” will automatically be converted to digit-only numbers like “0124411700”.

To use VICIDIAL’s Leads Loader:
STEP 1: Click on the LISTS tab in VICIDIAL ADMIN
STEP 2: Click on the “LOAD NEW LEADS” link.
STEP 3: Click on the “Browse…” button and select the Leads file to import.
STEP 4: Optionally enter the List ID of the VICIDIAL list into which the leads must be imported. Leave this field blank to use the Leads File’s List ID field.
STEP 5: Select a “Lead Duplicate Check” option. This specifies how VICIDIAL should handle duplicate Leads.
STEP 6: Select a “Lead Timezone Lookup” option.
STEP 7: Click on the SUBMIT button.
The “START OVER” button will reset the fields and allow another Leads File to be imported.

hi, thank you
i read steps that you are give to me
step 1 and 2 is it ok but step 3 i not find file to import??

there are list but it not contain any leads!!!

You are suppose to create the Leads file yourself, based on the customer information you want to import. See my previous post for the format of this file or download the manual.

caspar wrote:You are suppose to create the Leads file yourself, based on the customer information you want to import. See my previous post for the format of this file or download the manual.

i have another problem that i can't find solution , when i have made cron in crontab i have a message /usr/bin/perl: symbol lookup error:/usr/lib/perl5/site_perl/5.8.7/i486_linux/auto/DBD/mysql/mysql.so:undefined symbol: mysql_serverr_init what is the error

Looks like you don't have DBD::mysql installed through cpan for the version of perl you are using.

are at least one list assigned to the current campaign?"
yes , there are
"does this list contain any leads?"
yes there leads in the list
"what are the statuses of thees leads in the list ?"
the status is new
is the "hopper level hight enough?
yes
did you attemp a force reset of hopper
no
did you attemp a "reset lead called status for this list"
no

hello, there are something wrong with the hopper loading script i think taht are relation with crontab !!!!!!!!! where is the problem

Seems like the server is not running

first check the status of mysql service by the following command

"service mysql status"

If service not running then to start it run the command

"service mysql start"

Then check again. Should sort out the problem. If not then state the next error.

i make "mysql start "
i have teh message
"mysql:error while loqding shared libreries:libmysqlclient.so.14 cannot open shared objet file: no such file or directory"

Hi,

there is a problem with MySQL installation...

you need to reinstall it...

i want to reinstalle mysql but i would delete the last mysql ????

You might want to backup your database first:

Code: Select all

/usr/local/mysql/bin/mysqldump --lock-tables --flush-logs asterisk | gzip > /root/DB_asterisk.gz

i want to backup my database but after this opertaion i want to delete mysql can you help how to delete it???

there are not another solution for my problem without detelte mysql!!!!

1) have you followed what we have been telling you what to do?

2) Have you ever read this?

http://www.eflo.net/VICIDIALforum/viewtopic.php?t=443

I highly suggest you read that first.

not that I dont want to help about your questions.

its just that you have to learn how to ask.

Op3r wrote:1) have you followed what we have been telling you what to do?

2) Have you ever read this?

http://www.eflo.net/VICIDIALforum/viewtopic.php?t=443

I highly suggest you read that first.

not that I dont want to help about your questions.

its just that you have to learn how to ask.

thanks a lot for your help , i have read http://www.eflo.net/VICIDIALforum/viewtopic.php?t=443 and i will make all my effort to respect all recommandation !!!

hello , i have this message when i added

### updater for vicidial hopper
* * * * * /usr/share/astguiclient/AST_VDhopper.pl -q


New mail for root@localhost has arrived:

----
From: root@localhost.pitek
Subject: cron: /usr/share/astguiclient/AST_VDhopper.pl -q
/usr/bin/perl: symbol lookup error: /usr/lib/perl5/site_perl/5.8.7/i486-linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_server_init

Hi

is the Mysql and DBI and DBD install perfectly ?

ram

ramindia wrote:Hi

is the Mysql and DBI and DBD install perfectly ?

ram

maybe the problem is in installation of mysql because i installed it several times !!!

hakimabouchaib wrote:

ramindia wrote:Hi

is the Mysql and DBI and DBD install perfectly ?

ram

maybe the problem is in installation of mysql because i installed it several times !!!

i have this when i make perl -MCPAN -e shell
root@localhost:~# perl -MCPAN -e shell
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_COLLATE = "C",
LANG = "en_US"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
CPAN: File::HomeDir loaded ok
Sorry, we have to rerun the configuration dialog for CPAN.pm due to
the following indispensable but missing parameters:

mbuild_arg, mbuild_install_arg, mbuild_install_build_command, mbuildpl_arg


The next questions deal with Module::Build support.

A Build.PL is run by perl in a separate process. Likewise we run
'./Build' and './Build install' in separate processes. If you have any
parameters you want to pass to the calls, please specify them here.

Parameters for the 'perl Build.PL' command?
Typical frequently used settings:

--install_base /home/xxx # different installation directory

Your choice: []

what distro
you are using
check the perl installation ?

ram