Modify

Opened 6 years ago

Closed 5 years ago

#4453 closed defect (wontfix)

Cannot import CSV files that have MacOS end-of-lines

Reported by: farialima Owned by: farialima
Priority: normal Component: TicketImportPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

A file exported as CSV from Microsoft Excel 2004 for Mac and choosing "CSV (Comma delimited)" format, can not be imported into Trac: An error occurs at upload: "Unable to read this file, does not seem to be a valid Excel or CSV file.".

This is because the default export format from Excel puts MacOS-type end-of-lines in the file, which can't be read by the CSV library. See an example of such file attached.

There are two possible workarounds:

  • in Excel, use "CSV (Windows)" as the format to save as. The file will be importable into Trac
  • or, simply, import directly the Excel spreadsheet. This will only work if xlrd has been installed on the Trac machine, however.

Attachments (1)

report.csv (249 bytes) - added by farialima 6 years ago.
An example of CSV file with MacOS end-of-lines

Download all attachments as: .zip

Change History (3)

Changed 6 years ago by farialima

An example of CSV file with MacOS end-of-lines

comment:1 Changed 6 years ago by farialima

  • Component changed from SELECT A HACK to TicketImportPlugin
  • Owner changed from anonymous to farialima

comment:2 Changed 5 years ago by farialima

  • Resolution set to wontfix
  • Status changed from new to closed

I don't think I will have time to fix this. I think it's OK, people should use Excel more (I think :) )

Add Comment

Modify Ticket

Action
as closed The owner will remain farialima.
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.