Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Plugins Page: 1 2 3 4 5 6 ...15  Previous   Next
Tool: ProfilerQuery
Author Message
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,195
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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!
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,195
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Just when you thought it was safe to assume that ProfilerQuery was done...

[BACKSTORY]
I was using ProfilerQuery, looking at the statistics for Studio when I noticed "20th Century Fox Home Entertainment" as a studio name. I said to myself: "Myself! This can't be right. Those profiles should probably have that moved into the Media Companies field."

Then I thought: "That's a long studio name to key into a selection in order to find which profiles that have this studio name. It would be so much simpler if I could just double click that entry in the statistics in order to select just those profiles." And my very next thought was "Oh, shut up!" but it was too late. My developer mind had already accepted the challenge. It sounded like a pretty easy task.

So I started coding a solution, but I just couldn't get it to work. It was one of those situations where you fix one thing only to create a new problem. And another. And another. And finally I remembered my old motto "If at first you don't succeed - give up!" But of course I didn't heed that motto, so I fell back to plan B: If at first you don't succeed, scrap it, sleep on it, and start fresh in the morning.

So next morning I actually did some thinking (!) before starting to code again, and I came up with a new approach that actually seems to have worked. But darn it - how much simpler wouldn't it have been to just type in that bloody studio name and have been done with it. But of course this can be useful in other situations as well. I hope.

[/BACKSTORY]

New in 3.5.0:
Double click an entry in the statistics and the program adds that as a selection criteria and reruns the query. This took some re-coding of parts of the original code, so I'm not 100% sure that everything works as it should. So please, if you find any anomalies or bugs, let me know.

There is one search from statistics that has not been implemented yet; Release Years.

Please note: This functionality only works as intended if the original selection is using "And" logic. I have a plan to fix this (as well as the above mentioned Release Years), but I was hoping for some feedback on the current functionality before I implement it.

As always, you can download this version (3.5.0) here.
My freeware tools for DVD Profiler users.
Gunnar
 Last edited: by GSyren
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,195
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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.
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,195
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
I have added Purchase Price and SRP to the statistics. Example:


If you have as many different currencies as I do, it'll take some work to calculate the combined value. If you have only one, then this may be immediately useful. Or you can just use it as interesting trivia.

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

Version 3.6.0 is available here.
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,195
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quote:
NOTE: Double clicking a currency in the statistics will not yield a valid search.

Fixed so this works in ProfilerQuery 3.6.1
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,195
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Version 3.7.0 adds a tool to check which profiles that have SRP currenciy that does not match the locality. This is done from the Tools menu:

NOTE: The check is made against the whole loaded collection. You don't need to run a query.

The result will look something like this:

Double clicking a line will take you to that profile in DVD Profiler, provided that Profiler is running and is not minimized.

Clicking Save Flags! will save a flag set in Profiler that you can load using Collections -> Flags -> Load Set...
The flag set will be named PQ_SrpAll.lst, PQ_SrpZero.lst or PQ_SrpNotZero.lst depending on which check you selected.

Download version 3.7.0 here.
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited Registrantnuoyaxin
prev. known as ya_shin
Registered: March 13, 2007
Taiwan, Province of China Posts: 3,398
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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.
Achim [Ya-Shin//Nuo]
Registered: May 29, 2000 (at InterVocative)
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,195
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Did you specify in the Presentation tab which fields you wanted in the result?
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited Registrantnuoyaxin
prev. known as ya_shin
Registered: March 13, 2007
Taiwan, Province of China Posts: 3,398
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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.
Achim [Ya-Shin//Nuo]
Registered: May 29, 2000 (at InterVocative)
DVD Profiler Unlimited Registrantnuoyaxin
prev. known as ya_shin
Registered: March 13, 2007
Taiwan, Province of China Posts: 3,398
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
It was indeed the Presentation settings... Everything is working fine now.

Sorry for replying so late
Achim [Ya-Shin//Nuo]
Registered: May 29, 2000 (at InterVocative)
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,195
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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.
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,195
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Here's a little tweak that I added mostly for my own sake:


I tend to add and rearrange my presentation fields quite a bit, and in order to restore the default set I added the Load Default Set button. What it does is to load the presentation set named Default.xml. It's just a bit easier than loading it from the menu.

If you don't like the standar default set, you can just save whatever set you like by using Tools->Presentation  Sets->Save from the menu, and save it as Default.xml.

Of course, if you are not in the habit of changing the presentation fields, this is of little use. The program still remembers the last used presentation set.



In addition to this I have also added a splash screen that you can disable. Just a way of putting my own "brand" on my programs, starting with ProfilerQuery. The splash screen closes after 8 seconds, but you can dismiss earlier it by clicking on the logo.  (If you have set ProfilerQuery to autoload the last used collection, this will still load in the background)

As always, you find the download link here.
My freeware tools for DVD Profiler users.
Gunnar
 Last edited: by GSyren
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,195
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Unlimited RegistrantStar ContributorGSyren
Profiling since 2001
Registered: March 14, 2007
Reputation: Highest Rating
Sweden Posts: 3,195
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
ProfilerQuery Beta 3.9

I have updated ProfilerQuery to take advantage of the new features in the beta release of DVD Profiler 3.9.5.

I don't intend to make it official until 3.9.5 is released as there may still be changes in the new features. However, if anyone is interested in beta testing ProfilerQuery 3.9 together with the Profiler beta, send me a PM and I'll send you a download link.

The supported new features are:
Media - UltraHD
Features - DBOX, Cine Chat, Play All, Movie IQ
Cast - Puppeteer
Audio formats - Dolby Atmos, DTS-X, Auro-3D
Audio channels - 3D

Let me know if you think I have missed anything. Thank you!
My freeware tools for DVD Profiler users.
Gunnar
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 5,203
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
That's a useful checklist for plugins as well. Thanks.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
DVD Profiler Unlimited RegistrantStar ContributorWigram
Don't blink!
Registered: June 6, 2007
Reputation: High Rating
Canada Posts: 885
Posted:
PM this userEmail this userDirect link to this postReply with quote
Thanks for this great tool! Lately, I have been using it to hunt down old formatting in Overviews:



Find Boxsets where the purchase information has not been copied to the child profiles:



I particularly appreciate the call to "select by UPC" when double clicking a line in the Results, which brings you to the profile in DVDP.


A minor point of presentation: when the profile has discs but the location/slot fields are empty, the results show commas:

    Invelos Forums->DVD Profiler: Plugins Page: 1 2 3 4 5 6 ...15  Previous   Next