AppAdmin: CSV import bug

[DJ]

Not able to upload data using CSV import tool, get the following error  (perhaps, web2py csv import tool needs to read it in using 'rU' option?) -

Running Version 2.5.1, Python 2.7, MacOSX. Tested it using a csv file exported out using appadmin's Export/Import tool.

Unable to parse CSV file:

new-line character seen in unquoted field - do you need to open the file in universal-newline mode?

[Massimo Di Pierro]

Hard to say without an example.

[Andy W]

Just come across the same problem -  using ver 2.7.4 with pythonanywhere.com

The issue seems to be with the csv files created by Excel (I am on Mac OSX). I have a simple 2-column list of ISO country codes and nationalities on an Excel spreadsheet. Saving from Excel to CSV creates a file that, when uploading, creates the above error message. If I use OpenOffice to write the CSV file it uploads without an issue.

[Dave S]

On Friday, November 22, 2013 2:49:37 AM UTC-8, Andy W wrote:

Just come across the same problem -  using ver 2.7.4 with pythonanywhere.com

The issue seems to be with the csv files created by Excel (I am on Mac OSX). I have a simple 2-column list of ISO country codes and nationalities on an Excel spreadsheet. Saving from Excel to CSV creates a file that, when uploading, creates the above error message. If I use OpenOffice to write the CSV file it uploads without an issue.

Have you diffed the 2 files?  Is there a little difference between them or a lot?

/dps

[Michael Beller]

I'm also using Excel on a Mac and had the same problem.  However, if I select "Windows Comma Separated (.csv)" option rather than the default "Comma Separated Values (.csv)" in the "Save As ..." dialog box the import through the appadmin interface works.

[Gary Fung]

worked for me doing the same windows comma separated (.csv) option.

[Derek]

If your CSV file is not RFC-4180 compliant, I would expect it not to work. RFC-4180 calls for CR+LF linefeeds. Your program may just be outputting a single linefeed without the carriage return.