Re: weberp vtiger integration

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:

-------------------------------------------------------------------------
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