10.5: Export Mail.app's RSS feed URLs in Terminal

10.5: Export Mail.app's RSS feed URLs in Terminal | 8 comments | Create New Account

Click here to return to the '10.5: Export Mail.app's RSS feed URLs in Terminal' hint

The following comments are owned by whomever posted them. This site is not responsible for what they say.

10.5: Export Mail.app's RSS feed URLs in Terminal
Authored by: chill_apple on Wed, Apr 9 2008 at 11:07AM PDT

I was trying to get to work so that i can port it to NewsFire. I am not very good at BASH and here is what I came up with (Well I borrowed the script that someone did for Safari). NOTE: I left the code that pulls it out of Safari. Any help would be appreciated.


#!/bin/sh
# version 1.2
# 	* added the htmlURL field for Wordpress
#	* escaped XML special strings from the title field
# Written by Sameer D'Costa and released into the public domain
# http://dcostanet.net/wordpress/2005/06/13/export-safari-rss-feeds-via-opml/


cat << HEADER
<?xml version="1.0" encoding="UTF-8"?>
<opml version="1.0">
	<head>
		<title>Safari OPML Export</title>
	</head>
	<body>
		<outline text="Mail Feeds">
HEADER
sqlite3 ~/Library/Syndication/Database3 'select *  from Sources;' | \
	sed -e 's/&/\&amp\;/g'  -e 's/</\&lt\;/g' -e 's/>/\&gt\;/g' -e 's/"/\&quot\;/g' -e 's/\x2C/\&#39/g' | \
	awk -F"|" '{printf "<outline type=\"rss\" text=\"\" title=\"%s\" xmlUrl=\"%s\"\ />\
		", $4, $2   }'

IFS=$'\n';for i in $(find ~/Library/Mail/RSS/ -name "Info.plist");do grep "<string>http://" $i | sed -e "s/.*\(http[^<]*\).*/\1/" | xargs echo "<outline type=\"rss\" text=\"\" title=\"$BASH_ARGV\" xmlUrl=\"$BASH_ARGV\" \/>";done


cat << FOOTER
                </outline>
        </body>
</opml>
FOOTER


Thanks,
Calvin

10.5: Export Mail.app's RSS feed URLs in Terminal
Authored by: chleuasme on Sun, Apr 13 2008 at 6:33AM PDT

I just read your post. Here is a bash script which should allow you to import the Mail RSS feeds in NewsFire :

#!/bin/bash

of=/dev/stdout
[ $# -gt 0 ] && of=$1

cat > "$of" << HEADER
<?xml version="1.0" encoding="UTF-8"?>
<opml version="1.0">
	<head>
		<title>Mail RSS OPML Export</title>
	</head>
	<body>
		<outline text="Mail Feeds">
HEADER

for mbox in ~/Library/Mail/RSS/*.rssmbox
do
    title=$(echo ${mbox##*/} | sed 's:.rssmbox::')
    url=$(defaults read "${mbox}/Info" RSSFeedURLString)
    echo "<outline type=\"rss\" text=\"\" title=\"$title\" xmlUrl=\"$url\" />"
done >> "$of"

cat >> "$of" << FOOTER
                </outline>
        </body>
</opml>
FOOTER

With no option, it should work the same ways the one you gave code, or you can give an output file name as argument.

From our Sponsor...

The macosxhints Poll

What version of OS X are you running as your main OS?

Search

From our Sponsor...

User Functions

What's New:

Hints

Comments last 2 days

Links last 2 weeks

What's New in the Forums?

The Editor's Corner...

Hints by Topic

News from Macworld

The macosxhints Poll