search

scraperwiki / spreadsheet-upload-tool

A ScraperWiki tool for uploading structured data from a CSV or Excel spreadsheet
3 stars 5 forks source link

New-line errors in CSVs #15

Open zarino opened 11 years ago

zarino commented 11 years ago

Feedback from a new user:

I can't upload files. I've tried both XLSX and CSV, and your system barfs on both.

I get "Error new-line character seen in unquoted field - do you need to open the file in universal-newline mode?" when I try to do the CSV, and I get a KeyError when I try to upload XLSX. I'm on Mac OS, using MS Office for Mac.

I saw this on StackOverflow regarding the CSV error: http://stackoverflow.com/questions/6726953/open-the-file-in-universal-newline-mode-using-csv-module-django

Please fix! I very much want to use this!!

I've asked him for a copy of the CSV in question so we can diagnose.

zarino commented 11 years ago

Another report of the same issue.

screen shot 2013-08-19 at 17 43 38

I'm told the CSV was exported straight from Excel (Mac). I've asked for a link to the file.

frabcus commented 11 years ago

This will probably be fixed by just changing it to use messytables as in https://github.com/scraperwiki/spreadsheet-upload-tool/issues/6