search

scraperwiki / spreadsheet-upload-tool

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

Extraction fails when header cell contains integers/floats #1

Closed zarino closed 11 years ago

zarino commented 11 years ago

Once extract.py finds the header row, it should cast each cell to a String before using the cell values at keys for the data columns.

Otherwise, when scraperwiki.sqlite.save() attempts to save the data (as a list of dictionaries with some troublesome non-string keys) the save fails.

zarino commented 11 years ago

screen shot 2013-04-30 at 10 55 16

Use the qep211.xls file to reproduce.

frabcus commented 11 years ago

Not relevant to new version of tool