Quoting surfeur51:

Quote:
Well, quickly and perfectly done. I have 10 users in my database, and it works perfectly for all of them. Great !!! 

Always nice to hear from a satisfied "customer". Thank you, Yves!

Sometimes new features help reveal old bugs. I looked at statistics for Country of Origin and found that I had 3 from Austria. I double clicked that line and 2 titles popped up in the result. Wait! Only two titles?

It turns out that while most fields that can have more than one value (like Genre, for example) are presented as multiple fields with the same name in the XML export file. Country of Origin, on the other hand, uses three fields with different names (CountryOfOrigin, CountryOfOrigin2 and CountryOfOrigin3). I handled that correctly in the statistics, but not in the selection. This has been fixed now.

I have also fixed searching for Year of Release. That's a date field in Profiler, so searching for a whole year means adding two separate selection criteria; a from-date and a to-date. Not rocket science, but it just had to be handled separately from the other searches.

So both these are fixed in version 3.5.1.

The release year thing paid off immediately. When testing it on my full collection I discovered that I had a title that was released in the year 2200. Since I couldn't recall a visit from a time traveler, I concluded that the date in the profile must be wrong. And it was. And it's fixed now. I guess I'll look through the statistics a bit more to see if I can spot any other unlikely values. Every little bit helps to make the database more accurate.

Quote:
NOTE: Double clicking a currency in the statistics will not yield a valid search.

Fixed so this works in ProfilerQuery 3.6.1

Forgive me if I failed to find this discussed before:

I finally, finally finally used ProfilerQuery for the first time. Unfortunately, after created a criteria and then hit RUN!, the Result window only showed this:



It says there is a result, which seems reasonable too, but no text. Am I missing a font, maybe...?

I run Windows 10 in a VirtualBox VM under macOS. All latest updates and patches are installed.

Quoting GSyren:

Quote:
Did you specify in the Presentation tab which fields you wanted in the result?

I looked at the manual, really, I did.

I'll check this later and let you know. But I thought I was probably missing something rather obvious, so this is probably it.

Just FYI, I have updated ProfilerQuery so that if you don't specify any presentation fields, it will automatically add the fields ID Base, Collection Number and Title. This was done to avoid any misunderstanding as to how ProfilerQuery works.



I have not updated the version control for this version. Since it is really only useful for new users, there is no reason to prompt existing users of version 3.7.0 to update. It will not add any useful features for them.

However, if you still haven't tried ProfilerQuery, version 3.7.1 is here.

I just noticed that there was a problem with Watched Date in the presentation. For profiles with more than one watched date, the dates were interpreted as invalid, and displayed as "0001-01-01". This has been corrected so the last watched date is displayed. While it is not ideal to display just one date, this is the only way that the column can be sorted properly.

This is fixed in version 3.8.1

That's a useful checklist for plugins as well. Thanks.