I know this is a complex one but it would be great to have

What I'd like to do is find dupes, but not dupes in general. What I want is to compare two subcollections (the new custom ones) and find movies that I have on them both. My main need for this is to find items on my DVD wishlist that are also on my Blu wishlist and thus should be removed

I'm trying to identify BY's that are "needed" by weeding out the unnecessary ones.
In my local cast, I found 440 people with BY, and after filtering out the officially allowed ones, still 374. For the duplicates in my local, I made manual entries in Options, leaving still 256. Meaning 118 names to start documenting BYs for if I would want to upload those.

Similarly for crew (only 63).

Now my question is the following, because in some cases, the reason for having a BY is overlap between cast and crew.

Is there a way to do a combined search for cast/crew with BY, filtering out the ones in the list in Options (which is after all only one list for both cast and crew)?

Strange filter behaviour:
If I select just owned collection and run "Personal Information > Collection Number > Find caps", all my profiles that are part of any custom collection get listed even when they are part of owned collection too.

Quoting Kulju:

Quote:
Is there any way to find profiles that have a "count as" value but doesn't have a collection number. I'd like those numbers to match, but no matter what I do they are off by 9.

In DVD Profiler itself you could filter by "Collection Number" --> "None" and then sort by "Count As".

Quoting Kulju:

Quote:
Quoting Muckl:

Quote:

In DVD Profiler itself you could filter by "Collection Number" --> "None" and then sort by "Count As".

Thanks for you help. I was able to spot a few errors made by me, but something strange is still going on. If I filter Collection number > none, the result is hundreds of correct entries (disc level child profiles)and they all show "count as" value "0" as it should be.

Still... the filter count says "Filtered 4" That's the exact number how much the count is off.

In your online, I can see 3 profiles without a Collection Number, that are not child profiles. In the list they are positioned between the child profiles and the numbered items.

PS. You didn't leave an adult filter on?

Quoting Kulju:

Quote:
If I filter Collection number > none, the result is hundreds of correct entries (disc level child profiles)and they all show "count as" value "0" as it should be.

Still... the filter count says "Filtered 4" That's the exact number how much the count is off.

Maybe one picture tells more that many words, here

I'm trying to move this issue out from this thread, since it isn't Database Query problem. I just wanted to know if I could use this tool to figure this one out.

Quoting JeroenX:

Quote:
Can anyone help me figure out the regulare expression for an empty string.
I would like to find all actors which do not have a role name.
thanks.

^\s*$

^ = beginning of string
\s = space
* = zero or more times
$ = end of string

This will also list dividers, as their role is always empty. Just sort by Name descending to move all dividers to the end of the list.


EDIT: Actually, ^$ matches an empty string, but in this case the expression above is the best way to go...

Mark, good job on the plug-in.  I used it to help solve a massive foul-up in my numbering that happened when I upgraded to the new version of DVDP.

I have a small request, though, based on using it.  When I pick a title out of the list to edit -- which works fine -- when it goes back to the list it rewinds to the beginning instead of coming back at the point it jumped into edit mode at.  If you've got a bunch of changes to make, in a large list, that wastes an enormous amount of time scrolling to the next title in the list.

This may already have been covered in the thread, but I'm not going to wade through 25 pages to see.  It still took me a long time to fix my mess, but it was less time than it would have been if your plug-in wasn't here.  Thanks again.