[OGo-Developer] Database layout?

[Adam Williams]

> I'm new to this list and a user of opengroupware. I installed it for a
> company and it works really good. They have some Outlook-Connectors from
> Skyrix to use Outlook.
> So, now there is one task left in my to-do list (and I hope I'm right
> here). Problem:
> They have already a CRM system in production and would like to see all
> contacts synchronized to OGO. I looked around and did not find any
> solution for this. Now my idea is, I have a database connection to their
> CRM and I have OGOs database - there must be a way to sync at least
> "low-level".

We developed a CRM application that uses OGo via XML-RPC.

> But therefore I need to understand how OGOs database is organized
> (especially for contacts). Is there any documentation about this?
> Of course if I can put something together I'll publish it.
> Any hints?

We also have a solution for pushing changes from OGo's database to other
databases/sources.  This is a .NET application that watches the audit
table for changes.

http://docs.opengroupware.org/Members/whitemice/OGoMojo/MOGIMon-HOWTO/view
http://docs.opengroupware.org/Members/whitemice/OGoMojo/Hedera.cs/view
http://docs.opengroupware.org/Members/whitemice/OGoMojo/OGoMojo-0.0.19.tar.gz/view