Re: Database Schema

[email protected] wrote: 
> Hi All,
> 
> I'm attempting to do a one off migration of just under 6000 entries from 
> an Outlook Calendar in a .pst file into OGo.
are there attendees assigned to the calendar entries?
I don't know anything about outlook calendar.

> 
> I have found that if I use the Outlook Connector and drag and drop the 
> entries many of them (especially the repeating ones) don't show up 
> properly.
and I cannot say much about the outlook connector too.

> 
> I'm probably doing this the wrong way, but, I've been experimenting with 
> using MS Access and ODBC as a tool to get the data in to the OGo 
> database. But, before I do this on a 'live' system I want to check that 
> I'm being true to the database schema. Do I just add entries to the 
> public_date_x table or are there other tables that need updated as well.
> 
there are at least the date_company_assignment and date_info tables too.

do you can create csv files out of your contacts, and appointments?
then it should be easy to write a small python script, and upload the data 
via zogi. More about zogi and example scripts you can find here:
http://code.google.com/p/zogi/

Sebastian


> Many thanks
> 
> Ken
> 
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
> 
> -- 
> OpenGroupware.org Users
> [email protected]
> http://mail.opengroupware.org/mailman/listinfo/users
> 

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users