Vtiger6如何与现有网站集成
I am confused as to the best way to integrate vtiger with my existing website's mysql db.
I have a mysql table called users. The table contains all the expected fields of a user table such as username, email, password, created, modified, newsletter, etc. etc. I have another table called membership which states when the user paid, how much and when his premium account will expire.
I would like to suck in all this info to manage in vtiger. The first step would be to import all users' data. After that, it would be a case of updating vtiger if any changes made to the users' record on the web db and vice versa.
What would be the best way to go about this? What tools already exist? Your comments would be very helpful as I have been searching everywhere to see how others have done this but cannot find any examples or ideas. I am using redhat, Apache, mysql and php with vtiger6.
我对将vtiger与现有网站的mysql db集成的最佳方法感到困惑。 p>
我有一个名为users的mysql表。 该表包含用户表的所有预期字段，例如用户名，电子邮件，密码，创建，修改，新闻稿等。我有另一个名为成员资格的表，其中说明用户何时付款，多少以及何时他的高级帐户将 到期。 p>
我想在vtiger中管理所有这些信息。 第一步是导入所有用户的数据。 之后，如果对Web数据库上的用户记录进行了任何更改，则更新vtiger将是一种情况，反之亦然。 p>
最好的方法是什么？ 已有哪些工具？ 您的评论将非常有用，因为我一直在寻找其他人如何做到这一点，但找不到任何示例或想法。 我使用redhat，Apache，mysql和php与vtiger6。 p> div>
It depends by what version of vtiger do you use, and what kind of website model/infrastructure do you using. For 100% website custom code you have 2 quickly ways: - Talend ETL https://www.talend.com/ suggested for complex data mapping - Mysql Triggers, (something like this http://blog.scarletkangaroo.com/2012/12/opencart-vtiger-syncmyshop-parte-1.html)
Good Luck! ;-)