Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[mdav]

I have removed audio and video files by using the Explorer in Windows and not in MC. As I understand this will screw up the database? Is there a way to use some smartlist to identify those files?

[glynor]

Yep.  Import this search into a Smartlist:

Code: [Select]

[=IsMissing([Filename])]=1 ~sort=[Filename]
A word of caution, because it tests the existence of all of your files, it'll be quite slow to open, especially if the files are on slow media like a network drive.  If you can filter them before running that search, it'll work better.

[blgentry]

If you've got a good idea of what directory they are under (the files you removed) you can view them in the Files view and you'll see a red indicator next to each one.  You can then highlight them and delete from Library.

If not, the smartlist will definitely work.

Brian.

[glynor]

If you know that, you can just add [Filename] contains M:\blah\blah\ to the smartlist (do it above the IsMissing thing to speed it up).

[blgentry]

I guess what I was trying to say was:

If they are all under one directory tree, then you can drill to this directory tree with Files view and then visually identify them by their red icons which show that they are missing.  Honestly, it's probably a very low probability, but I've used this technique in the past for other purposes.

Glynor's suggestions are both probably more likely to be fast and efficient.

Brian.

[glynor]

Yeah. That definitely works too.

I keep a View in my Advanced top-level View (a custom one now, it used to be built in) called Missing Files that looks like this so I can manage them with panes and filtering and whatnot:


Click to embiggen.

It uses this search:

Code: [Select]

-[Media Type]=[TV] [=IsMissing([Filename])]=1 ~sort=[Filename]
And has a few useful panes, the most useful of which are the Location and Media Types ones at the "front".  It is slow to open, but handy when I need it.  I always have missing files (because of my Drive X offline storage system, and my auto-deleting shows), but that lets me manage any others that slip through.

[jmhsb]

Yep.  Import this search into a Smartlist:

Code: [Select]

[=IsMissing([Filename])]=1 ~sort=[Filename]
A word of caution, because it tests the existence of all of your files, it'll be quite slow to open, especially if the files are on slow media like a network drive.  If you can filter them before running that search, it'll work better.

Another word of caution:  If you are using this smartlist for maintenance, and you have SACD iso files in your library, do not delete them out of this smartlist.  Since the individual "filenames" for each track in the iso don't actually exist, they will show up in this smartlist.  Deleting them will delete all your SACDs from your library. 

[oie]

Hi,
Glynor, when I use any of your suggested expressions I don't always get the "red icon" next to the file. Yes, some of the files are dsd files but not all.
Any suggestion?.
Thanks in advance

[mdav]

I think "[=IsMissing([Filename])]=1" is not working for me or I'm getting it wrong, see attached code. I get about 50 DVDs as a result (of about 140 totally). All I've tested play just fine and are not missing. No one of the DVDs has the red icon.

Thanks!