VFP -> iCal format...

[Neil Toulouse]

Hi guys!

We have a very simple calendar function in our application that basically lists important events coming up throughout the year.

The table structure is very simple:

DATE
EVENT TITLE
FROM (time)
TO (time)

We have been asked to provide an export function of this data so that it can be pulled into other external calendar applications. I have assumed this will need to be in "iCal" format. My initial research has provided a lot of bulky technical documents, which will take me a while to wade through!

So basically, does anyone have any experience in doing this who could offer any advice/best practice, or able to point me to some shorter documents, with some good examples so I can quickly get a handle on what needs to be done?

Any advice is much appreciated

TIA
Neil

I like work. It fascinates me. I can sit and look at it for hours...

 

[GriffMG]

Hi Neil,

I would have thought that for your application the first example in Wikipedia's notes on iCalendar would be about right:

BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//hacksw/handcal//NONSGML v1.0//EN
BEGIN:VEVENT
DTSTART:19970714T170000Z
DTEND:19970715T035959Z
SUMMARY:Bastille Day Party
END:VEVENT
END:VCALENDAR

You would need to convert the date and time stuff to suit.

The article is here:

http://en.wikipedia.org/wiki/ICalendar

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[Neil Toulouse]

Thanks Griff!

I did start with Wikipedia with my research, but somehow managed to completely miss that example and started at "Events"!!

But yes, it is as simple as that so many thanks for making me look at it again! (It's been a long week already, and it's only Monday...)

Neil

I like work. It fascinates me. I can sit and look at it for hours...

 

[GriffMG]

Glad to be of help.

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.