Re: [Banshee-List] list of all artists?

["bill martin" <bmartin paonline com>]

first find your banshee database.  In my system  it is /home/.config/banshee-1/banshee.db
it's a mysql database so it's pretty easy to access and get lists you want.

change into the directory of the database 
Create the following sql program and name it new.sql

SELECT coreartists.Name, coretracks.Title
FROM coreartists
INNER JOIN coretracks
ON coreartists.ArtistID = coretracks.ArtistID
ORDER BY coreartists.Name, coretracks.Title;

from the shell ($) type the following
sqlite3 banshee.db < new.sql | sort -f > alist.txt

the txt file should give you a very nice list sorted by artist and then title



---- Original Message ----
From: "Francois43" <f j h dols gmail com>
Sent: 3/29/2015 5:36:28 AM
To: banshee-list gnome org
Subject: [Banshee-List] list of all artists?

Hi,

I need a list of all artists that are in my Banshee database. Does 
anyone know how to do that?
_______________________________________________
banshee-list mailing list
banshee-list gnome org
https://mail.gnome.org/mailman/listinfo/banshee-list  (unsubscribe here)


-- 





-- 
BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------

NOTE: This message was trained as non-spam.  If this is wrong,
please correct the training as soon as possible.

Teach the Netrepid Spam Filter if this mail (ID 05O9Qzxxd) is spam:
Spam:        https://spam.netrepid.com/canit/b.php?i=05O9Qzxxd&m=6db2b75e4692&t=20150330&c=s
Not spam:    https://spam.netrepid.com/canit/b.php?i=05O9Qzxxd&m=6db2b75e4692&t=20150330&c=n
Forget vote: https://spam.netrepid.com/canit/b.php?i=05O9Qzxxd&m=6db2b75e4692&t=20150330&c=f
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS