Random Renegade Bits
Whatever comes to mind
Browse: Home / 2009 / August / 02 / Yahoo Pipes + CSV = Aggregated RSS
  • Old Projects and Content
    • Old Wallpapers
  • Zombinanza!

Yahoo Pipes + CSV = Aggregated RSS

By epb on August 2, 2009

You can use Yahoo Pipes to create an aggregated RSS feed from a CSV file you maintain.  It’s fairly easy too, which is awesome.  For those who are not familiar with Yahoo Pipes, it’s a beta product by Yahoo that makes it easy to create simple mashups of content available on the Internet, read more about it on the Yahoo Pipes homepage if you so please.

Basically, you create the CSV file containing the feeds you want to aggregate and place it somewhere that is web accessible.  I suggest having a second column for the name of the feed, as it makes it easier to keep track of them and you can actually use it in your pipe if you so chose.  (So as to limit the scope of this post, I’m saving that for an eventual part 2.)  For example, I have one set up for the blogs on this site at http://rrbits.com/feedlist.csv

Then you have Pipes fetch that CSV file, and iterate over each item in your CSV with the loop operator and have it fetch the feed specified at the URL in your CSV file. (You can do this by dragging the “fetch feed” module into the space available in the loop module and picking item.url_field_here as the URL.)  Choose to have it emit all results.

After doing this, simply pipe the output from the loop module to a sort module and sort by publication date (pubDate usually) descending.

This step is optional, but highly recommended: pipe that to a truncate module and limit the pipe’s output to something that’s relatively sane.

Finally, tie the last module to pipe output and save the pipe.  You can now grab the pipe as a badge for a website, an RSS feed, serialized PHP and in many more formats.  I’ve attached a screenshot of the pipe I made using this technique.  I hope you find this useful.

CSV to RSS

Related posts:

  1. Simple aggregated RSS Feed with Pipes Answering a question that was posed at work regarding RSS...
  2. Job Hunting: A practical use for aggregated RSS feeds A friend of mine was semi-recently laid off from his...
  3. Hanamaru Kindergarten [gallery link="file"] My god, Hanamaru Kindergarten is so adorable.  That's...
  4. Related posts brought to you by WordPress MU Related Posts Plugin.

Posted in Small Project | Tagged pipes

« Previous Next »

Search

Archives

  • January 2012
  • October 2011
  • April 2011
  • February 2011
  • November 2010
  • October 2010
  • September 2010
  • July 2010
  • June 2010
  • May 2010
  • March 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • February 2009
  • September 2008
  • August 2008
  • December 2007
  • August 2007

Tags

actionscript android charity CherryPad cloud code computer problems danbooru encryption flash fuse game gd hard drive hopefully_that_made_sense ImageMagick images Internet linux marisa mcrypt metadata mounting mp3 music outside_tutorials perl php pipes problem python rambling rss screenshots search slightly random solved storage svg tablets touhou ubuntu utility vhd web

About

A random blog where I write about my programming projects, Linux, the occasional video game and anything else that comes to mind.

Copyright © 2012 Random Renegade Bits.

Powered by WordPress and Hybrid.