General discussion on installation and configuration of SOGo

Text archives Help

Re: [SOGo] Scripting Calendar Entries direct into Db

Chronological Thread 
  • From: Ludovic Marcotte < >
  • To:
  • Subject: Re: [SOGo] Scripting Calendar Entries direct into Db
  • Date: Mon, 28 Jun 2010 20:58:02 -0400
  • Organization: Inverse inc.

Ben wrote:
I'm looking to write a script that will read data from a different database and insert calendar entries directly into the SOGo db. (Suggestions welcome of other ways of doing this -- I just want to have a cron job update a calendar based on our PO database). I've got a could questions about the data structure:

In calendar X there are 3 tables. X, X_acl and X_quick. Looking at the db format, it seems that every new calendar entry gets a long UID. Where c_name is UID.ics and in the Vcalendar entry has a UID: X

Is there a proper way to generate the UID? Is it random and incremented off something else I need to look at? Or can I just make something up? (I won't be doing syncing with funambol, etc)

What about X_quick? Is that something I need to populate as well, or can I trigger sogo to look at the X table and regenerate the X_quick table?

Any comments / pitfalls I may run into?
Why don't you use the DAV interface combined with SOGSuperUsernames?


Ludovic Marcotte

:: +1.514.755.3630 ::
Inverse inc. :: Leaders behind SOGo ( and PacketFence

Archive powered by MHonArc 2.6.16.

Top of page