Prune Duplicate Songs

[Sastraxi]

Hi all,

Installed XBMC, loving it, etc. etc.
One small problem - I live in a house where many people have music shared via SMB. Our musical tastes overlap slightly so now that I've added all our musical directories to the database, we have duplicate Albums and the same songs in each -- not an ideal situation.

My feature request is for a script that will prune these entries!

Cam

[jmarshall]

You should be able to do with with sqlitespy or similar.

You need to find all duplicate items in the songview, ignoring path + thumb + anything else that depends on path. Then remove those songs.

I'm sure an SQL guru can come up with an appropriate query, or you can google for such a query (remove duplicate rows is basically what you want).

Cheers,
Jonathan

[Sastraxi]

Does the python that comes with XBMC support SQL queries?

[El Piranna]

Does the python that comes with XBMC support SQL queries?

I don't know, but it should do. I remember some years ago i did in class something similir with Access SQL, and it was no more two line of query with db calls... I don't remember how to do it, but i say it's easy. Try looking the web with a good cup of chocolate ;-)