search

scraperwiki / spreadsheet-upload-tool

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

Error when uploading XLS file created by spreadsheet download #17

Closed pwaller closed 10 years ago

pwaller commented 10 years ago

When uploading a spreadsheet that has been created by the spreadsheet download tool we get the following error:

FileTypeError Unknown file type Composite Document File V2 Document, No summary info (I only understand .csv, .xls and .xlsx)

Here it is:

http://pwaller.net/sw/all_tables.xls

IanHopkinson commented 10 years ago

This file, downloaded as spreadsheet from :

https://www.dropbox.com/s/nnumy37kv7lntlp/agriaaffaires.co.uk.xls

Fails to upload, when upload is as xls the error message is:

Oh no! We received an unexpected error while structuring your spreadsheet: KeyError u'year'

The spreadsheet has 3 tabs and the key "year" occurs twice but changing one instance of year to something else does not help.

Trying to upload just the first sheet as csv gives this error:

Oh no! We received an unexpected error while structuring your spreadsheet: UnicodeDecodeError 'ascii' codec can't decode byte 0x81 in position 1: ordinal not in range(128)
zarino commented 10 years ago

I think we can file this under the "would probably be fixed by using Messytables" tag.