Hi All,
After reading this long argument without any solutions out there. I have come out with the solutions that partially solve the issue between Vtiger FA Integration. These 2 open source project have their pros and cons. The missing part is the bridge between the 2 as Vtiger does not have accounting while FA does not have CRM. It will be nice to create a bridge between the 2 projects with minimum changes.
Left me clarify some doubts that have been mention in this post.
1) Integrate vtiger and frontaccounting WITHOUT changing the core code of either vtiger or frontaccounting are INVISIBLE provided that you are using the Database Trigger/custom workflow. I do not suggest to used database trigger due to most of the users running those application under Shared Hosting Environment. In shared hosting package, they DO NOT provide database trigger (my shared hosting do not provide db trigger functions). So, I solve this issue by creating a new FA REST API to perform 2 way synchronization.
2) Multiple Login to different system was troublesome.?
This can be solve by using LDAP Server. Both system should support Single Sign On via LDAP Server or Open ID. if you don't, you can simple create it. (NOTE: LDAP Server only applicable to Semi or dedicated server/Cloud Computing)
3) It will become really difficult for a new developer to maintain the two different code bases?
The simple answer is YES. But after investigate the code bases of these 2 open source project. The answer become NOT Necessary. The reason is vtiger CRM already done some degree of integration by providing the REST API but FA does not. So, you have to create your own FA REST API to perform integration and synchronization process between the 2 system.
4) The end-users will have to learn 2 different set of UIs and base functionalities (like roles, etc.)
AGREED. To solve this issue, I have created a new UI and define the User Roles for these 2 applications. When the user login to the system, it will automatically provision into vtiger or FA. (This process is invisible to the user and it will work as normal login process). The end user will retrieve the functionalities base on the define roles.
5) The multi-currency concept is different in both the FA and vT.
Yes. But you can solve this issue by converting the multi-currency from FA to vtiger or vice-versa.
6) Combining the 2 database into 1 is meaningless. This is due to the future upgrade issue unless you stick with the current version.
This issue can be solve by using the normal installation on 2 separate databases. When it come to the database upgrade, just re-run the additional custom db script for FA and vtiger. For the source code, you need to re-patch the new version of vtiger or FA. You keep the latest version with minimum changes.
The overviews synchronization process as below:
- Vtiger -> 2 ways sync -> Front Accounting
- Front Accounting -> 2 ways sync -> Vtiger
Future Integrations:
Synchronize Customer, Order, Stock Movement, Products Inventory, Re order level, invoices etc from and to FA to Open Source Shopping Cart below:
- Open Source Shopping Cart include Magento, Virtualmart, OpenCart, OsCommerce, ZenCart etc will be supported.
Mobile Devices Integrations:
-The following mobile devices will be supported iPhone, Google Android, BlackBerry 6 and above (BB 5 and below DOES NOT supported).
Although my idea was there, but it will take a long time to complete the missions including the resources, time and money. Anyway, I will continue invest into the integration for the above said.
For those who are interested with this solutions, are can my post "2 ways synchronization between vtiger and front accounting - RELEASED" at https://frontaccounting.com/punbb/viewtopic.php?id=2096
