[ckan-dev] recline data type error?

Thu Aug 23 09:29:13 UTC 2012

You don't need quote marks in the CSV (though they shouldn't hurt) and
yes YYYY-MM-DD format is best (though other formats *may* work as
well).

Looking at the _mapping it does appear this field has been recognized
as date/time

http://data.cityofsantacruz.com/api/data/962cc112-570a-4fd1-a276-6c9bc07175ac/_mapping

Rufus

On 22 August 2012 21:05, Jim Craner <jim at codeforamerica.org> wrote:
> Just to confirm, dates should be stored in the underlying CSV in
> YYYY-MM-DD format, wrapped in "quote" marks, correct?
>
> Thanks!
> Jim
>
> On Wed, Aug 22, 2012 at 11:27 AM, Rufus Pollock <rufus.pollock at okfn.org> wrote:
>> Not really able to see the error immediately from that error log Jim
>> and date/time formatting seems pretty good. Hmmm!
>>
>> Rufus
>>
>> On 21 August 2012 18:03, Jim Craner <jim at codeforamerica.org> wrote:
>>> Hi all,
>>>
>>> Running CKAN 1.7, installed from source, on Ubuntu 10.04 LTS.  Uploaded a
>>> CSV with monthly data, for the date column I used format YYYY-MM-DD.
>>>
>>> I am 99.99% positive that I was once able to sort the resulting Recline grid
>>> by Sort Ascending on the Month column, which resulted in the data being in
>>> chronological order.
>>>
>>> However, when I try that now, nothing happens in Recline and I get the
>>> following pile of Java errors in my ElasticSearch logs:
>>>
>>> http://pastebin.com/SnUqj0ws
>>>
>>> Resource in question is here:
>>>
>>> http://data.cityofsantacruz.com/dataset/monthly-rainfall-totals-santa-cruz-1996-2006/resource/962cc112-570a-4fd1-a276-6c9bc07175ac
>>>
>>> I see an Issue about ElasticSearch failing on string sort here, but it
>>> doesn't look like there's a resolution mentioned:
>>>
>>> https://github.com/okfn/recline/issues/133
>>>
>>> Can anyone suggest any troubleshooting steps?  Alternatively, is there a
>>> better way to format the month value so CKAN/Recline accepts it as a date
>>> value instead of a string?
>>>
>>> Thanks!
>>> Jim
>>>
>>> --
>>> -----
>>> Jim Craner, 2012 Fellow
>>> Code for America
>>> jim at codeforamerica.org
>>> (+1) 773-809-4546
>>> http://codeforamerica.org
>>>
>>>
>>> _______________________________________________
>>> ckan-dev mailing list
>>> ckan-dev at lists.okfn.org
>>> http://lists.okfn.org/mailman/listinfo/ckan-dev
>>>
>>
>>
>>
>> --
>> Co-Founder, Open Knowledge Foundation
>> Promoting Open Knowledge in a Digital Age
>> http://www.okfn.org/ - http://blog.okfn.org/
>>
>> _______________________________________________
>> ckan-dev mailing list
>> ckan-dev at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/ckan-dev
>
>
>
> --
> -----
> Jim Craner, 2012 Fellow
> Code for America
> jim at codeforamerica.org
> (+1) 773-809-4546
> http://codeforamerica.org

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