Print / Export List of artists - Albums - Songs

[phazzard]

Is there a way to export to excel or print a list of all of the artists, Albums and songs in your collection with Subsonic?

[mitrailer]

Yep, use http://localhost:4040/db.view

Here you can retrieve anything you want using SQL query. For example for retrieving all your artist use

Code: Select all

SELECT artist
   FROM media_file
     WHERE
     TYPE = 'MUSIC' OR TYPE = 'ALBUM'
   GROUP BY artist


The list of available tables can be found here http://forum.subsonic.org/forum/viewtopic.php?f=2&t=6671&p=51000&hilit=db+view+tables#p51000

[phazzard]

Sounds like what I am looking for but I am unable to get it to work. When I type that in I get "Page cant be displayed" message?

[mitrailer]

OK try http://xxxxx.subsonic.org/db.view replace the "xxxxx" with the name of your subsonic address.

[phazzard]

That brings me to my login screen - Thanks for continuing to help, any other thoughts / ideas?

[mitrailer]

ok... i see the problem.

1.- Login with the admin account
2.- Replace the url with http://xxxxx.subsonic.org/db.view replace the "xxxxx" with the name of your subsonic address. of your subsonic address.

Then you will see the screen shown in the picture (I hope!)

1.png