[OGo-Users] RE: ics calendar files

Peter Duda users@opengroupware.org
Tue, 8 Apr 2008 10:40:21 -0700


This is all fine and dandy and an interesting read - no really it is, but it
doesn't really address the question I was asking.
:)  

> > >> Did you use iCal-over-HTTP or CalDAV? Using
> > >> the
> > >> former for editable calendars is strongly discouraged. yes, maybe we
> > >> should completely disable this feature per default, Adam?)
> > > Agree;  I know that I'm tired of explaining why iCalendar PUT is/was a
> > > bad idea.
> > Well, it can be useful in some situations. But I guess abuse is the
> > bigger issue.

I have a number of Thunderbird "people" who would like to use that as their
client - I was testing the new 0.8 lightning to connect to Ogo via CalDAV
which after reading https://bugzilla.mozilla.org/show_bug.cgi?id=418050 I
now know doesn't work - 

No abuse here -I just tried the ical option to see if it worked, and when I
created a single appointment it deleted ALL the participants on ALL events
in that calendar EXCEPT the one I created (funny huh?).  ALL participants
have valid email addresses, and they all match Ogo, so something else
happened here.  I am not really interested in why or what happened at this
point - I obviously am NOT going to use this as a solution, it was simply a
test.  Maybe when I have 15 minutes I might scour the error logs and try and
find out what happened, but in the meantime I AM interested in getting back
the 300 or so appointments that now are floating around in limbo in my
database - The appointments exist but do not show up anywhere because they
have NO participants.
Again - here is a copy of a single event (with names and emails changed to
protect the innocent) from an ics file that I have that contains ALL the
events that were changed.

BEGIN:VEVENT
CLASS:PUBLIC
LOCATION:Guild Hall
PRIORITY:1
STATUS:CONFIRMED
SUMMARY: Cabinet Meeting
DTSTART:20080228T013000Z
DTEND:20080228T030000Z
TRANSP:OPAQUE
UID:skyrix://192.168.1.116/og/136200
CREATED:20030710T120000Z
DTSTAMP:20080404T181534Z
X-MICROSOFT-CDO-IMPORTANCE:1
X-MICROSOFT-CDO-BUSYSTATUS:BUSY
X-MICROSOFT-CDO-INSTTYPE:0
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
ATTENDEE;CUTYPE="INDIVIDUAL";PARTSTAT="NEEDS-ACTION";ROLE="REQ-PARTICIPANT";
RSVP="FALSE";CN="Eva C":MAILTO:someemail
ATTENDEE;CUTYPE="INDIVIDUAL";PARTSTAT="NEEDS-ACTION";ROLE="REQ-PARTICIPANT";
RSVP="FALSE";CN="Mark A":MAILTO: someemail
ATTENDEE;CUTYPE="INDIVIDUAL";PARTSTAT="NEEDS-ACTION";ROLE="REQ-PARTICIPANT";
RSVP="FALSE";CN="Georgia N":MAILTO: someemail
ATTENDEE;CUTYPE="INDIVIDUAL";PARTSTAT="NEEDS-ACTION";ROLE="OPT-PARTICIPANT";
RSVP="FALSE";CN="Peter D":MAILTO: someemail END:VEVENT

****---The question is ---**** IS this enough information to re-populate the
database with the participant's information to get these appointments to
show up in the proper calendars?
If NOT - what is missing?
IF it IS enough - can I PUT PUSH COPY PASTE SHOVE this information into the
database, and what would be the best way of doing that?

Peter