October 31, 200421 yr 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?
October 31, 200421 yr 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.
November 3, 200421 yr 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.
November 14, 200421 yr Author 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
Create an account or sign in to comment