Updates playcount, skipcount and rating from a
Banshee/Clementine database to another. Use it like this:
$ python banshee-clementine -v ~/.config/Banshee/banshee.db ~/.config/Clementine/clementine.db
2012-06-02 22:15:10,480 INFO Backed up ~/.config/Clementine/clementine.db to
~/.config/Clementine/clementine.db-1338668110.41.bk
2012-06-02 22:15:10,548 INFO Backed up ~/.config/Clementine/clementine.db to
~/.config/Clementine/clementine.db-1338668110.48.bk
2012-06-02 22:15:10,551 INFO Retrieving data from ~/.config/Clementine/clementine.db
2012-06-02 22:15:10,578 INFO Updating ~/.config/Clementine/clementine.db's ratings and counters
2012-06-02 22:15:10,912 INFO 2741 tracks successfully updated
2012-06-02 22:15:11,267 INFO Updated ~/.config/Clementine/clementine.db
It will set all ratings in the Banshee database tracks to the ones
in Clementine, and update their playcounts and skipcounts adding
them to the existent ones. Reload the database (Clementine in this
case) and you shall see the same ratings and the updated playcounts as
they were in the Banshee database.
You could also use it Banshee to Banshee or Clementine to
Clementine, it doesn't matter.
Default behaviour is to add old counts to the new ones, but you can
avoid this by using the --overwrite flag, which will make overwrite
counts in the destination.database All tracks with either rating or
counts are updated. You can restrain this to update only the rated
tracks by using the --only-rated flag.
I wrote this scripts when moving from Banshee to Clementine
music player. I hated the idea of completely lost all ratings assigned
to songs, and so playcounts, which I use to create smart playlists and
statistics. Now I also use it when I install Clementine on another
computer on the same collection. Just grab the old Clementine
database and sync with the new empty one.
Both Banshee and Clementine use sqlite for its database, so
all the script has to do its to query them song by song (by matching
title, album and artist) and grab and convert their values.
Conversion is needed due to different punctuation systems.
Clementine's ratings are in [0-5] and uses -1 for unrated songs,
while Banshee's ratings are in [0-1] and uses 0 for unrated
songs.
Exports ratings/playcounts from one clementine/banshee db to another Usage: banshee-clementine.py [options] [dbfrom, [dbto]] Options: -h, --help Show this help message and exit -f DBFROM, --from=DBFROM Source database path -t DBTO, --to=DBTO Destination database path -r,--only-rated Ignore unrated songs -o,--overwrite Overwrites playcounts instead of adding them -v, --verbose Verbosity. Default silent. -v (info) -vv (debug)
python-sqlite3