Since I did not release PQPal yet, and have no idea whether anyone would use it, I have no basis to ask you to do any extra work. But I had assumed that PQLib would always stay compatible with Selection scripts being built in native PQ.

Quoting mediadogg:

Quote:
Since I did not release PQPal yet, and have no idea whether anyone would use it, I have no basis to ask you to do any extra work. But I had assumed that PQLib would always stay compatible with Selection scripts being built in native PQ.

Ok, let me give that some thought before you release PQPal, then.

Quote:
Do you want to get some user feedback before doing the work? I could go ahead and make PQPal available, and if it flops, then you save the effort.

Yeah, why not? You'll just have to make it clear that the new crew fields are not supported.

Quoting mediadogg:

Quote:
For any any of the query guru's out there: what would be the best way to generate a list of DVD profiles that have a corresponding Blu-Ray profile in the database, and likewise, a list of regular Blu-Ray titles that have a 4K version available?

I'm looking to reclaim some physical space and dollars by selling off duplicates created by format upgrades. I don't mind using a report, filter or any of the query tools out there.

Well, ProfilerQuery can list duplicates. It considers profiles with the same name and production year as duplicates. Otherwise you could check out DJ Doena's plugin Find Double Dips.

In both cases you'd have to check manually if they are indeed upgrades, rather than just same media duplicates.

PorfilerQuery 3.19.3
- Fixes a minor bug in Duplicate Check.
- XML export from DVD Profiler can leave illegal XML characters that would cause ProfilerQuery to crash. It will now recover from such an error without crashing, and use a slower work-around to eliminate illegal characters. This will not slow down loading of XML export files that do not contain illegal characters.

It should be noted that the Duplicate Check only looks to the title (and production year), not the original title. So if you have different spellings in the title it will not see them as the same. For example if you have a US release named "Color of Money" and a UK release named "Colour of Money", they will not be considered the same, even if the latter does have an original title of "Color of Money". If you think that this is a problem, you might want to consider DJ Doena's plugin Find Double Dips, which does take original title into account.

Quoting mediadogg:

Quote:
I'm really muddleheaded today, but I cannot find how to run the duplicate query. Sorry to be so dense ...

Run an empty query to select all profiles, then select Tools / DuplicateCheck.

What it does is actually to eliminate from the result all profiles that are not duplicates.

Quoting mediadogg:

Quote:
But when I try to save a flag set, those options are greyed out.

Hm, don't quite remember if there was a reason for that, or if that's unintended. I'll have a look at it.

Quote:
is there a way to run a duplicates selection from PQPal

No.

Quote:
open result to spreadsheet had all the fields jammed together in the first column, separated with semi-colons, which I think might be the Euro separation symbol. How do I get the comma used, so that my spreadsheet parses the fields?

Doesn't your spreadsheet let you select separation character? ProfilerQuery lets you configure semicolon, colon or tab (tools/settings). Comma is really not a good alternative since some titles contain a comma.

Quoting GSyren:

Quote:
Quoting me:

Quote:
I'll have a look at it.

I looked at it, and it is intentional. The duplicate check was a bit of an afterthought, and it  doesn't change the actual result set, it just hides the non-duplicates in the grid. The flagset menu items work on the result set, so they would set flags for everything.

I can check if I can make a work-around so you can save flags after the duplicate check as well. But it's too late to start looking at it tonight.

Don't spend your precious time on it. I am a master data manipulator. Got what I needed in a matter of minutes.

Procedure:

1) Set PQ presentation fields to include UPC as first column, title, and production year
2) Run empty selection
3) Tools > Duplicate Check
4) File > Open result in spreadsheet (fortunately you load the grid view, which has the subset)

Now in the spreadsheet (This could be made into a macro that PQ could include in the Excel launch, to create a flag set from whatever is in the grid, regardless of how it got there)

1) Highlight column A
2) Data > Text to columns: answer yes to "overwrite ...", then Next (note choose ";" as delimiter)
3) Change format of column A to Text
4) Delete all columns except A (should now be only the UPC)
5) File Save As  (text)  .... filename.lst  (A one column CSV file of UPCs  = "flag set")

DVDP will not load unicode text, so keep that in mind when doing the save as. Use tab delimited or ansi text.

Done. Now just load the flag set into DVDP and do the work.