Migrate Libraries and Playlists from Rhapsody to Spotify

by Joe Havelick 24. August 2011 18:58
UPDATE:  I have created a tool to automate most of this process. Please see Rhapsody2Spotify

If you're a Rhapsody user looking to try out Spotify, one of the frustrating things will be the lack of your historical playlists. Rhapsody appears to have done everything it can to prevent you from easily sharing out a library or playlist in a portable format, but there is a fairly simple approach to migrate a playlist or library.

Step 1: Export your library

Option 1:

You're going to want to export the contents of the database table which stores your track information. It's a SQL Lite database, and basic instructions on accessing it can be gathered here. I would suggest using the following SQL command, which will exclude tracks you have deleted:

SELECT ARTIST_NAME, TRACK_NAME
FROM TRACK
WHERE In_Library = 1

Alternately, you could just generate a list for a single playlist using the following:

SELECT ARTIST_NAME, TRACK_NAME
FROM Track
INNER JOIN Playlist_Track ON  Playlist_Track .Track_ID = Track.Track_ID
INNER JOIN Playlist ON  Playlist_Track .Playlist_ID = Playlist.Playlist_ID
WHERE In_Library = 1
AND Playlist_Name = 'Blues'

Save the results to a CSV file.

Option 2:

Right click on a playlist, and select share. Email the playlist to yourself. Copy and paste just the artists and tracks to Excel

Step 2: Remove the quotes

It appears that there is no way to export to CSV from SQLit without double quote qualifiers. The tool that we will use doesn't like that. Simply open the CSV in Excel and save it as a CSV. Alternately, you could do a Replace in notepad.

Step 3: Migrate

The tool we will use is located at http://www.ivyishere.org/. Insomuch as it might be tempting to upload our file, it did not work for me. However, if you open the CSV as a text file, then use the copy/paste mode, I had very good success.

Step 4: Paste into Spotify

Copy the results as instructed. Load the Spotify desktop all, create a new playlist, select it, then click on Paste from the edit menu.

Note: Ivy only imports by Artist and Track name. Although we could export a lot more, it would only consume extra space :-/

Happy listening.

Tags:

Tech Tips

Comments (3) -

10/27/2011 3:11:45 PM #

veer77

Hey Joe - thanks for the article. This definitely got me moving in the right direction. Some of the things I observed were that it's helpful to modify the SQL statement above so that it shows only the subscription tracks versus everything that's in your library, since you can import your personally ripped library to spotify anyway. This cut down my export from 23000+ entries to like 7300 entries.

Also, I found that, I had to edit some track names for things like asterisks to get better conversion results(rhapsody obscures four letter words it seems - f*ck!). I had to use Google Docs to do that in the spreadsheets, I only got about 50% conversion.

I decided to download and use Textpad, for the same editing and it appears to give me a  lot better results when doing the conversion. It alerted about converting some characters when I first opened the file, maybe that helped.

In the end, I got 5318 out of 7268 with Ivy, I only got 686 with playlistify, so I think there are some difference between the two sites. Ivy seemed to be the better of the two.

I can definitely live with getting 5300 of my tracks at this point and I will compare what got missed later on. I don't think that spotify simply didn't have the 2000 or so missing tracks, I just think that the conversion couldn't match what they were.

veer77 |

12/2/2011 12:24:49 AM #

Dana

Alternatively, one could email a Rhapsody playlist to themselves from the Rhapsody application. Then take the playlist from the email into a text editor and excel to delimit the list to artis-song format. Then paste the list into Ivy's Copy/Paste tab.

Thanks for finding that Ivy web app. Neat tricks!!

Dana |

12/2/2011 8:09:11 AM #

Joey

Dana, very cool! I don't think this was an option when I first wrote this. I've updated the article to reflect this tip. Thank you very much.

Joey |

Comments are closed

About Me

Joe Havelick is a reasonable facsimile of this photo.


profile for Joe on Stack Exchange, a network of free, community-driven Q&A sites

Recommendations