Getting RSS from Apple mail to NetNewsWire
I have been using Apple Mail to monitor my RSS feeds. I like it because it’s right there when I check email. Unfortunately, while I can set up my mail account using IMAP and have everything in sync regardless of whether I use the Mac Pro in the study, my Macbook Air, or my iPhone, the RSS feeds do not sync up. So, sitting here in the hospital, I am unable to keep up with all the feeds on my main machine. I did a bit of searching and found that NetNewsWire will do the trick of keeping them all synchronized (including the iPhone).
Downloaded…Installed…now, just import my RSS feeds from Apple Mail…hmmmmm…. search Google… only hit is this blog entry bemoaning the lack of this capability.
Well now, a bored programmer, laid up in the hospital, feeling just fine, and sharing the same need can’t just let a situation like this stand.
So, here’s a ruby script that will read the RSS feeds from your Apple Mail and create an opml file named AppleMailRSS.opml on your desktop. This file will import into NetNewsWire and, though I’ve not tested anything else, presumably any other RSS reader that imports opml files.
(Update note: (March 21, 2009) I’ve updated the script to handle any RSS feeds in folders in Apple Mail. Thanks Sebastion for pointing this out. I was not using folders in Apple Mail so I missed this detail.)
skeleton = <<EOSTRING
<?xml version="1.0" encoding="UTF-8"?>
<opml version="1.1">
<head>
<title>Subscriptions from Apple Mail</title>
</head>
<body>
</body>
</opml>
EOSTRING
return node if folders.length == 0
folder = folders.shift
node.each_element("outline[@title='']") do |fNode|
return getFolder(fNode,folders)
end
fNode = REXML::Element.new 'outline'
fNode.attributes['text'] = folder
fNode.attributes['title'] = folder
node << fNode
return getFolder(fNode,folders)
end
ol = REXML::Element.new 'outline'
ol.attributes['text'] = title
ol.attributes['description'] = ''
ol.attributes['title'] = title
ol.attributes['type'] = 'rss'
ol.attributes['version'] = 'RSS'
ol.attributes['htmlUrl'] = ''
ol.attributes['xmlUrl'] = url
getFolder(body,folders) << ol
end
doc = REXML::Document.new(skeleton)
body = REXML::XPath.match(doc,'//body')[0]
Dir.chdir()
Dir.chdir('Library/Mail/RSS')
Dir.glob('**/*.rssmbox') do |mbox|
m = mbox.match(/(.*\/)*(.*).rssmbox/)
folders = m[1] ? m[1].split('/') : []
title = m[2]
File.open("/Info.plist") do |file|
url = file.read.match(/RSSFeedURLString.*?<string>(.*?)</m)[1]
addRSSNode(body,folders,title,url)
end
end
Dir.chdir()
File.open('Desktop/AppleMailRSS.opml','w') do |file|
doc.write( file, 0 )
end
Hi!
Looks like a great script, but unfortunately I get an error trying to run it on my MacBook. I ran it by copying the text from here into a file I named mailrssopml.rb and ran it from the Terminal using ‘ruby mailrssopml.rb’.
mailrssopml.rb:31: undefined method `[]‘ for nil:NilClass (NoMethodError)
from mailrssopml.rb:30:in `glob’
from mailrssopml.rb:30
I have no experience in Ruby so I have no idea how to correct it.
That would seem to imply that the script did not find any *.rssmbox files.
Can you open a terminal session and try the follwing command?
ls ~/Library/Mail/RSS
if you see a list of files ending with .rssmbox, then I need to work on the script since I’m obviously not finding them. If you don’t have any files in that directory, I’m not sure what to say. For my version of Apple Mail, this is where those files are located.
I have my RSS feeds organized in folders, so running that command displays my folders, and the lone *.rssmbox that does not reside in a folder. Does your script check in sub folders? Even if it doesn’t, I think it should pick up the one RSS feed that is in the root folder.
Ah, that makes sense. I wasn’t using folders. Let me play around and I’ll try to post an updated version in the next few days (maybe this weekend)
I’ve just updated the script to handle RSS feeds in folders. Give it a try and let me know if you have any problems.
Hey!
Great update to the script.
Sebastian
The style of writing is quite familiar to me. Did you write guest posts for other blogs?
Nope, guess I’ve just been influenced by others. I’ve been told that I write pretty conversationally. Folks that know me have told me that I write exactly the way I talk and that they can pretty much hear me talking as they read what I write. It’s always a bit funny that they find this surprising. “Hey the words come out the same whether you speak or type!!”.
A backslash is missing on line 44, before the yellow forward slash..
Fixed line:
m = mbox.match(/(.*\/)*(.*).rssmbox/)
And so I learned Ruby to avoid writing an email
Thanks Mike!
hmmm… that’s interesting. I just pulled up my local copy and it has the missing backslash. I wondered how it worked for me if I had it wrong. Looks like something funky happened when I used TextMate to create the syntax highlighted html for the script.
I’ve updated it. Thanks for pointing that out.
great, it did exactly the job!
thank you very much for turning out this solution.
maybe, you wanna add some little tips for newbies –
how to use this code.
(saving the code to a “***.rb” file,
executing in terminal with “ruby *file*”
bye,
ewok
hey,this is Chet Shawhan,just found your Post on google and i must say this blog is great.may I share some of the writing found in this website to my local buddies?i’m not sure and what you think?in either case,Thx!
sure, share all you want
Interesting blog. It would be great if you can provide more details about it. Thanks you
I believe when you need a dictionary to read the first paragraph of a blog post, you really wouldn’t want to continue, especially when you’re in a rush.
You post great posts. Bookmarked !
You wouldn¡¯t believe it but I¡¯ve wasted all day digging for some articles about this. You¡¯re a lifesaver, it was an excellent read and has helped me out to no end. Cheers,
[...] welches die RSS-Feeds aus Mail ausliest und als OPML Datei zusammenfasst. Den Script Content vom Blog des Entwicklers – Danke an dieser Stelle an Mike Cargal – in eine neue “ImportRSS.rb” [...]
Nice post, thanks!
Great blog, I will add this blog to my favorites.