Modify ↓

Opened 16 years ago

Closed 15 years ago

#4453 closed defect (wontfix)

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

Reported by: François Granade Owned by: François Granade
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 François Granade 16 years ago.
An example of CSV file with MacOS end-of-lines

Download all attachments as: .zip

Change History (3)

Changed 16 years ago by François Granade

Attachment: report.csv​ added

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

comment:1 Changed 16 years ago by François Granade

Component: SELECT A HACK → TicketImportPlugin
Owner: changed from anonymous to François Granade

comment:2 Changed 15 years ago by François Granade

Resolution: → wontfix
Status: new → closed

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain François Granade.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

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

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.