 |
| << | August 2010 | >> |
| Su |
Mo |
Tu |
We |
Th |
Fr |
Sa |
| 1 |
2 |
3 |
4 |
5 |
6 |
7 |
| 8 |
9 |
10 |
11 |
12 |
13 |
14 |
| 15 |
16 |
17 |
18 |
19 |
20 |
21 |
| 22 |
23 |
24 |
25 |
26 |
27 |
28 |
| 29 |
30 |
31 |
|
|
|
|
|
 |
|
|
| Goto page 1, 2 Next |
 quixote1024 Post subject: VTiger and WebERP
|
Mon Jun 12, 2006 2:56 am
Posts: 13
Location: Ottawa, Canada
|
| |
 |
Hello all, and I hope this is the right forum for this posting ...
First and foremost, we think VTiger is a really fantastic product. It is a pleasure to recommend it to all of ourclients and to extol the benefits of open source to anyone who cares to listen. My colleague and I have been interested in both VTiger and WebERP for a while and have been following the discussions in both developer and user groups exploring the possibility of integrating the two applications.
We had a client who recently needed the functionality offered by both apps - taking advantage of the sales tools implemented in VTiger but with the inventory and manufacturing control, plus accounting support, provided by WebERP. The trick, of course, is coming up with a solution that allows both applications to continue to function as is while being able to share information stored in a common database.
We think we have come up with a solution and we have successfully managed to integrate several aspects of VTiger and WebERP. At the outset, I would like to state that it is just a hack at this time; however, it is a proof of concept that the two applications can function together.
So far, we have managed to accomplish the following:
- both WebERP and VTiger can easily be installed in the same database. In this case, VTiger was installed into the WebERP database. - the account information in VTiger and the "customer / branch" information in WebERP are now fully integrated. Additions and edits in either application are instantly available in the other (although for control purposes, on WebERP can delete at this time).
- VTiger now pulls product information, standard pricing, and quantity in stock information from WebERP (read only in VTiger, although VTiger can still create custom pricebooks and set custom pricing)
- we are just finishing the sales order integration, where VTiger sales orders are posted to WebERP. When an order is fulfilled and an invoice created in WebERP in response to the sales order, it is then listed in VTiger.
It is important to note that the necessary modifications span both applications and hence cannot be easily provided in the form of a plug-in. Nevertheless, the required changes are fairly straightforward. There are some changes with the underlying tables (combining some fields, adding fields to other tables, etc.). There are changes and additions to the uitypes in VTiger and changes to a number of queries in the utils.php file, in addition to a number of other changes to various php files in both WebERP and VTiger.
We are interested in contributing our work to both communities and are looking for some advice on how best to proceed. We were wondering if there would be any interest among developers or users to pursue the idea of having WebERP and VTiger made compatible. Perhaps with some commonly set standards between the two applications, they could be made to automatically work together if they are installed together yet could continue to function as independent applications.
It is our belief that both programs working together creates a very powerful tool, leveraging each other's strengths to build a real competitor to commercial ERP solutions like MS Great Plains. We will be more than happy to share our findings and work with anyone who may be interested.
Thanks again - we love VTiger and will continue to contribute and support the community in any way we can.
Gareth Spanglett (gareth@agora-group.com) and Piotr R. Sidorowicz (prsidoro@mavericsolutions.ca)
|
|
|
|
|
 |
rasomu Post subject: Re: VTiger and WebERP
Senior Member
|
Wed Jun 14, 2006 12:27 pm
Posts: 132
Location: Valencia, Spain
|
| |
|
I think it's a great idea.
Please Vtiger Team, take a look on it when you can because it can create the most important open source business program ever (IMHO).
Well done.
|
|
|
|
quixote1024 Post subject: Re: VTiger and WebERP
|
Thu Jun 15, 2006 3:48 pm
Posts: 13
Location: Ottawa, Canada
|
| |
|
Sorry for the delay, but I have put up the first part of our work integrating VTiger and webERP. Because I am double-checking and refining things as I go, I will do this in parts. This first part ties together account information in VTiger and customer/branch information in webERP. Hopefully by tonight or tomorrow, I will have the inventory/pricing/quantity integration notes and demo. The sales order/invoicing part will be completed over the weekend.
I've set up a little site with all my notes and specific files that were edited at: http://testbed2.agora2.com The VTiger demo is at http://testbed2.agora2.com/vtiger_crm (user/pass: admin/admin) and the webERP demo is at http://testbed2.agora2.com/webERP (user/pass: demo/weberp).
In total, my edits so far only affect 5 files - 4 in VTiger (although one more file is to be edited for the VTiger new account save routine) and one in webERP. The notes I've uploaded have all the details including line numbers of edits in the modified files, sql queries, table changes, etc. Copies of all modified files are up as well.
Of importance to VTiger, the bulk of the changes occured at the MySQL table level, particularly the changes and additions to the 'field' table. Most other changes were in utils.php involving uitypes. Although the tables have changed, the addition of the 'accountid' field to the webERP table allows VTiger accounts to continue to function virtually 'as is'.
Constructive criticisms, comments, suggestions or contributions are always appreciated.
Gareth.
ps - I will cross-post this in the users forum as well, G.
_________________
Mahsie Open Source Solutions Inc.
155B Loretta Ave. N.
Ottawa ON K1Y 2J7 Canada
613-216-2045
www.mahsie.com
|
|
|
|
gerardo Post subject: Re: VTiger and WebERP
|
Fri Jun 16, 2006 5:35 pm
Posts: 28
|
| |
|
Congratulations!!!!!
It's a great work, at this moment the accounts's needes require of the integration of those type of solutions to performance their diferent process(sales, purchasing, inventory, GL).
I hope many people have inerested of this new project , the comunity will be very greatful with you.
Thanks & Regards
|
|
|
|
codyheit Post subject: Re: VTiger and WebERP
Senior Member
|
Sat Jun 17, 2006 3:51 pm
Posts: 318
|
| |
|
I think that vtiger is becoming such a good program that we wouldn't need to do any integration if we designed a few new modules.
For example the ability to have a simple chart of accounts and to enter vendor bills.
What do people think?
Or you could use this software:
http://www.enterprisegroupwaresystem.org
Which already has vtiger and weberp integrated
|
|
|
|
kiang Post subject: Re: VTiger and WebERP
|
Sun Jun 18, 2006 4:41 pm
Posts: 54
|
| |
|
| codyheit wrote: | I think that vtiger is becoming such a good program that we wouldn't need to do any integration if we designed a few new modules.
For example the ability to have a simple chart of accounts and to enter vendor bills.
What do people think?
Or you could use this software:
http://www.enterprisegroupwaresystem.org
Which already has vtiger and weberp integrated |
EGS didn't announce that they are trying to integrate the two projects. I could only find the information about EGS did merge webERP into their project.
_________________
|
|
|
|
Phil Daintree Post subject: Re: VTiger and WebERP
Guest
|
Tue Jul 25, 2006 3:44 am
|
| |
|
I am the lead developer on webERP.
There is only value in including the necessary code in webERP if the code is also included with vtiger. I thought a parameter to enable or disable the integration would suit so that should the applications be run separately and no integration required then the interfacing could be turned off.
I tend to think the sum is greater than the parts so an interface like this is really good stuff for both communities.
Phil
|
|
|
|
ksasser Post subject: Re: VTiger and WebERP
Guest
|
Tue Aug 29, 2006 1:51 pm
|
| |
|
We're running the webERP + Vtiger integration at the office, and there is a potentially catastrohpic problem with the way vTiger handles accounts. It's a simple fix but I thought I would put it here so that people could be aware of it.
The problem is basically that vTiger will actually delete the row from custbranch, which will really mess weberp up. If you accidentally delete a row, you will have to figure out what it was and manually place it back into the database (with appropriate branchcodes, etc).
The simple work around that we did was to simply comment out the line in VTIGERROOT/modules/Accounts/Delete.php that contains the sql statement:
// $sql ='delete from custbranch where accountid = '.$_REQUEST['record'];
Vtiger has a field in table 'crmentity' called 'deleted', and if set to =1 it will not show the record in vtiger, will still allow weberp to pull the records appropriatedly and generally just play a lot nicer than originally.
I'll CC this over to the vtiger.com discussion, but figured that a lot of people here would like this information as well.
Kyle Sasser
|
|
|
|
turkpipotutunu Post subject: Re: VTiger and WebERP
|
Sun Jul 08, 2007 7:08 pm
Posts: 1
|
| |
|
Hi all,
I see the latest posts on that matter are a it outdated by now but I am one of those wanting to benefit from both worlds vTiger + webERP...
After reading the various posts, i would like to hav ome kind of answer on the following points :
* Is there any kind of solution to integrate both products, and if yes, any ready-made package ?
* What is the scope of that integration ?
* Does the swith "vTiger Integration" in weberp actually do anything ?
* If no ready made package is available is there any step-by-step howto to make it happen ?
Thanks...
Laurent
|
|
|
|
HenVog Post subject: Re: VTiger and WebERP
Senior Member
|
Wed Jul 25, 2007 2:51 pm
Posts: 190
|
| |
|
I just read about this topic and looked for over two hours at webERP..
It would be (IMHO) the most suitable Open Source Business Application when it could be possible to combine these two tools.
I am looking forward to hear anything from this ...
|
|
|
|
|
|
| |
