[ckan-dev] Offering the same resource in multiple file formats

Tue Mar 14 10:12:14 UTC 2017

This probably doesn't help you much but I recently noticed that Google's
drive API can export a range of formats from Google Sheets, e.g.:

https://github.com/okfde/2030-watch-dataprocessing/blob/master/gsToJson.py#L102

Best,
Matt

--
Matt Fullerton
Software development & data science for open data and mobility
matt at crowdsalad.de
+49 89 7456 0495 / +49 176 5789 6501
http://www.crowdsalad.de

On 7 March 2017 at 14:39, <Florian.Brucker at it.karlsruhe.de> wrote:

> > It would be pretty easy to build XLSX output on
> > https://github.com/ckan/ckan/pull/3390 and you can already use this to
> > generate Excel-compatible CSVs with the bom=true parameter. Maybe it's
> > time to add a plugin interface to allow these formats to be extended
> > by plugins.
>
> Great idea! That would be a really nice way to do  the actual conversion,
> since it would lead to consistent results (no separate import/export
> logic). And a plugin-interface for custom datastore export formats would be
> really nice, too.
>
> That still leaves the question on how to offer this separate format to the
> users. For example, if one wanted to create separate XSLX-copies of
> CSV-resources then these need to be created and kept in sync. Any ideas for
> that or for other UI approaches?
>
>
> Regards,
> Florian
>
> "ckan-dev" <ckan-dev-bounces at lists.okfn.org> schrieb am 07.03.2017
> 14:30:49:
>
> > Von: Ian Ward <ian at excess.org>
> > An: CKAN Development Discussions <ckan-dev at lists.okfn.org>,
> > Datum: 07.03.2017 14:31
> > Betreff: Re: [ckan-dev] Offering the same resource in multiple file
> formats
> > Gesendet von: "ckan-dev" <ckan-dev-bounces at lists.okfn.org>
> >
> > It would be pretty easy to build XLSX output on
> > https://github.com/ckan/ckan/pull/3390 and you can already use this to
> > generate Excel-compatible CSVs with the bom=true parameter. Maybe it's
> > time to add a plugin interface to allow these formats to be extended
> > by plugins.
> >
> > On Tue, Mar 7, 2017 at 8:19 AM,  <Florian.Brucker at it.karlsruhe.de>
> wrote:
> > > Hi everybody,
> > >
> > > I often would like to offer the same resource in multiple file
> formats. For
> > > example, Excel's auto-import for CSV is rather broken, so instead of
> > > mangling all our CSV-files to suit Excel's needs I'd rather just offer
> > > XSLX-files of the same data in addition to "standard"-compliant
> CSV-files
> > > for everybody else.
> > >
> > > However, I definitely don't want to manually maintain the
> separateversions.
> > > Has anybody set up automated ways of doing this? Off the top of my
> head, I
> > > could image
> > >
> > > 1. Generating converted copies when the original resource is
> > > created/modified
> > > 2. Generating converted copies when they are requested
> > >
> > > Both have their pros and cons, so I'd love the hear some real-world
> > > experiences.
> > >
> > > In addition I'm wondering about the best way to present this choice to
> the
> > > user.
> > >
> > >
> > > Regards,
> > > Florian
> > > _______________________________________________
> > > 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
> > >
> > _______________________________________________
> > 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
>
> _______________________________________________
> 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/20170314/0193044d/attachment-0003.html>