ViciDial - Vtiger 7.1 Support

Discussions about new features or changes in existing features

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

ViciDial - Vtiger 7.1 Support

Postby mstopkey » Tue Oct 30, 2018 4:24 pm

Greetings all.
First off, Mr. Florell, do we have your permission to modify ViciDial Vtiger stuff? (we kinda already have)
What our goal is to make the Vtiger files/functions that come with ViciDial work with Vtiger 7.1. We have succeeded so far to some extent. We would like to submit all the code to ViciDial once finished and thoroughly tested to be included in releases and SVN from ViciDial group.
One of the MAJOR modifications we are working on is to move the Vtiger integration functions from System Settings to Campaign and Inbound Group settings. This way one instance of ViciDial can work with multiple instances and databases of Vtiger. (and here is a question) Do you have any "gotchas" to look out for on this?
ViciBox 7.0.4 | Version 2.14-694a | SVN Trunk | 2803| Asterisk 11.25.1-vici |Build 181005-1738 | DB Schema 1561 | 7 64bit Telephony servers | 3 64bit Web servers | 1 64bit Database server | 1 64bit Archive server
mstopkey
 
Posts: 146
Joined: Sun Dec 28, 2008 1:01 pm

Re: ViciDial - Vtiger 7.1 Support

Postby williamconley » Tue Oct 30, 2018 4:43 pm

When you have completed your task, generate DIFFs against the latest version of Vicidial and post those DIFFs at the Vicidial Issue Tracker (link at the top of this page). Then post a link to that issue tracker entry here for posterity.
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 17584
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: ViciDial - Vtiger 7.1 Support

Postby mflorell » Fri Nov 02, 2018 8:52 am

You certainly have my permission to work on the source code.

As for VTiger, its a mess, we have built a few simple PHP integration scripts in recent years, but the back-end is so unstable at moderate to high account volumes, and so much of the code changes with each revision that it's difficult to maintain the prior deep integration we used to support.

As for gotchas, they are all over the place. Before working with Vtiger I had no idea that people used 6 different ways of incrementing and storing counter variables in a database, but in Vtiger they use all 6 of those methods. And that's just one of the quirks that I ran into with Vtiger. We even had to write a crontab script that would run a couple times a minute to kill the orphan queries that would lock the vtiger database tables on the larger systems that our clients were using.
mflorell
Site Admin
 
Posts: 17067
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: ViciDial - Vtiger 7.1 Support

Postby mstopkey » Fri Nov 02, 2018 9:38 am

Wow, well we have run into a few of those and implemented some changes to Vtiger. We have had success in screen popping leads, accounts, organizations and vendors and inserting new leads. We have that down. We are currently working on Vtiger settings at the campaign level. I had a question, I am sure there is a logged in agent session campaign variable in ViciDial. Could you provide that variable for us? We are going to need it to identify which Vtiger a logged in agent should be pulling.
ViciBox 7.0.4 | Version 2.14-694a | SVN Trunk | 2803| Asterisk 11.25.1-vici |Build 181005-1738 | DB Schema 1561 | 7 64bit Telephony servers | 3 64bit Web servers | 1 64bit Database server | 1 64bit Archive server
mstopkey
 
Posts: 146
Joined: Sun Dec 28, 2008 1:01 pm

Re: ViciDial - Vtiger 7.1 Support

Postby mflorell » Sat Nov 03, 2018 10:07 am

What exactly are you looking for in a "logged in agent session campaign variable"?
mflorell
Site Admin
 
Posts: 17067
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: ViciDial - Vtiger 7.1 Support

Postby mstopkey » Mon Nov 05, 2018 8:35 am

We will need to pass the campaign_id of the campaign the agent logs into to perform a lookup of the that campaign's Vtiger settings.
ViciBox 7.0.4 | Version 2.14-694a | SVN Trunk | 2803| Asterisk 11.25.1-vici |Build 181005-1738 | DB Schema 1561 | 7 64bit Telephony servers | 3 64bit Web servers | 1 64bit Database server | 1 64bit Archive server
mstopkey
 
Posts: 146
Joined: Sun Dec 28, 2008 1:01 pm

Re: ViciDial - Vtiger 7.1 Support

Postby mflorell » Tue Nov 06, 2018 8:49 am

That would be "--A--campaign--B--" in the webform or script.
mflorell
Site Admin
 
Posts: 17067
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: ViciDial - Vtiger 7.1 Support

Postby mstopkey » Thu Nov 15, 2018 12:25 pm

Looking for suggestions. As for 1 instance of Vicigial supporting multiple instances of Vtiger through separate Inbound Group and Campaign Vtiger search PHP files, of course everything refers back to System Settings/Vtiger Settings. We have Vicidial working fine on Inbound Groups. Now we need to supply multiple Vtiger settings in Vicidial System Settings. Our current thinking is a reference DB table with a list of Vtiger Settings which would include Campaign ID so when agents login to a Vtiger enabled campaign, they are launched into that campaigns Vtiger instance. We are entertaining all ideas here.
Anny suggestions would be greatly appreciated.
ViciBox 7.0.4 | Version 2.14-694a | SVN Trunk | 2803| Asterisk 11.25.1-vici |Build 181005-1738 | DB Schema 1561 | 7 64bit Telephony servers | 3 64bit Web servers | 1 64bit Database server | 1 64bit Archive server
mstopkey
 
Posts: 146
Joined: Sun Dec 28, 2008 1:01 pm

Re: ViciDial - Vtiger 7.1 Support

Postby williamconley » Thu Nov 15, 2018 1:00 pm

multiple Vtiger settings

Move it to the campaign settings. Or even the user settings. But "System Settings" isn't a good place for "multiple". Although you could just use Settings Containers combined with "Web Form". Settings Containers for credentials/domain name and Web Form to identify which settings container to use on "this campaign".
Vicidial Installation and Repair, plus Hosting and Colocation
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 17584
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: ViciDial - Vtiger 7.1 Support

Postby mstopkey » Thu Nov 15, 2018 1:23 pm

Thanks William. We are leaning toward adding fields to campaign table, Altering any code that references system_settings to reference campaign table, supply a PHP code generator that when Vtiger settings are applied in campaign, the PHP generator creates that campaign's "campaign_id"_vtiger_search.php
ViciBox 7.0.4 | Version 2.14-694a | SVN Trunk | 2803| Asterisk 11.25.1-vici |Build 181005-1738 | DB Schema 1561 | 7 64bit Telephony servers | 3 64bit Web servers | 1 64bit Database server | 1 64bit Archive server
mstopkey
 
Posts: 146
Joined: Sun Dec 28, 2008 1:01 pm

Re: ViciDial - Vtiger 7.1 Support

Postby mstopkey » Thu Nov 15, 2018 1:24 pm

We have also improved on Vtiger's lookup performance from dialer with a database view in Vtiger which the search.php queries for lookups.
ViciBox 7.0.4 | Version 2.14-694a | SVN Trunk | 2803| Asterisk 11.25.1-vici |Build 181005-1738 | DB Schema 1561 | 7 64bit Telephony servers | 3 64bit Web servers | 1 64bit Database server | 1 64bit Archive server
mstopkey
 
Posts: 146
Joined: Sun Dec 28, 2008 1:01 pm

Re: ViciDial - Vtiger 7.1 Support

Postby mflorell » Thu Nov 15, 2018 2:57 pm

As a note, we've been moving a lot of configuration settings(like those you would used for campaign-based Vtiger) into Settings Containers. It's much more flexible and a lot less work to program in the interface, especially for something that could have a lot of settings.
mflorell
Site Admin
 
Posts: 17067
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: ViciDial - Vtiger 7.1 Support

Postby dspaan » Thu Nov 15, 2018 3:27 pm

Is the lastest Vtiger any good? I've been testing with SuiteCRM a bit. We just open Suite in an iframe in the Script tab and it looks great and you can have all the benefits of using your CRM while in a call (so also email the client). All that's needed is importing the phonenummers and uniqie CRM ID's into vicidial.
Regards, Dennis

Vicibox 8.0.1
Version: 2.14b0.5
SVN Version: 2951
DB Schema Version: 1540
dspaan
 
Posts: 1013
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Re: ViciDial - Vtiger 7.1 Support

Postby mstopkey » Thu Nov 15, 2018 5:17 pm

Thanks Matt, we will definitely look at that route. I think that along with what we are doing would probably work better.
ViciBox 7.0.4 | Version 2.14-694a | SVN Trunk | 2803| Asterisk 11.25.1-vici |Build 181005-1738 | DB Schema 1561 | 7 64bit Telephony servers | 3 64bit Web servers | 1 64bit Database server | 1 64bit Archive server
mstopkey
 
Posts: 146
Joined: Sun Dec 28, 2008 1:01 pm

Re: ViciDial - Vtiger 7.1 Support

Postby patelsaheb » Tue Nov 20, 2018 7:36 am

Greetings All,

I need help for vtiger7.1 integration with VICI. how i can do export to dialer function working.

thank you
patelsaheb
 
Posts: 2
Joined: Thu Nov 15, 2018 3:24 am

Re: ViciDial - Vtiger 7.1 Support

Postby mstopkey » Tue Nov 20, 2018 8:00 am

patelsaheb, I will post what we have done so far. We have it to the point of functioning with single instance of Vtiger. No user synchronization. No click to dial from Vtiger but inbound and outbound screen pop and insert new lead is working. As for users, we just create same user and password in Vtiger as in dialer. In our case only 20% of users need Vtiger. There are many changes to make in Vtiger and Vicidial's vtiger_search.php. We create a vtiger_search.php for each campaign and name is like camp_ID_search.php.
ViciBox 7.0.4 | Version 2.14-694a | SVN Trunk | 2803| Asterisk 11.25.1-vici |Build 181005-1738 | DB Schema 1561 | 7 64bit Telephony servers | 3 64bit Web servers | 1 64bit Database server | 1 64bit Archive server
mstopkey
 
Posts: 146
Joined: Sun Dec 28, 2008 1:01 pm


Return to Features

Who is online

Users browsing this forum: No registered users and 7 guests