CKAN ERROR 预览 CSV ，但可以下载 [英] CKAN ERROR preview CSV , but OK for Download

问题描述

我的本​​地测试机出现以下错误，刚刚安装.Ckan、datapusher、datastore 都在同一台机器上.

I have the following error in my local test machine, just instaled. Ckan, datapusher, datastore all in the same machine.

访问 csv 资源时，我收到以下消息；"此资源视图目前不可用.单击此处了解更多信息.

Accesing a csv resource i have the following message; "This resource view is not available at the moment. Click here for more information.

无法加载视图:DataProxy 返回错误(数据转换失败.错误:连接到服务器时发生错误:无法在 URL 处连接到服务器:http://192.16set-2fac17e2f/resource/015a5fc1-efac-49c8-9aff-82b04b0bdc93/download/MICCSV.-97c2-51101dcfee2f/resource/015a5fc1-efac-49c8-9aff-82b04b0bdc93/download/MICCSV.csv)"

Could not load view: DataProxy returned an error (Data transformation failed. error: An error occured while connecting to the server: Unable to connect to server at URL: http://192.168.146.131/dataset/f2139e6a-7e22-41b1-97c2-51101dcfee2f/resource/015a5fc1-efac-49c8-9aff-82b04b0bdc93/download/MICSV.csv)"

是一个简单的CSV测试burt看不到URL 没问题，我可以通过在导航栏中复制/粘贴来访问资源.可能是conf中的一些东西.我忘记了插件?

Is a simple CSV for test burt cannot see The URL is ok, i can access the resorce by copy/paste in the navbar. May be some thing in conf. I forget a plugin?

我的 conf 文件中修改的行是:

The modified lines in my conf file are:

sqlalchemy.url = postgresql://ckan_default:pass@localhost/ckan_default
ckan.datastore.write_url =     postgresql://ckan_default:pass@localhost/datastore_de

故障ckan.datastore.read_url = postgresql://datastore_default:pass@localhost/datastore_default

fault ckan.datastore.read_url = postgresql://datastore_default:pass@localhost/datastor e_default

ckan.site_url = http://127.0.0.1
solr_url = http://127.0.0.1:8983/solr
ckan.storage_path = /var/lib/ckan/default
ckan.datapusher.url = http://127.0.0.1:8800
ckan.plugins = stats text_view image_view recline_view datastore datapus       her resource_proxy recline_preview

推荐答案

CSV 预览使用 DataProxy，它是来自 OKF (http://jsonpdataproxy.appspot.com/).此服务下载 CSV 并解析其内容.为了正常工作，资源必须是公开可用的.这意味着您的 CKAN 实例必须具有公共 IP，并且必须可以从 Internet 访问.

The CSV preview uses the DataProxy, which is a service from the OKF (http://jsonpdataproxy.appspot.com/). This service downloads the CSV and parses its content. In order to work properly the resource must be publicly available. This means your CKAN instance must have a public IP and must be accessible from the internet.

我的猜测是 192.168.146.131 不是您的公共 IP，因此它不起作用.如果这只是一个内部测试系统，它是行不通的.您可以运行自己的 dataproxy 本地实例.

My guess is that 192.168.146.131 is not your public IP, hence it doesn't work. If this is just an internal test system, it wouldn't work. You could run your own local instance of dataproxy.

未来，我会考虑切换到DataStore 或查看新的 Resource Views from >= CKAN 2.3.

In the future, I would consider to switch to the DataStore or look at the new Resource Views from >= CKAN 2.3.

这篇关于CKAN ERROR 预览 CSV ，但可以下载的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！