[ckan-dev] xlsx import strange behaviour

Tue Nov 22 08:31:07 UTC 2016

Matt,

what I discovered this weekend confirms what you are writing below. Some
xls/xlsx files failed to load on the Azure instance. As they didn't load,
jsonpdataproxy.appspot.com is triggered.

On Azure, a xls/xlsx files with column where the first value (after the
header) is numeric trigger an error in :

/usr/lib/ckan/datapusher/lib/python2.7/site-packages/messytables/types.py
on line 188
if len(value) == 1:
TypeError: object of type 'float' has no len()

I solve my issue returning False just before this line (it is a bad patch
... but I needed to go forward)

Do you have a clue about why, the same files could trigger an error on
Azure and not on VirtualBox, Linode ? (same installation)

Best

On Mon, Nov 21, 2016 at 3:01 PM, Matthew Fullerton <matt.fullerton at gmail.com
> wrote:

> Hi Francois,
> The second part is just a signal that pushing to the datastore using the
> datapusher didn't work. Pushing not working could be because of firewall
> (i.e. port configuration on Azure) issues. Datapusher tries to access CKAN
> from the "outside" using your ckan_url and the datapusher port. If you can
> ensure that accessing the datapusher from the CKAN Azure machine itself
> (but using the public url) works, then this might start working.
>
> Also, looking under "Manage"... for the Resource under Datastore should
> show whether pushing was attempted and if it worked.
>
> -Matt
>
> P.S. The thing with not needing to use the public URL is a known issue:
> https://github.com/ckan/datapusher/issues/83#issuecomment-151121100
>
> --
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20161122/5f02b1d5/attachment-0003.html>