[ckan-dev] is my datastore working correctly?

George Sattler George.sattler at xvt.com.au
Wed Apr 3 03:45:33 UTC 2013


Hi Everyone

I've enabled the datastore and tested it as per http://docs.ckan.org/en/latest/datastore-setup.html with the command,
curl -X GET http://127.0.0.1:5000/api/3/action/datastore_search?resource_id=_table_metadata
returning output that starts with this (I'm not pasting the entire output)...

{"help": "Search a datastore table.\n\n    The datastore_search action allows a user to search data in a resource.\n\n    :param resource_id: id or alias of the resource to be searched against.\n

... and I believe that this is what I should be seeing (at least, no errors are mentioned).

I've installed datastorer as per https://github.com/okfn/ckanext-datastorer and can launch 'paster celeryd' which is running while I try the following uploads:

If I upload a .csv file:

-          The output from celeryd indicates success

-          I can preview the data by clicking the Explore -> Preview button for the resource (shows a grid with the .csv file's content)

-          Data API button is clickable

If I upload a .json file:

-          The output from celery ends with "ChooseNotToDownload: Of content type "application/json" which is not a recognised data file for download"

-          I can preview the data by clicking the Explore -> Preview button for the resource and I can see the json printed on the screen

-          Data API button is NOT clickable

If I upload a .xlsx file:

-          The output from celery ends with "ChooseNotToDownload: Of content type "application/vnd/openxmlformats-officedocument.spreadsheetml.sheet" which is not a recognised data file for download"

-          I cannot preview the data - it says "No handler defined for datatype xlsx"

-          Data API button is NOT clickable

So, I'm confused as to what's happening here. Is the datastorer and datastore operating at all?

By the way, I'm using CKAN 2.0

Thanks

George

________________________________
This email and any files transmitted with it is confidential and intended solely for the use of the addressee. The unauthorised use, dissemination, forwarding, printing or copying of this communication is strictly prohibited. If you have received this communication in error please notify us immediately by reply email and destroy this communication. Any views and opinions presented in this email are solely those of the author and do not necessarily represent the views of XVT Solutions. The recipient should check this email and any attachments for viruses. XVT Solutions accepts no liability for the content of this email, and any damage caused by any viruses that could potentially be transmitted through this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130403/d641ac8d/attachment.html>


More information about the ckan-dev mailing list