[ckan-dev] Previewing resources with Google Docs

Fri Mar 20 14:22:09 UTC 2015

The excel spreadsheet now works as well. Yesterday I tried to view it in Chrome and saw nothing, but today I can view it.

Claire

From: Ross Jones [mailto:ross at servercode.co.uk]
Sent: March 20, 2015 08:26
To: CKAN Development Discussions
Subject: Re: [ckan-dev] Previewing resources with Google Docs

I've flipped it over to the office docs, the PDF is missing-in-action,but is the XLS at http://liverpool.servercode.co.uk/dataset/lcc-payments-of-invoices-to-vendors-over-500-april-2012/resource/a03edab7-ccbb-4af8-89e6-032716e56d0c any better?

Thanks for your help in checking this - useful to know it isn't *just* working (or not) for me.

Ross

On 19 Mar 2015, at 20:45, Aaron McGlinchy <McGlinchyA at landcareresearch.co.nz<mailto:McGlinchyA at landcareresearch.co.nz>> wrote:

Hi, I tried the links below, the pdfs worked great, but the xls gave an error and did not load at all.

That was using both Firefox and IE

Cheers
Aaron

----------------------------------------------------------------------

Message: 1
Date: Wed, 18 Mar 2015 19:09:04 +0000
From: Ross Jones <ross at servercode.co.uk<mailto:ross at servercode.co.uk>>
To: CKAN Development Discussions <ckan-dev at lists.okfn.org<mailto:ckan-dev at lists.okfn.org>>
Subject: [ckan-dev] Previewing resources with Google Docs
Message-ID: <FF432145-4B23-420E-87D0-B5C545F5A475 at servercode.co.uk<mailto:FF432145-4B23-420E-87D0-B5C545F5A475 at servercode.co.uk>>
Content-Type: text/plain; charset="us-ascii"

Hi,

After finally getting fed up with watching the Javascript loading spinner when trying to view Excel files (and only seeing the first sheet when it did load) I decided to try using the Google Docs preview which you can embed into your pages  ( docs.google.com/preview?url=<http://docs.google.com/preview?url=> <http://docs.google.com/preview?url=><URL>&embedded=true for reference).

So I wrote https://github.com/rossjones/ckanext-gdoc <https://github.com/rossjones/ckanext-gdoc> which is an IResourceView that does just that - it will allow you use use the google docs previewer for .doc, .xls, .xlsx and .pdf file.. Wrote is a strong word, there really isn't that much to it.

I've deployed in on a test site I have been playing with today, and you can (hopefully) see the pdf previewing just fine at http://liverpool.servercode.co.uk/dataset/lcc-payments-of-invoices-to-vendors-over-500-april-2012/resource/3bdb30bd-afb1-4f68-a680-4bcb1bbf7174 <http://liverpool.servercode.co.uk/dataset/lcc-payments-of-invoices-to-vendors-over-500-april-2012/resource/3bdb30bd-afb1-4f68-a680-4bcb1bbf7174>

Unfortunately, *and totally defeating the point of the whole exercise*, Google Docs Previewer seems to be having a tough day with XLS files today - http://liverpool.servercode.co.uk/dataset/lcc-payments-of-invoices-to-vendors-over-500-april-2012/resource/a03edab7-ccbb-4af8-89e6-032716e56d0c <http://liverpool.servercode.co.uk/dataset/lcc-payments-of-invoices-to-vendors-over-500-april-2012/resource/a03edab7-ccbb-4af8-89e6-032716e56d0c>

If anyone could find ten minutes to give it a try and see if it works for them, I'd be eternally grateful.  Well, for a while anyway, maybe not eternally.  If this does eventually work (it has before so I assume Google is just having a bad day) then I'll add some config options to allow you to specify which formats it will cope with (i.e. it also supports PPT but I refuse to believe it is possible to call anything in a PPT data).

Cheers

Ross

p.s. I was impressed on doing my first IResourceView just how easy it was to do - much easier than I imagined it would be. Give it a try ....

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20150318/9caec859/attachment-0001.html>

------------------------------

________________________________

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<mailto: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/20150320/f96099bb/attachment-0003.html>