[ckan-dev] Previewer with semicolon separated CSVs?

Stefan Oderbolz stefan.oderbolz at liip.ch
Wed Jan 23 10:49:14 UTC 2019

Hi Christoph

this has been an issue for quite some time (see
https://github.com/ckan/ckan/issues/1296) and the current consensus seems
to be to use the DataStore with DataPusher or XLoader, since these
components support semicolons and are maintained by the CKAN community.
Unfortunately if you have a standard installation of CKAN, it will
automatically use the legacy JSON proxy, which only handles truly
comma-separated values. Iirc there was a discussion about finally getting
rid of the json proxy, but I can't find it right now.

By using the DataStore and xloader you get previews, that are backed by
your own infrastructure and as a bonus an querable API to the data.

I'd say it's worth the effort and we use this approach for both
opendata.swiss and data.stadt-zuerich.chm where it works fine.

- Stefan

On Mon, Jan 21, 2019 at 3:36 PM Christoph Blank <cb at unused.at> wrote:

> Hi there,
> Is there any way the previewer can be configured to handle semicolon
> separated CSVs
> as well?
> Excel does not directly open comma separated files if the regional
> settings are Germany/Austria, etc and people keep uploading it like this.
> Thank you,
> Christoph
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev

Liip AG  // Limmatstrasse 183 //  CH-8005 Zürich
Tel +41 43 500 39 80 // GnuPG 0x7B588C67 // www.liip.ch
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20190123/43ec5996/attachment-0002.html>

More information about the ckan-dev mailing list