desktop liberation
Follow
Find
16.6K views | +0 today
desktop liberation
Your new post is loading...
Your new post is loading...
Scooped by brucemcpherson
Scoop.it!

draft-kelly-json-hal-03 - JSON Hypermedia API Language

Never knew there was an RFC for building JSON Hypermedia APIs: "draft-kelly-json-hal-03 - JSON Hypermedia API Language" http://t.co/zoSbWgfw...
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Select, prettify publish snippets in multiple languages from within a GIST module

Excel Liberation.: Select, prettify publish snippets in multiple languages from within a GIST module | desktop liberation | Scoop.it

I posted how to include and prettify snippets from GAS, Gist, and scriptDB the other day, adding the ability to select particular functions from within modules. With Google Apps Script, we only had to worry about how to pick out functions from a javascript module. Now that Gists are supported - well, they could be any language. Turns out though that it's pretty straightforward to add new languages. Anybody want to try?

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Windows 8 exploited by Google doc hack - Fudzilla

Windows 8 exploited by Google doc hack - Fudzilla | desktop liberation | Scoop.it
Hot HardwareWindows 8 exploited by Google doc hackFudzillaBut what is odd about the malware is that it uses Google Docs.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Google Apps Script Liberation - publishing your stuff

Usually on this blog and the associated site I cover topics to do with getting data in an out of Excel. Lately though, I've been playing around with using Google Apps Script as a proxy and publishing data out of Google Apps Scripts.

I've brought many of those concepts together to create a single publisher to expose your scripts, scriptdb data and other public content in a variety of formats such as standalone web page, a js function that returns the html code for a page, as json data and as jsonp data. I've also included a code prettifier and json beautifier in the code.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Is It Too Late for Microsoft Office to Matter on Mobile? - Wired

Is It Too Late for Microsoft Office to Matter on Mobile? - Wired | desktop liberation | Scoop.it
Complex.comIs It Too Late for Microsoft Office to Matter on Mobile?WiredLikewise, Microsoft Excel was the spreadsheet program everyone had.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Google Introduces Six-Month Trial for Cloud SQL

Google Introduces Six-Month Trial for Cloud SQL | desktop liberation | Scoop.it
Google has pushed out a Cloud SQL update: more storage, faster reads, faster writes, EU datacenter, Google Apps Script integration, and a six-month trial.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Google Apps Script - a new day - a new feature

GAS just keeps getting better. I was thinking the other day about how I might be able to embed sample Google Apps Script code in Google Sites, or other web sites in the way that you can embed Gist samples from github.

Here's how to use a  new (I think undocumented) method of the ScriptApp Class to help publish the source code of your script file.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Delegating processing to the cloud from Excel and other plafforms

Excel Liberation.: Delegating processing to the cloud from Excel and other plafforms | desktop liberation | Scoop.it

Excel liberation is all about being able to step outside Excel, whether it's getting public data, integrating with other platforms or in the case of today's post, interacting with and delegating processing to the cloud on a completely different environment.

In today's post, I'll describe where I've got to in bringing together a bunch of topics I've been posting on from time to time. The general theme is to have a single place where a library of scripts, rest API queries, mashups, API keys and other things could be accessible from multiple platforms (well Excel, javaScript and Google Apps Script at least), and where possible, sharing code. Here are the various threads I can finally pull together.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Visualization: Every hurricane since 1851 ~ Policy by the Numbers

Visualization: Every hurricane since 1851 ~ Policy by the Numbers | desktop liberation | Scoop.it
Visualization: Every hurricane since 1851. ... On Monday, our friends at The Guardian Data Store posted a very cool visualization of the world's hurricanes since 1851 by John Nelson. The underlying dataset is from NOAA's ...
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: API library entry of the day: use builtwith.com to see how websites are built

Excel Liberation.: API library entry of the day: use builtwith.com to see how websites are built | desktop liberation | Scoop.it

I came across a great site, builtwith.com, that shows the technology being used in a given web site. You can also take a look and see the usage of various specific technologies over time. Now, this site has an API, so I thought I'd add it to the rest library. 

Here's the output for 'msdn.com'. (Interesting that microsoft are using both google webmaster and bing webmaster).

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Google Caching and faking jsonp

In Proxy jsonp we covered how to fake jsonp requests using google content service. Another advantage of piping this stuff through Google Apps script is that we can now use the Google Caching service to speed up multiple requests for the same thing.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Zoomable d3.js partition charts straight from Excel

Excel Liberation.: Zoomable d3.js partition charts straight from Excel | desktop liberation | Scoop.it

It's been a while since I played around with d3.js. Previously I've covered Sankey diagrams, trees, force diagrams and a few others - all directly fromf excel. Now here's how to create a zoomable d3.js partition chart straight out of excel.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Selecting specific Gist and GAS functions for publication

Excel Liberation.: Selecting specific Gist and GAS functions for publication | desktop liberation | Scoop.it

In publishing gists and publishing Google Apps Scripts I showed how to prettify and embed snippets in web sites, blogs and so on. However, one last requirement is to be able to publish only particular functions. Although you can select particular modules and libraries for publication, this is probably not granular enough for small snippets. So here's how to select particular functions from a module for publication, from both Google Apps Script and Github.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Publishing and prettifying Gists through google apps script

The other day, I showed how to prettify Google Apps Script snippets and scriptDB contents, include them in web sites, blogs and google sites, and encode them in jSon and jSonP using the GAS content service and html service. This provides a simple way to share your code. Here's how to publish, prettify and embed  source code GIst snippets in exactly the same way.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Using Google Cache to persist data across function calls

When working with spreadsheet data, I always use sheet caching - a class in the mcpher library. This gives great performance improvements and simplification for processing Sheet Data and other attributes. But the cache doesn't persist across discrete function calls. Here's how to get performance when you have reference material in a Spreadsheet.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Google Apps Script Publisher - embed prettified code snippets and data

Google Apps Script Publisher - embed prettified code snippets  and data | desktop liberation | Scoop.it

Here's how to embed all your public Google Apps Script code snippets and scriptDB data in Google Sites and other consumers. http://ramblings.mcpher.com/Home/excelquirks/gaspublish. Includes code and jSon prettification, standalone publishing and publishing data as jSon and jSonp objects. No server required - it's all done with GAS templates, HTML service and content service.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Microsoft adds Excel surveys to SkyDrive - Neowin

Microsoft adds Excel surveys to SkyDrive - Neowin | desktop liberation | Scoop.it
Microsoft has announced that it has finally added its previously promised support for online Excel surveys for all users of its Microsoft SkyDrive cloud-based service.
more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Publishing Google Apps Script code snippets

In a previous post I showed how Google Apps Script could return the contents of a script as Json so you could format that for including script samples on web sites.

Today, here is how to use the html service to format that code.  It takes arguments of ?module=xxx&template=yyy and will use html template yyy, to publish module xxx.

 

 

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Delegation to Google Apps Script - Step by Step guide

Delegation to Google Apps Script - Step by Step guide | desktop liberation | Scoop.it

Here's a step by step guide showing how to use scriptDB to store data, to serve it up as a rest query, and to use google apps script as a proxy to process on your behalf, and return the result as jSon

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Keeping all those Google Apps script 'shortcuts' under control

I don't know about you, but I have trouble keeping all my various Google Apps Script shortcuts and keys (links to workbooks, links to content service queries, library keys and so on) under control and organized. I think that previous posts about using the scriptDB as a lockbox, using Google Apps Script as a jsonP proxy and various others showed the power of ScriptDB for sharing data both inside and outside the Google Apps Script environment. Here's how to organize all your publicly shared GAS links and keys and distribute them with json.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Somewhere to keep those API keys: google apps script rest library entry

Excel Liberation.: Somewhere to keep those API keys: google apps script rest library entry | desktop liberation | Scoop.it

In the builtwith.com api rest library entry for Excel I covered how to get data about a given web site using the builtwith.com API. I went against my usual rule here, by including an api that needs an API Key. Here's how to securely store your API keys in one place, and use them without exposing them in your code. 

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Excel Liberation.: Shortening a string, but keeping it unique: Google Apps Script Caching Keys

In Google Caching and faking jsonP, i showed how to use google cache to avoid multiple calls to the same json data. One of things i discovered was that the key value in google cache services has an undocumented maximum length, so the challenge is to figure out how to come up with a unique key that will not break any limits, given a URL of unpredictable length.

One way to shorten the key is to use the a cryptographic hash function. Google apps script has a variety of these built-in. I selected the SHA_1 function since it is pretty collision resistant (meaning it is unlikely that 2 keys will be hashed to the same result).

So here is a function to shorten a key to a manageable size.

more...
No comment yet.
Scooped by brucemcpherson
Scoop.it!

Proxy jsonp - How to use Google Apps Script to avoid same origin json problems

Proxy jsonp - How to use Google Apps Script to avoid same origin json problems | desktop liberation | Scoop.it

If you are reading this, I guess you are familiar with this error message "XMLHttpRequest cannot load somedata.json. Origin null is not allowed by Access-Control-Allow-Origin."

This is of course the same origin policy that prevents you being able to access jSon data that is stored on a different domain than your javaScript Code. This is really annoying if you are trying to use publicly hosted data, but there are ways round it.

 

Here's how to use Google Apps Script as a Proxy for all your jsonp needs.

more...