Re: Database Schema

> > 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.

Yes, Outlook records participants.  I don't know if it *requires*
participants.
 
> > 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.

It would be interesting to drop one of the disappearing appointments
while watching the ZideLook server log and see what you see.  But
recurrences are always a problem moving between any two kinds of servers
as they are really complicated (even if the server honors the spec to
the letter) and I don't any servers completely implement the spec.  And
does Exchange/Outlook respect the spec completely?  Probably not.

Also participants are matched by E-MAIL ADDRESS in ZideStore (this is
covered in detail in the next edition of WMOGAG) so if you don't have
participants with e-mail addresses, or with unique e-mail addresses,
data can get mix-mastered.  [ZideStore will create new place-holder
contacts for participants it can't find].  So it is advisable to move
Contact data first and then schedule data.

> > 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 

If you produce any notes/documentation on this process they would be
much appreciated so we can incorporate them into existing documentation.

Basically there is "date_x" core appointment data,
date_company_assignment is the relation between the date and the
contact/team (participants).  "date_info" holds the comment (description
of the appointment).  The "appointment_resource" table, deceptively,
isn't used for anything;  resources are stored [oddly] as a CSV value
(by name, not Id, even more oddly) in the resource_names field.

> > 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.

Yes.   But importing directly into the OGo database can be tricky;  make
sure you generate primary keys correctly (aka
"nextval('key_generator')") and fill in the object_version fields.

> 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/

This is the safer way to do things.  It will take care of allot of the
nitty-gritty Db stuff for you.  There is a list specifically for XML-RPC
(zOGI & legacy xmlrpcd) questions regarding either scripting or
development.
<http://mail.opengroupware.org/mailman/listinfo/xmlrpc>.   Feel free to
ask any questions if you decide to go that route.  Questions make the
archives more useful, so nothing is "too dumb".

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