Re: [Evolution] Entering multiple appointments

[Lonnie Borntreger <email borntreger com>]

On Sat, 2003-07-12 at 10:11, Ted Anderson wrote:
> Is there an easy way to enter a large number of appointments at once?
> I'm trying to make an ICS file for the 2003 NFL schedule, and I have a
> list of all of the games. I tried making a spreadsheet (which was easy
> to do from the given list on espn.com) and then exporting as a CSV, but
> Evo doesn't import CSV. So I imported into Outlook on my wife's machine
> from the CSV, and that worked but of course Outlook makes it hard to get
> that data to an ICS format. If there's an easier way, please let me
> know, otherwise I'll just enter every game manually.

For the NASCAR schedule I wrote a little script that took the data and
generated an ICS file from it.  If you are putting it into CSV, then you
obviously know what the field mapping is, so you can write them out to
the ICS.  One ICS file can have multiple VEVENTS in it, so it can all be
pulled in using one import.  See below for an example, although you can
also add VALARM to it for reminders if so inclined.

Lonnie Borntreger

==================================
BEGIN:VCALENDAR
PRODID:-//Ximian//NONSGML Evolution Calendar//EN
VERSION:2.0

<<<<<<<<<<<<<<<<<<<<<<< START MULTIPLE VEVENTS
BEGIN:VEVENT
SUMMARY:Workshop
DTSTART;TZID=/softwarestudio.org/Olson_20011030_5/America/Chicago:
 20030711T190000
DTEND;TZID=/softwarestudio.org/Olson_20011030_5/America/Chicago:
 20030711T230000
END:VEVENT
<<<<<<<<<<<<<<<<<<<<< END MULTIPLE VEVENTS

END:VCALENDAR