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.
On Monday, August 31, 2015 at 6:00:45 PM UTC-7, Gary Fung wrote: > > worked for me doing the same windows comma separated (.csv) option. > > On Tuesday, May 20, 2014 at 11:49:44 AM UTC-7, Michael Beller wrote: >> >> 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. >> >> On Friday, November 22, 2013 5:49:37 AM UTC-5, 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. >>> >>> On Thursday, August 8, 2013 12:29:31 PM UTC+4, Massimo Di Pierro wrote: >>>> >>>> Hard to say without an example. >>>> >>>> On Thursday, 8 August 2013 00:07:38 UTC-5, DJ wrote: >>>>> >>>>> >>>>> 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? >>>>> >>>>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
