Member Avatar for paul-lucas

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.

  • 2 Contributors
  • 1 Reply
  • 245 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by diafol
Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.