The Joomla! Forum™

Not too sure if anyone has tried to get vtiger5 and Joomla working but the chaps at vtiger have developed a bunch of bots, coms, and mods which, although still in dev, are matured enough to work

vtiger5 Joomla Module project can be found here: http://vtigerforge.fosslabs.com/frs/?group_id=12

The trick is to follow the following instructions (their wiki can be a bit confusing)

I assume that you installed your vtiger installation in http://www.xxx.com/vtiger

Use the v0.6 files available from the vtiger-joomla project

I download, install and publish, in Joomla, the bot_vconnector
http://vtigerforge.fosslabs.com/frs/?group_id=12
file bot_vconnection.tar.gz
* It is a system bot for Joomla

I've checked with the bot developer and the correct settings for the bot are

SOAP server - to the vtiger root (as it goes to check vtigerservice.php) so
http://www.xxxx.com/vtiger

Secured SOAP - to the soap directory
http://www.xxx.com/vtiger/soap

I also need to add these service file which are available http://vtigerforge.fosslabs.com/frs/?group_id=12
file soap.tar.gz - need to extract
Using my ftp client I upload the following
in /vtiger/soap

contact.php
fields.php
jdef.php
jinc.php
joomla.php
jportal.php
products.php
salesorder.php

Next I need to patch the vtigerservice file with vtigerservice.php.patch
(this file is included in soap.tar.gz)

As I don't have command line a simple cut and paste of the patch is possible
So I download the /vtiger/vtigerservice.php
Edit it in Editor (can be any)

The patch requires me to add to vtigerservice.php the line with the + sign.


{
include("soap/thunderbirdplugin.php");
}
+ elseif($_REQUEST['service'] == "joomla")
+ {
+ include_once("soap/joomla.php");
+ }
else
{
echo "No Service Configured for $_REQUEST[service]";

Once patched, I renamed the original vtigerservice.php to originalservice.php
and uploaded via my ftp the new vtigerservice.php to /vtiger

To note that within joomla I've also installed the
com_vregistration (to test synchronisation)
mod_vlogin
Com_products.... (see project files for all available plugins)

com_vregistration will get new user registration, add them as a contact within vtiger and as a user within Joomla.
I still have a little issue with Community Builder correctly accepting that a user has been validated ( the com_vregistration requires email activation and validation) but otherwise the tables are synched up nicely.

I'll add some more once I've gone through it all

Thanks for sharing this, sounds like it's starting to be really usable toogether, cool!

No worries, It's working well actually   

Remembering that you will need to use their mod_vlogin instead of the joomla default mod_login and synchronise users using their com_vregistration (registrations must be enabled within the global config of joomla).

The vtiger mod_lead sends potential lead info...
Here I'm having a little bit of trouble adding additional fields and getting it to synch up to the vtiger leads table (it's missing first name for example), you can see a post on the vtiger forums about this here

I've also managed to get their ticketing component  working.... called com_helpdesk
There are a few things that needs to be done to get it working

Three functionalities are available in com_helpdesk
1. Open a Ticket
2. List Tickets
3. Knowleade Database

You will need to create menu items for these and you'll need to choose Link to Component Item (com_helpdesk)
I then edited it directly in  myPHPAdmin to change the link to

For Open a Ticket: index.php?option=com_helpdesk&task=NewTicket
For List Tickets: index.php?option=com_helpdesk&task=ListTickets
For Knowledge Database: index.php?option=com_helpdesk&task=Kbase

If you have SEF on, then you'll need to tell it to accept Uppercase (not only lowercase)...

More to come on the Product component... which if it works should allow me to remove Virtuemart all together :-)
Why? Well vtiger CRM has Product and inventory capabilities and the Product component includes cart facility.
I should be able to list all my products within my CRM and have them listed in my Joomla front-end, my employees will then be able to updated only the CRM to do all the back-office stuff (new product lines, sales orders, invoicing etc).

The revolution will be Joomlavised :-)

Having been a fan of both Joomla and Vtiger myself I am finally getting around to trying the Vtiger bits and pieces again
(cannot pass up on the virtuemart tie in and it's a weekend)

thanks for the great writeup!

and as an aside, for those of you who are not familiar with it, the Vtiger5 CRM is absolutly outstanding!

(Its so nice NOT to have to hack the heck out of it to get it working under php5)

Worked like a charm and only took a few minutes to install everything!

hats off to Matthew Brichacek for this great set of tools!!

vtiger to joomla communication, registration, lead & login work

I'm still stuck on the salesorder and product side... but from what I understand the components are still under heavy dev (although Matthew has managed to get them working on his sandbox)..

Matthew's initial release note in the joomla forum: http://forum.joomla.org/index.php/topic ... #msg420537


If anyone wants to share their setup experience I'm interested too.
PM or Email me

Hi,

i try to integrate my vTiger 5.0.0 into my joomla! 1.0.11 ...

j0nathan wrote:
I've checked with the bot developer and the correct settings for the bot are

SOAP server - to the vtiger root (as it goes to check vtigerservice.php) so
http://www.xxxx.com/vtiger

Secured SOAP - to the soap directory
http://www.xxx.com/vtiger/soap

in which file do you set the quoted URLs? 

thanks for replay

greez
Idefiks

the urls do not go into a file, they go in the mambots config section within Joomla

in the Joomla admin go to mambots -> site mambots  -> Base Vtiger Connection Module

Thanks for replay ...

if i go to site mambots an click on "Base Vtiger Connection Module" i get an Error message "Restricted access"

any idea what's going wrong?

thanks
Idefiks

soudns to me like you need to install the latest mambots patch

http://forum.joomla.org/index.php/topic,89865.0.html

thanks .... it worked

Idefiks

Hi,

I have joomla and vtiger in my computer working (separatelly), but after installed everything strictly as mentioned in the first post my joomla site just halted. Joomla admin still works, but when I published the connection bot, the site just halted, and if I unpublish again the connection bot, the site don't halt anymore; but don't work also  it renders just nothing.

config:

soap server: http://localhost/vv/crm
soap secure server: http://localhost/vv/crm/soap

vtiger is installed on http://localhost/vv/crm and joomla on http://localhost/vv/home


Any ideas?

Thanks for your time and help.


Richard

Problem solved - in a strange way - but makes sense.

Changed the connection strings in Joomla admin:

http://localhost/vv/cm TO http://127.0.0.1/vv/crm


Anyway, let's see how it goes now. Thanks for your tutorial, it's better than the vtigerforge wiki, indeed.


Regards,
Richard.

j0nathan wrote:
If anyone wants to share their setup experience I'm interested too.
PM or Email me

Thank you for your instructions. I had successfully integrated them today. In fact, I am half-successfully. Because when I click the link of "Open a Ticket" on the menu which was linked to the URL

index.php?option=com_helpdesk&task=NewTicket

Then an error message appear instead of a normal page:

Fatal error: Cannot use string offset as an array in J:\xampp\htdocs\components\com_helpdesk\helpdesk.newticket.php on line 8

You can see that I am using XAMPP 1.5.4a as my localhost testing server. Joomla was installed just under the root of htdocs directory. And vTiger was installed at /vtiger folder. Both can run smoothly respectively. And the other two menu items, List Tickets and Knowledge Database, can work properly just as you predicted.

Could you please give me more help ? Thank you !

Not too sure what your problem is but looking at the helpdesk.newticket.php file

line 8 -> if($result[$i]['productid'] != '')

Try adding a product in vtiger and see then how it behaves

Hello,
i can do what i want, i don´t get it up and running. i have installed Vtiger localhost:81 and joomla at localhost:81/joomla. So i have the joomla folder INSIDE the vtigerCRM folder. Following exactly the instructions above , i still get to the point where i publish and get an "Connection to vtiger failed" message. When i unpublish the Base bot joomla shows up and everything is fine. I´ve tried to change localhost to 127.0.0.1 , patched the vtigerservice.php but still only the error message comes up. I run vtiger 5.0.2 german and joomla 1.0.11 with mambot patch. Does anybody have the same experience or is there an conclusion to this issue?

tIA

Don't use vtiger 5.0.2
use vtiger 5.0.0 or 5.0.1

The 5.0.2 patch us unstable and actually created new bugs.
As a result vtiger will release a 5.0.3 before year end, once they do, we will then work on testing it against the vtiger to joomla components and mods and update the code as necessary....

I am using JSAS on my laptop, for demonstration purposes for clients and meetings. I have now got Vtiger running in a /vtiger diretory on one of the joomla installations. I am not trying to integrate the two, and have installed all the joomla extensions. Vtiger seems to run fine on its own, also joomla.
I am having a few problems with the integration, when I try to list the tickets through joomla, the message is that there are no tickets, even though there are. If I issue a ticket through joomla, it does however display in the vtiger backend. I can view products in the shopping cart through joomla, and put a sales order in. But if I try to view the sales orders in joomla the message says that I need to put items into the cart.
I have now just seen that we should be using vtiger 5.0.0 or 5.0.1 and not 5.0.2 which is what I am using. Where does one get an older version of vtiger then? I have been to vtiger.com, and into the archive on their site, but I dont get an option to download one of these versions.
Does anyone actually have this vtiger integration with joomla working yet?

- Francois

As discussed in the forum, some of the functionalities work, some don't

coms and mods for registration, lead, product, helpdesk work
salesorder, shopping cart don't

Try the sourceforge and get vtiger patch 1 there.
https://sourceforge.net/project/showfil ... _id=117522

Hello, I'm brand new to vitiger and currently use Virtuemart as my cart.  I'm wondering what the status of this integration is and if there is a well written how-to.  Also what functionality it will gain me and my customers.
Thanks
Troy

Hi everyone... been joomla user for awhile, and neve had to make a post until now.


I setup the connection then loaded Lead form.. all seems to be working, but nothing is showing up for leads in the Vtiger end.

I'm running vtiger on a differnt server then joomla, would this be the problem?

Or am I missing something, I read something about synchronising with vtiger, but can't find this in joomla anywhere.

Any ideas?

Thank you.

This is for the LEAD moudle that sends possible leads from a form in Joomla to yoru vTiger CRM.

Patched Vtiger 5.0.2 with 5.0.3 then in vtiger/modules/emails/emails.php on line 436 I changed

function get_to_emailids($module) TO function get_to_emailids2($module)

This function is duplicated in another class email.php

Once that was done it worked, but you have to patch 5.0.3 as it also has method errors.

Please note, you can't see the errors I had to use Zend with server side debugging to dig down into the debug returns.

Cheers

N6REJ wrote: Hello, I'm brand new to vitiger and currently use Virtuemart as my cart.  I'm wondering what the status of this integration is and if there is a well written how-to.  Also what functionality it will gain me and my customers.
Thanks
Troy

N6Rej, funky name :-)

Vtiger is a CRM  and different to an e-commerce component.
CRMs are mostly for sales force automation, order & inventory management, marketing and ticketing.
We're trying to integrate some e-commerce functionality but still quite a long way to go, we actually need devs with some interest in this project to come to assist... if anyone is interested let us know on the vtiger forum https://vtigerforge.fosslabs.com/projec ... a-modules/

Jonathon

Thanks so much for your post, I have printed it and braced myself to do a hookup with Joomla and VTiger.

Can I suggest we get child forum under Integration Development just for VTiger? It seems to be the only viable, fully FREE, open source CRM right now so we should beef up the support for it.

Thanks for the link to the VTiger forum that documents Joomla integration at http://vtigerforge.fosslabs.com/project ... a-modules/

Well done

Cheers
Mark

btw, all the above functions with joomla 1.0.12 in case you wondered...

I have been trying the LEAD module with 1.0.12 and it wasn't working did something change?

I had to change an issue on vtiger side like I said above but I loose the 'Create Lead' from the firefox toolbar. Is this fixed with vtiger now?

Thanks

Derek

HELP

I am doing a test installation on my local machine. I am using WAMP 5 1.6.6,  Here's what I have done so far:

1.1) Locate the files needed for integrating VTiger and Joomla by going to: http://vtigerforge.fosslabs.com/frs/?group_id=12 . This is the VTiger5 Joomla Module project home page. Use the v0.6 files available from the vtiger-joomla project as shown below:

1.2) Download all of these files and put them in a folder on your PC.

Step 2) Install the Modules into Joomla

2.1) Log into your Joomla admin panel and go to >Installers>Mambots and install the file titled “bot_vconnection.tar.gz” .This is the VTiger system bot for Joomla.

2.2) Make sure it is “published” in your admin panel by going to >Mambots>Mambot Manager>Base Vtiger Connection Module and select “publish” and save.

BUT I am stuck on this line:

I assume that you installed your vtiger installation in http://www.xxx.com/vtiger

How do I do that? Do I create a directory and install something at http://www.xxx.com/vtiger which for me would be http://www.localhost.com/vtiger?

By the way Jonathon, I am so happy with your instructions that I am rewriting them for an associate which explains the text above. If its ok with you I may submit my final "dummies guide to installation of VTiger in Joomla" to you. I must have step by step instructions and pictures help, so i am including screenshots

Many kudos - I am watching this post now

Cheers

Mark

Marc,

Best would be to have a chat on the tel or Skype... I'll send you a PM with my details...  In the mean time...

Wampserver 5 1.6.6 uses PHP 5.2 I believe... Be careful as I have not tested the integration with that version.
I would recommend using WAMPserver version 1.6.5 which uses PHP 5.1.6

Vtiger... you need to install it locally too so go and download it from the vtiger site... and choose the LAMP/WAMP version
And choose VERSION 5.0.1 NOT 5.0.2 (too many bugs in 5.0.2)
In you local www folder extract vtiger and install following instructions

What I mean by http://www.xxx.com/vtiger (xxx being the name of your domain) is that I assume that you've installed vtiger in the folder /vtiger of your root... so in wamp you'll want to install vtiger in www/vtiger...  On you localhost it will be seen as http://localhost/vtiger
if you're installing vtiger in a sub folder then it's http://xxx/yyy/vtiger ... Catch my drift :-)

Regarding the dummies guide...
I will, in the next three weeks or so, complete with the developers the integration of the sales order management mods.
Once complete and stable, I will be write a complete manual. However I'm happy for you to start and we can then amalgate both into a complete document.

Jonathan

ledneonflex wrote: This is for the LEAD moudle that sends possible leads from a form in Joomla to yoru vTiger CRM.
Patched Vtiger 5.0.2 with 5.0.3 then in vtiger/modules/emails/emails.php on line 436 I changed
function get_to_emailids($module) TO function get_to_emailids2($module)
This function is duplicated in another class email.php
Once that was done it worked, but you have to patch 5.0.3 as it also has method errors.
Please note, you can't see the errors I had to use Zend with server side debugging to dig down into the debug returns.
Cheers

ledneonflex... two things...

1. vtiger patch 5.0.3 is still in RC believe, so it's a bit early to use it for the integration to Joomla using the joomla modules project.

2. Mod Lead (just so we don't have any misunderstanding)
From what I understand in the vtiger forums, rhoobler has created a seperate webforms lead module called com_vtwebform.zip and released it to the community read here.
I believe you are referring above to to com_vtwebform

This is a seperate development module to the mod_lead created by Matt Brichacek and I only refer to the mod_lead in my write up above.

I have not tested com_vtwebform but it looks very promising...

Hi Jonathon

Yes, I will get started on the manual and we can collaborate. All these instructions are kinda hard to follow so this should help a bunch. Any word from the Joomla Forum on getting a VTiger child forum?

Regards
Mark