Adding a URL for a google doc

[stevieflow]

There's a dataset from Macc at

https://docs.google.com/spreadsheets/d/1TggIY677FG4uUmSqUJYdrTRTtJDKuQuOh5dgn45jjhA/pubhtml

Adding this URL to a package isnt possible:

The selected file pubhtml could not be referenced. Only files with the following extensions are allowed: csv html xls json xlsx doc docx rdf txt jpg png gif tiff pdf odf ods odt tsv geojson xml zip.

[practicalparticipation]

Two elements here:

Firstly, we should link to the CSV version using the /export?format=csv option instead of /pubhtml on the end of the URL

https://docs.google.com/spreadsheets/d/1TggIY677FG4uUmSqUJYdrTRTtJDKuQuOh5dgn45jjhA /export?format=csv

That still doesn't let DKAN accept the URL yet (there might be a setting somewhere...) but for the time being we could put this in the 'Link to an API' field instead of file URL...

Tim

On Tue, Mar 10, 2015 at 4:37 PM, Steven Flower notifications@github.com wrote:

There's a dataset from Macc at

https://docs.google.com/spreadsheets/d/1TggIY677FG4uUmSqUJYdrTRTtJDKuQuOh5dgn45jjhA/pubhtml

Adding this URL to a package isnt possible:

The selected file pubhtml could not be referenced. Only files with the following extensions are allowed: csv html xls json xlsx doc docx rdf txt jpg png gif tiff pdf odf ods odt tsv geojson xml zip.

— Reply to this email directly or view it on GitHub https://github.com/ThreeSixtyGiving/data.threesixtygiving.org/issues/12.

w: http://www.timdavies.org.uk | m: 07834 856 303 | twitter: timdavies

Co-director of Practical Participation:

http://www.practicalparticipation.co.uk

Practical Participation Ltd is a registered company in England and Wales -

5381958.

[stevieflow]

Thanks @practicalparticipation

Ah yes - actually need to link to the xlsx version, as it includes a tab on multiple locations:

https://docs.google.com/spreadsheets/d/1TggIY677FG4uUmSqUJYdrTRTtJDKuQuOh5dgn45jjhA/export?format=xlsx

The Link to an API field still doesnt accept this though...

Have uploaded the xlsx and json files for now: http://data.threesixtygiving.org/dataset/macc-grants

[stevieflow]

@caprenter I'm going to do this in salesforce for this org, so we can test if publishing via google docs is feasible (it should be, given that we're just publishing the link, and not previewing)