[ckan-dev] handling xlsx files with Datapusher?

Fri Apr 4 04:24:43 UTC 2014

Hi Aaron,

This is great. If you can send a pull request, I'd be happy to review it!

Nigel Babu

Developer  |  @nigelbabu <https://twitter.com/nigelbabu>

The Open Knowledge Foundation <http://okfn.org/>

Empowering through Open Knowledge

http://okfn.org/  |  @okfn <http://twitter.com/OKFN>  |  OKF on
Facebook<https://www.facebook.com/OKFNetwork> |
Blog <http://blog.okfn.org/>  |  Newsletter<http://okfn.org/about/newsletter>

 CKAN | http://ckan.org/ | @CKANproject
<http://twitter.com/CKANproject> |the world’s leading open-source data
portal platform

On 4 April 2014 06:50, Aaron McGlinchy <McGlinchyA at landcareresearch.co.nz>wrote:

> I solved my own problem
>
> We have now got CKAN pushing XLSX format excel files to the datastore, and
> previewing works.  We also got tab delimited text files to work (using .tsv
> as extension (trying .tab we couldn't get to  work)).
>
> Edit the config.ini file to include
>
> ckan.datapusher.formats = csv xls xlsx tsv application/csv
> application/vnd.ms-excel
> application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
> application/vnd.ms-excel
>
> Perhaps the documentation could be updated to reflect this option (and/or
> the default config.ini setting updated)?
>
> Cheers
> Aaron
>
> ----------------------------------------------------------------------
> Today's Topics:
>
>    1. handling xlsx files with Datapusher? (Aaron McGlinchy)
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 3 Apr 2014 04:13:48 +0000
> From: Aaron McGlinchy <McGlinchyA at landcareresearch.co.nz>
> To: "ckan-dev at lists.okfn.org" <ckan-dev at lists.okfn.org>
> Subject: [ckan-dev] handling xlsx files with Datapusher?
> Message-ID:
>         <
> A924326C14714F409FB3703B815FF9FD122154E9 at HERMES.landcare.ad.landcareresearch.co.nz
> >
>
> Content-Type: text/plain; charset="us-ascii"
>
> Sorry for cross post - thought I was sending to this list frst time.
>
> Hi - is it possible to get the datapusher (and hence preview) to handle
> xlsx (latest format excel) files as well as the older xls?  Wondered if
> something like
>
> ckan.datapusher.formats = csv xls xlsx
>
> Default value: csv xls xlsx application/csv application/vnd.ms-excel
> application/vnd.ms-excel application
>
> would work?
>
> 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-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140404/b4c82d0c/attachment-0003.html>