Could you point me in the right direction on the script? You're right that I have the field mapping, at least the ones I need, but I don't know how to get them from CSV into the ICS format. I imagine it's some sort of for loop that writes "DTSTART;TZID..." + $DTG (date time group) etc, etc...but I'm not exactly sure how to do that.
Also, did you have any problems with the /softwarestudio... at the beginning of each TZID? I'm trying to use this NFL calendar with phpicalendar, and it really messes up unless I take out everything but the "America/Chicago" for example. Thanks, Ted On Sat, 2003-07-12 at 17:59, Lonnie Borntreger wrote: > 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 > > > _______________________________________________ > evolution maillist - [EMAIL PROTECTED] > http://lists.ximian.com/mailman/listinfo/evolution -- Ted Anderson [EMAIL PROTECTED] http://www.tedandellen.com/blog _______________________________________________ evolution maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/evolution
