Custom List Fields Feature has been committed to SVN trunk!

Discussions about development of VICIDIAL and astGUIclient

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Custom List Fields Feature has been committed to SVN trunk!

Postby mflorell » Fri Jul 02, 2010 3:17 pm

The Admin and Agent portions of the Custom List Fields feature are done(lead loader is not complete yet) and ready for you to test in SVN/trunk.

look below for example screens.

To activate you need to enable custom fields in system settings, then
you can go to the Lists section to add custom fields to a list. The
fields are tied to a list, not a campaign, and they can be displayed
in a new tab in the agent interface, and there is a new option to have
the Get Call Launch open this custom fields tab upon a call being sent
to the agent. Also, the Calls Export Report and the List Download
feature include the custom fields values for the leads exported. You
can import custom field data through the web-based lead loader in TXT
and CSV format(you must set a list ID override and you must select
Custom Format). You can also use the non-agent API add_lead function,
(see the NON-AGENT_API.txt doc for more info). You can also use the
third gen lead loader to import leads with custom files in several
other formats.



Here is a screenshot of an example set of custom fields in the agent interface:
http://www.vicidial.org/images/agent_custom_fields.jpg

Here is a sample page of the admin portion of the custom fields administration:
http://www.vicidial.org/vicidial_demo/a ... custom.htm


You can also use the default fields from vicidial_list in your custom fields screen.

EDIT- Added custom field loading ability through web-based lead loader for CSV and TXT formats and though non-agent API.
Last edited by mflorell on Mon Oct 04, 2010 8:26 am, edited 4 times in total.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby ruben23 » Fri Jul 02, 2010 5:21 pm

how to have this features on my existing 2.4 svn install.. :(
SkypeID: rlacumba
IBM x3200 Dual Core 2.4 Ghz.
4GB Ram
VERSION: 2.4-311a
BUILD: 110514-1351
© 2011 ViciDial Group
Asterisk 1.4.27-vici
Another VICI_day, same trunK, same Channel-->Transcode...
ruben23
 
Posts: 1161
Joined: Thu Jul 31, 2008 10:35 am
Location: Davao City, Philippines

Postby mflorell » Fri Jul 02, 2010 7:41 pm

cd /usr/src/astguiclient/trunk
svn update
perl install.pl

read the UPGRADE doc to see what has changed since your current version

And make sure you run the upgrade on the database!

Then kill all of the screen sessions(don't do this while you are in production of course)

Start Asterisk back up with the start_asterisk_boot.pl script

Then you should be good to go.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby brett05 » Fri Jul 02, 2010 8:49 pm

WAW GREAT mflorell THIS FEATRES I WAS WAITING IT
congratulation mflorell
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 Trying » Sat Jul 03, 2010 3:55 am

You can also use the default fields from vicidial_list in your custom fields screen.


Please explain how this is done?
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby gmcust3 » Sat Jul 03, 2010 5:42 am

Awesome !!

Now, companies in India will understand the pain in their ar*e who changes layout of Vici and sell them in their name. Now, they have to redo everything as they are NOT in tandem with Updated Vici !!!

Matt , you are Great !!
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 » Sat Jul 03, 2010 9:11 am

Trying wrote:
You can also use the default fields from vicidial_list in your custom fields screen.


Please explain how this is done?



It's easy, just use the MySQL field name as a field label in custom fields(this is explained in the help) and make sure you leave it as a TEXT field type. After you have added it, it will show up as red in the custom field summary.

In the screenshot the Contact ID field is actually the vendor_lead_code field and it is displaying that value from the vicidial_list table in the example.

So, in the end you can customize the screen almost any way you want using both default fields and custom fields together.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby Trying » Sat Jul 03, 2010 9:35 am

Wow, it just gets better and better! :D
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby Trying » Sat Jul 03, 2010 10:03 am

So when it is a default field that you are using within the custom fields section and you add and/or edit information, will it also automatically update the default field? Meaning the agent can edit ONLY in the custom field form without having the need to go back to the default page?
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby mflorell » Sat Jul 03, 2010 12:13 pm

Yes and Yes
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby Trying » Sun Jul 04, 2010 6:28 am

It will be useful to have the default "comments" field, which can also be used in the custom fields section, store and display previous comments per disposition, user, date and time.

For example, user Kevins phoned the client and his comment is that the client needs to discuss the product with his wife. When a second agent, Pierred, phones the client he can view the previous comment by Kevins without being able to edit it. He can however add his own comment.

It will look something like this:

Client wants to speak to his wife - Kevins - Callback - 04/07/2010 - 13:46
He asked me to phone him in 30 min - Pierred - Callback - 05/07/2010 - 10:23
Closed the sale. QC please ensure you phone him before delivery - Johns - Sale - 06/07/2010 - 16:18

This will also be useful for the QC feature when done. The sales agent and QC agent can see each others comments.

Please get the correct bank account details as the account number is invalid - Janeb (QC) - Incomplete - 07/07/2010 - 09:02
Bank account number corrected - Johns - Sale - 07/07/2010 - 13:15
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby mflorell » Sun Jul 04, 2010 7:46 am

I believe there is already a feature request for that, and it is not within the scope of the custom fields project.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby mflorell » Sun Jul 04, 2010 11:41 am

Small update:

I just added the ability to include custom fields data when using the add_lead function in the Non-agent API.

Also, you can see and edit custom fields data for a specific lead using the lead modification page.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby mflorell » Mon Jul 05, 2010 6:44 pm

Another small update:

Added ability to use custom fields through the web-based lead loader when using TXT(tab or pipe delimited) or CSV(comma separated values) files(but not with XLS files).

Custom fields must already be defined in the List Custom Fields section, and you need to use a List ID Override as well as Custom Format when on the lead loading page.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

thanks

Postby brett05 » Tue Jul 06, 2010 7:14 am

day after day vicidial is the power really thanks vicidial
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 mflorell » Tue Jul 13, 2010 2:12 am

To make it easier to allow leads to be moved to other list IDs I have added a field to vicidial_list: entry_list_id

This is used by the system when importing leads with custom fields as well as when custom fields are populated after they have not been populated. Then even if the list_id field is changed, the list ID that custom fields data was loaded into will be preserved and used to show the populated custom fields for that lead.

This was just committed to SVN/trunk tonight.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby gerald_lyc » Mon Sep 06, 2010 5:29 pm

is there any detailed doc on how to use the agent_custom_fields?
gerald_lyc
 
Posts: 59
Joined: Fri May 21, 2010 5:44 pm

Postby mflorell » Mon Sep 06, 2010 7:47 pm

Not yet, I am working on that for the 2.4 manager manual though. Until then there is the HELP in the admin interface and the postings here on the forum.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby DarknessBBB » Thu Sep 09, 2010 11:18 am

Trying wrote:It will be useful to have the default "comments" field, which can also be used in the custom fields section, store and display previous comments per disposition, user, date and time.

For example, user Kevins phoned the client and his comment is that the client needs to discuss the product with his wife. When a second agent, Pierred, phones the client he can view the previous comment by Kevins without being able to edit it. He can however add his own comment.

It will look something like this:

Client wants to speak to his wife - Kevins - Callback - 04/07/2010 - 13:46
He asked me to phone him in 30 min - Pierred - Callback - 05/07/2010 - 10:23
Closed the sale. QC please ensure you phone him before delivery - Johns - Sale - 06/07/2010 - 16:18

This will also be useful for the QC feature when done. The sales agent and QC agent can see each others comments.

Please get the correct bank account details as the account number is invalid - Janeb (QC) - Incomplete - 07/07/2010 - 09:02
Bank account number corrected - Johns - Sale - 07/07/2010 - 13:15


We have the same brain, my dear :D

http://www.vicidial.org/VICIDIALmantis/view.php?id=117
DarknessBBB
 
Posts: 328
Joined: Mon Jul 16, 2007 10:14 am

Postby Trying » Thu Sep 09, 2010 12:34 pm

Ahhh, nice one!
Vicibox Redux 3.1.14 64 bit
Asterisk: 1.4.39.2-vici | VERSION: 2.8-433a | BUILD: 140411-1434
Sangoma A102D/E1
Servers: 1 x Database; 1 x Web; 6 x Telephony; 2 x Archive
Outbound and blended ratio 3:1 with full voice recording
No additional software
Trying
 
Posts: 865
Joined: Sun Sep 09, 2007 8:41 am
Location: South Africa

Postby williamconley » Sun Oct 03, 2010 9:37 pm

Matt:
Here is a sample page of the admin portion of the custom fields administration:
http://www.vicidial.org/vicidial/admin_lists_custom.htm
(top of this post)

DEAD LINK :shock:
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby mflorell » Mon Oct 04, 2010 8:26 am

Link fixed, Thanks!
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby DarknessBBB » Tue Oct 05, 2010 3:13 pm

mflorell wrote:Another small update:

Added ability to use custom fields through the web-based lead loader when using TXT(tab or pipe delimited) or CSV(comma separated values) files(but not with XLS files).

Custom fields must already be defined in the List Custom Fields section, and you need to use a List ID Override as well as Custom Format when on the lead loading page.


Hi Matt, I cannot understand what custom fields have to be inserted in the TXT file. Obviously I have to insert the columns that have the same name of the custom fields. But, how can I link those data to preloaded leads? Adding the phone_number column ?
DarknessBBB
 
Posts: 328
Joined: Mon Jul 16, 2007 10:14 am

Postby williamconley » Tue Oct 05, 2010 3:32 pm

mflorell wrote:... Custom Format ...
instead of "Standard" you choose "Custom" and it should give you the ability to "Map"
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby DarknessBBB » Tue Oct 05, 2010 3:41 pm

williamconley wrote:
mflorell wrote:... Custom Format ...
instead of "Standard" you choose "Custom" and it should give you the ability to "Map"


Absolutely clear!
Thank you from Italy!!
DarknessBBB
 
Posts: 328
Joined: Mon Jul 16, 2007 10:14 am

Postby williamconley » Tue Oct 05, 2010 4:04 pm

hey, matt spent 15 seconds in this post. consider yourself "honored". if I can "translate" his quickie and he can fix 4 more people's problems ... :)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

SVN/Trunk 2.4.0

Postby alkinjay1 » Thu Nov 04, 2010 2:55 pm

We have a new business venture coming up in the next month that would require the use of the custom fields option. Is the trunk version ready for production? We are small business and I prefer to wait for the official release but it doesn't look like we will be able to wait this time.
alkinjay1
 
Posts: 31
Joined: Fri Jan 30, 2009 6:55 pm

Postby williamconley » Thu Nov 04, 2010 3:14 pm

ready for production
it's in use in several call centers. it works. but if you want to know if it's ready for production, you have to TEST it for yourself. ready for production is subjective.

install the latest SVN trunk code and test it out.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby mflorell » Thu Nov 04, 2010 4:27 pm

We have several clients using it in production right now.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

IE issue

Postby alkinjay1 » Thu Nov 04, 2010 6:44 pm

I'm looking over 2.4 on a test box now and it looks great. I am wondering how you get past Internet Explorers URL limit of 2048 characters? With a limitless amount of custom fields you could easily eat that up.
alkinjay1
 
Posts: 31
Joined: Fri Jan 30, 2009 6:55 pm

Postby williamconley » Thu Nov 04, 2010 8:47 pm

1) use short field names

2) learn to pass "id" information and security information only then and use the underlying php script in the receiving system to access the mysql data directly instead of passing it on the URL, and then you can do ANYTHING with the data.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby mflorell » Thu Nov 04, 2010 8:57 pm

or, don't use IE :)
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby gardo » Fri Nov 05, 2010 2:37 pm

Right on! Hehehe! 8)

mflorell wrote:or, don't use IE :)
http://goautodial.com
Empowering the next generation contact centers
gardo
 
Posts: 1926
Joined: Fri Sep 15, 2006 10:24 am
Location: Manila, 1004

Postby saidmsl » Sun Dec 12, 2010 5:09 am

Hi,

i'm trying to use custom fields , some questions ;
- how to use html code inside the name , ex: new line,
- how to use french accents
- do you plan to add a sort of basic workflow :

ex :
are you single or married ?
if yes => do you live with your parents
if no => do you rent or have your own house?

or do we still have to use limesurvey for that?

Thanks
saidmsl
 
Posts: 67
Joined: Mon Mar 15, 2010 9:21 pm

Postby mflorell » Sun Dec 12, 2010 1:54 pm

standard basic HTML like <BR> should work within Custom Fields.

At this time we do not have branching capability, if you want to do that you would have to use something like Lime Survey.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby williamconley » Sun Dec 12, 2010 3:06 pm

Since the form is "static", and branching would require "dynamic" forms ... that's a lime survey moment for sure. Or just a javascript application to determine which fields to show (and have all of them there, just not visible unless/until needed ...?)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby saidmsl » Sun Dec 12, 2010 10:39 pm

Thanks
it work fine (with more than 25 fields) , combined text, display, script, ....

i just noted an error while creating the fields :
if field is radio, it's not created in the custom_<list id> table, had to add them manually in mysql.
others types works
saidmsl
 
Posts: 67
Joined: Mon Mar 15, 2010 9:21 pm

Postby williamconley » Sun Dec 12, 2010 11:52 pm

If you can reproduce this error (and give step by step instructions to "cause/reproduce" this error!) you can help out a lot by placing this in the Issue Tracker at the top of this page.

then when it gets fixed ... you'll automatically get a notice! :)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby mflorell » Mon Dec 13, 2010 10:30 am

Yes, please post instructions on how to reproduce this, as well as your version and build of admin.php
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby dspaan » Wed Dec 15, 2010 7:26 pm

My compliments for this great feature Matt!

One suggestion for improving the documention is that before you can create the fields you need to give yourself the rights to do so. At first i could not see the custom fields list pages, it said 'You are not authorized to view this section'.
dspaan
 
Posts: 1374
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Next

Return to Development

Who is online

Users browsing this forum: No registered users and 19 guests