[ckan-dev] File Upload Hugs ckan 1.7

Sat Jul 28 10:02:31 UTC 2012

Hi John,

As Adria says, the question here is whether you have set up the
DataStore or not (and are storing data into it). CKAN provides 2
routes for doing Data (Pre)Views:

* Use the DataProxy route
* Use the DataStore route

The DataProxy route does not require you to install anything as it
uses a DataProxy running outside of CKAN and it will usually work for
CSV and Excel files. A summary of how the system works is given in
this diagram here:

https://docs.google.com/drawings/d/1IkZluguoWT6Gd92_-0uHeFviZkUrufQdeP9b76e8Zu0/edit

To assist here can you provide the URL to the CSV file referenced in
the Resource that you are trying to view?

Rufus

On 27 July 2012 07:35, John <john at farwell-consultants.com> wrote:
> @ Rjufus
> I have defined the file type as a csv but still the problem persists.
>
> @ Adrià
> The Process for enabling the data store requires Nginx as the deployment web
> server , is it possible  to have data store  work on Apache or do I first
> have to deploy Ckan on Nginx  first?
>
>
> John
>
> -----Original Message-----
> From: ckan-dev-bounces at lists.okfn.org
> [mailto:ckan-dev-bounces at lists.okfn.org] On Behalf Of Adrià Mercader
> Sent: Thursday, July 26, 2012 6:58 PM
> To: CKAN Development Discussions
> Subject: Re: [ckan-dev] File Upload Hugs ckan 1.7
>
> On 26 July 2012 14:11, John <john at farwell-consultants.com> wrote:
>> Now the error is "Only HTTP URLs are supported: Data proxy does not
>> support URLs" when I try to preview the csv file I have  uploaded
>
> The problem may be that you are trying to pass a file which was uploaded to
> your server (so it has a
> http://localhost:5000/storage/f/...) to the DataProxy, which is an external
> service (it lives at http://jsonpdataproxy.appspot.com/) and does not have
> access to your computer.
>
> This will work if you were on a publicly accessible instance
> (http://yoursite.ckan.org or similar).
>
> Note that the CSV preview works as follows:
>
> 1 - If the file has been uploaded to the local datastore, this is used to
> query the data
> 2 - If not, the file is queried via the DataProxy
>
> You are on point 2, so the proper fix is probably installing and configuring
> the datastore (and the datastorer extension), as per these
> instructions:
>
> http://docs.ckan.org/en/ckan-1.7.1/datastore.html#installation-and-configura
> tion
> http://docs.ckan.org/en/ckan-1.7.1/datastore.html#datastorer-automatically-a
> dd-data-to-the-datastore
>
>
> Adrià
>
>
>
>> John
>>
>> -----Original Message-----
>> From: ckan-dev-bounces at lists.okfn.org
>> [mailto:ckan-dev-bounces at lists.okfn.org] On Behalf Of Sean Hammond
>> Sent: Thursday, July 26, 2012 3:24 PM
>> To: ckan-dev at lists.okfn.org
>> Subject: Re: [ckan-dev] File Upload Hugs ckan 1.7
>>
>>> Yes I am logged in as a sysadmin, I  have also set up the
>>> "pairtree_version0_1" file inside the upload  directory as suggested
>>> in some posts, this only served to solve the "failed to get
>>> credentials" error
>>
>> Hi John, unfortunately this could be quite difficult to debug. Is
>> there any more information you can provide about your setup and what
>> is happening? See my reply to your earlier thread for suggestions:
>>
>> http://lists.okfn.org/pipermail/ckan-dev/2012-July/002725.html
>>
>> _______________________________________________
>> ckan-dev mailing list
>> ckan-dev at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/ckan-dev
>>
>>
>> _______________________________________________
>> ckan-dev mailing list
>> ckan-dev at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/ckan-dev
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev

-- 
Co-Founder, Open Knowledge Foundation
Promoting Open Knowledge in a Digital Age
http://www.okfn.org/ - http://blog.okfn.org/