[KLUG Members] presentation calendar

[Adam Williams]

> > > >There is iCAL support in PHP....
> > > Where?
> > Sorry, you're right.  It has iCAP support, not iCAL supprt.  And heading
> > over to the manual it appears that iCAP support has been pulled from
> > recent versions due to lack of maintainers.
> > iCAP support and other calendar functions are via mcal, whose download
> > page seems to be broken.  Not to mentiont hat mcal could do with a few
> > more active maintainers than it has.
> > Bummer, guess the situation is quite a bit worse than I thought.
> > But there is an iCalendar/PHP class (supposedly) available from -
> > http://sourceforge.net/projects/php-flp/
> > And there is the PHP/iCalendar projects which can DISPLAY the contents
> > of iCalendar files, but I don't know if it can create them. -
> > http://phpicalendar.sourceforge.net/nuke/
> > And there is always OpenGroupWare which exports calendars via WebDAV for
> > things like the Mac OS X & Mozilla calendars.  But that is a bit like
> > hitting a fly with an anvil for this problem.
> So, where does that leave us?  (knowing nothing about this stuff myself)
> What if we were to forget about postgres?  The schedule doesn't change
> very often, we could write a cron job to dump the database into a text
> file every night.  Would that work for this?

A cron job to generate an iCal file (which is just a text file with
markup) from the PostgreSQL database would work.  Writing the data from
PostgreSQL out a flat file doesn't really get us any nearer the mark (if
that is what you were suggesting).  I think if someone is going to write
a Cron job to do it they could almost just as easily write a live iCal
generator.

BTW, an iCal file looks like (this is from evo, which probably contains
more tags than is absolutely required) -

BEGIN:VCALENDAR
CALSCALE:GREGORIAN
PRODID:-//Ximian//NONSGML Evolution Calendar//EN
VERSION:2.0
BEGIN:VTIMEZONE
TZID:/softwarestudio.org/Olson_20011030_5/America/Detroit
X-LIC-LOCATION:America/Detroit
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:19701025T020000
RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:19700405T020000
RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=4
END:DAYLIGHT
END:VTIMEZONE
. . .
  {events}
. . .
BEGIN:VEVENT
UID:20030713T192054Z-4254-500-1-2@estate2.whitemice.org
DTSTAMP:20030713T192054Z
DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/America/Detroit:
 20030826T190000
DTEND;TZID=/softwarestudio.org/Olson_20011030_5/America/Detroit:
 20030826T200000
TRANSP:OPAQUE
SEQUENCE:2
SUMMARY:KLUG: Bind Shorts
LOCATION:Kalamazoo Chamber Of Commerce
DESCRIPTION:Tonight we have two BIND/DNS presentations. Adam Williams\,
 System Administrator and local LDAP Guru will be demonstrating BIND SDB
 and SDB LDAP in particular. SDB is a layer in bind that permits domain
 name information to be drawn from various sources such as an RDBMS or
 LDAP server. This lets you simply use named as a DNS front end to a
 centralized or pre-existing source of host information.
CATEGORIES:KLUG Speakers
CLASS:PUBLIC
LAST-MODIFIED:20030713T192152Z
END:VEVENT
. . .
  {events}
. . .
END:VCALENDAR