455848 - outlook csv module always uses US date format

Status: VERIFIED DUPLICATE of bug 301750

(Calendar :: Import and Export, defect)

Description

[James Andrewartha]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.13) Gecko/20080313 SeaMonkey/1.1.9
Build Identifier: 2008090920

I want to import events from outlook into Lightning. I export events from outlook as csv which uses DD/MM/YYYY, then import them into Lightning, which parses the dates as MM/DD/YYYY and **** it up. Export into outlook csv format from Lightning also uses US date format.

Reproducible: Always

Steps to Reproduce:
1. Export events from Outlook as csv
2. Import csv file into Lightning
3.
Actual Results:  
Dates are parsed as MM-DD-YYYY

Expected Results:  
Dates are parsed as DD-MM-YYYY

Mmmm, data corruption. For dates that are invalid when parsed as MM-DD-YYYY, weird **** happens:

"[STAFF] Christmas Day public holiday","25/12/2008","12:00:00 AM","26/12/2008","12:00:00 AM","True","True","24/12/2008","6:00:00 AM","Carole Lefort","'Staff'",,,,," 
","",,"Normal","False","Normal","3"

ends up as Tuesday, 12 January 2010 - Thursday, 11 February 2010

Comment 1

[Stefan Sitter [:ssitter]]

Currently the CSV parser supports only English (US) and Dutch outlook files.

You might have more luck by using a tool like FreeMiCal to export from Outlook to the better supported iCalendar format.