| Author |
Message |
| Registered: March 14, 2007 | Reputation:  |  Posts: 4,694 |
| | Posted: | | | | It's funny how hard it is sometimes to think just a little outside the box. When I first developed ProfilerQuery I thought "It's a pity that the xml export file has no info about the cover scans". And I just let it go at that. It wasn't until today that it dawned on me. I can access them directly in the Images directory. So I have added code to get the file size of the front and back scans. For missing images, the file size is reported as zero. So here are some possible uses: Missing cover scans - check for Front Image Size = 0 Low quality scans - check for images less than a certain size. Perhaps start with < 15 000. Unnecessarily large scans (if you're short on disc space) - check for images larger than a certain size. Perhaps 100 000. Missing back cover only - well, I think you get the idea. By default ProfilerQuery looks for images for a database named Default in the MyDocuments/DVD Profiler folder. But you can change the path to the image directory by using Tools -> Settings from the menu, if needed. You find the new fields under Other - Front Scan Size and Other - Back Scan Size. Download from here. | | | My freeware tools for DVD Profiler users.
Gunnar |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,694 |
| | Posted: | | | | And another funny thing. I test the new version. I satisfy myself that it does everything that I want. I publish it. And of course just moments later I think of something else that I could - and should - have added. In this case a way to check if front and back are of the exact same size. Because if they are the same size, then more than likely they are the same image, i.e. the front scan has been used both for front and back. And that is something that might be very useful to find out. So, probably a personal record in fastest version update, I give you ProfilerQuery 2.1.0.This test does not include profiles with no scans, i.e. where front size and back size are zero. | | | My freeware tools for DVD Profiler users.
Gunnar | | | | Last edited: by GSyren |
|
| Registered: March 19, 2007 | | Reputation: |  Posts: 6,018 |
| | Posted: | | | | Great work, Gunnar! Many thanks!   |
|
| Registered: June 6, 2007 | Reputation:  |  Posts: 950 |
| | Posted: | | | | Works like a charm, thanks.  |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,694 |
| | Posted: | | | | It should be noted that although the image data does not come from the xml file, that data is collected when the xml file is loaded, not when the query is run. So if you update images while ProfilerQuery is running, you need to reload the xml file for the changes to show. So in that regards it is the same as with any other changes you make in your collection.
Just thought I'd point it out so there is no confusion. | | | My freeware tools for DVD Profiler users.
Gunnar |
|
| Registered: March 13, 2007 | Reputation:  |  Posts: 3,321 |
| | Posted: | | | | Quoting GSyren: Quote:
And of course just moments later I think of something else that I could - and should - have added. In this case a way to check if front and back are of the exact same size. Because if they are the same size, then more than likely they are the same image, i.e. the front scan has been used both for front and back. And that is something that might be very useful to find out. That's how my code works too. If they're the same file size and dimensions, then I identify them as possibly being the same image. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,694 |
| | Posted: | | | | The chance of proper front and back scans being of exactly the same file size seems to be pretty low. In my 7000+ collection I identified 60 profiles, no false positives. So zero wrong out of 7000 seems to be a pretty low percentage...  On the other hand I have no idea if I may have missed some profiles that have a front scan for back cover yet not being the same size. It would take a lot fancier coding to detect that. Doesn't seem very likely, but I gess it can happen. | | | My freeware tools for DVD Profiler users.
Gunnar |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,694 |
| | Posted: | | | | Updated to version 2.2.0What's New:- Added a file watcher that notifies if the loaded file has changed and asks if you want to reload it. - Added an option in Settings to reload automatically if the file changes Why?After doing many changes in Profiler I would sometimes re-export my collection, but forget to reload the XML file. Now there will be no more head scratching wondering why I still get the same result  What? Me absent minded?  | | | My freeware tools for DVD Profiler users.
Gunnar |
|
| Registered: June 6, 2007 | | Reputation: | | Posts: 950 |
| | Posted: | | | | I'm having problem running ProfilerQuery since upgrading to windows 10. The xml file loads OK, but after clicking "add selection criteria", the windows which opens is empty. Some limited text appears if one pass the mouse over it.
I tried running as an admin, with no effect.
edit: ProfilerMissing, on the other hand, still works like a charm. | | | | Last edited: by Wigram |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,694 |
| | Posted: | | | | Sorry to hear that. I guess I'll have to upgrade to Win 10 eventually, but I have no immediate plans. I'll see if I can get a clue what's causing it, but it's kind of hard when I can't verify. | | | My freeware tools for DVD Profiler users.
Gunnar |
|
| Registered: June 6, 2007 | | Reputation: | | Posts: 950 |
| | Posted: | | | | Actually, I kept trying since my post and the program works fine, once the window displays completely. Upon opening, one can only see the radio elements on the left, but one can see all the options in the window by selecting them one by one. Once selected, it displays the options for that element. |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,694 |
| | Posted: | | | | New in ProfilerQuery 2.3.0: Right click an entry in the result to show the thumbnail of the front scan. (And I'm still on Win 7, so the Win 10 problem probably still exists. Sorry about that.) Download here. | | | My freeware tools for DVD Profiler users.
Gunnar | | | | Last edited: by GSyren |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,694 |
| | Posted: | | | | Just realized that the image display only works as intended if you don't re-sort the result set. I'll have a look at that. Edit: Fixed in 2.3.1 | | | My freeware tools for DVD Profiler users.
Gunnar | | | | Last edited: by GSyren |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,694 |
| | Posted: | | | | It's not a bug, it's a feature!
Well, perhaps it is a bug, but let's call it an unintended feature, or possibly a benign bug. And by now I can imagine one or two of you thinking - WHAT? Because you probably haven't noticed it, at least not yet. Well, I'm going to give you the background first, so bear with me.
When I came up with the idea to be able to show the front cover, I realized that I needed the full ID in order to build the filename. And since this wasn't necessarily part of the displayed result, I needed to get it somewhere else. So in 2.3.0 I saved the ID in a separate list, and I could access that list using the row position of the selected item in the grid. And that worked fine. Until I re-sorted the grid, after which the position in the grid and the position in the list didn't match.
My next idea was to get the ID from the dataset that was the source for the grid. But sorting the grid didn't sort the dataset, so that didn't work any better. Then finally I came up with an idea that worked. I added the ID as the first column in the datagrid and made it a hidden column. Worked like a charm. Except I forgot one thing ...
Save output to file (as well as Save and Run) exports the data from the datagrid. Including the hidden column. So you get a column in the output that you didn't ask for. Hopefully this doesn't cause too much problems, unless someone uses the csv file as input to some other custom program. If you import it into a spreadsheet, it's just an extra column that's easy to delete.
But it does illustrate a dilemma that developers often face. Changes can have unforeseen effects. In theory you should test every aspect of your program for every change you make. In practice that is often not feasible. In the case of hobby development, the sad truth is that testing is boring! You most often just test the obvious cases.
So - can this be fixed? Sure! Will this be fixed? Probably. Will it be fixed soon? If someone starts shouting at me - yes, otherwise eventually. | | | My freeware tools for DVD Profiler users.
Gunnar |
|
| Registered: March 14, 2007 | | Reputation: | | Posts: 4,694 |
| | Posted: | | | | Presenting ProfilerQuery 2.4.0: - Added "Has Episode Dividers" and "Has Group Dividers" to criteria. - Added "Clear selection criteria" button to the selection tab, so you don't have to remove them one by one if you want to start over with entirely new criteria. - Removed the extra ID column in the exported output as mentioned in my previous post. When testing "Has Episode Dividers" I first thought I had a bug, because I got hits for several titles that should not have episode dividers. It turned out that they actually had episode dividers where they should have had group dividers. I don't know if this is a relic from an older version of Profiler, or if people just added the wrong type of divider. If you have a large collection, you probably will find some such titles. Enjoy! | | | My freeware tools for DVD Profiler users.
Gunnar |
|
| Registered: June 2, 2009 | | Reputation: |  Posts: 306 |
| | Posted: | | | | Again, very much appreciated, Gunnar. Greenie given |
|