Closed Bug 405737 Opened 17 years ago Closed 16 years ago

Import of .csv from Outlook 2000 calculates all alerts in reverse

Categories

(Calendar :: Import and Export, defect)

defect
Not set
major

Tracking

(Not tracked)

VERIFIED FIXED

People

(Reporter: billsmo, Assigned: Hb)

References

Details

Attachments

(2 files)

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6
Build Identifier: Thunderbird/2.0.0.9 with Lightning/0.7

I live in NYS, so my time zone is "(GMT-5:00) Eastern Time", and the default for Lightning, when I installed it was "America/New York". I left it that way, since it was correct for my time zone. After import from the .csv file, all alerts that were supposed to be of 15 min. before the event were imported as 15 min. after the event. Also, alerts that were 3 hours before the event were imported as 3 hours after the event. And an alert that was 2 days before the event was imported as 2 days after the event. 

Every alert is imported as exactly the correct offset, but on the wrong side of the event. This is hard to explain, since the .csv file actually has alert times (not offsets) in it, which are correct, so the importer must be doing the subtraction backwards, or adding the offset instead of subtracting it, or something like that - a very common programming error, in my experience.

Here is a sample from my imported .csv file:

"Cirque - Saltimbanco","9/15/2007","3:30:00 PM","9/15/2007","4:00:00 PM","False","False","9/15/2007","12:30:00 PM",,,,,,,,"Wilkes Barre Wachovia Arena",,"Normal","False","Normal","2"
"Bibliophile - Adventures on the Silk Road of Ancient and Modern China  ","9/12/2007","7:30:00 PM","9/12/2007","8:00:00 PM","False","False","9/11/2007","7:30:00 PM",,,,,,,,"Barnes & Noble",,"Normal","False","Normal","2"
"Dinner at the Hog Ranch","9/15/2007","7:00:00 PM","9/15/2007","7:30:00 PM","False","False","9/15/2007","12:00:00 PM",,,,,,,,"",,"Normal","False","Normal","2"
"Massage","9/11/2007","5:30:00 PM","9/11/2007","6:00:00 PM","False","False","9/11/2007","3:30:00 PM",,,,,,,,"DFC",,"Normal","False","Normal","2"
"Cirque - WinTuk - Mad. Sq. Gar. - WaMu Theater","12/8/2007","11:00:00 AM","12/8/2007","11:30:00 AM","False","False","11/18/2007","11:00:00 AM",,,,,,,,"",,"Normal","False","Normal","2"
"Scan covers of Annabel for Sean","9/28/2007","9:30:00 AM","9/28/2007","10:00:00 AM","False","False","9/28/2007","9:15:00 AM",,,,,,,,"",,"Normal","False","Normal","2"
"Redo resume for EDI, B2B, perl, etc.","9/30/2007","11:30:00 AM","9/30/2007","1:30:00 PM","False","False","9/30/2007","11:15:00 AM",,,,,,,,"",,"Normal","False","Normal","2"
"Dryden LGB films","9/29/2007","2:00:00 PM","9/29/2007","2:30:00 PM","False","False","9/29/2007","1:00:00 PM",,,,,,,,"",,"Normal","False","Normal","2"
"Xerox Lunch","10/12/2007","12:00:00 PM","10/12/2007","1:00:00 PM","False","False","10/12/2007","11:30:00 AM",,,,,,,,"",,"Normal","False","Normal","2"
"Flu Clinic","10/5/2007","10:00:00 AM","10/5/2007","10:30:00 AM","False","False","10/5/2007","9:00:00 AM",,,,,,,,"Tops - 1900 Clinton Ave S.",,"Normal","False","Normal","2"
"Eric","10/5/2007","10:00:00 AM","10/5/2007","10:30:00 AM","False","False","10/5/2007","9:00:00 AM",,,,,,,,"",,"Normal","False","Normal","2"
"Massage","10/15/2007","5:30:00 PM","10/15/2007","6:30:00 PM","False","False","10/15/2007","3:30:00 PM",,,,,,,,"DFC",,"Normal","False","Normal","2"
"Excellus Interview w/ Tom","10/16/2007","8:50:00 AM","10/16/2007","9:50:00 AM","False","False","10/16/2007","8:20:00 AM",,,,,,,,"Court St. - Renee (TEKsystems) 738-8023",,"Normal","False","Normal","2"
"Scan last page of R&L AJN Abroad for David M (tigerkiss)","10/16/2007","2:00:00 PM","10/16/2007","2:30:00 PM","False","False","10/16/2007","1:45:00 PM",,,,,,,,"",,"Normal","False","Normal","2"
"Mike at Fairfield Inn","10/23/2007","7:00:00 PM","10/23/2007","7:30:00 PM","False","False","10/23/2007","6:45:00 PM",,,,,,,,"529-5000 - 1200 Brooks Ave",,"Normal","False","Normal","2"


Reproducible: Always

Steps to Reproduce:
1. Export .csv file (default layout) from Outlook 2000
2. Import into Lightning or Sunbird
3. Check the Alert setting in the calendar entries
Actual Results:  
What should be displayed as a 15 minute warning is displayed as an alert 15 minutes after the event.

Expected Results:  
It should display as an alert 15 minutes before the event.

This bug may, or may not, be connected to another bug where all event alarms are activated 6 hours early, or thereabouts. I am not sure it is consistent for all alarms. Most of mine are set for 15 minute warnings, but they trigger 6 hours before that (I think it is six hours - you have to be at the computer when it triggers to notice it, and I am typically not on six hours before any of my appointments). If I see an alarm dialog, I just set it to snooze for as many hours as it is until it should have triggered from whatever time it is when I notice it, and that works fine, except that it never works out to an even number of hours after whatever time it is now, because it triggered when I wasn't looking. I haven't experimented things like 4.7 hours, or other fractions.
please attach the an export to ics of your calendar when it's imported in Lightning so we can see what the problem is. What happens if you export to ics from outlook and then import in Lightning? The csv-import is rather buggy...
I was asked to supply a .ics export of my Lightning calendar for comparison, so I thought I'd better supply the complete .cvs export from Outlook 2000, so they would be easier to compare. I was also asked why I didn't use a .ics export instead of .cvs from Outlook (cvs being buggy - no kidding?). There is no .ics export from Outlook - only .cvs or .pst can be exported. The Outlook-to-ics utility offered on the Lighting web site failed, so I had to settle for .csv.
I was asked to provide a .ics export of my Lightning calendar to understand what happened when importing from Outlook 2000 via .cvs file. I could not find a viable path from Outlook using .ics, so I had to use .cvs for the transfer. Here is the .ics output produced from the data imported into Lightning.
TRIGGER;VALUE=DURATION:PT10M means 10 minutes after precise time, the same holds for the events which according to your csv should be happening 3 hours before the events start and not PT3H -> 3 hours after. There's something going wrong in the calculations... So confirming...

Status: UNCONFIRMED → NEW
Ever confirmed: true
I changed the subtraction between start and alarm time. Please try a replacement for the file calOutlookCSVImportExport.js as shown in bug 359083 
Depends on: 359083
Blocks: 401273
Resolution:

> -                 event.alarmOffset = sDate.subtractDate(alarmDate);
> +                 event.alarmOffset = alarmDate.subtractDate(sDate);

No separate diff given for this change. It is in the patch for bug 401273.
No longer blocks: 401273
Status: NEW → ASSIGNED
Depends on: 401273
No longer depends on: 359083
Flags: wanted-calendar0.8?
OS: Windows XP → All
Hardware: PC → All
Attachment #290550 - Flags: review?(mvl)
Assignee: nobody → hb
Status: ASSIGNED → NEW
Comment on attachment 290550 [details]
.ics export from Lightning of calendar imported from Outlook

I'm not sure why I should review a csv file...
Attachment #290550 - Flags: review?(mvl)
Attachment #290546 - Attachment mime type: application/octet-stream → text/plain
Attachment #290550 - Attachment mime type: application/octet-stream → text/plain
Hb, I just checked in the patch for bug 401273. If I understand this bug correctly, it can now be closed as FIXED. Could please resolve this bug in case my understanding is correct.
Flags: wanted-calendar0.8? → wanted-calendar0.8-
Status: NEW → RESOLVED
Closed: 16 years ago
Resolution: --- → FIXED
Target Milestone: --- → 0.8
Status: RESOLVED → VERIFIED
Flags: wanted-calendar0.8-
You need to log in before you can comment on or make changes to this bug.