Quoting jfrench:

Quote:
It's back!  Thanks media!  I'm starting to think that a re-install after backup might not be a bad idea.

It might just be a layout issue. If it is, then perhaps you could avoid a complete re-install. But I'm not sure about that ...

ProfilerQuery 3.32.0
Two minor enhancements:
- Export files can now be dragged and dropped into ProfilerQuery to open them.
- The Tools menu has a new menu item: Export collection.

If you use ProfilerQuery regularly, you have probably created a command file to help export your collection. If you haven't, see the ProfilerQuery help file for instructions. It's easy.

Now it is even easier to export your collection. You just have to specify your command file in the Settings in ProfilerQuery, and then you can just select Tools/Export collection and ProfilerQuery will send the necessary keystrokes to DVD Profiler to run your command file.

NOTE: If you are using a translated version of DVD Profiler, there are a couple of registry entries that need to be modified.
PM me and tell me which translation you are using, and I'll help you fix it.

No comments (just one greenie), so I guess the improved showcase is not something that I need to put any work into. Not totally unexpected, but a little disappointing. So this test is now abandoned. 

ProfilerQuery 3.34.1

Fixed a minor bug. Profiles with bonus features were mistakenly still flagged as boxset parents.

ProfilerQuery 3.36.0

Another update so soon? Well, yeah, I'm sort of an impulsive fellow. If I think of something that I need I tend to implement it right away. And once I have implemented it I feel I should share it. Stuff that I don't need right away goes into my todo-list, but that seldom gets very long. So what have I been up to this time?



When you right click on a row in the result, you get this context menu. The two last items are new. I found that while I was searching for profiles that needed improving I often found myself going to the contribution notes and to IMDb for checking things. So I made it easy to get to those from within ProfilerQuery.

I also fixed a minor bug that I stumbled onto, and restructured the help file a bit.

[Grumble] Character sets  !  Character sets is a bitch! Or should that be "Character sets are bitches"? Whatever.

Someone wisely said "The best thing about standards is that there are so many to chose from". Right! Why can't you all follow my standard? Things would be so much easier.

So, what prompts this outburst, I hear you think. Yep, you think loudly. But since you ask so politely I shall tell you. I have had a problem in ProfilerQuery that I have tried really hard to "ostrich". Bury my head in the sand and try to pretend it doesn't exist. But eventually the taste of sand in my mouth got too much, so I decided to do something about it.

It took me a while to identify the problem. At first I - foolishly - though that I had done something wrong. As if that could ever happen ... 
Then I realized that it was all Ken's fault. Those of you who mainly buy English titles may not have noticed the problem. It stems from the fact that the XML export files set the character set to "Windows-1252". That works fine for English, but creates a problem for some other languages, like the Scandinavian languages. Most likely also for many other languages.

So I sat down and started googling and reading documentation and experimenting. Trying to edit the xml file programatically before loading it, that wasn't really a good idea. Not with a 150 MB file. But after pounding my head against my desk at failure after failure I finally found the solution. And of course it turned out to be ridiculously simple. Just one line of code.

So now I've got a fix (and a headache). ProfilerQuery 3.37.1

I wanted to shop for disc envelopes to replace all my dvd keep cases and this was very useful. First filter on media type = DVD and case type = keep case in DVD Profiler, export the list to xml, import it in Gunnar's program and then filter for number of discs = 1 and number of discs = 2 respectively to find out how many single and double envelopes I had to order. Very helpful! 

Back on topic:

It's typical that shortly after I have released a version of ProfilerQuery, I come up against a problem that I decide is best solved with a new feature in ProfilerQuery. 

I don't usually sort my collection by Title (but rather by collection number, showing me the latest aditions first). However, I found myself having sorted by title, and I noticed that several titles were sorted wrong. Or rather looked sorted wrong. It turned out that the Sort Title was way off.

So I wondered what other titles had incorrect sort titles. At first I had the idea of creating a new program, but then I realized that this was something that would go very well into Misc. Queries in ProfilerQuery. So after a few tests and modifications I came up with this:



So, basically here is how it works. If the Title starts with an article, I remove that. If the Sort Title ends with an article, I remove that. Then I compare them to see if they are equal. The result shows the "trimmed" titles.

I soon realized that I had a lot of child profiles with special sort titles. For example the children of the Bond 50 boxset had sort titles "Bond 01" to "Bond 22" in order to sort them in release order. So I added the "Exclude child profiles" option.

Then I realized that a lot of profiles had slightly different, but not incorrect, sort titles. So in order to find the really disturbing sort titles I added the "Limit to first three letters" option. If these are the same, then at least the sorting won't be way off.

Finally there was the problem with "Die", which is an article in German, but a regular word in English. So if I treated "Die" as an article, I would get into trouble with "Die Hard", "Die Another Day" etc. But if I left it out I would miss a lot of German titles that starts with "Die". So the best compromise was to make that an option as well.

The articles that I test for are "A", "An", "Das", "Der", "Die", "El", "La", "Le", "Les", "The". As I write this, it occurs to me that perhaps I should have included "Los". There could be more articles that I have missed, since they were not in any of the titles in my collection. Let me know if you can think of any!

In case you're wondering why I haven't included Swedish articles (being a Swede myself), it's because Profiler does not consider them articles. So "Det sjunde inseglet" is still isted as "Det sjunde inseglet" even if you have configured "Append title articles" in display options. That's "The Seventh Seal", for those who are too lazy to Google it. (Or don't know your Bergman)

Anyway, if you feel the need to clean up your sort titles, it's here in ProfilerQuery 3.39.0.

By the way, I noticed that several of my Swedish releases of English movies had the Title set to the Swedish translated title, but Sort Title set to the original English title. That's not necessarily wrong, it's a matter of personal choice, but it's not the way I like my profiles sorted. That's sorted (!) now.