List albums that are missing art

Got an idea? Missing something? Post your feature request here.

Moderator: moderators

List albums that are missing art

Postby edimusrex » Sat Dec 08, 2018 3:26 am

I was wondering if it is possible to sort all albums that are missing art work. This would be a useful feature if there was a way to accomplish this. I have a VERY large library and trying to go through it all to fill in what's missing is grueling.
edimusrex
 
Posts: 9
Joined: Fri Mar 20, 2015 3:47 pm

Re: List albums that are missing art

Postby ArtW » Thu Dec 27, 2018 8:04 pm

If you have access to your library from a windows computer you can use a small powershell script that I wrote for that exact purpose. It lists all folders at a given location that have files of one type (flac or mp3 for example) but are also missing another file, in my case: Folder.jpg
It's not a perfect "out of the box" solution but it is better than hunting for those folders with missing images. I'm not at home at the moment, I'll post the script later.
ArtW
 
Posts: 9
Joined: Tue Apr 26, 2016 6:02 pm

Re: List albums that are missing art

Postby wendigo » Wed Jul 03, 2019 5:31 pm

How to list albums without album art:
1. Open http(s)://yourserver.subsonic.org/db.view
2. Run this query:
Code: Select all
select * from ALBUM where COVER_ART_PATH is null and PRESENT=1
wendigo
 
Posts: 26
Joined: Sun Dec 11, 2011 11:50 am


Return to Feature Requests

Who is online

Users browsing this forum: No registered users and 7 guests