List Loader reports no permission to load in version 1.1.12

[D]

When we first configured ViciDial, we were able to access the Lead Loader page using the admin id but after restarting the server we are unable to do it. Its giving a message saying - You do not have permissions to load leads. What could be causing that and how do we fix it? Thanks

http://xx.xxx.xxx.xx/vicidial/listloaderMAIN.php

edited by kchung for more detailed subject line

[mflorell]

Check the permissions in the vicidial_users table for the user you logged into the admin.php page under.

[D]

Got it, thanks. For some reason the same id that we had used earlier stopped working on this page...created a new admin id and it is working.

By the way, how do we upload data from the command line? Are there instructions for that? What steps should we follow. Don't recall seeing those in Scratch Install.

Appreciate your feedback.

[mflorell]

The VICIDIAL_IN_new_leads_file.pl script should be located in /usr/share/astguiclient in default 2.0.1b2 installations.

For more information about it run it with the "--help" flag:

perl VICIDIAL_IN_new_leads_file.pl --help

[D]

We found the VICIDIAL_IN_new_leads_file.pl script in:

1. /home/cron/astguiclient/VICIDIAL_IN_new_leads_file.pl

2. /home/cron/VICIDIAL_IN_new_leads_file.pl

Couldn't find it in /usr/share/astguiclient.

We are unable to run it with the "--help" flag in all 3 locations(we are using 1.1.12). Where do we run this:

perl VICIDIAL_IN_new_leads_file.pl --help


Thanks

[mflorell]

Sorry, that was information for the 2.0 tree of VICIDIAL.

The 1.1.12 version doesn't have as many options. It only takes a pipe-delimited file in the vicidial lead format and you must place that file in the LEADS_IN directory in order to have it loaded.

[D]

We have already installed the 1.1.12 version. Can we replace that with the 2.0 tree of VICIDIAL without causing too many problems? If we change the versions - where all would we have to make changes?

Thanks

[mflorell]

There is an UPGRADE document in the release that you can read to see what you need to do to UPGRADE to 2.0.1. You should also at least read through the BASE_INSTALL document as well.

basically:
- Net::MySQL is replaced with DBI/DBD::mysql
- you can configure paths in 2.0 tree
- AST_SERVER_conf.pl is gone
- install.pl is interactive configuration/installation script
- new universal config file /etc/astguiclient.conf is created by install.pl

[D]

How do we find out the List ID or do we assign it during data upload. If we assign it - where do we assign it?

We want to upload a pipe-delimited file in the vicidial lead format would like place that file in the LEADS_IN directory in order to have it loaded.

Thanks

[mflorell]

It is part of the data format.
1. Vendor Lead Code - shows up in the Vendor ID field of the GUI
2. Source Code - internal use only for admins and DBAs
3. List ID - the list number that these leads will show up under
4. Phone Code - the prefix for the phone number - 1 for US
5. Phone Number - must be at least 8 digits long
6. Title - title of the customer - 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 - limited to 2 characters
15. Province
16. Postal Code
17. Country
18. Gender
19. Date of Birth
20. Alternate Phone Number
21. Email Address
22. Security Phrase
23. Comments

In the 2.0 tree you can assign it in the command line flag for the script.

[D]

Thanks. Can we assign a list id when we upload data in the 1.1.12 - prior to the upload? Or does it automatically assign one?

[mflorell]

You need to put it in the data file in the 1.1.12 release. If you do not put one in, it will be blank in the database.

[D]

Ok...just so that I understand this correctly - We will assign and enter a List ID in the data file that we want to upload in the 1.1.12 release?

Thanks

[mflorell]

yes.

That will also work in 2.0 versions, but it is usually easier to do that when loading in the 2.0 version.

[D]

Thanks...we did that but for some reason I don't know if the leads got uploaded. We see the List ID in ViciDial Admin but it says zero leads. Is there a way to confirm that the data was uploaded correctly in correct format. Is there a way to make sure that the fields match and upload is doing correctly in the pipe-delimited file format?

Thanks again for your feedback.

[mflorell]

select * from vicidial_list order by lead_id desc limit 10;
[/code]

[D]

Below is the output of the command mentioned by you:


select * from vicidial_list order by lead_id desc limit 10; in
asterisk datadase


mysql> use asterisk;
Database changed
mysql> select * from vicidial_list order by lead_id desc limit 10;
+---------+---------------------+----------------+--------+------+------------------+-----------+---------+----------------+-------------------------+------------+--------------+-------+------------+----------------+-----------+-----------------+----------+----------+--------+-------+----------+-------------+--------------+--------+---------------+------------+---------------+-----------------+----------+--------------+
| lead_id | entry_date | modify_date | status | user |
vendor_lead_code | source_id | list_id | gmt_offset_now |
called_since_last_reset | phone_code | phone_number | title |
first_name | middle_initial | last_name | address1 | address2 |
address3 | city | state | province | postal_code | country_code |
gender | date_of_birth | alt_phone | email | security_phrase
| comments | called_count |
+---------+---------------------+----------------+--------+------+------------------+-----------+---------+----------------+-------------------------+------------+--------------+-------+------------+----------------+-----------+-----------------+----------+----------+--------+-------+----------+-------------+--------------+--------+---------------+------------+---------------+-----------------+----------+--------------+
| 29 | 2006-09-12 20:52:31 | 00000000000000 | NEW | |
100013 | 10013 | 107 | -4.00 | N
| 1 | 7275551213 | MR | I | P
| FREELY13 | 249 MUNDON ROAD | | | MALDON |
FL | | 33709 | | M | 1970-01-01
| 7275551212 | test@test.com | nothing | COMMENTS |
0 |
| 28 | 2006-09-12 20:52:31 | 00000000000000 | NEW | |
100012 | 10012 | 107 | -4.00 | N
| 1 | 7275551213 | MR | I | P
| FREELY12 | 249 MUNDON ROAD | | | MALDON |
FL | | 33709 | | M | 1970-01-01
| 7275551212 | test@test.com | nothing | COMMENTS |
0 |
| 27 | 2006-09-12 20:52:31 | 00000000000000 | NEW | |
100011 | 10011 | 107 | -4.00 | N
| 1 | 7275551213 | MR | I | P
| FREELY11 | 249 MUNDON ROAD | | | MALDON |
FL | | 33709 | | M | 1970-01-01
| 7275551212 | test@test.com | nothing | COMMENTS |
0 |
| 26 | 2006-09-12 20:52:31 | 00000000000000 | NEW | |
100013 | 10013 | 107 | -4.00 | N
| 1 | 7275551213 | MR | I | P
| FREELY13 | 249 MUNDON ROAD | | | MALDON |
FL | | 33709 | | M | 1970-01-01
| 7275551212 | test@test.com | nothing | COMMENTS |
0 |
| 25 | 2006-09-12 20:52:31 | 00000000000000 | NEW | |
100012 | 10012 | 107 | -4.00 | N
| 1 | 7275551213 | MR | I | P
| FREELY12 | 249 MUNDON ROAD | | | MALDON |
FL | | 33709 | | M | 1970-01-01
| 7275551212 | test@test.com | nothing | COMMENTS |
0 |
| 24 | 2006-09-12 20:52:31 | 00000000000000 | NEW | |
100011 | 10011 | 107 | -4.00 | N
| 1 | 7275551213 | MR | I | P
| FREELY11 | 249 MUNDON ROAD | | | MALDON |
FL | | 33709 | | M | 1970-01-01
| 7275551212 | test@test.com | nothing | COMMENTS |
0 |
| 23 | 2006-09-12 20:52:31 | 00000000000000 | NEW | |
100010 | 10010 | 107 | -4.00 | N
| 1 | 7275551213 | MR | I | P
| FREELY10 | 249 MUNDON ROAD | | | MALDON |
FL | | 33709 | | M | 1970-01-01
| 7275551212 | test@test.com | nothing | COMMENTS |
0 |
| 22 | 2006-09-12 20:52:31 | 00000000000000 | NEW | |
100009 | 10009 | 107 | -4.00 | N
| 1 | 7275551213 | MR | I | P
| FREELY09 | 249 MUNDON ROAD | | | MALDON |
FL | | 33709 | | M | 1970-01-01
| 7275551212 | test@test.com | nothing | COMMENTS |
0 |
| 21 | 2006-09-12 20:52:31 | 00000000000000 | NEW | |
100008 | 10008 | 107 | -4.00 | N
| 1 | 7275551213 | MR | I | P
| FREELY08 | 249 MUNDON ROAD | | | MALDON |
FL | | 33709 | | M | 1970-01-01
| 7275551212 | test@test.com | nothing | COMMENTS |
0 |
| 20 | 2006-09-12 20:52:31 | 00000000000000 | NEW | |
100007 | 10007 | 107 | -4.00 | N
| 1 | 7275551213 | MR | I | P
| FREELY07 | 249 MUNDON ROAD | | | MALDON |
FL | | 33709 | | M | 1970-01-01
| 7275551212 | test@test.com | nothing | COMMENTS |
0 |
+---------+---------------------+----------------+--------+------+------------------+-----------+---------+----------------+-------------------------+------------+--------------+-------+------------+----------------+-----------+-----------------+----------+----------+--------+-------+----------+-------------+--------------+--------+---------------+------------+---------------+-----------------+----------+--------------+
10 rows in set (0.07 sec)

mysql> [/code]select * from vicidial_list order by lead_id desc limit 10;
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near '[/code]select * from vicidial_list order by lead_id desc
limit
mysql> [/code

[mflorell]

These leads seem to be under list_id 107.

Do you have other leads that you have loaded in here under a different list_id?

Have you created a list 107 in your admin screen?

[D]

Yes we created a list id of 107 and uploaded the sample test .txt file that is mentioned in Scratch Install to see if that would upload.

It shows on the ViciDial admin page as 26 leads to be dialed BUT says that there are Zero leads in the Hopper? I even set the hopper level at 1000 this time. When do the leads actually come in the Hopper?

We also have uploaded 2 other lists under list ids 102 and 104 respectively. One has 7 leads and the other one has around 800 leads. Please advice.

[mflorell]

leads go into the hopper when the AST_VDhopper.pl script is run every minute(if your crontab is configured properly)

When it runs it takes the active campaigns and looks for the active lists and the leads in those lists to grab within the calling time and then it will insert them into the hopper to be dialed.

[D]

How do we check and ensure that our crontab is configured properly. Which command do we run?

Thanks again.

[mflorell]

crontab -l will print out your crontab. just make sure that the AST_VDhopper.pl script is being run every minute.

Also, you could try running it manually with the --debug flag to see what it is doing.

[D]

Thanks. Please advice - Below is the output that I am getting when I run (it says - ERROR CANNOT ADD ANY NEW LEADS TO HOPPER): /home/cron/astguiclient/AST_VDhopper.pl --debugX


root@phone:~# /home/cron/astguiclient/AST_VDhopper.pl --debugX

----- DEBUG -----


----- SUPER DEBUG -----

TIME DEBUG: ||0| GMT: 19:54
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where
callback_time <= '2006-09-14 19:54:21' and status='ACTIVE';|

|GMT-DAY-HOUR|
|13.00-5-854||12.75-5-839||12.50-5-824||12.25-5-809||12.00-5-754||11.75-5-739||11.50-5-724||11.25-5-709||11.00-5-654||10.75-5-639||10.50-5-624||10.25-5-609||10.00-5-554||9.75-5-539||9.50-5-524||9.25-5-509||9.00-5-454||8.75-5-439||8.50-5-424||8.25-5-409||8.00-5-354||7.75-5-339||7.50-5-324||7.25-5-309||7.00-5-254||6.75-5-239||6.50-5-224||6.25-5-209||6.00-5-154||5.75-5-139||5.50-5-124||5.25-5-109||5.00-5-54||4.75-5-39||4.50-5-24||4.25-5-9||4.00-4-2354||3.75-4-2339||3.50-4-2324||3.25-4-2309||3.00-4-2254||2.75-4-2239||2.50-4-2224||2.25-4-2209||2.00-4-2154||1.75-4-2139||1.50-4-2124||1.25-4-2109||1.00-4-2054||0.75-4-2039||0.50-4-2024||0.25-4-2009||0.00-4-1954||-0.25-4-1939||-0.50-4-1924||-0.75-4-1909||-1.00-4-1854||-1.25-4-1839||-1.50-4-1824||-1.75-4-1809||-2.00-4-1754||-2.25-4-1739||-2.50-4-1724||-2.75-4-1709||-3.00-4-1654||-3.25-4-1639||-3.50-4-1624||-3.75-4-1609||-4.00-4-1554||-4.25-4-1539||-4.50-4-1524||-4.75-4-1509||-5.00-4-1454||-5.25-4-1439||-5.50-4-1424||-5.75-4-1409||-6.00-4-1354||-6.25-4-1339||-6.50-4-1324||-6.75-4-1309||-7.00-4-1254||-7.25-4-1239||-7.50-4-1224||-7.75-4-1209||-8.00-4-1154||-8.25-4-1139||-8.50-4-1124||-8.75-4-1109||-9.00-4-1054||-9.25-4-1039||-9.50-4-1024||-9.75-4-1009||-10.00-4-954||-10.25-4-939||-10.50-4-924||-10.75-4-909||-11.00-4-854||-11.25-4-839||-11.50-4-824||-11.75-4-809||-12.00-4-754||-12.25-4-739||-12.50-4-724||-12.75-4-709|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for western campaign- GMT: 24hours HOPPER: 1000
hopper DONE cleared: 0
|DELETE from vicidial_hopper where campaign_id='western' and
status IN('DONE');|
hopper GMT BAD cleared: 0
|DELETE from vicidial_hopper where campaign_id='western' and
((gmt_offset_now IN('99') ) );|
hopper READY count: 26
|SELECT count(*) from vicidial_hopper where campaign_id='western'
and status='READY';|
hopper too low (26|1000) starting hopper dump
campaign lists count: 2 | '104','107'
|SELECT list_id FROM vicidial_lists where campaign_id='western'
and active='Y';|
no lead filter defined for campaign: western
|NONE|
|SELECT count(*) FROM vicidial_list where
called_since_last_reset='N' and status IN('NEW','','','','') and
list_id IN('104','107') and ((gmt_offset_now
IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99')
) ) ;|
leads to call count: 26
|SELECT count(*) FROM vicidial_list where
called_since_last_reset='N' and status IN('NEW','','','','') and
list_id IN('104','107') and ((gmt_offset_now
IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99')
) ) ;|
ERROR CANNOT ADD ANY NEW LEADS TO HOPPER
Getting Leads to add to hopper
|SELECT lead_id FROM vicidial_hopper where campaign_id='western';|
lead call order: order by lead_id asc
|SELECT lead_id,list_id,gmt_offset_now,phone_number,state FROM
vicidial_list where called_since_last_reset='N' and status
IN('NEW','','','','') and list_id IN('104','107') and lead_id NOT
IN('4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','0')
and ((gmt_offset_now
IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99')
) ) order by lead_id asc limit 1000;|
Adding to hopper: 0
DONE with this campaign

|GMT-DAY-HOUR|
|13.00-5-854||12.75-5-839||12.50-5-824||12.25-5-809||12.00-5-754||11.75-5-739||11.50-5-724||11.25-5-709||11.00-5-654||10.75-5-639||10.50-5-624||10.25-5-609||10.00-5-554||9.75-5-539||9.50-5-524||9.25-5-509||9.00-5-454||8.75-5-439||8.50-5-424||8.25-5-409||8.00-5-354||7.75-5-339||7.50-5-324||7.25-5-309||7.00-5-254||6.75-5-239||6.50-5-224||6.25-5-209||6.00-5-154||5.75-5-139||5.50-5-124||5.25-5-109||5.00-5-54||4.75-5-39||4.50-5-24||4.25-5-9||4.00-4-2354||3.75-4-2339||3.50-4-2324||3.25-4-2309||3.00-4-2254||2.75-4-2239||2.50-4-2224||2.25-4-2209||2.00-4-2154||1.75-4-2139||1.50-4-2124||1.25-4-2109||1.00-4-2054||0.75-4-2039||0.50-4-2024||0.25-4-2009||0.00-4-1954||-0.25-4-1939||-0.50-4-1924||-0.75-4-1909||-1.00-4-1854||-1.25-4-1839||-1.50-4-1824||-1.75-4-1809||-2.00-4-1754||-2.25-4-1739||-2.50-4-1724||-2.75-4-1709||-3.00-4-1654||-3.25-4-1639||-3.50-4-1624||-3.75-4-1609||-4.00-4-1554||-4.25-4-1539||-4.50-4-1524||-4.75-4-1509||-5.00-4-1454||-5.25-4-1439||-5.50-4-1424||-5.75-4-1409||-6.00-4-1354||-6.25-4-1339||-6.50-4-1324||-6.75-4-1309||-7.00-4-1254||-7.25-4-1239||-7.50-4-1224||-7.75-4-1209||-8.00-4-1154||-8.25-4-1139||-8.50-4-1124||-8.75-4-1109||-9.00-4-1054||-9.25-4-1039||-9.50-4-1024||-9.75-4-1009||-10.00-4-954||-10.25-4-939||-10.50-4-924||-10.75-4-909||-11.00-4-854||-11.25-4-839||-11.50-4-824||-11.75-4-809||-12.00-4-754||-12.25-4-739||-12.50-4-724||-12.75-4-709|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for Test campaign- GMT: 24hours HOPPER: 1
hopper DONE cleared: 0
|DELETE from vicidial_hopper where campaign_id='Test' and status
IN('DONE');|
hopper GMT BAD cleared: 0
|DELETE from vicidial_hopper where campaign_id='Test' and
((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='Test'
and status='READY';|
hopper too low (0|1) starting hopper dump
campaign lists count: 0 |
|SELECT list_id FROM vicidial_lists where campaign_id='Test' and
active='Y';|
no lead filter defined for campaign: Test
|NONE|
|SELECT count(*) FROM vicidial_list where
called_since_last_reset='N' and status IN('NEW','','','','') and
list_id IN() and ((gmt_offset_now
IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99')
) ) ;|
ERROR CANNOT ADD ANY NEW LEADS TO HOPPER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR|
|13.00-5-854||12.75-5-839||12.50-5-824||12.25-5-809||12.00-5-754||11.75-5-739||11.50-5-724||11.25-5-709||11.00-5-654||10.75-5-639||10.50-5-624||10.25-5-609||10.00-5-554||9.75-5-539||9.50-5-524||9.25-5-509||9.00-5-454||8.75-5-439||8.50-5-424||8.25-5-409||8.00-5-354||7.75-5-339||7.50-5-324||7.25-5-309||7.00-5-254||6.75-5-239||6.50-5-224||6.25-5-209||6.00-5-154||5.75-5-139||5.50-5-124||5.25-5-109||5.00-5-54||4.75-5-39||4.50-5-24||4.25-5-9||4.00-4-2354||3.75-4-2339||3.50-4-2324||3.25-4-2309||3.00-4-2254||2.75-4-2239||2.50-4-2224||2.25-4-2209||2.00-4-2154||1.75-4-2139||1.50-4-2124||1.25-4-2109||1.00-4-2054||0.75-4-2039||0.50-4-2024||0.25-4-2009||0.00-4-1954||-0.25-4-1939||-0.50-4-1924||-0.75-4-1909||-1.00-4-1854||-1.25-4-1839||-1.50-4-1824||-1.75-4-1809||-2.00-4-1754||-2.25-4-1739||-2.50-4-1724||-2.75-4-1709||-3.00-4-1654||-3.25-4-1639||-3.50-4-1624||-3.75-4-1609||-4.00-4-1554||-4.25-4-1539||-4.50-4-1524||-4.75-4-1509||-5.00-4-1454||-5.25-4-1439||-5.50-4-1424||-5.75-4-1409||-6.00-4-1354||-6.25-4-1339||-6.50-4-1324||-6.75-4-1309||-7.00-4-1254||-7.25-4-1239||-7.50-4-1224||-7.75-4-1209||-8.00-4-1154||-8.25-4-1139||-8.50-4-1124||-8.75-4-1109||-9.00-4-1054||-9.25-4-1039||-9.50-4-1024||-9.75-4-1009||-10.00-4-954||-10.25-4-939||-10.50-4-924||-10.75-4-909||-11.00-4-854||-11.25-4-839||-11.50-4-824||-11.75-4-809||-12.00-4-754||-12.25-4-739||-12.50-4-724||-12.75-4-709|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for TestCamp campaign- GMT: 24hours HOPPER: 1
hopper DONE cleared: 0
|DELETE from vicidial_hopper where campaign_id='TestCamp' and
status IN('DONE');|
hopper GMT BAD cleared: 0
|DELETE from vicidial_hopper where campaign_id='TestCamp' and
((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where
campaign_id='TestCamp' and status='READY';|
hopper too low (0|1) starting hopper dump
campaign lists count: 0 |
|SELECT list_id FROM vicidial_lists where campaign_id='TestCamp'
and active='Y';|
no lead filter defined for campaign: TestCamp
|NONE|
|SELECT count(*) FROM vicidial_list where
called_since_last_reset='N' and status IN('NEW','','','','') and
list_id IN() and ((gmt_offset_now
IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99')
) ) ;|
ERROR CANNOT ADD ANY NEW LEADS TO HOPPER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR|
|13.00-5-854||12.75-5-839||12.50-5-824||12.25-5-809||12.00-5-754||11.75-5-739||11.50-5-724||11.25-5-709||11.00-5-654||10.75-5-639||10.50-5-624||10.25-5-609||10.00-5-554||9.75-5-539||9.50-5-524||9.25-5-509||9.00-5-454||8.75-5-439||8.50-5-424||8.25-5-409||8.00-5-354||7.75-5-339||7.50-5-324||7.25-5-309||7.00-5-254||6.75-5-239||6.50-5-224||6.25-5-209||6.00-5-154||5.75-5-139||5.50-5-124||5.25-5-109||5.00-5-54||4.75-5-39||4.50-5-24||4.25-5-9||4.00-4-2354||3.75-4-2339||3.50-4-2324||3.25-4-2309||3.00-4-2254||2.75-4-2239||2.50-4-2224||2.25-4-2209||2.00-4-2154||1.75-4-2139||1.50-4-2124||1.25-4-2109||1.00-4-2054||0.75-4-2039||0.50-4-2024||0.25-4-2009||0.00-4-1954||-0.25-4-1939||-0.50-4-1924||-0.75-4-1909||-1.00-4-1854||-1.25-4-1839||-1.50-4-1824||-1.75-4-1809||-2.00-4-1754||-2.25-4-1739||-2.50-4-1724||-2.75-4-1709||-3.00-4-1654||-3.25-4-1639||-3.50-4-1624||-3.75-4-1609||-4.00-4-1554||-4.25-4-1539||-4.50-4-1524||-4.75-4-1509||-5.00-4-1454||-5.25-4-1439||-5.50-4-1424||-5.75-4-1409||-6.00-4-1354||-6.25-4-1339||-6.50-4-1324||-6.75-4-1309||-7.00-4-1254||-7.25-4-1239||-7.50-4-1224||-7.75-4-1209||-8.00-4-1154||-8.25-4-1139||-8.50-4-1124||-8.75-4-1109||-9.00-4-1054||-9.25-4-1039||-9.50-4-1024||-9.75-4-1009||-10.00-4-954||-10.25-4-939||-10.50-4-924||-10.75-4-909||-11.00-4-854||-11.25-4-839||-11.50-4-824||-11.75-4-809||-12.00-4-754||-12.25-4-739||-12.50-4-724||-12.75-4-709|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for New campaign- GMT: 24hours HOPPER: 1000
hopper DONE cleared: 0
|DELETE from vicidial_hopper where campaign_id='New' and status
IN('DONE');|
hopper GMT BAD cleared: 0
|DELETE from vicidial_hopper where campaign_id='New' and
((gmt_offset_now IN('99') ) );|
hopper READY count: 1
|SELECT count(*) from vicidial_hopper where campaign_id='New' and
status='READY';|
hopper too low (1|1000) starting hopper dump
campaign lists count: 1 | '101'
|SELECT list_id FROM vicidial_lists where campaign_id='New' and
active='Y';|
no lead filter defined for campaign: New
|NONE|
|SELECT count(*) FROM vicidial_list where
called_since_last_reset='N' and status IN('NEW','','','','') and
list_id IN('101') and ((gmt_offset_now
IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99')
) ) ;|
leads to call count: 1
|SELECT count(*) FROM vicidial_list where
called_since_last_reset='N' and status IN('NEW','','','','') and
list_id IN('101') and ((gmt_offset_now
IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99')
) ) ;|
ERROR CANNOT ADD ANY NEW LEADS TO HOPPER
Getting Leads to add to hopper
|SELECT lead_id FROM vicidial_hopper where campaign_id='New';|
lead call order: order by lead_id asc
|SELECT lead_id,list_id,gmt_offset_now,phone_number,state FROM
vicidial_list where called_since_last_reset='N' and status
IN('NEW','','','','') and list_id IN('101') and lead_id NOT
IN('1','0') and ((gmt_offset_now
IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99')
) ) order by lead_id asc limit 1000;|
Adding to hopper: 0
DONE with this campaign
DONE... Exiting... Goodbye... See you later... Really, I mean it
root@phone:~#

[mflorell]

Are there NEW leads in the list?

SELECT count(*),status,list_id,called_since_last_reset from vicidial_list group by status,list_id,called_since_last_reset;

[D]

The newest set of leads that we entered was forList ID 107. It shows the correct number in Count = 26 but shows zero in the hopper though.

We had uploaded around 800 leads in List ID 103 but it only shows 1 lead count and zero in the hopper eventhough we have not made a single call?


mysql> SELECT count(*),status,called_since_last_reset,list_id from
vicidial_list group by status,called_since_last_reset,list_id;
+----------+--------+-------------------------+---------+
| count(*) | status | called_since_last_reset | list_id |
+----------+--------+-------------------------+---------+
| 1 | NEW | N | 101 |
| 1 | NEW | N | 102 |
| 1 | NEW | N | 103 |
| 26 | NEW | N | 107 |
+----------+--------+-------------------------+---------+
4 rows in set (0.08 sec)

[mflorell]

" hopper READY count: 26 "

The leads were in the hopper and you had the hopper level set to 1000 so it was not able to fill it up because you don't have enough leads in your vicidial_list table to accomodate.

[D]

Initially I had the Hopper level set at 1 and we were having the same issue...changed it to 50 but still had the same issue. Therefore, I changed it to a 1,000.

What is the optimum Hopper level for 26 leads and 800 leads?

Thanks

[gerski]

do the leads loaded correctly? do you set the list ID and where campaign will it use?

the hopper will work if you have leads on that campaign

[D]

The 26 leads that show up in one of the campaigns above did load correctly. We did assign that List ID a campaign.

What is the optimum Hopper level for:

Lead Count = 26 leads and

Lead Count =800 leads?

Thanks