[ckan-dev] recline data type error?

Thu Aug 23 20:34:50 UTC 2012

Yeah, and plenty of other similarly-formatted time-based data sets are
working just fine on the site.  I'll mess around with reimporting and
tinkering a bit more.

Thanks for the advice!
Jim

On Thu, Aug 23, 2012 at 4:29 AM, Rufus Pollock <rufus.pollock at okfn.org> wrote:
> 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/

-- 
-----
Jim Craner, 2012 Fellow
Code for America
jim at codeforamerica.org
(+1) 773-809-4546
http://codeforamerica.org