[ckan-discuss] Random column sorting in grid preview for csv resource in datahub.io

Tue Jul 24 19:20:36 BST 2012

On 20 July 2012 17:51, José Félix Ontañon <fontanon at emergya.com> wrote:
> I guess the data type for storing the key/values is a python
> dictionary, and it doesn't store any sort order. Am i wrong?

Strictly it's a JSON dictionary in ElasticSearch but the same answer.

> If this is to be fixed I could give a hand, maybe.
> Is there any ticket for tracking advances in this issue?

There is no simple way to fix this without some actual work to store
this when we create the DataStore table in ElasticSearch. We're
working on a new Postgres based DataStore which may assist with
solving this issue.

Rufus

> Cheers,
>
> 2012/7/19 Rufus Pollock <rufus.pollock at okfn.org>:
>> OK, simple answer: the datastore as pure key/value does not support
>> storing the original column sort order - you just get the order the
>> keys come back in.
>>
>> This is something we've been thinking about (e.g. storing column sort
>> order in the _meta of the mapping).
>>
>> I note this does not happen with the dataproxy because that returns
>> the column order (and recline supports preserving column order).
>>
>> Rufus
>>
>> On 19 July 2012 20:48, José Félix Ontañon <fontanon at emergya.com> wrote:
>>> 2012/7/19 Rufus Pollock <rufus.pollock at okfn.org>:
>>>> Can you point to the dataset?
>>>>
>>>> Rufus
>>>
>>> Oh! Sorry
>>>
>>> This is the dataset URL: http://datahub.io/dataset/seville-budget
>>> And this is the resource:
>>> http://datahub.io/dataset/seville-budget/resource/accfda1e-e3ed-40fe-a683-69645ab51f5b
>>>
>>> Regards,
>>>
>>>> On 19 July 2012 19:56, José Félix Ontañon <fontanon at emergya.com> wrote:
>>>>> Hi, I'm not sure this is the correct mailing list for my question. If
>>>>> i'm wrong, please show me the right one,
>>>>>
>>>>> I've uploaded recently a csv file as resource for a dataset i'm
>>>>> working inside datahub.io
>>>>> The grid preview isn't displaying columns sorted as in the csv, but in
>>>>> a random order, why?
>>>>>
>>>>> Is there anything I can do?
>>>>> Regards,
>>>>>
>>>>> --
>>>>> J. Félix Ontañón Carmona
>>>>> Emergya Consultoría
>>>>>
>>>>> _______________________________________________
>>>>> ckan-discuss mailing list
>>>>> ckan-discuss at lists.okfn.org
>>>>> http://lists.okfn.org/mailman/listinfo/ckan-discuss
>>>>
>>>>
>>>>
>>>> --
>>>> Co-Founder, Open Knowledge Foundation
>>>> Promoting Open Knowledge in a Digital Age
>>>> http://www.okfn.org/ - http://blog.okfn.org/
>>>
>>>
>>>
>>> --
>>> J. Félix Ontañón Carmona
>>> Emergya Consultoría
>>
>>
>>
>> --
>> Co-Founder, Open Knowledge Foundation
>> Promoting Open Knowledge in a Digital Age
>> http://www.okfn.org/ - http://blog.okfn.org/
>
>
>
> --
> J. Félix Ontañón Carmona
> Emergya Consultoría

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