A PowerShell RSS Reader using an OPML file

To celebrate the announcement of the planned  demise of Google Reader, I’ve done a PowerShell script that gives you the  items from the OPML collection of feeds that you import or export between your feed readers. Basically,  you create your own primitive feed reader. I’m afraid it isn’t as good as Google Reader.

So what is involved?  RSS/Atom is a rather loose definition, in that the only attribute a feed item actually needs is link and the content. The spec has been liberally interpreted too, so that there isn’t much you can really guarantee being able to read every RSS file..

To get a well-constructed  RSS feed is trivial. In PowerShell v3, it is a one-liner.  The problem is in getting resilience.  To get every feed to work is a struggle, and so I apologise for giving up at a point.

Because I can throw lists of links at this routine instead of an OPML, or use it in a function with several OPML files, I use this type of PowerShell routine for specific tasks such as checking to see if particular groups of sites have had postings. It is very easy to set up an alert if a particular site gets a posting.

I’ve added things to the script to take out all the HTML tags from the description and just view the first five-hundred characters. I’ve limited it to the first hundred feeds just to test it, and I’ve limited it to report just the current days articles. You’ll want to change all that, I expect.

You’ll need to fill in the path to the location of your  OPML file (basically an XML list of links), and the number of days back you want to read items from,  and either change or delete the ‘Select -first 100 | ‘ bit, which just gets the first articles. You’ll want to change the (truncate ($_.xxx -replace “<.*?>”) 500) (take out all the HTML tags and truncate to 500 characters or less) to suit your tastes.

 At the end of the pipeline you can, of course, save the results to a database or file, or maybe send it as an email, or format it into an HTML file: but there is no sense in adding all that stuff because you know it already!

If  you don’t already have an OPML file to practice on, here is one you can use that I’ve put together to give you exciting articles and blogs from Simple-Talk. Just save it to a file, extend it with your favourite blogs and sites, and you’ll soon be wondering why you ever felt that Google Reader was essential! Of course, you can still use the routine above with a simple list of RSS feeds, but then you wouldn’t have something that could be stitched into your news feed reader OPML file.


How you log in to Simple Talk has changed

We now use Redgate ID (RGID). If you already have an RGID, we’ll try to match it to your account. If not, we’ll create one for you and connect it.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.


Simple Talk now uses Redgate ID

If you already have a Redgate ID (RGID), sign in using your existing RGID credentials. If not, you can create one on the next screen.

This won’t sign you up to anything or add you to any mailing lists. You can see our full privacy policy here.