create ICS file with FSO

[kredd]

hello all,
i've got an online calendar and am providing links to download the calendar events to users calendar client...as either a CSV file(PC) or a ICS file(MAC). i'm using FSO to create the files from a recordset. the CSV files work great, but the ICS files.......don't.

iCalendar says "The calendar file is unreadable" but doesn't give me any other info. When i go to import the file i can see that my MAC is recognizing it as an ICS file, its has a file type, file size, etc., and i opened it up in NOTEPAD and everything **looked** fine...tho i don't know what they are supposed to look like to begin with.

are there any special requirements/formatting that go into making ICS files? basically once i got my FSO code working to create the .CSV files i just changed the file type from ".CSV" to ".ICS". kinda of a shot in the dark that seemed to work at first, but turns out it can't be read by iCalendar.

any help is appreciated or even any info on iCalendar files.

thanks,
kelly

[nmrdave]

Here is formatted Vcalendar file, same thing as Icalendar, just a different extension. Hope it helps.

BEGIN:VCALENDAR
PRODID:-//Program that generated this file
VERSION:2.0
METHOD:PUBLISH
BEGIN:VEVENT
ATTENDEE;ROLE=OPT-PARTICIPANT;RSVP=FALSE:MAILTO:bob@bob.com
DTSTART:20041130T133000Z
DTEND:20041201T223000Z
LOCATION:New York
TRANSP:OPAQUE
UID:blahblah
DTSTAMP:20041026T193339Z
SUMMARY:Selling Cookies
PRIORITY:5
CLASS:PUBLIC
BEGIN:VALARM
TRIGGER:PT60M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR

[kredd]

yes, i wasn't aware of the diff formatting. thanks. if that is what the ICS file has to look like with the "name:value" format then i guess the comma-delimited file i'm using is the problem.

i guess i can try spitting out the recordset into the array in the "name:value" format without the headers necessary for the CSV and see what happens.

thanks again