GOOD THINGS HAPPEN when a developer is able to grab ideas and techniques from around the web and put them together to make a better solution. When that developer is able to make it modular, the whole developer community benefits.
Douglas Alder of Homebase Software did just that recently by making a stand alone export solution that exports calendar .ics files from FileMaker for import into a calendar application like iCal or Outlook:
I have been working on an event-based database project and my client was requesting some way to get the events to their Calendar application. I looked around and found the basics of how to do this, generating the required text for a calendar .ics file. I also found a good article on FileMaker Hacks that suggested employing a Virtual List, to deal with exporting text file issues in the .fmp7 format. With FileMaker Pro 13, there are some new capabilities —Get(UUID) and Get(CurrentTimeUTCMilliseconds) — and some older file formatting issues seem to have gone away.
I decided to write my own, portable script for exporting .ics calendar files from FileMaker Pro 13 databases and thought I would share it here for others who may find this useful. I built my script using ideas from the above resources. This script should give you the ability to export events from FileMaker Pro 13 into Apple Calendar, BusyCal, Google Calendar, Outlook etc.
To add this capability to your own solution, you will need a copy of FileMaker Pro 13.
Virtual lists, custom functions from Brian Dunning’s website, new features from FileMaker 13, modularity, and more. And downloadable example files for the desktop and iPhone/iPad. Follow the link to read it all.