Recently I posted an Experiment to dynamically timeline media posted on Twitter using Topsy and Timeline (my contribution to @Arras95) #arras95 which uses a Yahoo Pipes to extract tweets with images and videos using the Topsy Otter API, which is then pulled into a Google Spreadsheet before being rendered in a Timeline tool developed by Vérité.
This recipe appears to be working, that is the timeline is automatically updating with new media. There’s a separate question about practicality of the timeline and navigation which I’m quietly ignoring, instead I want to highlight some technical hit/misses and present a revised version.
Technical misses
Because Topsy includes tweets to image sites like twitpic and yfrog in the search results, which redirect to those sites rather than having an image source url these appear in frames (up until recently Timeline used the snapito.com API to convert into a thumbnail but this was recently removed because the free service was stopped).
To get around this I’ve modified the source Yahoo Pipe to only let image urls (new source Pipe here). This limits results to those uploaded via the Twitter official interfaces (e.g. Web/New Tweetdeck). Update: I’ve now coded the data collection from Topsy directly in the Google Spreadsheet using Google Apps Script. New version is available via the link at the end of the post.
If you wanted to replicate the original experiment another drawback was that you would have to host the Timeline code somewhere. As not everyone has easy access to a web host I’ve published an interface which lets you include the published Google Spreadsheet key in the URL. Here’s an example for #cam12
Here’s a new version of:
*** Topsy Media Timeline Google Spreadsheet Template v2.1 ***
Enjoy!
[PS I’m looking forward to seeing what Sam comes up with using Timeline ;)]
Experiment to dynamically timeline media posted on Twitter using Topsy and Timeline (my contribution to @Arras95) #arras95 – JISC CETIS MASHe
[…] Martin Hawksey Tags: #arras95. Share this post on: Google+ | Facebook | Twitter | LinkedInUpdate: New version of this spreadsheet template hereThere’s a new kid on the block if you are considering an open source timeline tools. For a long […]
#ididnotreport: Life of a Twitter Meme across social network platforms Twitter Abused
[…] and decided to revise his Timeline approach to cover visual representations only in his post “Revisiting: Experiment to dynamically timeline media posted on Twitter using Topsy and Timeline“. Perfect. So, using Hawksey’s revised method, I created my clone of his Yahoo Pipes, […]
Sam
Funny your thinking mapped my thinking re. filtering for image urls – cheers for that! And again, finally, my post, with the “How to embed a Timeline” bit near the end of it (and under the timeline you helped bring into fruition): http://twitterabused.com/2012/04/12/pintrest-scraperwiki-and-didnotreport-campaign/
Sam
IWMW12 Data Hacks JISC CETIS MASHe
[…] you a nice sense of the event. [If anyone else would like to make their own twitter media timeline there is a template in this post (it is easy as make a copy of the template, enter your search terms and publish the […]