I believe that in the example they were discussing they were using Export Field Contents not Export Records.
I do not believe so.
It was discussed in the thread in post number #2:
AHunter3 says: "If you were to export field contents, the resulting text file would be UTF-16 which may not work properly. ikf you were to isolate a single record and export records as text (this one field ONLY), the apparent hard returns would be exported as the vertical tab character that FileMaker uses for hard returns within fields and that probably won't work either."
I did try just exporting my .ics file from one calculation record, but I ran in to the problem described above.
If I followed the example correctly you load all the lines of the ics file into a vlist and export the whole thing out with a export records.
I have the vlist working just fine, but I can not get the export to have the correct format.
I don't have an easy button for you, but here are some possible solutions:
- Use AppleScript or a File plug-in to convert the returns to proper line breaks
- Export to XML and write an XSLT to convert it into iCal
- Build an iCal table for the purpose of exporting records. Add records for all of the header stuff, as well as a single record for each iCal value. Then you can export as tab or CSV and you wont have to worry about line endings.
- If you are on FileMaker Server you can subscribe to the events directly instead of exporting them.
I found the website filemakerhacks.com and on it Kevin Frank details how to export ics files out of Filemaker.
I never could find an option to export in the format I wanted, but i was able to copy the example script and make it work.
What bothers me still is that I can not choose the option if I were writing my own script.
Thanks for all the replies!