[ckan-dev] Previewer with semicolon separated CSVs?

Matthew Fullerton matt.fullerton at gmail.com
Wed Jan 23 11:36:39 UTC 2019


This is relevant:
https://github.com/ckan/ideas-and-roadmap/issues/217

A solution of sorts was actually quite close.

I remember a call where it was decided to remove the JSON proxy.

-Matt

On Wed, 23 Jan 2019 at 11:49, Stefan Oderbolz <stefan.oderbolz at liip.ch>
wrote:

> 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
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20190123/b4e5f2a0/attachment-0002.html>


More information about the ckan-dev mailing list