vicidial.org

by **arvindsandilya24** » Sat Mar 20, 2010 8:57 am

yes Matt, i saw the 'A' thing in the code.. I dont have any issues with sharing the code (already done) .. (still as I had thought about it, when our clients use this modified version we fall into the category of "service but not open to general public" where as AGPL says if your server is open to public access you code should also be open to public access.. so if i just expose code the the consumers [my clients] i am complying.. if you can suggest otherwise please make a comment)

+ brett05,
we were using the gui for creating fields ( field_create.php and edit_web_form.php ) these files are not fully developed but mostly works.. so until we get them fully effective we are currently using sql templates to create fields..

eg

Code: Select all: INSERT INTO `custom_field` (`id`, `campaign_id`, `name`, `vname`, `type`, `mandatory`, `comment`, `edit`, `default`, `size_text`, `size_content`, `type_text_box`, `group`, `position`, `mainform_priority`, `status`) VALUES ( 'TESTCAMP', 'Mobile', 'MobileNo', 'text', 0, '', 1, '', 10, 100, 'text', '1', 0, NULL, 'hidden'), ( 'TESTCAMP', 'Name', 'CustomerName', 'text', 0, '', 1, '', 10, 200, 'text', '1', 0, '01', 'mainform'), ( 'TESTCAMP', 'Remark', 'mainRemarks', 'text', 0, '', 1, '', 10, 1000, 'text', '1', 0, '99', 'mainform'), ( 'TESTCAMP', 'CallBack_Type', 'CALLBK_REASON', 'drop', 1, 'Scheduled,General', 1, '', 0, 0, '', '0. Callback Type', 1, NULL, '|CALLBK|'), ( 'TESTCAMP', 'ERROR_REASON', 'ERROR_REASON', 'drop', 1, 'No Customer Info,Repeated Call,No Number,Other', 1, '', 0, 0, '', '0. Description', 1, NULL, '|ERROR|'), ( 'TESTCAMP', 'Remark', 'ERROR_REMARK', 'text', 0, '', 1, '', 0, 0, 'text', '0. Description', 3, NULL, '|ERROR|'), ( 'TESTCAMP', 'ApptDoor', 'AppointmentDoor', 'text', 1, '', 1, '', 10, 1000, 'text', '1. Appointment Address', 1, NULL, '|LEAD|'), ( 'TESTCAMP', 'ApptStreet', 'AppointmentStreet', 'text', 1, '', 1, '', 10, 1000, 'text', '1. Appointment Address', 2, NULL, '|LEAD|'), ( 'TESTCAMP', 'ApptArea', 'AppointmentArea', 'text', 1, '', 1, '', 10, 1000, 'text', '1. Appointment Address', 3, NULL, '|LEAD|'), ( 'TESTCAMP', 'ApptLandmark', 'AppointmentLandmark', 'text', 1, '', 1, '', 10, 1000, 'text', '1. Appointment Address', 4, NULL, '|LEAD|'), ( 'TESTCAMP', 'ApptPIN', 'AppointmentPIN', 'text', 0, '', 1, '', 10, 1000, 'text', '1. Appointment Address', 5, NULL, '|LEAD|'), ( 'TESTCAMP', 'DocumentsToCollect', 'DocumentsToCollect', 'text', 1, '', 1, '', 10, 1000, 'text', '2. Documents and Appointment', 1, NULL, '|LEAD|'), ( 'TESTCAMP', 'AppointmentDate', 'AppointmentDate', 'text', 1, '', 0, '__YYYYMMDD__', 10, 100, 'text', '2. Documents and Appointment', 2, NULL, '|LEAD|'), ( 'TESTCAMP', 'AppointmentFrom', 'AppointmentFrom', 'drop', 1, '9:00,9:30,10:00,10:30,11:00,11:30,12:00,12:30,13:00,13:30,14:00,14:30,15:00,15:30,16:00,16:30,17:00,17:30,18:00,18:30,19:00,19:30,20:00,20:30,21:00,21:30', 1, '', 10, 100, 'text', '2. Documents and Appointment', 3, NULL, '|LEAD|'), ( 'TESTCAMP', 'AppointmentTo', 'AppointmentTo', 'drop', 1, '9:00,9:30,10:00,10:30,11:00,11:30,12:00,12:30,13:00,13:30,14:00,14:30,15:00,15:30,16:00,16:30,17:00,17:30,18:00,18:30,19:00,19:30,20:00,20:30,21:00,21:30', 1, '', 10, 100, 'text', '2. Documents and Appointment', 4, NULL, '|LEAD|'), ( 'TESTCAMP', 'AltDoor', 'AltDoor', 'text', 0, '', 1, '', 10, 1000, 'text', '3. Alternate Address', 7, NULL, '|LEAD|'), ( 'TESTCAMP', 'AltStreet', 'AltStreeat', 'text', 0, '', 1, '', 10, 1000, 'text', '3. Alternate Address', 8, NULL, '|LEAD|'), ( 'TESTCAMP', 'AltArea', 'AltArea', 'text', 1, '', 1, '', 10, 1000, 'text', '3. Alternate Address', 9, NULL, '|LEAD|'), ( 'TESTCAMP', 'AltLandmark', 'AltLandmark', 'text', 0, '', 1, '', 10, 1000, 'text', '3. Alternate Address', 10, NULL, '|LEAD|'), ( 'TESTCAMP', 'AltPIN', 'AltPIN', 'text', 0, '', 1, '', 10, 1000, 'text', '3. Alternate Address', 11, NULL, '|LEAD|'), ( 'TESTCAMP', 'AltContactNo', 'AltContactNo', 'text', 0, '', 1, '', 10, 1000, 'text', '3. Alternate Address', 12, NULL, '|LEAD|'), ( 'TESTCAMP', 'PANorForm60', 'PANorFORM60', 'drop', 1, 'PAN,FORM60', 1, '', 0, 0, '', '4. Customer Info', 5, '56', '|LEAD|'), ( 'TESTCAMP', 'MaritialStatus', 'MaritialStatus', 'drop', 1, 'Single,Married', 1, '', 0, 0, '', '4. Customer Info', 6, NULL, '|LEAD|'), ( 'TESTCAMP', 'ResidenceType', 'ResidenceType', 'drop', 1, 'Own,Rented,PG', 1, '', 0, 0, '', '5. Resi-Office Info', 1, NULL, '|LEAD|'), ( 'TESTCAMP', 'PermaLandLine', 'PermaLandLine', 'text', 1, '', 1, '', 10, 1000, 'number', '5. Resi-Office Info', 2, NULL, '|LEAD|'), ( 'TESTCAMP', 'OfficeNumber', 'OfficeNumber', 'text', 0, '', 1, '', 10, 1000, 'number', '5. Resi-Office Info', 3, '55', '|LEAD|'), ( 'TESTCAMP', 'Designation', 'Designation', 'text', 1, '', 1, '', 10, 1000, 'text', '5. Resi-Office Info', 4, '53', '|LEAD|'), ( 'TESTCAMP', 'CompanySeg', 'CompanySeg', 'drop', 1, 'PVT,PUB,GOVT,PSU,MNC,SelfEmp,Other', 1, '', 0, 0, '', '5. Resi-Office Info', 5, NULL, '|LEAD|'), ( 'TESTCAMP', 'ApplSource', 'ApplSource', 'drop', 1, 'Surrograte,Income', 1, '', 10, 1000, 'text', '5. Resi-Office Info', 6, NULL, '|LEAD|'), ( 'TESTCAMP', 'AnnualIncome', 'AnnualIncome', 'text', 1, '', 1, '', 10, 1000, 'number', '6. Finance Info', 1, NULL, '|LEAD|'), ( 'TESTCAMP', 'Basic', 'Basic', 'text', 1, '', 1, '', 10, 1000, 'number', '6. Finance Info', 2, NULL, '|LEAD|'), ( 'TESTCAMP', 'HRA', 'HRA', 'text', 1, '', 1, '', 10, 1000, 'number', '6. Finance Info', 3, NULL, '|LEAD|'), ( 'TESTCAMP', 'Allounces', 'Allounces', 'text', 1, '', 1, '', 10, 1000, 'number', '6. Finance Info', 4, NULL, '|LEAD|'), ( 'TESTCAMP', 'CardLimit', 'CardLimit', 'text', 1, '', 1, '', 10, 1000, 'number', '6. Finance Info', 5, NULL, '|LEAD|'), ( 'TESTCAMP', 'CardTimeMoB', 'CardTimeMoB', 'text', 0, '', 1, '', 10, 1000, 'text', '6. Finance Info', 6, NULL, '|LEAD|'), ( 'TESTCAMP', 'ExistingRel', 'ExistingRel', 'text', 0, '', 1, '', 10, 1000, 'text', '6. Finance Info', 7, '52', '|LEAD|'), ( 'TESTCAMP', 'Name', 'CustomerName', 'text', 1, '', 1, '', 10, 1000, 'text', '4. Customer Info', 1, NULL, '|LEAD|CCMS|'), ( 'TESTCAMP', 'Initial', 'Initial', 'text', 1, '', 1, '', 10, 1000, 'text', '4. Customer Info', 2, NULL, '|LEAD|CCMS|'), ( 'TESTCAMP', 'SurnameorFather', 'SurnameorFather', 'text', 1, '', 1, '', 10, 1000, 'text', '4. Customer Info', 3, NULL, '|LEAD|CCMS|'), ( 'TESTCAMP', 'DOB', 'DOB', 'text', 1, '', 1, '', 10, 1000, 'calendar', '4. Customer Info', 4, '51', '|LEAD|CCMS|'), ( 'TESTCAMP', 'OfficeName', 'OfficeName', 'text', 1, '', 1, '', 10, 1000, 'text', '4. Customer Info', 7, '54', '|LEAD|CCMS|'), ( 'TESTCAMP', 'Not Elegible Reason', 'NE_REASON', 'drop', 1, 'Recently applied,CIBIL bad customer confirm,Closed his SCB cards,DocumentIssue,AgeIssue,BusinessProofNotAvailable,ExistingCardHolder,LessCardLimit,LessSalary,NegativeBusiness,NoCardsSE,OutsideCityLimit,NonMgmtCase', 1, '', 0, 0, '', '1.Information', 1, NULL, '|NE|'), ( 'TESTCAMP', 'Remarks', 'remarks', 'text', 0, '', 1, '', 10, 1000, 'text', '1.Information', 3, NULL, '|NE|NI|'), ( 'TESTCAMP', 'Not Interested Reason', 'NI_REASON', 'drop', 1, 'Not ok with Service,Too many calls,Not Ready to talk,Using too many cards,Irate of cards,Bad experience with cards', 1, '', 0, 0, '', '1.Information', 1, NULL, '|NI|');

+DarknessBBB : I am trying to put the download link out of the website IT ppl dont like it :-)

give me a while to put it back on. Matt can share you a copy ?

by **mflorell** » Sat Mar 20, 2010 9:09 am

If anyone has time to gather together all of the comments here and the zipped code and make a nice document then i will put it up somewhere for download, otherwise just the zip file by itself is unusable and it will be a few days before I have to time to package this together.

by **brett05** » Sat Mar 20, 2010 11:02 am

arvindsandilya24 wrote::D yes Matt, i saw the 'A' thing in the code.. I dont have any issues with sharing the code (already done) .. (still as I had thought about it, when our clients use this modified version we fall into the category of "service but not open to general public" where as AGPL says if your server is open to public access you code should also be open to public access.. so if i just expose code the the consumers [my clients] i am complying.. if you can suggest otherwise please make a comment)

+ brett05,
we were using the gui for creating fields ( field_create.php and edit_web_form.php ) these files are not fully developed but mostly works.. so until we get them fully effective we are currently using sql templates to create fields..

+DarknessBBB : I am trying to put the download link out of the website IT ppl dont like it give me a while to put it back on. Matt can share you a copy ?

thanks arvindsandilya24 as you say you have a sql template for creating fields can you share it please.
your developement seem very good and we can all here work in it and develope it more.
for mflorell:
i have add the zip file with the sql file in mantis here the link:
http://www.vicidial.org/VICIDIALmantis/view.php?id=325

by **Trying** » Sat Mar 20, 2010 11:42 am

I think we are all looking forward to the custom fields feature. It is good to see some people already have this functioning!

by **mflorell** » Sat Mar 20, 2010 2:42 pm

Thanks for posting brett05

I do applaud the buzzworks guys for some of their inventive new features, but this really isn't a distributable package as it is, and the method of storing multiple custom fields in a single database field has some holes, and does not allow for easy or efficient sorting/exporting by custom field.

I do look forward to when I have enough time to working on the official ViciDial solution for custom fields, and I have gathered a lot of great ideas on how to do it over the last several months.

by **arvindsandilya24** » Sat Mar 20, 2010 4:45 pm

I do agree with Matt that this may not be the best method to work with custom fields but the advantages are also noticeable :
1. Least hacking of the existing db structure (just changed a column size)
2. One lead record per row. <-- big convenience in managing leads.
3. Key-Value pair method of implementing this would be a visualisation mess.. i mean if something goes wrong looking at DB wont help.

As you are also figuring out ways to implement the same, if you can let us know what you are planning we can offer man hours in helping you out developing them(i dont doubt our capabilities to do PHP/Ajax... :-)

)

also to make the point we know that the features you have chosen and generally implemented are well suited for scale and stability, on the other side we have this challenge of making the solution work exactly as the users/clients need.. which sometime means working at 90% of the scale/stability but delivering required stuff..

for example the original vicidial has one flashing callback reminder on the agent screen where as some of our users requested additional data so we now have 8 different numbers on screen, and it was just not possible to fire 8 queries/user/30sec to refresh the numbers... CPU loads went crazy with even 30-35 agents. so we changed the strategy and now the numbers are refreshed after every call.. this worked and load is back to the previous levels. I can say we have easily invested close to 200 man-hours in creating/testing/fixing all these features and making them stable enough. (there are at-least a dozen more key features other than custom fields)

so now the end game, if others also like and can use these features it is also in our interest to get them into the trunk so that we dont have to re fix the entire thing for a newer version.. if we can have a general discussion on if that is possible would be great.

Thanks.

by **mflorell** » Sat Mar 20, 2010 5:37 pm

Well, the next version(2.2.0) was branched off in January and is feature-frozen, and at this point is at RC 6(soon to be RC7 this week).

We are on to 2.4 now in SVN/trunk and have done quite a lot of development since the 2.2.0 branch-off.

If you want to get some of these feature into trunk the best thing to do is separate them into manageable features or groups of features and start tickets in the issue tracker for each of them, with a patch against the trunk code. We have several contributors that have done this in the last year and we have added many new features through this process.

by **arvindsandilya24** » Mon Mar 22, 2010 12:31 am

hi matt, is there any plan to separate the AJAX from the user interface? it would be lot more easier to develop external functions and interfaces if that happens. Thanks

by **brett05** » Mon Mar 22, 2010 2:47 am

hi arvindsandilya24 as i have say you before can you share the template for forms edit please because i have seen that you have add many table to sql and they are sure a interface for use them .
thanks

by **brett05** » Mon Mar 22, 2010 5:09 am

i have try it but i can log in then i see a mysql error say that costumer information or same thing as thing is not good ?

Customer Information

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/test/index.php on line 203

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/test/index.php on line 207

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/test/index.php on line 211

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/html/test/index.php on line 242

then i can not dial or logout nothing can accept my clik in the page ?
ant idea please

by **arvindsandilya24** » Mon Mar 22, 2010 6:47 am

hi brett05, did you run the db sqls?

by **brett05** » Mon Mar 22, 2010 7:06 am

yes first i have create this two table :

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' ;

then i have try to insert into table as you have put as :

INSERT INTO `custom_field` (`id`, `campaign_id`, `name`, `vname`, `type`, `mandatory`, `comment`, `edit`, `default`, `size_text`, `size_content`, `type_text_box`, `group`, `position`, `mainform_priority`, `status`) VALUES
( 'TESTCAMP', 'Mobile', 'MobileNo', 'text', 0, '', 1, '', 10, 100, 'text', '1', 0, NULL, 'hidden'),
.....

but the this one can not be run good i see a mysql syntaxe error
please give us a dump sql for your to each update in the datavase asterisk.
thanks

by **arvindsandilya24** » Mon Mar 22, 2010 9:25 am

brett05,

please use the link to get the code
http://techbugs.org/agc.zip

and use the /agc/field_create.php to create forms for main screen and dispositions. (Please note that all dispositions must be campaign specific.)

by **gmcust3** » Mon Mar 22, 2010 11:40 am

Something somewhere is missing.. As I cannot logout.. I cannot see customer Info.. !!!

by **DarknessBBB** » Mon Mar 22, 2010 2:04 pm

gmcust3 wrote:Something somewhere is missing.. As I cannot logout.. I cannot see customer Info.. !!!

And in the campaign real-time report it shows like I was logged since 129123123 minutes (or something like that). Nice interface, though, but if possible it is even smaller than the original one (on a 19" wide monitor)

by **arvindsandilya24** » Mon Mar 22, 2010 2:29 pm

did you tried the new zip file link i posted? http://techbugs.org/agc.zip it has the db.sql file also. and an fully functional field_create.php to create webforms.

DarknessBBB, you can just increase font size to a few points and try?

by **gmcust3** » Mon Mar 22, 2010 2:40 pm

Sorry but I don't see any db.sql file.

Also, do you have any demo server where we can see how it works as Looks its pretty good and fresh and new but functionality wise , may be we are TOO used to of vici ?

by **arvindsandilya24** » Tue Mar 23, 2010 12:07 am

test server :
https://scb-mumbai.no-ip.org:4432

UserID/PhoneID : 6060
UserPass/Phone Pass : 1234

will be up in daytime.

by **gmcust3** » Tue Mar 23, 2010 4:29 am

Tried at 3 PM IST but Its down

by **arvindsandilya24** » Tue Mar 23, 2010 5:14 am

please ping on
skype : siddharth.upmanyu
gtalk : siddharth at buzzworks dot com

its a no-ip thing.. may take 1-2 tries to connect.

by **gmcust3** » Tue Mar 23, 2010 5:28 am

1) No more leads in the hopper for campaign: SCB1

2) Manual Mode

3) I can see atleast ,

CustomerName
-------------
Mobile
-------------
Address
-------------
VendorCode
-------------
Product

But when I tried yr agc, its not there

by **arvindsandilya24** » Tue Mar 23, 2010 5:47 am

you will need to use the /agc/field_create.php to design your own webform..

by **gmcust3** » Tue Mar 23, 2010 5:51 am

CustomerName and others also ??

Nothing default there ??

by **arvindsandilya24** » Tue Mar 23, 2010 6:00 am

yes.. that is how it is.. you can completely design whatever u want... no defaults.

by **Trying** » Tue Mar 23, 2010 6:06 am

This really looks nice.

by **gmcust3** » Tue Mar 23, 2010 6:18 am

So, for every campaign, its a repetitive job of creating fields ?

Agents can also create field in run time OR only Managers with authorisation ?

by **arvindsandilya24** » Tue Mar 23, 2010 6:22 am

its one time job only.. we generally copy fields from one campaign to another from database and then continue editing rather than doing from scratch...

the field_create.php is removed before putting it into production so that agents cant temper with it..

by **gmcust3** » Tue Mar 23, 2010 6:28 am

INSERT INTO `custom_field` works instead of manual entry or creating field as I tried but gave me error ?

by **arvindsandilya24** » Tue Mar 23, 2010 6:59 am

gmcust3, I didnt understand.. you cannot use the gui to create forms?

by **gmcust3** » Tue Mar 23, 2010 7:49 am

I was trying to run that in mysql through webmin.

by **arvindsandilya24** » Tue Mar 23, 2010 9:47 am

please use the posted newer http://techbugs.org/agc.zip and the field_create.php

Thanks

by **brett05** » Tue Mar 23, 2010 4:26 pm

thanks again to arvindsandilya24
this is the db.sql

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(11) 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 latin!_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' ;

-- phpMyAdmin SQL Dump
-- version 3.2.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 23, 2010 at 10:34 PM
-- Server version: 5.1.44
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `asterisk`
--

-- --------------------------------------------------------

--
-- Table structure for table `custom_field`
--

CREATE TABLE IF NOT EXISTS `custom_field` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`campaign_id` varchar(11) 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 AUTO_INCREMENT=1090 ;

--
-- Dumping data for table `custom_field`
--

INSERT INTO `custom_field` (`campaign_id`, `name`, `vname`, `type`, `mandatory`, `comment`, `edit`, `default`, `size_text`, `size_content`, `type_text_box`, `group`, `position`, `mainform_priority`, `status`) VALUES
( 'AXIS1', 'LoanNumber', 'loan_number', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 1, '0', 'mainform'),
( 'AXIS1', 'Product', 'product', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 2, '0', 'mainform'),
( 'AXIS1', 'Branch', 'branch', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 3, '0', 'mainform'),
( 'AXIS1', 'EmailID', 'email_id', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 3, '0', 'mainform'),
( 'AXIS1', 'CustomerName', 'customer_name', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 4, '0', 'mainform'),
( 'AXIS1', 'Gender', 'gender', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 5, '0', 'mainform'),
( 'AXIS1', 'ResiAddress', 'residence_address', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 6, '0', 'mainform'),
( 'AXIS1', 'OfficeAddress', 'office_address', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 7, '0', 'mainform'),
( 'AXIS1', 'MailingAddress', 'mailing_address', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 8, '0', 'mainform'),
( 'AXIS1', 'Resi_Landline', 'contact_number_residence_landline', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 9, '0', 'mainform'),
( 'AXIS1', 'OfficeLandline', 'contact_number_office_landline', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 10, '0', 'mainform'),
( 'AXIS1', 'Mobile', 'contact_number_mobile', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 11, '0', 'mainform'),
( 'AXIS1', 'Company', 'name_of_organisation_employed_with', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 13, '0', 'mainform'),
( 'AXIS1', 'CompanyAddress', 'AddressOfTheOrganisation', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 14, '0', 'mainform'),
( 'AXIS1', 'DPD', 'dpd', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 15, '0', 'mainform'),
( 'AXIS1', 'RepaymentMode', 'repayment_mode', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 16, '0', 'mainform'),
( 'AXIS1', 'Bucket', 'bucket', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 17, '0', 'mainform'),
( 'AXIS1', 'CycleDate', 'cycle_date', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 18, '0', 'mainform'),
( 'AXIS1', 'TotalEMIOverdue', 'total_emi_overdue', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 19, '0', 'mainform'),
( 'AXIS1', 'Outstanding', 'balance_outstanding', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 20, '0', 'mainform'),
( 'AXIS1', 'ChequesBounced', 'number_of_cheques_bounced', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 21, '0', 'mainform'),
( 'AXIS1', 'AccountStatus', 'account_status', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 22, '0', 'mainform'),
( 'AXIS1', 'LastPaymentDate', 'last_payment_date', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 23, '0', 'mainform'),
( 'AXIS1', 'LastPaymentAmount', 'last_payment_amount', 'text', 0, '', 1, '', 10, 100, 'text', '1.CUSTOMER DETAILS', 24, '0', 'mainform'),
( 'AXIS1', 'AmountFinanced', 'amount_financed', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 4, '0', 'mainform'),
( 'AXIS1', 'DisbursalDate', 'disbursal_date', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 5, '0', 'mainform'),
( 'AXIS1', 'InterestRate', 'interest_rate', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 6, '0', 'mainform'),
( 'AXIS1', 'Tenure', 'tenure', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 7, '0', 'mainform'),
( 'AXIS1', 'CycleDate', 'cycle_date', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 8, '0', 'mainform'),
( 'AXIS1', 'TotalInstallements', 'total_number_of_installements', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 9, '0', 'mainform'),
( 'AXIS1', 'InstallmentDate', 'installment_date', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 10, '0', 'mainform'),
( 'AXIS1', 'BilledInstallments', 'count_of_billed_installments', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 11, '0', 'mainform'),
( 'AXIS1', 'NumberOfOverdue', 'number_of_installments_overdue', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 12, '0', 'mainform'),
( 'AXIS1', 'BalanceOutstanding', 'balance_outstanding', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 13, '0', 'mainform'),
( 'AXIS1', 'PrincipalOutstanding', 'principal_outstanding', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 14, '0', 'mainform'),
( 'AXIS1', 'InterestOutstanding', 'interest_outstanding', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 15, '0', 'mainform'),
( 'AXIS1', 'PrincipalOverdue', 'principal_overdue', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 16, '0', 'mainform'),
( 'AXIS1', 'InterestOverdue', 'interest_overdue', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 17, '0', 'mainform'),
( 'AXIS1', 'ChargesOverdue', 'charges_overdue', 'text', 0, '', 1, '', 10, 100, 'text', '2.LOAN DETAILS', 18, '0', 'mainform'),
( 'AXIS1', 'PaymentMode', 'field3', 'text', 0, '', 1, '', 10, 100, 'text', '3.BOUNCE DETAILS', 3, '0', 'mainform'),
( 'AXIS1', 'ChequeNumber', 'cheque_number', 'text', 0, '', 1, '', 10, 100, 'text', '3.BOUNCE DETAILS', 4, '0', 'mainform'),
( 'AXIS1', 'ChequeDate', 'cheque_date', 'text', 0, '', 1, '', 10, 100, 'text', '3.BOUNCE DETAILS', 5, '0', 'mainform'),
( 'AXIS1', 'ChequeAmount', 'cheque_amount', 'text', 0, '', 1, '', 10, 100, 'text', '3.BOUNCE DETAILS', 6, '0', 'mainform'),
( 'AXIS1', 'BankName', 'bank_name', 'text', 0, '', 1, '', 10, 100, 'text', '3.BOUNCE DETAILS', 7, '0', 'mainform'),
( 'AXIS1', 'PresentationDate', 'presentation_date', 'text', 0, '', 1, '', 10, 100, 'text', '3.BOUNCE DETAILS', 8, '0', 'mainform'),
( 'AXIS1', 'CycleDate', 'cycle_date', 'text', 0, '', 1, '', 10, 100, 'text', '3.BOUNCE DETAILS', 9, '0', 'mainform'),
( 'AXIS1', 'ReturnDate', 'returen_date', 'text', 0, '', 1, '', 10, 100, 'text', '3.BOUNCE DETAILS', 10, '0', 'mainform'),
( 'AXIS1', 'BounceReason', 'bounce_reason', 'text', 0, '', 1, '', 10, 100, 'text', '3.BOUNCE DETAILS', 11, '0', 'mainform'),
( 'AXIS1', 'DueDate', 'due_date', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 3, '0', 'mainform'),
( 'AXIS1', 'PaymentDate', 'payment_date', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 4, '0', 'mainform'),
( 'AXIS1', 'TotalAmountPaid', 'total_amount_paid', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 5, '0', 'mainform'),
( 'AXIS1', 'PrincipalPaid', 'principal_paid', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 6, '0', 'mainform'),
( 'AXIS1', 'InterestPaid', 'interest_paid', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 7, '0', 'mainform'),
( 'AXIS1', 'LateFeesPaid', 'late_fees_paid', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 8, '0', 'mainform'),
( 'AXIS1', 'BounceChargesPaid', 'bounce_charges_paid', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 9, '0', 'mainform'),
( 'AXIS1', 'OtherFeesPaid', 'other_fees_paid', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 10, '0', 'mainform'),
( 'AXIS1', 'ModeOfPayment', 'mode_of_payment', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 11, '0', 'mainform'),
( 'AXIS1', 'ChequeNumber', 'cheque_number', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 12, '0', 'mainform'),
( 'AXIS1', 'ChequeDate', 'cheque_date', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 13, '0', 'mainform'),
( 'AXIS1', 'BankName', 'BankName', 'text', 0, '', 1, '', 10, 100, 'text', '4.REPAYMENT DETAILS', 14, '0', 'mainform'),
( 'AXIS1', 'Reason', 'CALLBK_REASON', 'drop', 0, 'Busy,No Answer,No Promise,Other', 1, '', 10, 100, 'text', '5.FEEDBACK / COLLECTION DETAILS', 4, NULL, '|CALLBK|'),
( 'AXIS1', 'ActionDate', 'ActionDate', 'text', 0, '', 1, '', 10, 100, 'date', '5.FEEDBACK / COLLECTION DETAILS', 5, NULL, '|PTP|'),
( 'AXIS1', 'ActionTime', 'ActionTime', 'text', 0, '', 1, '', 10, 100, 'text', '5.FEEDBACK / COLLECTION DETAILS', 6, NULL, '|PTP|'),
( 'AXIS1', 'ContactedTo', 'PersonContactedTo', 'drop', 0, 'Customer,Spouse,Relative,Friend,Neighbor,Other', 1, '', 10, 100, 'text', '5.FEEDBACK / COLLECTION DETAILS', 7, NULL, '|PTP|'),
( 'AXIS1', 'PlaceAtContactd', 'PlaceAtContactEstablished', 'drop', 0, 'Resi,Office,Other', 1, '', 10, 100, 'text', '5.FEEDBACK / COLLECTION DETAILS', 8, NULL, '|PTP|'),
( 'AXIS1', 'Amount', 'AmountToBeCollected', 'text', 0, '', 1, '', 10, 100, 'text', '5.FEEDBACK / COLLECTION DETAILS', 9, NULL, '|PTP|'),
( 'AXIS1', 'OtherContact', 'OtherContactNumber', 'text', 0, '', 1, '', 10, 100, 'text', '5.FEEDBACK / COLLECTION DETAILS', 10, NULL, '|PTP|'),
( 'AXIS1', 'Remarks', 'Remarks', 'text', 0, '', 1, '', 10, 100, 'text', '5.FEEDBACK / COLLECTION DETAILS', 11, NULL, '|PTP|'),
( 'AXIS1', 'ContactedBy', 'ContactedBy', 'text', 0, '', 1, '', 10, 100, 'text', '5.FEEDBACK / COLLECTION DETAILS', 12, NULL, '|PTP|');

by **gmcust3** » Tue Mar 23, 2010 4:40 pm

Thnx Brett.

SQL works.

Now, In Vici, the way we do :

1) Login to Phone and Vici.
2) Click on Resume
3) Get Call. See Customer Details.
4) Once Done, Hang Up. Dispose and Submit.
5) Wait for Next Call.

But process flow in BuzzAgc is somewhat different ?

I keep clicking Hang Up, No effect..

I don't see any Customer Details.. when calls comes in..

and few other things ...

by **brett05** » Tue Mar 23, 2010 4:51 pm

first really i want to help you ,but this design have maybe MORE 80% of java and really i'am a php and sql person,but i have see this bug when i have test it.
for me i want to share may experience to work all together in vicidial also i have propose to add a google map in this interface i will do it soon.finally gmcust3 try to ask arvindsandilya24 i'am sure he will answer he is a good one .

by **arvindsandilya24** » Tue Mar 23, 2010 4:53 pm

hi gmcust3,

flow here is :
1) Click on Resume
2) When Call comes Dispo tab is activated. Click on it and you will see all the dispositions
3) you can also hangup from this screen if u like but you will be automatically hanged-up once u select a disposition.
4) next call will come.

----------------------
Now for the display of the customer information
1) you need to create the custom form using field_create.php
2) use the data loading page /agc/upload/ to load leads

Data loading steps :
1) Select campaign
2) select list id (created in Admin panel)
3) click on "Get Format" link to download the template Excel
4) fill the Excel and upload.. also fill the fields as displayed on the loading page.
(filling Name and MainPhone is required rest can be filled if needed, these are the excel headers for your campaign)

** /agc/upload/ folder should be writeable

by **gmcust3** » Tue Mar 23, 2010 4:55 pm

Arbind, can u pack one Zip File with a proper document, to make the thing work completely and make it in download format. Extra work for you but nice if we can also use and try yr nice interface. Last time It was gersky who developed and this time u..

Looks like we are missing some steps in bit and pieces .

by **brett05** » Tue Mar 23, 2010 5:01 pm

arvindsandilya24 wrote:hi gmcust3,

flow here is :
1) Click on Resume
2) When Call comes Dispo tab is activated. Click on it and you will see all the dispositions
3) you can also hangup from this screen if u like but you will be automatically hanged-up once u select a disposition.
4) next call will come.

----------------------
Now for the display of the customer information
1) you need to create the custom form using field_create.php
2) use the data loading page /agc/upload/ to load leads

Data loading steps :
1) Select campaign
2) select list id (created in Admin panel)
3) click on "Get Format" link to download the template Excel
4) fill the Excel and upload.. also fill the fields as displayed on the loading page.
(filling Name and MainPhone is required rest can be filled if needed, these are the excel headers for your campaign)

** /agc/upload/ folder should be writeable

arvindsandilya24 you have make interface agent all in one so why we need the admin interface lol

by **arvindsandilya24** » Tue Mar 23, 2010 5:11 pm

gmcust3,
will try to create a document and a single point admin page to do all this.

brett05,
Still have to move all non agent stuff to admin side, but for now it works.

data loading :

by **gmcust3** » Tue Mar 23, 2010 5:12 pm

After clicking CALL BACK, and RESUME, screen remain Green. Means call NOT getting disconnected ?

If I click on Logout.. It says There is still a Live Call.

Timer on Agent Information panel, keep going on..

Tried pressing HANG UP link but no change

Finally, had to CLOSE the screen ..

by **brett05** » Tue Mar 23, 2010 5:20 pm

great job arvindsandilya24
continue to add trunk line and the the other option of admin vicidial then mflorell will cry

this is called all in one interface agent

vicidial.org

COMPLETE - dynamic field creation within ViciDial

thanks

thanks

thanks

thanks

thanks

thanks

Who is online