[ckan-dev] Importing XLS resources with many sheets to DataStore

Thu Jan 24 11:02:39 UTC 2019

Hi,

I'm working on a CKAN installation where we import XLS resources that have
two problems:

- Some of them have several sheets, so only one of them is
imported/previewed.
- Some of them don't follow a "strict" tabular format (i.e. some columns
are joined to be used as titles, subtitles etc.)

I see this problems is already identified and documented in places like Spec:
DataStore and FileStore Consolidation
<https://github.com/ckan/ckan/wiki/Spec:-DataStore-and-FileStore-Consolidation>
and #123 <https://github.com/ckan/ideas-and-roadmap/issues/123>.

¿Which is the current status of supporting XLS files with many sheets?¿Any
suggestions on what to do for resources that don't follow a strict "tabular
format"?

We're thinking of giving a try to ckanext-officedocs
<https://github.com/jqnatividad/ckanext-officedocs> or directly disable the
preview for XLS resources with only two columns (it's the pattern we've
seen for resources which are not parsed correctly) - this last is a bit
fragile.

Thanks in advance!

Alberto Miedes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20190124/b199bd25/attachment.html>