It doesn't find CSV files inside ZIPs.

scraperwiki / spreadsheet-upload-tool

A ScraperWiki tool for uploading structured data from a CSV or Excel spreadsheet

3 stars 5 forks source link

It doesn't find CSV files inside ZIPs. #12

Open drj11 opened 11 years ago

drj11 commented 11 years ago

It seems to be relatively common to distribute CSV files zipped. Which means one (or more?) files in a ZIP file. e.g. police crime data: http://data.police.uk/data/fetch/b109fd2a-030e-4af5-96e3-940fa86b553c/ (no idea if that URL works).

Uploader should open a zip and doing something sensible. For example, if there is just one .csv or .xls file then it should open that.

frabcus commented 11 years ago

We should change the tool to use messytables, outsourcing a bunch of these kinds of issues.

There's a card on the tool board for doing this.

drj11 commented 11 years ago

I saw there was a messytables issue, but since it was phrased in terms of solution not requirement I had no idea what problems it solved (I don't know anything about messytables).

But yeah, messytables sounds good to me.