Looks like the problem is solved!
Thanks very much!

Jeroen

Quoting Mark Harrison:

Quote:
I've put up version 2.0.

It should fix the problem when running with other plugins.

I've also added the ability to list tags as a column on any query.

I've also added a couple queries to list profiles where the currency type for SRP and Purchase Price don't match.

The complete details are on the website.

Quoting m.cellophane:

Quote:
Is it possible to query for profiles that have customized crew roles?

That's a good question.  One which I have no answer for!  I believe it should be possible.  But I'll have to look into it.  I suspect the crew are being read already, but since I'm not handling the customized roles, it probably doesn't know what to do with them.  Hopefully they're both accessable and easy to program for!

I took a quick peek before bed and it doesn't look like we get that data on crew.  I'll make a post in the plugin area, but at this point I wouldn't expect a change before version 3.7 or whatever.  Still, it doesn't hurt to ask.

Quoting Mark Harrison:

Quote:
I've also added a couple queries to list profiles where the currency type for SRP and Purchase Price don't match.

This helps to track errors.    It would also be useful to match currency and locality.

However, the above gives false positives for items in the Wish List, which have no Purchase Price set, and where the comparison with the SRP is made with US Dollars for PP. (This reminds me, in my system the US $ still display as Euros, the Austalian $ are okay though).

And a suggestion: support Custom Media Types?

Thanks for all the great work on this great plugin. After all, what's the use of a database that you can't query? (Or for that matter [hint to Ken], what is the use of forums that you can't search?).

Quoting Staid S Barr:

Quote:
However, the above gives false positives for items in the Wish List, which have no Purchase Price set, and where the comparison with the SRP is made with US Dollars for PP.

Good point.  I usually exclude Wishlist stuff from those types of queries since it doesn't make sense that something in your wishlist would have a purchase price (if you use the tab as designed).  I'll fix that.

Quote:
(This reminds me, in my system the US $ still display as Euros, the Austalian $ are okay though).

You might just have to send me a back of your database along with exactly which query and parameters you're using so I can try to duplicate it.

Quote:
And a suggestion: support Custom Media Types?

I'm already supporting custom media types.  What specifically did you have in mind?  Is there some queries you'd like to see?  Have you looked at Media Types?  They're just lumped in with the queries for the built-in media types.  But if there's something useful, that can be added.

Quoting Mark Harrison:

Quote:

Quote:
(This reminds me, in my system the US $ still display as Euros, the Austalian $ are okay though).

You might just have to send me a back of your database along with exactly which query and parameters you're using so I can try to duplicate it.

Actually, in every place where I should see US$, i see the Euro symbol. Probably because that is the default setting in my system, not because of any setting in DVDP (which shows US$ just fine).

Quoting Staid S Barr:

Quote:
Quoting Mark Harrison:

Quote:

I'm already supporting custom media types.  What specifically did you have in mind?  Is there some queries you'd like to see?  Have you looked at Media Types?  They're just lumped in with the queries for the built-in media types.  But if there's something useful, that can be added.

This is "count profiles by Media Type". The types I defined still have DVD set as first type, and the second type distinguishing subtypes, (for example DVD-R or VHS copy, rather than an actual VHS, which would not have the DVD type set). This second type is supported by DVDP, but I can see why you only count the first type.
Now that I understand it, not a big issue.

I don't understand what you mean by "the second type".  But I've not really messed much with custom media types.

I also still don't get the money thing.  It really should be formatting the money correctly unless you've customized English (United States) in your computer's Regional and Language Options.  You might actually check that to see if the currency symbol has been modified.  It's in the control panel.  Not sure what it's named on Vista, but on XP it's Regional and Language Options.

Quoting Mark Harrison:

Quote:
I've put up version 2.0.

It should fix the problem when running with other plugins.

I've also added the ability to list tags as a column on any query.

I've also added a couple queries to list profiles where the currency type for SRP and Purchase Price don't match.

The complete details are on the website.

Thanks a lot!