Synchronize SugarCRM with Bamboo

[Chris80]

Hi,

I need to keep my SugarCRM in sync with Bamboo. Especially the contacts / bamboo_clients table.
It’s a very simple script: It connects to both databases, SELECTS everything from Sugar contacts with an ORDER BY id.
Afterwards it INSERTs everything in a while in Bamboo client table.
It works very good with the ORDER BY, even if I TRUNCATE clients Table. Maybe it’s a very brutal way of doing it. If there are other people interested we could talk it over and maybe create a temptable with a timestamp in it or something like that.
For me it works though.

Just insert your Database Connection and open the PHP in a browser.
It works with Sugar 5.2.2 and Bamboo 0.8.8

Bye, Chris

[wayneward]

works great cheers
i was using simple invoices but had to keep adding clients!
this will do the trick till i fing a intergrated invoices module
thanks

Wayne :-)

[cosm55]

yes it working for me i am also using for invoices but now it is working fine.

I have just inserted Database Connection and it is working for me now.

Thanks for the great help now it is easier for me to add and delete and mainly for inserting.