Filemaker, iCal, and Excel

[Heathbo]

1. Is there a way to transfer a callendar with schedules and to do items created in Filemaker into iCal?

2. Is there a way to transfer a spreadsheet created in Filemaker to Excel?

[MarkWilson]

To export imformation to Excel from FileMaker export as a .CSV, .DIF, or .SYLK file or a couple other formats. Review the export info of FileMaker's help.

I have not used iCal so no help here.

[hayesk]

For iCal, there are two ways:

1. iCal uses the standard vCal format. The best way is to create a calc field that takes all the other relevant fields and makes a vCal entry. Then export only that vCal field for all records. You'll have to look up the vCal format to do this - or just look at iCal's data file (I think it's in your Home folder/Library folder somewhere.

2. Make a script and loop through all the records, and use an AppleScript for each record to make a new entry in iCal.

[Heathbo]

I looked at the ical .ics document. Its pretty easy to decipher in a text editor. Is there a way to export the data in Filemaker into a text document with the appropriate format? I've attached the .ics file turned into a .rtf so anyone can see it. What do you think?

icsdocumentin.rtf.zip

[Heathbo]

How would I go about exporting a record into a text document?