[horde] [PATCH] datemap.inc

Tue Oct 15 16:36:23 PDT 2002

On Wed, 16 Oct 2002, Jan Schneider wrote:

> Zitat von Andrew Morgan <morgan at orst.edu>:
>
> > Without this patch, when I import calendar entries, it gives me an
> > "undefined index Start Date ..." when it asks for the format of the date
> > field (the final step before the import succeeds).
>
> Can you give a short example (import file) when this exactly happens?
>
> Jan.

Attached is the CSV file I was using, which is an export from Outlook of a
user's Exchange Calendar.  The first line is the column names.

	Andy
-------------- next part --------------
"Subject","Start Date","Start Time","End Date","End Time","All day event","Reminder on/off","Reminder Date","Reminder Time","Meeting Organizer","Required Attendees","Optional Attendees","Meeting Resources","Billing Information","Categories","Description","Location","Mileage","Priority","Private","Sensitivity","Show time as"

"lunch w/ Mom","10/14/2002","1:00:00 PM","10/14/2002","2:00:00 PM","False","False","10/14/2002","12:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"revamp billing script to reflect AD changes","11/4/2002","10:00:00 AM","11/4/2002","10:30:00 AM","False","True","11/4/2002","10:00:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"feed juke","10/7/2002","4:00:00 PM","10/7/2002","4:30:00 PM","False","False",,,,,,,,,,"",,"Normal","False","Normal","3"

"meet w/ Bob Christensen at OSU FCU","10/9/2002","1:30:00 PM","10/9/2002","3:00:00 PM","False","False","10/9/2002","10:30:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"quilting class","10/14/2002","6:00:00 PM","10/14/2002","8:30:00 PM","False","True","10/14/2002","5:30:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"quilting class","10/21/2002","6:00:00 PM","10/21/2002","8:30:00 PM","False","True","10/21/2002","5:30:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"quilting class","10/28/2002","6:00:00 PM","10/28/2002","8:30:00 PM","False","True","10/28/2002","5:30:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"quilting class","11/4/2002","6:00:00 PM","11/4/2002","8:30:00 PM","False","True","11/4/2002","5:30:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"quilting class","11/11/2002","6:00:00 PM","11/11/2002","8:30:00 PM","False","True","11/11/2002","5:30:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"quilting class","11/18/2002","6:00:00 PM","11/18/2002","8:30:00 PM","False","True","11/18/2002","5:30:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"quilting class","11/25/2002","6:00:00 PM","11/25/2002","8:30:00 PM","False","True","11/25/2002","5:30:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"help Erik and Melo","10/7/2002","6:00:00 PM","10/7/2002","8:00:00 PM","False","False","10/7/2002","5:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"home and garden show","10/8/2002","6:00:00 PM","10/8/2002","7:30:00 PM","False","False","10/8/2002","3:00:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"update backup script for new clients","10/2/2002","11:00:00 AM","10/2/2002","11:30:00 AM","False","False","10/2/2002","11:00:00 AM",,,,,,,,"",,"Normal","False","Normal","3"

"set up recipient policy for rcn.uhds.oregonstate.edu","10/2/2002","9:30:00 AM","10/2/2002","10:00:00 AM","False","False","10/2/2002","9:30:00 AM",,,,,,,,"",,"Normal","False","Normal","3"

"move Jennifer Abbas mailbox","10/1/2002","6:00:00 PM","10/1/2002","6:30:00 PM","False","False","10/1/2002","6:00:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"JPN 311","10/7/2002","8:00:00 AM","10/7/2002","8:50:00 AM","False","False","10/7/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","10/9/2002","8:00:00 AM","10/9/2002","8:50:00 AM","False","False","10/9/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","10/14/2002","8:00:00 AM","10/14/2002","8:50:00 AM","False","False","10/14/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","10/16/2002","8:00:00 AM","10/16/2002","8:50:00 AM","False","False","10/16/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","10/21/2002","8:00:00 AM","10/21/2002","8:50:00 AM","False","False","10/21/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","10/23/2002","8:00:00 AM","10/23/2002","8:50:00 AM","False","False","10/23/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","10/28/2002","8:00:00 AM","10/28/2002","8:50:00 AM","False","False","10/28/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","10/30/2002","8:00:00 AM","10/30/2002","8:50:00 AM","False","False","10/30/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/4/2002","8:00:00 AM","11/4/2002","8:50:00 AM","False","False","11/4/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/6/2002","8:00:00 AM","11/6/2002","8:50:00 AM","False","False","11/6/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/11/2002","8:00:00 AM","11/11/2002","8:50:00 AM","False","False","11/11/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/13/2002","8:00:00 AM","11/13/2002","8:50:00 AM","False","False","11/13/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/18/2002","8:00:00 AM","11/18/2002","8:50:00 AM","False","False","11/18/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/20/2002","8:00:00 AM","11/20/2002","8:50:00 AM","False","False","11/20/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/25/2002","8:00:00 AM","11/25/2002","8:50:00 AM","False","False","11/25/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/27/2002","8:00:00 AM","11/27/2002","8:50:00 AM","False","False","11/27/2002","7:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"callback: Deborah Healey","10/2/2002","9:00:00 AM","10/2/2002","9:30:00 AM","False","False","10/2/2002","9:00:00 AM",,,,,,,,"",,"Normal","False","Normal","3"

"Halon check","10/10/2002","8:00:00 AM","10/10/2002","8:30:00 AM","False","False","10/10/2002","7:45:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"feed juke","9/30/2002","4:00:00 PM","9/30/2002","4:30:00 PM","False","False","9/30/2002","4:00:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"lunch w/ Jen","9/30/2002","1:00:00 PM","9/30/2002","2:00:00 PM","False","False","9/30/2002","12:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"JPN 311","10/4/2002","9:00:00 AM","10/4/2002","9:50:00 AM","False","True","10/4/2002","8:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","10/11/2002","9:00:00 AM","10/11/2002","9:50:00 AM","False","True","10/11/2002","8:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","10/18/2002","9:00:00 AM","10/18/2002","9:50:00 AM","False","True","10/18/2002","8:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","10/25/2002","9:00:00 AM","10/25/2002","9:50:00 AM","False","True","10/25/2002","8:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/1/2002","9:00:00 AM","11/1/2002","9:50:00 AM","False","True","11/1/2002","8:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/8/2002","9:00:00 AM","11/8/2002","9:50:00 AM","False","True","11/8/2002","8:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/15/2002","9:00:00 AM","11/15/2002","9:50:00 AM","False","True","11/15/2002","8:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/22/2002","9:00:00 AM","11/22/2002","9:50:00 AM","False","True","11/22/2002","8:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311","11/29/2002","9:00:00 AM","11/29/2002","9:50:00 AM","False","True","11/29/2002","8:50:00 AM",,,,,,,,"Kidd 236",,"Normal","False","Normal","4"

"JPN 311 drill","10/2/2002","8:00:00 AM","10/2/2002","8:50:00 AM","False","False","10/2/2002","7:45:00 AM",,,,,,,,"",,"Normal","False","Normal","4"

"JPN 311","9/30/2002","9:00:00 AM","9/30/2002","9:50:00 AM","False","False","9/30/2002","8:45:00 AM",,,,,,,,"",,"Normal","False","Normal","4"

"sign papers at Kara's office","9/30/2002","3:30:00 PM","9/30/2002","4:00:00 PM","False","False","9/30/2002","3:15:00 PM",,,,,,,"sometime before 4pm

","",,"Normal","False","Normal","2"

"help Erik & Melo w/ roofing","9/28/2002","8:00:00 AM","9/28/2002","12:00:00 PM","False","False","9/28/2002","7:45:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"house pressure-washing; close windows","9/28/2002","8:00:00 AM","9/28/2002","5:00:00 PM","False","False","9/28/2002","7:45:00 AM",,,,,,,,"",,"Normal","False","Normal","3"

"feed juke","9/25/2002","4:00:00 PM","9/25/2002","4:30:00 PM","False","False","9/25/2002","4:00:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"meet w/ Kara","9/24/2002","4:00:00 PM","9/24/2002","5:30:00 PM","False","False",,,,,,,,,,,,"Normal","False","Normal","2"

"move keith king's mailbox to CN","9/24/2002","8:30:00 AM","9/24/2002","9:00:00 AM","False","False",,,,,,,,,"","",,"Normal","False","Normal","2"

"move mammoth park back to g1 store 1","9/18/2002","6:30:00 PM","9/18/2002","7:00:00 PM","False","False","9/18/2002","6:15:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"add tape to Email pool","9/16/2002","4:30:00 PM","9/16/2002","5:00:00 PM","False","False","9/16/2002","4:30:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"Fishing","9/22/2002","8:00:00 AM","9/22/2002","1:00:00 PM","False","False","9/22/2002","7:45:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"run DS/IS Consistency check","9/16/2002","5:00:00 PM","9/16/2002","5:30:00 PM","False","False","9/16/2002","5:00:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"move Peggy Peterson to CN group 3","10/15/2002","8:00:00 AM","10/15/2002","8:30:00 AM","False","True","10/15/2002","7:45:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"ONID migration to AD","9/1/2002","10:00:00 AM","9/1/2002","12:00:00 PM","False","False","9/1/2002","9:45:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"Fall term begins","9/30/2002","12:00:00 AM","10/1/2002","12:00:00 AM","True","False","9/29/2002","11:45:00 PM",,,,,,,,"",,"Normal","False","Normal","3"

"spa party w/ Jen","8/29/2002","7:00:00 PM","8/29/2002","9:00:00 PM","False","False","8/29/2002","3:00:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"Labor Day","9/2/2002","12:00:00 AM","9/3/2002","12:00:00 AM","True","False","9/1/2002","11:45:00 PM",,,,,,,,"",,"Normal","False","Normal","3"

"Time off","9/19/2002","8:30:00 AM","9/19/2002","5:30:00 PM","False","False","9/19/2002","8:15:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"Time off","9/20/2002","8:30:00 AM","9/20/2002","5:30:00 PM","False","False","9/20/2002","8:15:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"Fishing?","9/19/2002","12:00:00 AM","9/20/2002","12:00:00 AM","True","False","9/18/2002","11:45:00 PM",,,,,,,,"",,"Normal","False","Normal","3"

"move CN users to Exchange 2000","8/27/2002","5:00:00 PM","8/27/2002","5:30:00 PM","False","False","8/27/2002","4:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"move AD users to Exchange 2000","9/16/2002","6:00:00 PM","9/16/2002","6:30:00 PM","False","False","9/16/2002","5:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"hang out w/ Jill","8/25/2002","12:00:00 PM","8/25/2002","6:00:00 PM","False","False","8/23/2002","12:00:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"meet w/ Jon","8/21/2002","9:00:00 AM","8/21/2002","9:30:00 AM","False","False","8/21/2002","8:55:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"clean up mail","8/21/2002","8:30:00 AM","8/21/2002","9:00:00 AM","False","False","8/21/2002","8:30:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"Fall Festival","9/28/2002","12:00:00 AM","9/30/2002","12:00:00 AM","True","False","9/27/2002","11:45:00 PM",,,,,,,,"",,"Normal","False","Normal","3"

"geeks & steaks: food","9/7/2002","4:00:00 PM","9/7/2002","6:00:00 PM","False","False","9/7/2002","3:45:00 PM",,,,,,,,"philomath city park - shelter 1",,"Normal","False","Normal","2"

"geeks & steaks: softball","9/7/2002","2:30:00 PM","9/7/2002","4:00:00 PM","False","False","9/7/2002","2:15:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"feed juke","8/16/2002","3:00:00 PM","8/16/2002","3:30:00 PM","False","False","8/16/2002","3:00:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"bathroom deconstruction!","8/22/2002","12:00:00 AM","8/23/2002","12:00:00 AM","True","False","8/21/2002","11:45:00 PM",,,,,,,,"",,"Normal","False","Normal","3"

"cleaning at Dr. Frome","11/5/2002","1:00:00 PM","11/5/2002","2:00:00 PM","False","True","11/4/2002","1:00:00 PM",,,,,,,"","",,"Normal","False","Normal","2"

"call Jill","8/15/2002","7:00:00 PM","8/15/2002","7:30:00 PM","False","False",,,,,,,,,,"",,"Normal","False","Normal","2"

"test","8/12/2002","6:00:00 PM","8/12/2002","6:30:00 PM","False","False","8/12/2002","5:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"Paula Minear - move mailbox from F&W","8/14/2002","5:00:00 PM","8/14/2002","5:30:00 PM","False","False","8/14/2002","4:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"Scandinavian Festival","8/8/2002","3:00:00 PM","8/8/2002","7:00:00 PM","False","False","8/8/2002","2:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"ATT BI","8/12/2002","12:00:00 PM","8/12/2002","4:00:00 PM","False","False","8/12/2002","11:45:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"check out Engr's juke","8/7/2002","2:00:00 PM","8/7/2002","2:30:00 PM","False","False","8/7/2002","1:00:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"LAN party","8/1/2002","7:00:00 PM","8/1/2002","10:00:00 PM","False","False","8/1/2002","4:00:00 PM",,,,,,,,"Rob and Kay's",,"Normal","False","Normal","2"

"astronomy","8/4/2002","9:00:00 PM","8/5/2002","1:00:00 AM","False","False","8/4/2002","8:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"astronomy","8/3/2002","9:00:00 PM","8/4/2002","1:00:00 AM","False","False","8/3/2002","8:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"barbeque at Mom and Dad's","8/3/2002","2:00:00 PM","8/3/2002","7:00:00 PM","False","False","8/3/2002","1:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"

"gutter replacement","8/9/2002","7:00:00 AM","8/9/2002","5:00:00 PM","False","False","8/9/2002","6:45:00 AM",,,,,,,,"",,"Normal","False","Normal","3"

"Net meeting","8/20/2002","10:30:00 AM","8/20/2002","12:00:00 PM","False","False","8/20/2002","10:15:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"Net meeting","9/3/2002","10:30:00 AM","9/3/2002","12:00:00 PM","False","False","9/3/2002","10:15:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"Net meeting","9/17/2002","10:30:00 AM","9/17/2002","12:00:00 PM","False","False","9/17/2002","10:15:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"Net meeting","10/1/2002","10:30:00 AM","10/1/2002","12:00:00 PM","False","False","10/1/2002","10:15:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"Net meeting","10/15/2002","9:00:00 AM","10/15/2002","10:30:00 AM","False","True","10/15/2002","9:00:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"Net meeting","10/29/2002","10:30:00 AM","10/29/2002","12:00:00 PM","False","False","10/29/2002","10:15:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"Net meeting","11/12/2002","10:30:00 AM","11/12/2002","12:00:00 PM","False","False","11/12/2002","10:15:00 AM",,,,,,,,"",,"Normal","False","Normal","2"

"Net meeting","11/26/2002","10:30:00 AM","11/26/2002","12:00:00 PM","False","False","11/26/2002","10:15:00 AM",,,,,,,,"",,"Normal","False","Normal","2"