Page 1 of 1

Modify Web Based Leads Loader

PostPosted: Wed Feb 02, 2011 5:30 pm
by mstopkey
Hello,

I am looking to have the Standard Leads Loader modified to include the Extended numbers. The objective is to have an additional file layout format and leads load script when selecting this format that would insert the extended phone numbers along with the standard entries.
Also, when deleting a list, it should delete the associated extended number entries.
We typically load 20 to 30 new lists each day then delete them at the end of the day. Our agent mangers do this and we need it in the web interface to make it simple for them.
I would prefer this to be done in the current stable version of ViciBox Redux with current SVN trunk. We would make the system upgrade after the task was done.

Any takers?

PostPosted: Thu Feb 03, 2011 3:01 am
by williamconley
You could also consider a standard php script that uses a web page to upload the file and then initiates the import from the command line. There would then not even be any modification made to Vicidial itself and could even have a completely different security protocol (perhaps even be initiated from another software package ... such as the one you keep your lists in ... ). Deleting is even easier, and could be done on the same page.

Leads Loader

PostPosted: Thu Feb 03, 2011 10:44 am
by mstopkey
Hello William,
We would actually love to do just that. Our application is built on top of Adempiere and the phones are stored in PostgreSQL. Adempiere has a job scheduler that we are trying to figure out. We would like to have it build our lists each night according to templates, then call upon ViciDial to load these leads including the extended numbers. We assign the same list ID to the same list of leads each day for versatility and result tracking purposes. But I think the first step is getting the leads loader to load extended and when deleting a list, delete the associated extended numbers. That being said, is there any harm in deleting extended numbers info from the vicidial_list_alt_phones?
We are taking bids on this.

PostPosted: Thu Feb 03, 2011 11:44 am
by williamconley
I would expect The Vicidial Group to have had some experience doing this in the past, since they built all the tools involved and it seems this is always proprietary (every office wants it done differently!). But failing that ... a standalone option would be perfect.

What is your time range?

Leads Loader

PostPosted: Thu Feb 03, 2011 2:44 pm
by mstopkey
A couple of months to get done.

Leads Loader

PostPosted: Thu Feb 03, 2011 2:46 pm
by mstopkey
We are looking for fairly tight integration of ViciDial with our application. Several integration steps all the way down to ViciDial updating account notes in our app with call times and dispo's.

PostPosted: Thu Feb 03, 2011 3:23 pm
by williamconley
hm. if you said a few instead of a couple, we'd be interested in discussing it in depth. :) we're working on some fairly intricate items right now ... but we'll be loosening up in a couple weeks.

We are already performing list building and breakdown, etc., for other clients (some have daily reloads, some have manual reloads ... some have criteria based resets, always clears the hopper to avoid a snafu :))

RE:

PostPosted: Thu Feb 10, 2011 3:57 pm
by mstopkey
Making headway on this. We now have a PHP extended numbers leads loader. Working on more refinement to have drop down, choose list. HOOORRRAAAYYY!