A demonstration of a simple Yahoo! Pipe.
Yahoo! Pipes has been around for a while now, but I would like to showcase this excellent tool by demonstrating the creation of an 'On This Day In History' type feed which I have recently created. It is a simple 'Pipe' - many fantastic and complicated uses are possible for mashing up feeds from all sorts of sources - but I hope this is a good 'starter' demo which will encourage people to build something useful for their business sites. You can put a 'Pipe' on any web page, and of course they are particularly suited for sucking into a Webadvantage® module, so businesses who use Glanton Solutions should be particularly interested. Why not create something relevant for your customers and/or employees to give your site enhanced individuality and 'stickiness'?
My demo comes from the website I manage for the Crimean War Research Society. Rather esoteric you say? Yes, just a bit! However, this particular 'Pipe' can be easily modified to fit any number of situations.
It all started about four years ago when I decided that some sort of 'On This Day' feature would be good on the society website - not just 'on this day in history', but specifically 'on this day during the Crimean War'. I was inspired by the fact we had a chronological list of main events during the war on our site, amounting to 103 dates from 1853 to 1856 inclusive.
Could I expand this and re-jig it so it was a list of 365 - plus one for Feb 29 1856, the day in that leap year when the armistice was signed - and make the right event(s) image appear at the top of our homepage on the right date...?
Below is a diagram of how it works [click on each image to view at full size]:
However, more recently I had become fascinated by the idea of providing the whole thing as an RSS feed so that people could put it on their own site, or suck it into a feed reader. How to do it? To start with I thought a combination of Feedity and Yahoo! Pipes might do the trick. Feedity is a very neat tool with which you can create an RSS feed from a webpage which doesn't have one. It is very cute, and I have used it elsewhere, but the free version only allows you up to 10 posts in the resulting feed. As I'm way too cheap to pay for one of the pro deals at Feedity, this clearly wasn't going to work for my 366 items. Yahoo! Pipes on its own would clearly have to be the answer - I would have to work out what was going to be the best format to suck in my data. I looked at XML, but ended up converting my original XLS spreadsheet to CSV (Comma Seperated Values) and adding a few columns to define the navigation and add a link to the final feed. Then I uploaded it to a server.
The whole Pipes interface and drawing board is wonderfully designed: you really feel as if you are doing the plumbing! The first thing to put on the drawing board was a 'Fetch CSV' module, which happens to be the first one in the 'Source' folder. It was then a simple matter to enter the URL of my CSV file and give names to its five columns. Now at this stage all you would get as output is the whole CSV file as 366 posts in an RSS feed.
So from the 'Operator' menu I selected the 'Filter' module, and the 'Date builder' from the 'Date' menu. See image below. The date for my purposes had to be 'today' and this had to be connected to the 'Day' and 'Month' columns of the CSV file, restricting the filter's output to the right day in the right month.
The resulting Yahoo! Pipe is here.
The great thing about Pipes is that there are hundreds published and you can clone ones that you think will work for you to your own free account. There you can modify them precisely to your specifications - or if no one has done something similar in the past, you can start from scratch. The potential for business websites is enormous: from mash-ups of news feeds about your particular industry, through comparative prices of raw materials to 'quotes of the day' or 'did you know that' - the latter two ideas could use a clone of my Pipe as a base from where to suck in you own CSV file. The output of your Pipe can be pumped into various social media sites, got as a 'badge', RSS, JSON, PHP or CSV, or sent by email or phone.
Our next post will be Glanton Solutions personnel giving their personal recommendations for free tools and apps they can't live without. Stay tuned!