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.
