Page 1 of 1

Drop Lists Generate nothing

PostPosted: Mon Feb 05, 2018 10:38 am
by jatomusic
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!

Re: Drop Lists Generate nothing

PostPosted: Mon Feb 05, 2018 10:51 am
by mflorell
Confirm that you are selecting an active server for it to run on.

Re: Drop Lists Generate nothing

PostPosted: Mon Feb 05, 2018 10:58 am
by jatomusic
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;|

Re: Drop Lists Generate nothing

PostPosted: Mon Feb 05, 2018 11:18 am
by jatomusic
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

Re: Drop Lists Generate nothing

PostPosted: Mon Feb 05, 2018 1:35 pm
by jatomusic
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.