[OGo-Users] RE: ics calendar files

[Adam Tauno Williams]

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

Sadly. normal. :(

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

Have you verified the appointments actually are still in the db?  (Can
you connect to the db directly?)

SELECT date_id, start_date, end_date, title
FROM date_x
WHERE date_id NOT IN (SELECT company_id FROM date_company_assignment)

should list participant-less appointments.

Interesting,  where did the "skyrix://192.168.1.116/og/136200" value in
you iCalendar file come from?  I think 136200 wold be the date_id in the
database.