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

Fri Jul 20 17:51:29 BST 2012

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?

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

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