[ckan-dev] is my datastore working correctly?

[Dominik Moritz]

Hi George,

looks good. The datastorer can only import CSV, TSV, XLS and XLSX files at the moment. The data-API button is only visible if the resource is available in the datastore. You can check which resources are in the datastore at `http://127.0.0.1:5000/api/3/action/datastore_search?resource_id=_table_metadata`. The .xlsx file is not recognized because `application/vnd/openxmlformats-officedocument.spreadsheetml.sheet` is not yet recognized by the datastorer. I'll make the necessary changes and push it to the repository. You will need to update the datastorer to get the fix, though.

Best wishes,
Dominik

On 3 Apr 2013, at 05:45, George Sattler <George.sattler at xvt.com.au> wrote:

> 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.
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev