[ckan-discuss] CSV files vs tab delimited text

Joe Tsoi joe.tsoi at okfn.org
Wed Oct 2 10:40:26 BST 2013


The datastore combined with the upcoming datapusher as a core
extension in ckan 2.2 can address this, it's currently in development
in this branch[1]. Messytables [2] is used to autodetect the delimiter
of the csv file as it gets pushed to the datastore

If you guys are able to help test it out then that would be great! I
would of course not recommend it for production environments right
now. You can also help test the backport of the datapusher core
extension for 2.1 [3]

[1]https://github.com/okfn/ckan/pull/1200
[2]https://github.com/okfn/messytables
[3]https://github.com/okfn/ckanext-datapusherext

On 2 October 2013 01:58, Tim McNamara <paperless at timmcnamara.co.nz> wrote:
> If CKAN could infer the delimiter and/or provide the user with an option to
> select their own, that would be a nice piece of functionality.
>
>
>
>
> On 2 October 2013 11:20, Aaron McGlinchy <McGlinchyA at landcareresearch.co.nz>
> wrote:
>>
>> Hi,
>>    I was demonstrating CKAN to someone the other day, and showing them how
>> for a CSV file you can preview the data, draw graphs (and map if spatial
>> data).  This is a really nice feature of CKAN.
>>
>> The person raised the question of commas (',') in a dataset and suggested
>> that using tab delimited text files can get around that issue.
>>
>> So, could the preview  be adapted to cope with tab delimited text?  How
>> have other people dealt with ',' in the data?
>>
>> Thanks
>> Aaron
>>
>> ________________________________
>>
>> Please consider the environment before printing this email
>> Warning: This electronic message together with any attachments is
>> confidential. If you receive it in error: (i) you must not read, use,
>> disclose, copy or retain it; (ii) please contact the sender immediately by
>> reply email and then delete the emails.
>> The views expressed in this email may not be those of Landcare Research
>> New Zealand Limited. http://www.landcareresearch.co.nz
>>
>> _______________________________________________
>> ckan-discuss mailing list
>> ckan-discuss at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/ckan-discuss
>> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-discuss
>
>
>
> _______________________________________________
> ckan-discuss mailing list
> ckan-discuss at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-discuss
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-discuss
>



More information about the ckan-discuss mailing list