Modify

Opened 5 years ago

Closed 4 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 5 years ago.
An example of CSV file with MacOS end-of-lines

Download all attachments as: .zip

Change History (3)

Changed 5 years ago by farialima

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

comment:1 Changed 5 years ago by farialima

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

comment:2 Changed 4 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 .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from farialima. Next status will be 'closed'.
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.