by dlaz » Fri Jun 15, 2012 12:02 pm
At this point I have it pretty well integrated, at least about as much as possible for us. The account notation engine will update the notes, change status codes, add BK and DEC info, etc to latitude based on what the agent puts in. It will also change desks etc based on how they notate the account based on internal business rules. Since the system drops info into Latitude about every 30-45 seconds, I added triggers to the vicidial_list and vicidial_log tables to populate custom tables with data to cut down some of the locking overhead in mysql that my query that runs to notate accounts.
Since my current employer has users that are not on the dialer all day, I also had to implement a DNC table that scrubs numbers that have been called during the day using our asterisk PBX and loads them into the DNC list for the day and then purges them back out overnight.
As far as the list loader what we do there is there is a tool in Latitude called account analysis that our supervisors use. This saves what they specify as a database query in the latitude database. Since our latitude and windows usernames are the same, I have a program that pulls logged in user, gets their last run query for account analysis and then uses that query to build the dialing lists, they also specify what types of phones they want to target in that list (home or work), since we are in the US and collection companies are now liable under the TCPA (for awhile we weren't or at least it was a grey area) we do scrub all our accounts against a cell phone suppression list. Our operations group wanted it set this way because they run a lot of adhoc stuff. There is also an auto building system I wrote that will take the above queries and save them to it and build them on the days they specify.
We also build a new list daily, its just easier for us than trying to keep our whole entire active inventory in the system. We have a set of scripts that auto archive the called lists/logs after 3 days.
The only minor issue I still have is the account pop integration, but its not that big of a deal for our users since they get all the basic information they need to do an initial talk off on the vicidial screen, and then if they need more info or to take a payment they just copy and paste the account number into latitude.