weberp vtiger integration

View: New views
19 Messages — Rating Filter:   Alert me  

weberp vtiger integration

by JoaoBR :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

hi
somebody can give me some advice on this? The weberp 3.05 option regarding
vtiger integration is still not enough to share  data like suppliers and
customers right? Where is my starting point? Full work like this thread
describes (http://forums.vtiger.com/viewtopic.php?t=8480&start=0) is
still necessary or is there a shortcut?

thank's
--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by weberp :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Gareth has not been able to get to this we are waiting for him to contribute
his work in a format we can use. He's promised to do this but that was before
Christmas.
It may not eventuate and if you want to pick this up he has posted his work
and provided a link to it noted in the earlier email you mention.

Phil

On Monday 19 February 2007 01:55, JoaoBR wrote:
> hi
> somebody can give me some advice on this? The weberp 3.05 option regarding
> vtiger integration is still not enough to share  data like suppliers and
> customers right? Where is my starting point? Full work like this thread
> describes (http://forums.vtiger.com/viewtopic.php?t=8480&start=0) is
> still necessary or is there a shortcut?
>
> thank's

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by JoaoBR :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Monday 19 February 2007 04:35, Phil Daintree wrote:
> Gareth has not been able to get to this we are waiting for him to
> contribute his work in a format we can use. He's promised to do this but
> that was before Christmas.
> It may not eventuate and if you want to pick this up he has posted his work
> and provided a link to it noted in the earlier email you mention.
>


I spend my weekend on this. Who did the integration option so I could talk to
him? Seems only the following files are touched so far

./CustomerBranches.php
./SelectOrderItems.php
./SystemParameters.php
./includes/DefineCartClass.php

in some occasions was missing the vtiger_ table prefix but still so it is far
not enough. I think without a common customer, supplier, products tables it
does not make sense unless weberp checks the final purchase and sales order  
in the vtiger tables and import them accordingly.
I am not sure but my first impression is that the full integration is not
reliable since weberp treats customers with branches and vtiger not. But
maybe some more input here could clear things up. Are there other people
which worked on this already?

>


> Phil
>
> On Monday 19 February 2007 01:55, JoaoBR wrote:
> > hi
> > somebody can give me some advice on this? The weberp 3.05 option
> > regarding vtiger integration is still not enough to share  data like
> > suppliers and customers right? Where is my starting point? Full work like
> > this thread describes
> > (http://forums.vtiger.com/viewtopic.php?t=8480&start=0) is still
> > necessary or is there a shortcut?
> >
> > thank's
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
>
>
>
> A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
> segura. Service fornecido pelo Datacenter Matik
> https://datacenter.matik.com.br

--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by steve-42 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I believe what has been done is on our wiki under 3rd party development.
There should be a package that contains a previous version of webERP along
with a previous version of vtiger ready to install and use.  However, there
are some glitches and restrictions I believe.  Also I believe it does
certain things but others it currently does not do.  Not sure but others may
be able to help once you get and try that package.

Steve

-----Original Message-----
From: web-erp-developers-bounces@...
[mailto:web-erp-developers-bounces@...] On Behalf Of
JoaoBR
Sent: Sunday, February 18, 2007 7:55 AM
To: webERP Developers
Subject: [WebERP-developers] weberp vtiger integration

hi
somebody can give me some advice on this? The weberp 3.05 option regarding
vtiger integration is still not enough to share  data like suppliers and
customers right? Where is my starting point? Full work like this thread
describes (http://forums.vtiger.com/viewtopic.php?t=8480&start=0) is
still necessary or is there a shortcut?

thank's
--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
5:40 PM
 

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
5:40 PM
 


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by steve-42 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

If I remember correctly it was only meant to connect customer. supplier and
item information.  I don't think it was meant to bring orders from one to
the other.  Anyway, Gareth could tell you best or looking through what he
provided.

Steve

-----Original Message-----
From: web-erp-developers-bounces@...
[mailto:web-erp-developers-bounces@...] On Behalf Of
JoaoBR
Sent: Monday, February 19, 2007 8:25 AM
To: webERP Developers
Subject: Re: [WebERP-developers] weberp vtiger integration

On Monday 19 February 2007 04:35, Phil Daintree wrote:
> Gareth has not been able to get to this we are waiting for him to
> contribute his work in a format we can use. He's promised to do this but
> that was before Christmas.
> It may not eventuate and if you want to pick this up he has posted his
work
> and provided a link to it noted in the earlier email you mention.
>


I spend my weekend on this. Who did the integration option so I could talk
to
him? Seems only the following files are touched so far

./CustomerBranches.php
./SelectOrderItems.php
./SystemParameters.php
./includes/DefineCartClass.php

in some occasions was missing the vtiger_ table prefix but still so it is
far
not enough. I think without a common customer, supplier, products tables it
does not make sense unless weberp checks the final purchase and sales order

in the vtiger tables and import them accordingly.
I am not sure but my first impression is that the full integration is not
reliable since weberp treats customers with branches and vtiger not. But
maybe some more input here could clear things up. Are there other people
which worked on this already?

>


> Phil
>
> On Monday 19 February 2007 01:55, JoaoBR wrote:
> > hi
> > somebody can give me some advice on this? The weberp 3.05 option
> > regarding vtiger integration is still not enough to share  data like
> > suppliers and customers right? Where is my starting point? Full work
like

> > this thread describes
> > (http://forums.vtiger.com/viewtopic.php?t=8480&start=0) is still
> > necessary or is there a shortcut?
> >
> > thank's
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
>
>
>
> A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
> segura. Service fornecido pelo Datacenter Matik
> https://datacenter.matik.com.br

--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
5:40 PM
 

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
5:40 PM
 


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by JoaoBR :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Monday 19 February 2007 14:31, Steve wrote:
> I believe what has been done is on our wiki under 3rd party development.
> There should be a package that contains a previous version of webERP along
> with a previous version of vtiger ready to install and use.  However, there
> are some glitches and restrictions I believe.  Also I believe it does
> certain things but others it currently does not do.  Not sure but others
> may be able to help once you get and try that package.


would you mind to send me the wiki url because I can not find it

thank's


--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by steve-42 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Huh, I could have sworn Gareth's webERP-vtiger combination was in 3rd party
on the webERP wiki.  Phil, do you know where it is?  Now, I have a copy as I
keep a copy of just about everything including webERP 0.2.7...hehe...only
that copy could be older than what he's done since.

Gareth, where are you?...

Steve

-----Original Message-----
From: web-erp-developers-bounces@...
[mailto:web-erp-developers-bounces@...] On Behalf Of Steve
Sent: Monday, February 19, 2007 11:32 AM
To: 'webERP Developers'
Subject: Re: [WebERP-developers] weberp vtiger integration

I believe what has been done is on our wiki under 3rd party development.
There should be a package that contains a previous version of webERP along
with a previous version of vtiger ready to install and use.  However, there
are some glitches and restrictions I believe.  Also I believe it does
certain things but others it currently does not do.  Not sure but others may
be able to help once you get and try that package.

Steve

-----Original Message-----
From: web-erp-developers-bounces@...
[mailto:web-erp-developers-bounces@...] On Behalf Of
JoaoBR
Sent: Sunday, February 18, 2007 7:55 AM
To: webERP Developers
Subject: [WebERP-developers] weberp vtiger integration

hi
somebody can give me some advice on this? The weberp 3.05 option regarding
vtiger integration is still not enough to share  data like suppliers and
customers right? Where is my starting point? Full work like this thread
describes (http://forums.vtiger.com/viewtopic.php?t=8480&start=0) is
still necessary or is there a shortcut?

thank's
--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
5:40 PM
 

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
5:40 PM
 


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
5:40 PM
 

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
5:40 PM
 


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by JoaoBR :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Monday 19 February 2007 15:27, Steve wrote:
> Huh, I could have sworn Gareth's webERP-vtiger combination was in 3rd party
> on the webERP wiki.  Phil, do you know where it is?  Now, I have a copy as
> I keep a copy of just about everything including webERP 0.2.7...hehe...only
> that copy could be older than what he's done since.
>

ok no problem, also vtiger had a greater version bump recently so it might not
be worse looking up the old stuff because it might not be valid any more


> Gareth, where are you?...
>
> Steve
>
> -----Original Message-----
> From: web-erp-developers-bounces@...
> [mailto:web-erp-developers-bounces@...] On Behalf Of
> Steve Sent: Monday, February 19, 2007 11:32 AM
> To: 'webERP Developers'
> Subject: Re: [WebERP-developers] weberp vtiger integration
>
> I believe what has been done is on our wiki under 3rd party development.
> There should be a package that contains a previous version of webERP along
> with a previous version of vtiger ready to install and use.  However, there
> are some glitches and restrictions I believe.  Also I believe it does
> certain things but others it currently does not do.  Not sure but others
> may be able to help once you get and try that package.
>
> Steve
>
> -----Original Message-----
> From: web-erp-developers-bounces@...
> [mailto:web-erp-developers-bounces@...] On Behalf Of
> JoaoBR
> Sent: Sunday, February 18, 2007 7:55 AM
> To: webERP Developers
> Subject: [WebERP-developers] weberp vtiger integration
>
> hi
> somebody can give me some advice on this? The weberp 3.05 option regarding
> vtiger integration is still not enough to share  data like suppliers and
> customers right? Where is my starting point? Full work like this thread
> describes (http://forums.vtiger.com/viewtopic.php?t=8480&start=0) is
> still necessary or is there a shortcut?
>
> thank's
> --
>
> João
>
>
>
>
>
>
>
> A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
> segura.
> Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
> 5:40 PM
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
> 5:40 PM
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
> 5:40 PM

--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by Gareth Spanglett :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hey all,

So sorry for the absence and I have a lot of news on a variety of
fronts.  First of all, Phil:  sorry for all the delays.  The integration
is stable enough for me to finally get to the code for the on/off switch.

I have the latest demo up and running:  demo.mahsie.com    The source
code is available here:  demo.mahsie.com/download/demo.tgz. It is
includes the SQL file.  I have put this up quickly so that it was
available; however, everything is manual install at this time.  That
means:  editing the config.php files in both vtiger_crm and webERP
directories.  If you create a database 'verp_demo' and import the
verp_demo.sql file, you should be good to go; otherwise, update database
name in config files and don't forget to rename the verp_demo company in
webERP/companies.  I preserved file permissions when I built the
tarball.  If something screws up, it is possible to set the permissions
manually - there are not that many.  I have moved this demo onto a dozen
or so servers with great success, so hopefully it shouldn't be too
painful for anyone.

I have the integrated solution in full implementation with La Siembra
Fair Trade Cooperative here in Ottawa (www.lasiembra.com).  They have
international buying, warehousing, manufacturing and selling and they
are one of the larger fair trade cooperatives in Canada.  The system has
undergone intensive scrutiny:  third party financial and technical
audits were conducted and the webERP/VTiger CRM combo has come through
with flying colours.  I will be soliciting a testimonial in support of
open source solutions, and webERP and VTiger in particular.

Next, I have managed to gather a group here in Ottawa and we have formed
an open source solutions company:  Mahsie Open Source Solutions Inc. -
www.mahsie.com.  There are seven of us in total, but we are going to be
rallying around open source for charities, non-profit organizaitons as
well as small business and cooperatives.  One of my associates is a
certified management accountant with whom I have been working on this,
and he has been very pleased with results as well.  Of course, webERP
and VTiger will feature prominently (site still under development) and I
hope that we will be able to add to the ongoing development efforts.

If you visit the demo, you will notice we have a new template in the
works for webERP (VTiger-esque).  We don't have a full manufacturing
system, but La Siembra get third party companies to manufacture
chocolate products from raw ingredients they buy - so we have a working
item assembly/production run system (similar to order/shipment system).  
Some details:

- it is running VTiger 4, not 5.  We are working with VTiger 5, though
it does not add a great deal of additional functionality per se (with
the notable exception of campaign management).  However, the code and
file structure is very different - they cleaned up and moved around a
lot of code and have added a lot more javascript for the GUI.  So for
now, we are still working with VTiger 4.
- webERP and VTiger are integrated on various levels:  customers and
branches (with VTiger accounts), products, prices, pricelists, sales
orders, weights and dims, currencies, taxes, sales types, areas,
shippers and warehouse locations.
- new clients and sales orders - whether created in either application -
automatically appear in either program.  New products are created in
webERP, with a switch to determine if they are available to sales staff.
- refined item assembly/production run system (help file coming),
automatically generated manufacturing request.  Additions to shipment
system - additional information captured, automatically generated
shipping request.
- new template
- a bunch of little tweaks and changes, mostly client requested - some
new reports, additional columns available in the report writer, budget
tool, etc.

Steve, Phil - I will try a drop you a line separately, but everything
seems to be working out here.  Would love to talk to you about promoting
webERP, the Wiki page, etc.  We have a project management application
that I would like to integrate next - it would not be a full-blown HR
component, but would handle timesheets, tasks, projects, milestones,
assignments, project reporting, etc.   We are also tying it into Joomla
for frontend - very promising.  For your info, the demo site is tied
together with Joomla 1.5 beta.  Otherwise, life is crazy, I am hanging
on by my fingertips, but it's looking good.

Warmest regards,

Gareth.






JoaoBR wrote:

> On Monday 19 February 2007 15:27, Steve wrote:
>  
>> Huh, I could have sworn Gareth's webERP-vtiger combination was in 3rd party
>> on the webERP wiki.  Phil, do you know where it is?  Now, I have a copy as
>> I keep a copy of just about everything including webERP 0.2.7...hehe...only
>> that copy could be older than what he's done since.
>>
>>    
>
> ok no problem, also vtiger had a greater version bump recently so it might not
> be worse looking up the old stuff because it might not be valid any more
>
>
>  
>> Gareth, where are you?...
>>
>> Steve
>>
>> -----Original Message-----
>> From: web-erp-developers-bounces@...
>> [mailto:web-erp-developers-bounces@...] On Behalf Of
>> Steve Sent: Monday, February 19, 2007 11:32 AM
>> To: 'webERP Developers'
>> Subject: Re: [WebERP-developers] weberp vtiger integration
>>
>> I believe what has been done is on our wiki under 3rd party development.
>> There should be a package that contains a previous version of webERP along
>> with a previous version of vtiger ready to install and use.  However, there
>> are some glitches and restrictions I believe.  Also I believe it does
>> certain things but others it currently does not do.  Not sure but others
>> may be able to help once you get and try that package.
>>
>> Steve
>>
>> -----Original Message-----
>> From: web-erp-developers-bounces@...
>> [mailto:web-erp-developers-bounces@...] On Behalf Of
>> JoaoBR
>> Sent: Sunday, February 18, 2007 7:55 AM
>> To: webERP Developers
>> Subject: [WebERP-developers] weberp vtiger integration
>>
>> hi
>> somebody can give me some advice on this? The weberp 3.05 option regarding
>> vtiger integration is still not enough to share  data like suppliers and
>> customers right? Where is my starting point? Full work like this thread
>> describes (http://forums.vtiger.com/viewtopic.php?t=8480&start=0) is
>> still necessary or is there a shortcut?
>>
>> thank's
>> --
>>
>> João
>>
>>
>>
>>
>>
>>
>>
>> A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
>> segura.
>> Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>> --
>> No virus found in this incoming message.
>> Checked by AVG Free Edition.
>> Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
>> 5:40 PM
>>
>>
>> --
>> No virus found in this outgoing message.
>> Checked by AVG Free Edition.
>> Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
>> 5:40 PM
>>
>>
>>
>> -------------------------------------------------------------------------
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web-erp-developers@...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>> --
>> No virus found in this incoming message.
>> Checked by AVG Free Edition.
>> Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
>> 5:40 PM
>>    
>
>  


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by JoaoBR :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Tuesday 20 February 2007 02:06, Gareth Spanglett wrote:
> So sorry for the absence and I have a lot of news on a variety of
> fronts.  First of all, Phil:  sorry for all the delays.  The integration
> is stable enough for me to finally get to the code for the on/off switch.
>
...

Hi, firstable great work! I am glad that you didn't vanished ;)

What you set up as demo is very close to what I need but I rather prefere to
work on the latest versions of both. Not only for compatibility and easier
upgrade but also and specially I think vtiger 5 is much better and has lots
of improvements. I am not sure if I ever get what I want because I am trying
out all kind of erp and crm for more than a year now. With your permission I
am downloading your demo as I write and will spy your sources ok.

When you talk about the on/off switch you are referring to the vtiger
integration option in weberp right? This switch will only activate code to
access the tables but will not do the integration right?

Sooner or later this might turn into a new project since it is unlikely the
vtiger and weberp merge. What are your plans?




--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by steve-42 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

The overall plan, at least for the official webERP project as far as I know,
is to move further and further toward API that clearly specifies and
controls access between another system and itself.  If you merge separate
systems you will likely be alone with that single version forever.  It will
be difficult to impossible to work in new upgrades or get support because
they will be combined and entangled as one.

Steve

-----Original Message-----
From: web-erp-developers-bounces@...
[mailto:web-erp-developers-bounces@...] On Behalf Of
JoaoBR
Sent: Tuesday, February 20, 2007 7:56 AM
To: webERP Developers
Subject: Re: [WebERP-developers] weberp vtiger integration

On Tuesday 20 February 2007 02:06, Gareth Spanglett wrote:
> So sorry for the absence and I have a lot of news on a variety of
> fronts.  First of all, Phil:  sorry for all the delays.  The integration
> is stable enough for me to finally get to the code for the on/off switch.
>
...

Hi, firstable great work! I am glad that you didn't vanished ;)

What you set up as demo is very close to what I need but I rather prefere to

work on the latest versions of both. Not only for compatibility and easier
upgrade but also and specially I think vtiger 5 is much better and has lots
of improvements. I am not sure if I ever get what I want because I am trying

out all kind of erp and crm for more than a year now. With your permission I

am downloading your demo as I write and will spy your sources ok.

When you talk about the on/off switch you are referring to the vtiger
integration option in weberp right? This switch will only activate code to
access the tables but will not do the integration right?

Sooner or later this might turn into a new project since it is unlikely the
vtiger and weberp merge. What are your plans?




--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
5:40 PM
 

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3/693 - Release Date: 2/19/2007
5:01 PM
 


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by JoaoBR :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Tuesday 20 February 2007 12:26, Steve wrote:
> The overall plan, at least for the official webERP project as far as I
> know, is to move further and further toward API that clearly specifies and
> controls access between another system and itself.  If you merge separate

that is good to know but not easy since the other products do change over time
so it will be hard controlling what you do not have in hands. So probably it
is better having does-less but does-it

> systems you will likely be alone with that single version forever.  It will
> be difficult to impossible to work in new upgrades or get support because
> they will be combined and entangled as one.

yep that is the dark and scary side

wouldn't it be easier working on the weberp sales module? What certainly is
missing is only the possibility to make quotes which turn later into sales
orders. But this is probably out of weberp's focus. But I think it is worth
to think about because quotes are part of any business and it is not so far
off. Leads and other CRM stuff is another story but quotes are close to stock
and sales. What do you think?


--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by weberp :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Great news JoaoBR we have quotations that turn into sales orders already since
February 2005. Its in 3.00 onwards. you simply flag a sales order as a
quotation and option is available to print the quotation.

Phil

>
> wouldn't it be easier working on the weberp sales module? What certainly is
> missing is only the possibility to make quotes which turn later into sales
> orders. But this is probably out of weberp's focus. But I think it is worth
> to think about because quotes are part of any business and it is not so far
> off. Leads and other CRM stuff is another story but quotes are close to
> stock and sales. What do you think?

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by hqi :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

For people interested in CRM, you way want to check out xrms (http://www.xrms.org) xrms is an open source crm application also written in php. It's not as mature as vtiger/sugarcrm. but it has a plugin mechanism for new module developments. I guess it would be easier to create a xrms plugin linked to weberp, eg, a quotes plugin.

----- Original Message -----
From: "JoaoBR" <joao@...>
To: <steve@...>; "webERP Developers" <web-erp-developers@...>
Sent: Tuesday, February 20, 2007 12:28 PM
Subject: Re: [WebERP-developers] weberp vtiger integration


On Tuesday 20 February 2007 12:26, Steve wrote:
> The overall plan, at least for the official webERP project as far as I
> know, is to move further and further toward API that clearly specifies and
> controls access between another system and itself.  If you merge separate

that is good to know but not easy since the other products do change over time
so it will be hard controlling what you do not have in hands. So probably it
is better having does-less but does-it

> systems you will likely be alone with that single version forever.  It will
> be difficult to impossible to work in new upgrades or get support because
> they will be combined and entangled as one.

yep that is the dark and scary side

wouldn't it be easier working on the weberp sales module? What certainly is
missing is only the possibility to make quotes which turn later into sales
orders. But this is probably out of weberp's focus. But I think it is worth
to think about because quotes are part of any business and it is not so far
off. Leads and other CRM stuff is another story but quotes are close to stock
and sales. What do you think?


--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by steve-42 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Yes, the less you can get away with, the less you have to change as products
move forward for sure.  I mean, if you integrate you're done from the start
as discussed.  The only other way is some communication between them.
However, in any and every case it would always be necessary to investigate
the communication between them when one or the other product changes.  Maybe
that change does not mean communications between are affected...and maybe it
does.  Even though most would wish it to just take care of itself....I think
that's called RI (real intelligence) as opposed to AI.

In webERP you can already create quotes then later turn them into orders.
The only possible hang up is the fact that you need to enter the customer or
use a "generic" customer to create a quote.

The main connection between the two products as I see it is the customer
info including address, etc. that needs to be synchronized.  As far as
quotes, orders, inventory, etc. I think it is ridiculous that vtiger (and
others) even go there.  They should concentrate on CRM functionality
obviously lacking in their product instead of creating poor erp
functionality!

Steve  

-----Original Message-----
From: web-erp-developers-bounces@...
[mailto:web-erp-developers-bounces@...] On Behalf Of
JoaoBR
Sent: Tuesday, February 20, 2007 3:29 PM
To: steve@...; webERP Developers
Subject: Re: [WebERP-developers] weberp vtiger integration

On Tuesday 20 February 2007 12:26, Steve wrote:
> The overall plan, at least for the official webERP project as far as I
> know, is to move further and further toward API that clearly specifies and
> controls access between another system and itself.  If you merge separate

that is good to know but not easy since the other products do change over
time
so it will be hard controlling what you do not have in hands. So probably it

is better having does-less but does-it

> systems you will likely be alone with that single version forever.  It
will
> be difficult to impossible to work in new upgrades or get support because
> they will be combined and entangled as one.

yep that is the dark and scary side

wouldn't it be easier working on the weberp sales module? What certainly is
missing is only the possibility to make quotes which turn later into sales
orders. But this is probably out of weberp's focus. But I think it is worth
to think about because quotes are part of any business and it is not so far
off. Leads and other CRM stuff is another story but quotes are close to
stock
and sales. What do you think?


--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3/693 - Release Date: 2/19/2007
5:01 PM
 

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3/693 - Release Date: 2/19/2007
5:01 PM
 


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by steve-42 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hey Brian, are you paying João?  Just kidding.  Brian can be found here, is
the Project Coordinator of XRMS CRM and also plays a part in SquirrelMail.  

Steve

-----Original Message-----
From: web-erp-developers-bounces@...
[mailto:web-erp-developers-bounces@...] On Behalf Of H.Q.
Sent: Tuesday, February 20, 2007 7:49 PM
To: webERP Developers
Subject: Re: [WebERP-developers] weberp vtiger integration

For people interested in CRM, you way want to check out xrms
(http://www.xrms.org) xrms is an open source crm application also written in
php. It's not as mature as vtiger/sugarcrm. but it has a plugin mechanism
for new module developments. I guess it would be easier to create a xrms
plugin linked to weberp, eg, a quotes plugin.

----- Original Message -----
From: "JoaoBR" <joao@...>
To: <steve@...>; "webERP Developers"
<web-erp-developers@...>
Sent: Tuesday, February 20, 2007 12:28 PM
Subject: Re: [WebERP-developers] weberp vtiger integration


On Tuesday 20 February 2007 12:26, Steve wrote:
> The overall plan, at least for the official webERP project as far as I
> know, is to move further and further toward API that clearly specifies and
> controls access between another system and itself.  If you merge separate

that is good to know but not easy since the other products do change over
time
so it will be hard controlling what you do not have in hands. So probably it

is better having does-less but does-it

> systems you will likely be alone with that single version forever.  It
will
> be difficult to impossible to work in new upgrades or get support because
> they will be combined and entangled as one.

yep that is the dark and scary side

wouldn't it be easier working on the weberp sales module? What certainly is
missing is only the possibility to make quotes which turn later into sales
orders. But this is probably out of weberp's focus. But I think it is worth
to think about because quotes are part of any business and it is not so far
off. Leads and other CRM stuff is another story but quotes are close to
stock
and sales. What do you think?


--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3/693 - Release Date: 2/19/2007
5:01 PM
 

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.3/693 - Release Date: 2/19/2007
5:01 PM
 


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by Gareth Spanglett :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi all,

Steve is absolutely right - moving to VTiger 5 is already a challenge.  
The modifications as they are now are too significant and extensive to
be made into a simple patch, but the goal is not to build a new
application but to work with the best existing applications.  I opted to
'merge' VTiger into webERP, but if I had to do it again I may opt to go
the other way as webERP is technically easier to modify (less files,
less tables, no javascript).  In the end, both programs need to be
modified, but one or the other has to have several tables and fields
changed.  This unfortunately can affect a lot of code.  So for now, we
are working with the last version of VTiger 4.  The webERP files should
be current or very recent versions as I was working from the CVS.  By
the way, the wiki integration is working on the demo - it is very
popular with clients and coworkers alike.

It's not a big deal, but I disagree that VTiger 5 adds a lot of new
functionality - I find most of the changes to be either cosmetic (they
did a ton of work on the GUI, but also added a lot more javascript) and
organizational (they organized the file structure better, moved the
javascript out of html templates and into their own .js files, tidied up
a lot of legacy code, etc.).  We want to and will integrate VTiger 5,
but it will take several weeks of work to port the code because of all
the changes.

To further echo Steve's comments:  I agree - VTiger should stick to CRM,
webERP should stick to accounting/inventory/ERP.  The amount of work and
experience invested into both applications is why they are both popular
and mature.  webERP's strength is in its subtleties - for all its
features, it's the attention to detail that makes webERP such a great
accounting/ERP package - the tax-on-tax handling and the way it 'knows'
what tax to charge is probably not thought of as major, but it is both
subtle and critical to the whole system's success.  Likewise, it is the
small things that make VTiger such a great CRM and I would not
underestimate the amount of effort, thought and experience needed to
make something on par.  I believe it's faster and easier to integrate
existing, proven solutions than to necessarily build new ones from scratch.

The big issue is mapping tables and core functions between different
applications.  I am looking around for a possible abstraction layer that
would minimize the amount of customization required in each application
- something that would mediate the data between the two table structures
without a lot of code revision.  An alternative may be to convince both
development teams to agree to a common table and field naming structure
- they can develop their applications as they see fit, but they agree to
a naming convention and core structure (everyone agrees to use certain
tablenames and fields for customers, suppliers, products, addressing
fields have the same name, etc.).  A core common table and field naming
convention or base structure would go a very long way to speeding up
development and would provide a basis for other open source integrations.

Either way, my colleagues and I are betting the farm on open source
software.  Most of my clients over the last ten years have been
charities and non-profits, with a bunch of small businesses for whom
there are no other affordable alternatives.   Furthermore, I would stake
the quality of many open source apps over comparable proprietary systems
- there is a lot of FUD and closed code hiding sloppy programming and
undisclosed bugs.  Both webERP and VTiger were major improvements over
the commercial packages our client was using - in terms of stability,
reliability, accuracy and transparency (let alone cost).

So I have convinced a small group here in Ottawa to push forward with
open source solutions.  I have a couple of Linux/network guys, a Perl
coder, I am doing a lot of the PHP and MySQL with another colleague, we
have a couple of graphics/art/marketing guys, an e-learning specialist
giving us a hand on documentation, a chartered management accountant,
and a few other people in the mix.

Next steps for the webERP/VTiger integration:  distributing the code to
interested developers, getting feedback and modifications, and
discussing next steps.  These include:  getting VTiger 5 integrated,
future integration/upgrade strategy, adding in project management (we
are looking at Achievo at the moment and probably wouldn't be too hard
to do) and document control, preformatted forms and reports, working on
the report generator, unified login procedure ... there are lots of
additional features/improvements/enhancements that could be be either
standalone or integrated.

Anyway, I've gone on long enough - and I still have to post on the
VTiger forums as well since there has been a lot of interest from there
too.  The bottom line:  we plan to aggressively promote and support
various open source projects (including webERP, VTiger, and Joomla) and
pursue opportunities to merge open source solutions to meet integrated
management needs.  The parts are all there - they just need to be put
together.


Steve wrote:

> Yes, the less you can get away with, the less you have to change as products
> move forward for sure.  I mean, if you integrate you're done from the start
> as discussed.  The only other way is some communication between them.
> However, in any and every case it would always be necessary to investigate
> the communication between them when one or the other product changes.  Maybe
> that change does not mean communications between are affected...and maybe it
> does.  Even though most would wish it to just take care of itself....I think
> that's called RI (real intelligence) as opposed to AI.
>
> In webERP you can already create quotes then later turn them into orders.
> The only possible hang up is the fact that you need to enter the customer or
> use a "generic" customer to create a quote.
>
> The main connection between the two products as I see it is the customer
> info including address, etc. that needs to be synchronized.  As far as
> quotes, orders, inventory, etc. I think it is ridiculous that vtiger (and
> others) even go there.  They should concentrate on CRM functionality
> obviously lacking in their product instead of creating poor erp
> functionality!
>
> Steve  
>
> -----Original Message-----
> From: web-erp-developers-bounces@...
> [mailto:web-erp-developers-bounces@...] On Behalf Of
> JoaoBR
> Sent: Tuesday, February 20, 2007 3:29 PM
> To: steve@...; webERP Developers
> Subject: Re: [WebERP-developers] weberp vtiger integration
>
> On Tuesday 20 February 2007 12:26, Steve wrote:
>  
>> The overall plan, at least for the official webERP project as far as I
>> know, is to move further and further toward API that clearly specifies and
>> controls access between another system and itself.  If you merge separate
>>    
>
> that is good to know but not easy since the other products do change over
> time
> so it will be hard controlling what you do not have in hands. So probably it
>
> is better having does-less but does-it
>
>  
>> systems you will likely be alone with that single version forever.  It
>>    
> will
>  
>> be difficult to impossible to work in new upgrades or get support because
>> they will be combined and entangled as one.
>>    
>
> yep that is the dark and scary side
>
> wouldn't it be easier working on the weberp sales module? What certainly is
> missing is only the possibility to make quotes which turn later into sales
> orders. But this is probably out of weberp's focus. But I think it is worth
> to think about because quotes are part of any business and it is not so far
> off. Leads and other CRM stuff is another story but quotes are close to
> stock
> and sales. What do you think?
>
>
>  


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@...
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by dsauzier :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


maybe http://www.jitterbit.com/ could help.



Gareth Spanglett wrote:
Hi all,

Steve is absolutely right - moving to VTiger 5 is already a challenge.  
The modifications as they are now are too significant and extensive to
be made into a simple patch, but the goal is not to build a new
application but to work with the best existing applications.  I opted to
'merge' VTiger into webERP, but if I had to do it again I may opt to go
the other way as webERP is technically easier to modify (less files,
less tables, no javascript).  In the end, both programs need to be
modified, but one or the other has to have several tables and fields
changed.  This unfortunately can affect a lot of code.  So for now, we
are working with the last version of VTiger 4.  The webERP files should
be current or very recent versions as I was working from the CVS.  By
the way, the wiki integration is working on the demo - it is very
popular with clients and coworkers alike.

It's not a big deal, but I disagree that VTiger 5 adds a lot of new
functionality - I find most of the changes to be either cosmetic (they
did a ton of work on the GUI, but also added a lot more javascript) and
organizational (they organized the file structure better, moved the
javascript out of html templates and into their own .js files, tidied up
a lot of legacy code, etc.).  We want to and will integrate VTiger 5,
but it will take several weeks of work to port the code because of all
the changes.

To further echo Steve's comments:  I agree - VTiger should stick to CRM,
webERP should stick to accounting/inventory/ERP.  The amount of work and
experience invested into both applications is why they are both popular
and mature.  webERP's strength is in its subtleties - for all its
features, it's the attention to detail that makes webERP such a great
accounting/ERP package - the tax-on-tax handling and the way it 'knows'
what tax to charge is probably not thought of as major, but it is both
subtle and critical to the whole system's success.  Likewise, it is the
small things that make VTiger such a great CRM and I would not
underestimate the amount of effort, thought and experience needed to
make something on par.  I believe it's faster and easier to integrate
existing, proven solutions than to necessarily build new ones from scratch.

The big issue is mapping tables and core functions between different
applications.  I am looking around for a possible abstraction layer that
would minimize the amount of customization required in each application
- something that would mediate the data between the two table structures
without a lot of code revision.  An alternative may be to convince both
development teams to agree to a common table and field naming structure
- they can develop their applications as they see fit, but they agree to
a naming convention and core structure (everyone agrees to use certain
tablenames and fields for customers, suppliers, products, addressing
fields have the same name, etc.).  A core common table and field naming
convention or base structure would go a very long way to speeding up
development and would provide a basis for other open source integrations.

Either way, my colleagues and I are betting the farm on open source
software.  Most of my clients over the last ten years have been
charities and non-profits, with a bunch of small businesses for whom
there are no other affordable alternatives.   Furthermore, I would stake
the quality of many open source apps over comparable proprietary systems
- there is a lot of FUD and closed code hiding sloppy programming and
undisclosed bugs.  Both webERP and VTiger were major improvements over
the commercial packages our client was using - in terms of stability,
reliability, accuracy and transparency (let alone cost).

So I have convinced a small group here in Ottawa to push forward with
open source solutions.  I have a couple of Linux/network guys, a Perl
coder, I am doing a lot of the PHP and MySQL with another colleague, we
have a couple of graphics/art/marketing guys, an e-learning specialist
giving us a hand on documentation, a chartered management accountant,
and a few other people in the mix.

Next steps for the webERP/VTiger integration:  distributing the code to
interested developers, getting feedback and modifications, and
discussing next steps.  These include:  getting VTiger 5 integrated,
future integration/upgrade strategy, adding in project management (we
are looking at Achievo at the moment and probably wouldn't be too hard
to do) and document control, preformatted forms and reports, working on
the report generator, unified login procedure ... there are lots of
additional features/improvements/enhancements that could be be either
standalone or integrated.

Anyway, I've gone on long enough - and I still have to post on the
VTiger forums as well since there has been a lot of interest from there
too.  The bottom line:  we plan to aggressively promote and support
various open source projects (including webERP, VTiger, and Joomla) and
pursue opportunities to merge open source solutions to meet integrated
management needs.  The parts are all there - they just need to be put
together.


Steve wrote:
> Yes, the less you can get away with, the less you have to change as products
> move forward for sure.  I mean, if you integrate you're done from the start
> as discussed.  The only other way is some communication between them.
> However, in any and every case it would always be necessary to investigate
> the communication between them when one or the other product changes.  Maybe
> that change does not mean communications between are affected...and maybe it
> does.  Even though most would wish it to just take care of itself....I think
> that's called RI (real intelligence) as opposed to AI.
>
> In webERP you can already create quotes then later turn them into orders.
> The only possible hang up is the fact that you need to enter the customer or
> use a "generic" customer to create a quote.
>
> The main connection between the two products as I see it is the customer
> info including address, etc. that needs to be synchronized.  As far as
> quotes, orders, inventory, etc. I think it is ridiculous that vtiger (and
> others) even go there.  They should concentrate on CRM functionality
> obviously lacking in their product instead of creating poor erp
> functionality!
>
> Steve  
>
> -----Original Message-----
> From: web-erp-developers-bounces@lists.sourceforge.net
> [mailto:web-erp-developers-bounces@lists.sourceforge.net] On Behalf Of
> JoaoBR
> Sent: Tuesday, February 20, 2007 3:29 PM
> To: steve@selectnet.ca; webERP Developers
> Subject: Re: [WebERP-developers] weberp vtiger integration
>
> On Tuesday 20 February 2007 12:26, Steve wrote:
>  
>> The overall plan, at least for the official webERP project as far as I
>> know, is to move further and further toward API that clearly specifies and
>> controls access between another system and itself.  If you merge separate
>>    
>
> that is good to know but not easy since the other products do change over
> time
> so it will be hard controlling what you do not have in hands. So probably it
>
> is better having does-less but does-it
>
>  
>> systems you will likely be alone with that single version forever.  It
>>    
> will
>  
>> be difficult to impossible to work in new upgrades or get support because
>> they will be combined and entangled as one.
>>    
>
> yep that is the dark and scary side
>
> wouldn't it be easier working on the weberp sales module? What certainly is
> missing is only the possibility to make quotes which turn later into sales
> orders. But this is probably out of weberp's focus. But I think it is worth
> to think about because quotes are part of any business and it is not so far
> off. Leads and other CRM stuff is another story but quotes are close to
> stock
> and sales. What do you think?
>
>
>  


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: weberp vtiger integration

by Amauryb :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

Anything new about the integration between WebERP and VTiger ? Version 5 is now compatible ?

Thank you in advance.

Amaury


steve-42 wrote:
If I remember correctly it was only meant to connect customer. supplier and
item information.  I don't think it was meant to bring orders from one to
the other.  Anyway, Gareth could tell you best or looking through what he
provided.

Steve

-----Original Message-----
From: web-erp-developers-bounces@lists.sourceforge.net
[mailto:web-erp-developers-bounces@lists.sourceforge.net] On Behalf Of
JoaoBR
Sent: Monday, February 19, 2007 8:25 AM
To: webERP Developers
Subject: Re: [WebERP-developers] weberp vtiger integration

On Monday 19 February 2007 04:35, Phil Daintree wrote:
> Gareth has not been able to get to this we are waiting for him to
> contribute his work in a format we can use. He's promised to do this but
> that was before Christmas.
> It may not eventuate and if you want to pick this up he has posted his
work
> and provided a link to it noted in the earlier email you mention.
>


I spend my weekend on this. Who did the integration option so I could talk
to
him? Seems only the following files are touched so far

./CustomerBranches.php
./SelectOrderItems.php
./SystemParameters.php
./includes/DefineCartClass.php

in some occasions was missing the vtiger_ table prefix but still so it is
far
not enough. I think without a common customer, supplier, products tables it
does not make sense unless weberp checks the final purchase and sales order

in the vtiger tables and import them accordingly.
I am not sure but my first impression is that the full integration is not
reliable since weberp treats customers with branches and vtiger not. But
maybe some more input here could clear things up. Are there other people
which worked on this already?

>


> Phil
>
> On Monday 19 February 2007 01:55, JoaoBR wrote:
> > hi
> > somebody can give me some advice on this? The weberp 3.05 option
> > regarding vtiger integration is still not enough to share  data like
> > suppliers and customers right? Where is my starting point? Full work
like
> > this thread describes
> > (http://forums.vtiger.com/viewtopic.php?t=8480&start=0) is still
> > necessary or is there a shortcut?
> >
> > thank's
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Web-erp-developers mailing list
> Web-erp-developers@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
>
>
>
> A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
> segura. Service fornecido pelo Datacenter Matik
> https://datacenter.matik.com.br

--

João







A mensagem foi scaneada pelo sistema de e-mail e pode ser considerada
segura.
Service fornecido pelo Datacenter Matik  https://datacenter.matik.com.br

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/web-erp-developers

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
5:40 PM
 

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.0/689 - Release Date: 2/15/2007
5:40 PM
 


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Web-erp-developers mailing list
Web-erp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/web-erp-developers