Hello,

I'm looking for the download solution from data on MySql to file .ical aims to import to Outlook Calendar.

Do you have something to share with me?

Thank a lot.

Member Avatar
diafol

A number of us have created such apps in the past. Can't find mine at the mo, but here's a sample:

http://stevethomas.com.au/php/how-to-build-an-ical-calendar-with-php-and-mysql.html

but it's very basic without repeat events, etc.

A mysql table for the calendar "object"
A table for "events (fields = properties) possibly with related tables e.g. timezones, status etc
And a link table

You need to read up on the various icalendar "markup" elements to get the fields you may want to include.

e.g. events (FK could be ENUM instead, but better if got releated tables)

ID | CREATED_AT | UPDATED_AT | DTSTART | DTEND | SUMMARY | CLASS | TRANSP | UID | TZID (FK) | RRULE_FREQ (FK) | RRULE_COUNT (FK) | RRULE_UNTIL | ...

You could get away with having a 'combined' field for items such as RRULE, but then your DB table may not be as "searchable". Swings and roundabouts maybe.