[OGo-Developer] Database layout?

Sebastian Reitenbach developer@opengroupware.org
Mon, 13 Nov 2006 12:10:13 -0000


Hi,

take a look into the sources, 
http://download.opengroupware.org/releases/unstable/opengroupware-1.1.6-yummy/so
urce/

in the Database subdirectory you will find the scripts that create the 
database layout, and the connection to ogo. Don't know whether there is a 
document available, that actually describes the database scheme.

directly writing into the database, might not be that good, using xml_rpc from 
the command line should be able to retrieve/insert the data you want to have, 
without the possibility of thrashing the ogo database.

kind regards
Sebastian


developer@opengroupware.org wrote: 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 
> Hi all together!
> 
> 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".
> 
> 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?
> 
> Thanks in advance,
> Jan
> 
> 
> 
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.3 (MingW32)
> Comment: GnuPT 2.7.6
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> 
> iD8DBQFFWFrlvvmCkIIgH8QRAqBeAJ0Vrr+nXQtYHR9L+emNvVTsGkE3WQCeJX9G
> bXBwnXXgyquBwxvNfqWuLHQ=
> =tr7h
> -----END PGP SIGNATURE-----
> -- 
> OpenGroupware.org Developer
> developer@opengroupware.org
> http://mail.opengroupware.org/mailman/listinfo/developer
> 

-- 
Sebastian Reitenbach            Tel.: ++49-(0)3381-8904-451
RapidEye AG                     Fax: ++49-(0)3381-8904-101    
Molkenmarkt 30                  e-mail:reitenbach@rapideye.de     
D-14776 Brandenburg             web:http://www.rapideye.de