Re: [Banshee-List] Delete all ratings



On 18/11/2012 16:10, garethbjenkins wrote:
> Morning,
> 
> I'd like to start the process of rating all my songs again now that I've
> moved from iTunes/Windows to Banshee/Linux. Banshee has, however, imported
> all my old ratings. 
> 
> Is there a way to mass delete the ratings (but leave the rest of the data
> intact)? I have quite a large collection so going line-by-line is a bit of a
> bind. 

Quit Banshee, then make a back up of the Banshee database file
(~/.config/banshee-1/banshee.db), then run this command in a terminal:

sqlite3 ~/.config/banshee-1/banshee.db "update coretracks set rating=0"

-- 
Kind regards,
Loong Jin

Attachment: signature.asc
Description: OpenPGP digital signature



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]