convert banshee "favorites" to xmms playlist

Issue:  Xmms is the only media player that I am currently able to configure to play mp3s.  So.. what I have done, is to install a Fedora 16 VM and run banshee with my RHEL ~/Music directory NFS mounted in my VM.  Banshee is where I manage my playlists, etc..  My logout script then copies the banshee.db to my ~/Music directory (as opposed to .config/banshee-1/banshee.db)

I then run the following script to create a "default" Xmms playlist.
I replace the default XMMS .m3u file, then I create a ~/Music/xmms.pls file (optional to use).

Resolution:

[jradtke@neo bin]$ cat banshee-to-xmms.sh 

#!/bin/bash

BANSHEEMINRATING=3

BANSHEEDBFILE=~/Music/banshee.db

TMPSYNC=/tmp/banshee2xmms.tmp

PLSOUT=~/Music/xmms.pls

echo "select Uri from CoreTracks where rating > ${BANSHEEMINRATING};" | sqlite3 $BANSHEEDBFILE > ${TMPSYNC}

sed -i -e 's/file:\/\///g' ${TMPSYNC}

# MORE GENERIC FILE CLEANUP TYPE STUFF

# THEN... REPLACE/REMOVE SOME OF THE SPECIAL CHARACTERS THAT RSYNC WON'T LIKE

# MOSTLY BANSHEE 

# http://www.degraeve.com/reference/urlencoding.php

sed -i -e 's/%20/ /g' ${TMPSYNC}

sed -i -e 's/%23/\#/g' ${TMPSYNC}

sed -i -e 's/%26/\&/g' ${TMPSYNC}

sed -i -e 's/%2B/\+/g' ${TMPSYNC}

sed -i -e 's/%2C/\,/g' ${TMPSYNC}

sed -i -e 's/%5B/\[/g' ${TMPSYNC}

sed -i -e 's/%5D/\]/g' ${TMPSYNC}

# easy way out of Poliça

sed -i -e 's/%CC%A7/?/g' ${TMPSYNC}

# replace the default XMMS playlist with your list

cat ${TMPSYNC} > ~/.xmms/xmms.m3u

# create a default .pls file

NOE=`cat ${TMPSYNC} | wc -l` 

cat << EOF > ${PLSOUT}

[playlist]

NumberOfEntries=$NOE

EOF

x=0

while read LINE

do 

  x=`expr ${x} + 1`

  echo "file${x}=${LINE}" >> ${PLSOUT}

done < ${TMPSYNC}

exit 0