COMPLETE - dynamic field creation within ViciDial

Projects needing sponsorship, and bounties for projects

Moderators: Staydog, mflorell, MJCoate, mcargile, Kumba

COMPLETE - dynamic field creation within ViciDial

Postby mflorell » Thu Jul 30, 2009 4:15 pm

Started from this thread:
viewtopic.php?t=3952

Goal:
To have a highly scalable, dynamic custom field creation system for use with ViciDial that would be tied to the list_id and could have up to 255 dynamically-defined fields.

Development Stages:
1. Create admin interface to manage dynamic fields per list_id *COMPLETE*
2. Create display of custom fields within the ViciDial agent interface, including variables to be used in web forms and scripts *COMPLETE*
3. Add exporting of custom tables to list download feature as well as the calls export report *COMPLETE*
4. Create list loading interface to put leads into the vicidial_list table and the custom fields, includes reusable template definitions *COMPLETE*

Limitations:
- You could not dial leads sorted by any custom fields
- Only one set of custom fields per list_id

Cost: (this is a very rough estimate)
Estimated at 100 hours (USD $18,000)

Pledged: $2900

$2000 - Trying
$300 - frank220
$250 - slider
$150 - gardo
$100 - gmcust3
$100 - starfederal


Please let me know what you think...

EDIT: 2010-05-06 - changed priority of development phases
Last edited by mflorell on Fri Jul 02, 2010 3:19 pm, edited 11 times in total.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby Op3r » Thu Jul 30, 2009 4:55 pm

How about on per campaign? I think this will be more effective?
Get paid for US outbound Toll Free calls. PM me.
Op3r
 
Posts: 1432
Joined: Wed Jun 07, 2006 7:53 pm
Location: Manila

Postby mflorell » Thu Jul 30, 2009 6:10 pm

I had thought about that, but I wanted to allow for multiple sets of fields per campaign potentially because then you could have a different set of fields for each in-group for example, because new calls are tied to a list_id, not a campaign and you can have many in-groups handled by a single campaign. So doing it based on List ID allows for more flexibility that you wouldn't get doing it by campaign. Also since this includes templating, it will not be difficult to import new leads with the same custom fields as you have already done for other lists in a campaign.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby Trying » Fri Jul 31, 2009 2:56 am

I will commit to $500.
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby Trying » Mon Aug 03, 2009 7:28 am

Weird........ doesn't anyone else want these fantastic features??? :shock:
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby Trying » Tue Aug 04, 2009 7:11 am

Add another $500 from me please.
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby Trying » Sun Nov 01, 2009 10:11 am

I will contribute another $1 000. Anyone else? Only 160 people need to contribute $100 each.
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

matt count me in

Postby frank220 » Tue Nov 03, 2009 9:27 pm

pledge 100 gbp
frank220
 
Posts: 32
Joined: Mon Jun 16, 2008 9:24 am

Postby mflorell » Tue Nov 03, 2009 9:46 pm

Pledges need to be in USD, can I put you down for $200 ?
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

why not

Postby frank220 » Tue Nov 03, 2009 10:03 pm

go on then - :wink:
frank220
 
Posts: 32
Joined: Mon Jun 16, 2008 9:24 am

Postby frank220 » Wed Nov 04, 2009 6:42 pm

Ill commit to another 100 usd - come on guys its got to be worth it!
frank220
 
Posts: 32
Joined: Mon Jun 16, 2008 9:24 am

Postby Trying » Thu Nov 05, 2009 12:11 pm

Great! Imagine how cool this feature will be!! :D
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby gmcust3 » Thu Nov 05, 2009 8:02 pm

I am committing 100$.

Sorry , a small amount. :-(

Do I need to send this amount now ?

If so, then where ?

But strange is out of 1462 views , Only 4-5 agreed to support this feature ?

.5% ??

Sorry but how about "Moderators" ?

None agreed to Support this ?
GoAutoDial CE
VERSION: 2.4-309a
BUILD: 110430-1642
No other software installed on the box.
I've read the manager manual.
gmcust3
 
Posts: 1148
Joined: Sat Oct 24, 2009 1:15 pm

Postby mflorell » Fri Nov 06, 2009 5:16 am

You don't need to send anything yet, once we have started work on the feature we will request payment so that we can begin development. So once we get close enough to the goal amount then I will be able to schedule development time for this.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby gmcust3 » Wed Dec 09, 2009 5:00 pm

Cant Vici send an email to all users and ask for the contribution ?

May be many users are NOT aware of this who have NOT recently visited this forum !!!
GoAutoDial CE
VERSION: 2.4-309a
BUILD: 110430-1642
No other software installed on the box.
I've read the manager manual.
gmcust3
 
Posts: 1148
Joined: Sat Oct 24, 2009 1:15 pm

Postby mflorell » Wed Dec 09, 2009 8:03 pm

I wouldn't really want to do that. I have mentioned this project to some people, but I don't think they wanted to contribute.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby gmcust3 » Wed Dec 09, 2009 9:31 pm

I am SURPRISED , NO MODERATORS showed any interest in this !!
GoAutoDial CE
VERSION: 2.4-309a
BUILD: 110430-1642
No other software installed on the box.
I've read the manager manual.
gmcust3
 
Posts: 1148
Joined: Sat Oct 24, 2009 1:15 pm

Postby gmcust3 » Sun Jan 03, 2010 2:47 pm

STUNNED !!!

Such a Wonderful feature but noone wants it ?

Come on guys, just invest 100$ each and we can have this feature !!!

{ On a contrary , all other dialer ( like Dhristi , Avaya and etc ) have this features and many time we DO SEE that CENTERS think twice before opting for Vici when they hear that there is NO CUSTOMISATION available of the CRM }
GoAutoDial CE
VERSION: 2.4-309a
BUILD: 110430-1642
No other software installed on the box.
I've read the manager manual.
gmcust3
 
Posts: 1148
Joined: Sat Oct 24, 2009 1:15 pm

Postby gardo » Sun Jan 03, 2010 4:51 pm

I missed this topic. I'm pledging $150 for the development. Op3r where are you? Hehehe! :wink:

This feature IMHO would put Vicidial on par if not better with the "big boys".
http://goautodial.com
Empowering the next generation contact centers
gardo
 
Posts: 1926
Joined: Fri Sep 15, 2006 10:24 am
Location: Manila, 1004

Postby mflorell » Sun Jan 03, 2010 7:44 pm

We have had a couple clients that expressed interest in sponsoring part of this some time in the next couple months, so hopefully this will be ready for 2.4.0 some time later this year.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby gmcust3 » Sun Jan 03, 2010 10:18 pm

I missed this topic.


Maybe other Members also missed it !!!
GoAutoDial CE
VERSION: 2.4-309a
BUILD: 110430-1642
No other software installed on the box.
I've read the manager manual.
gmcust3
 
Posts: 1148
Joined: Sat Oct 24, 2009 1:15 pm

Postby Trying » Mon Jan 04, 2010 5:34 am

That is excellent news Matt! My $2 000 contribution still stands.
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby mflorell » Tue Jan 05, 2010 4:58 pm

Since these last several posts are not relevant to the project they need to be moved to a different forum, this forum is ONLY for discussions of the bounty, not discussions of other products. I will move the content to a new topic under development.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Count us in.

Postby starfederal » Mon Jan 18, 2010 1:55 pm

I will also contribute $100
starfederal
 
Posts: 32
Joined: Sat Dec 19, 2009 2:52 pm
Location: Earth

5-10 custom fields

Postby slider » Sun Jan 31, 2010 5:24 pm

This may have already been covered, but would it be possible to have 5 custom fields, like custom1,custom2,etc. and let people use those to get by until this is built?

I'll pledge $250 towards dynamic field creation or even the idea above, thx!
slider
 
Posts: 42
Joined: Sun Jan 31, 2010 4:48 pm

Postby mflorell » Sun Jan 31, 2010 7:12 pm

And what would be the definition of those 5 fields?

Using a VARCHAR(255) could double the storage needs of the vicidial_list table. And most people that need several custom fields need a lot more than 5.

Currently we will usually just suggest using a CRM like Vtiger or a custom table for the fields the customer needs if they don't have an internal system already.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

woot

Postby slider » Sun Jan 31, 2010 8:32 pm

mflorell wrote:...using a CRM like Vtiger or a custom table for the fields the customer needs if they don't have an internal system already.


Thx for the quick reply. Can you elaborate a bit on how people have the custom table setup with the web gui?

I think your making good long term decisions and I support that. On the flip side, I was looking for something short and simple that doesn't require vtiger as I don't want to deal with another system for the type of lists I deal with.

Put me down for bounty in last post, thx. :wink:
slider
 
Posts: 42
Joined: Sun Jan 31, 2010 4:48 pm

Postby mflorell » Sun Jan 31, 2010 9:38 pm

Just making a simple PHP or other web page that interacts with a custom table on the backend, then using an IFRAME in the script tab to receive and display the information.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby arvindsandilya24 » Fri Mar 19, 2010 3:30 am

Hi All,

Buzzworks is company located in India and we use highly modified vicidial (mostly agent/reports side) at our current install base of 400+ seats spread out in 5 cities across country and for different clients.. custom fields were always needed for different processes and we had to try to implement them..

when at first we tried the webform approach it didnt worked well because of 2 separate screens which were not communicating well, our current approach is much cleaner and well integrated.
Features :
0. Everything in Single agent screen.
1. Unlimited dynamic fields per Campaign
2. Easy Web based list loader (all you have to do is select campaign, download the template for the campaign, fill it and load back.) you can also load any number of alt numbers.
3. Disposition-vise feedback form. :- Every disposition can be attached with a separate feedback form which gets activate when the disposition is selected. this allows to capture specific information and can also act as sub-disposition.
eg
after selecting Not Interested (NI) you can have a drop-down in which you can select exact reason and finally get a report based on this.
4. Custom fields can be used with scripts easily.

some of the screenies are located here : http://buzzworks.com/data/dialer.zip
Based on Vicidial version : 2.0.5
please ask back if you have any queries.

Thankyou.
End to end premised call center solutions @ USD 60/workstation/month.
Asterisk Cosultancy, IVR Development, CTI @ USD 30/hour.
arvindsandilya24
 
Posts: 192
Joined: Sun Oct 12, 2008 4:33 am

Postby gmcust3 » Fri Mar 19, 2010 3:39 am

Cool..

Anyway , to download the code ?

May be by paying $$ ?
GoAutoDial CE
VERSION: 2.4-309a
BUILD: 110430-1642
No other software installed on the box.
I've read the manager manual.
gmcust3
 
Posts: 1148
Joined: Sat Oct 24, 2009 1:15 pm

Postby Trying » Fri Mar 19, 2010 7:21 am

Excellent. Same question from me..... where can we download the code?
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby mflorell » Fri Mar 19, 2010 7:59 am

As the original copyright holder of this modified code I formally request the full source code.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby arvindsandilya24 » Fri Mar 19, 2010 3:10 pm

Hi Matt,

since you formally requested (pun intended) please find below links for the code.. there are also some db changes done (mostly increasing the column size in some tables..) but are not a pre-requirement to run this one.

so here goes.. changes are just too many if you ask me, we are not using the vicidial method of hidden and visible divs/spans they were too slow on slow systems. now we store all html in javascript variables and make them render when needed.

## we have stopped using the vicidial_list tables original fields.. existing fields are used only for indexing purpose. all data except phone_number goes into the comments field.
## alt numbers mechanism is changed
## added a config file varconfig.php which can be moved to admin interface later
## completely changed the calls lists (callback and other)
## single login page

lot of changes are less than optimum for handling huge lodes but they have worked for data in a few millions..we have done a lot of optimizations when needed.

anyways.. as you can see this is edited on 2.0.5 which is fairly new, we are still heavily editing the code.. lot of features are incomplete (eg generalisation of firing mail per campaign on marked dispositions..) which also means you might be having completely different priorities on the changes.

on closing note, i hope we get some credit if u like some of the additions.

Thanks

http://buzzworks.com/data/agc.zip
arvindsandilya24
 
Posts: 192
Joined: Sun Oct 12, 2008 4:33 am

Postby gmcust3 » Fri Mar 19, 2010 3:35 pm

Tried it. Looks pretty cool , after a long time, something new and fresh !!

Functionality wise, many not working, though may be DB update reqd.
GoAutoDial CE
VERSION: 2.4-309a
BUILD: 110430-1642
No other software installed on the box.
I've read the manager manual.
gmcust3
 
Posts: 1148
Joined: Sat Oct 24, 2009 1:15 pm

Postby mflorell » Fri Mar 19, 2010 3:57 pm

Looking at the code, a few comments:
- there are no headers on the files you have created/separated, a legal requirements of the license is that you maintain the copyright notice
- there are several tables/db changes that need to be documented for this to even function properly
- if you made changes to the backend scripts then this code doesn't do much for anyone
- I don't quite understand the "all data goes in the comments fields" statement, could you explain exactly how this works?
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby arvindsandilya24 » Fri Mar 19, 2010 11:52 pm

Hi,

1. as fas as I understand, GPL is enforced only when publishing/distributing the modified work. as we only used the changes on our own hardware I dont think we are required to comply (it is as good as internal use of the software)

however will try to make it done ( :-) this would be so unproductive..)

2. DB changes needed :


CREATE TABLE IF NOT EXISTS `buzzworks_alert` (
`id` int(11) NOT NULL auto_increment,
`user` int(11) NOT NULL,
`alert` varchar(512) NOT NULL,
`dateofexpire` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `custom_field` (
`id` int(11) NOT NULL auto_increment,
`campaign_id` varchar(8) NOT NULL,
`name` varchar(50) NOT NULL,
`vname` varchar(128) NOT NULL,
`type` varchar(20) NOT NULL,
`mandatory` tinyint(1) NOT NULL,
`comment` varchar(5000) NOT NULL,
`edit` tinyint(1) NOT NULL,
`default` varchar(50) NOT NULL,
`size_text` int(11) NOT NULL,
`size_content` int(11) NOT NULL,
`type_text_box` varchar(10) NOT NULL,
`group` varchar(50) NOT NULL,
`position` int(11) NOT NULL,
`mainform_priority` varchar(3) default NULL,
`status` varchar(512) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `campaign_id` (`campaign_id`,`name`,`position`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ALTER TABLE `vicidial_list` CHANGE `province` `province` VARCHAR(10000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `comments` `comments` VARCHAR(10000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;
ALTER TABLE `vicidial_log` CHANGE `alt_dial` `alt_dial` VARCHAR( 10000 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'NONE' ;



3. No changes to backend scripts. so i guess this can be useful.

4. Storing of Lead data/custom fields :- what is happening now is for a perticular campaign custom_field table contains the field description (meta about firlds)

now comments column of vicidial list will be in this format : "FieldName1~FieldValue1|FieldName2~FieldValue2|..." javascript takes care of everything else.
arvindsandilya24
 
Posts: 192
Joined: Sun Oct 12, 2008 4:33 am

Postby arvindsandilya24 » Sat Mar 20, 2010 12:01 am

5 . If you cant run some of the functionalities you might need to do some config changes (varconfig.php) ...

Thanks
arvindsandilya24
 
Posts: 192
Joined: Sun Oct 12, 2008 4:33 am

Postby mflorell » Sat Mar 20, 2010 7:11 am

1. Ah, but vicidial 2.0.5 is AGPL, not GPL. Under this license the software is considered "distributed" if any users outside of your company are actually using the software. You must offer a full source code download.

If you had based this on 2.0.4(which was GPL) you would not.


4. where are the Admin changes for configuring the custom fields? Do you have to do this manually in the database or is there a GUI interface?
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

thanks

Postby brett05 » Sat Mar 20, 2010 7:21 am

i think they are a gui interface because no way to use all this dynamic forms and comments without having a interface for it
we hope it share it here
thanks again arvindsandilya24
Jasperreports & Queuemetrics & SugarCRM integration - Customization and Add-ons
Freepbx||Billing||Centos||Opensuse||Debian||Centos||Fedora||Sangoma||Diguim
brett05
 
Posts: 571
Joined: Sun May 24, 2009 5:48 pm
Location: tunisia

Postby DarknessBBB » Sat Mar 20, 2010 8:03 am

The link doesn't work anymore :(
DarknessBBB
 
Posts: 328
Joined: Mon Jul 16, 2007 10:14 am

Next

Return to Projects

Who is online

Users browsing this forum: No registered users and 6 guests