[ckan-dev] xlsx import strange behaviour

[Matthew Fullerton]

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



On 17 November 2016 at 16:35, Bois Francois-Xavier <fxbois at gmail.com> wrote:

> Looking at the ressources loaded by the preview page on each server, I've
> detected that the Azure instance always load an url that looks like :
>
> http://jsonpdataproxy.appspot.com/?callback=jQuery171011270068980619152...
>
> Loading this url takes almost 10 seconds ... this should explain the
> timeout.
>
> What could explain that this resource is only loaded on the Azure instance
> ?
>
> Thank you in advance for your help
>
> > Hi
> >
> > I've installed CKAN on three servers : one on VirtualBox, one on a Linode
> > VM and one on Azure.
> >
> > CentOS7 is installed on VirtualBox and Linode, and Redhat 7 is installed
> on
> > Azure. The installation process is exactly the same on those 3 servers.
> >
> > I want to load a small xlsx file (300 lines).
> >
> > Import is ok for VirtualBox and Linode. On Azure the preview always fails
> > with the message : " This resource view is not available at the moment."
> >
> > If strip 100 lines (the xlsx file has now 200 lines), previsualisation
> > works fine. This means that the installation is ok.
> >
> > I have absolutely no idea how to debug this.
> >
> > Could it be a timeout ? (can I increase it ?)
> >
> > Should I look to any specific log file ?
> >
> > Best regards
>
> _______________________________________________
> 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/20161121/5eece9bc/attachment-0003.html>