Drop Lists Generate nothing

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Drop Lists Generate nothing

Postby jatomusic » Mon Feb 05, 2018 10:38 am

I am testing the new Drop Lists feature. When I am testing the trigger, I am not getting leads into the target lists. I have tried different settings and status codes and still the same result. If I check the DB, I certainly get results for statuses matching the time set. Any ideas what to check? I'm looking into the /pl script that runs to see where it may fail.

Any push would be great, thanks!
Vicibox 8.0.1 from .iso | Vicidial 2.14-647a Build 171229-2309 | Asterisk 11.25.3-vici | Cluster | No Digium/Sangoma | No Extra Software |
Dedicated Servers | ~50 Agents | DB 500+ Agents, Web+ 2voice standard | backup to AWS S3
jatomusic
 
Posts: 18
Joined: Fri Mar 06, 2015 5:58 pm

Re: Drop Lists Generate nothing

Postby mflorell » Mon Feb 05, 2018 10:51 am

Confirm that you are selecting an active server for it to run on.
mflorell
Site Admin
 
Posts: 16709
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Drop Lists Generate nothing

Postby jatomusic » Mon Feb 05, 2018 10:58 am

I did select an active server. I tried both of my voice servers and same result.

I manually ran AST_droplist_process.pl with debug on.
Code: Select all
/usr/share/astguiclient/AST_droplist_process.pl --debugX --test --dl-id=1001

----- DEBUG MODE -----


----- SUPER DEBUG MODE -----


----- TESTING -----


----- DROP LIST ID: 1001 -----













-- AST_droplist_process.pl --

This program is designed to run the drop list process.

SEED TIME  1517846136      :   2018-02-05 10:55:36  LOCAL GMT OFFSET NOW: -5.00
DROP LIST RUN: |1001|1002|900(2018-02-04 19:55:36)|
DROP LOG UPDATE: |0E0|UPDATE vicidial_drop_log set drop_processed='U' where drop_processed='N' and drop_date >= "2018-02-04 19:55:36" and campaign_id IN('9001','9002','9003','9004','9005','9006','9007','9009','9010','9011','9012','9014','9015','9016','9017','9018','9019','9020','9021','9022','9023','9024','9025','9026','9027','9028','9029','9030','9031','9032','9033','9034','9035','9036','9037') and status IN('AFTHRS');|
DROP LOG GATHER: |1|SELECT lead_id,drop_date,phone_code,phone_number,campaign_id,status,uniqueid from vicidial_drop_log where drop_processed='U' and drop_date >= "2018-02-04 19:55:36" and campaign_id IN('9001','9002','9003','9004','9005','9006','9007','9009','9010','9011','9012','9014','9015','9016','9017','9018','9019','9020','9021','9022','9023','9024','9025','9026','9027','9028','9029','9030','9031','9032','9033','9034','9035','9036','9037') and status IN('AFTHRS') order by drop_date;|
Vicibox 8.0.1 from .iso | Vicidial 2.14-647a Build 171229-2309 | Asterisk 11.25.3-vici | Cluster | No Digium/Sangoma | No Extra Software |
Dedicated Servers | ~50 Agents | DB 500+ Agents, Web+ 2voice standard | backup to AWS S3
jatomusic
 
Posts: 18
Joined: Fri Mar 06, 2015 5:58 pm

Re: Drop Lists Generate nothing

Postby jatomusic » Mon Feb 05, 2018 11:18 am

I think it has to do with similar list names and drop lists names.

I do have an ingroup id 1001, I also have a list id 1001, and I had a drop list id 1001.

I changed the droplist id to 1234 (I dont have anything labeled that) and it loaded to one of my list (1003) no problem. I'm sure the issue is from the ID's
Vicibox 8.0.1 from .iso | Vicidial 2.14-647a Build 171229-2309 | Asterisk 11.25.3-vici | Cluster | No Digium/Sangoma | No Extra Software |
Dedicated Servers | ~50 Agents | DB 500+ Agents, Web+ 2voice standard | backup to AWS S3
jatomusic
 
Posts: 18
Joined: Fri Mar 06, 2015 5:58 pm

Re: Drop Lists Generate nothing

Postby jatomusic » Mon Feb 05, 2018 1:35 pm

Also, it is important to note, the system does not start tracking drops until it is enabled in the system settings. So any drop made prior to the time you enabled drop lists, you wont find them in your lists.

I hope this helps anyone pulling their hair.
Vicibox 8.0.1 from .iso | Vicidial 2.14-647a Build 171229-2309 | Asterisk 11.25.3-vici | Cluster | No Digium/Sangoma | No Extra Software |
Dedicated Servers | ~50 Agents | DB 500+ Agents, Web+ 2voice standard | backup to AWS S3
jatomusic
 
Posts: 18
Joined: Fri Mar 06, 2015 5:58 pm


Return to Support

Who is online

Users browsing this forum: No registered users and 12 guests