vicidial.org

Here is the situation, I have an agent that quits and they have 50 CBHOLD's as an example and I want to change those to answering machine so that they go back into list and get recycled. I would think the fastest way to to do that is via SQL query for example something like this UPDATE vicidial_list SET status='A' WHERE status='CBHOLD'; but I want it to be specific to list ID and agent number and that I can seem to figure out.





ALL in one Server.
1.4.39.1-vici
VERSION: 2.4-359a
BUILD: 120213-1512

Please also post your installation method with version (Vicibox 4.0.3? GoAutoDial 2.1?)

UPDATE vicidial_list SET status='A' WHERE status='CBHOLD' and user='{USER}' and list_id='{LIST_ID}';

Just add "and", then the new criteria.

I would suggest adding a new status like "CBREL" for CallBackRelease to make these visible as released callbacks. In case you want to track stats on these aside from real Answering Machine statuses.

Thank you, as always you are a big help, and I know better when it comes to posting, I will flog myself later

Thad

never wait 'til later. Besides, it works better if you hire someone to flog you. Frees up your time to get into more mischief.

Worth mention: update the vicidial_callbacks table too and set status = INACTIVE because you don't want a callback to be triggered when the lead has an other status then CALLBK or CBHOLD.

else you might end up with this scenario:
* agent A calls a lead and register a "anyone"-callback to 2013-03-25
* you update that lead to NEW in vicidial_list
* agent B calls the lead and register a SALE
* and at 2013-03-25 the lead will be inserted into the hopper even if it was registered as SALE a few days earlier.

be prepared for stuff like this when you starts playing with the vicidial tables.

! Excellent point DomeDan!

Thank you! talking from experience you know, took a while to pin down why NI, SALE etc were being called.