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... 5 6 7 8 9 ...36  Previous   Next
Database Query - Version 3.0 now available
Author Message
DVD Profiler Unlimited RegistrantStar Contributorhydr0x
Registered: April 4, 2007
Germany Posts: 877
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
and yet another thing:

Apparently the original title duplicate finder doesn't work 100% as it should. I have three editions of Amarcord on my wishlist (both criterions and a german one). All have the same original title (Amarcord) but only the two criterions show up as duplicates. My guess is that it doesn't use the original title alone but also the edition.
- Jan
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting NewEnglander:
Quote:
Mark..

Will the new query give us the correct total running time if it differs?


It currently shows the running time for the parent and the combined running time of the children.  Of course it's possible to get some false positives.  For example, the Godfather set has a separate profile for the bonus disc and that bonus disc has a running time assigned to it.  So in that case, the sum of the children should NOT equal the parent.

You can either ignore those, or remove the running time of the bonus discs or tag them and exclude bonus profiles from the results with the Tags filter.  In fact, I have all my box sets tagged as well as all my manual profile that exist simply to group other profiles together (TV, HD, Documentaries, etc).  I never even use those weird Box Set filters and use my tags instead to filter my results.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting hydr0x:
Quote:
wow, I like this

Could you probably include an option to use the "original title" instead of "title" like dvdp does? Seeing the German titles instead of the original ones really confuses me


The option is already there.  Click on any tab other than Summary.  Right-click.  The first option in the popup menu is View Columns.  Uncheck Title and check Original Title.  Now you can see the original title instead of title on your results.

And for the next question you're about to ask  , bring up the Options screen.  The 6th one down is "Use Title when Original Title is blank".  If you check that, you'll get the Original Title when it exists and Title when there is no Original Title.  If you leave it unchecked, you get a blank when there is no Original Title.

Quoting hydr0x:
Quote:
Another request, although I might just be missing it: I'd love another filter: profiles with collection numbers

the reason is that I sometimes number the boxset and sometimes the children and basically filtering for numbered items would be the perfect filter


Hmm...  So you're happy with the way you've numbered things, you just want to weed out those without collection numbers (or weed out those with collection numbers)?  That's an odd request, but it certainly sounds simple.  I'll see what I can do.

Quoting hydr0x:
Quote:
and yet another thing:

Apparently the original title duplicate finder doesn't work 100% as it should. I have three editions of Amarcord on my wishlist (both criterions and a german one). All have the same original title (Amarcord) but only the two criterions show up as duplicates. My guess is that it doesn't use the original title alone but also the edition.


If you go to the Options screen, the third item down is "Display Edition".  When checked it will display Title: Edition.  So the duplicate title query will match on the title plus edition.  If that's not the behavior you're looking for, try unchecking that option so it just displays Title.  When I do that I go from 16 matches to 91.  I'd guess you're displaying the edition.

If that's not it, then I would suspect that those titles do differ somehow.  Because in my own collection I'm seeing plenty of matches where I have three versions of a title.  In fact, I get four hits on Planet of the Apes (the 2001 version, the 1968 version, the box set with all the movies and the 1968 version in the box set).
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantStar Contributorhydr0x
Registered: April 4, 2007
Germany Posts: 877
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
Quoting hydr0x:
Quote:
wow, I like this

Could you probably include an option to use the "original title" instead of "title" like dvdp does? Seeing the German titles instead of the original ones really confuses me


The option is already there.  Click on any tab other than Summary.  Right-click.  The first option in the popup menu is View Columns.  Uncheck Title and check Original Title.  Now you can see the original title instead of title on your results.


doesn't help with Last Watched/Bought lists though

Quote:

And for the next question you're about to ask  , bring up the Options screen.  The 6th one down is "Use Title when Original Title is blank".  If you check that, you'll get the Original Title when it exists and Title when there is no Original Title.  If you leave it unchecked, you get a blank when there is no Original Title.


see above

Quote:

Quoting hydr0x:
Quote:
Another request, although I might just be missing it: I'd love another filter: profiles with collection numbers

the reason is that I sometimes number the boxset and sometimes the children and basically filtering for numbered items would be the perfect filter


Hmm...  So you're happy with the way you've numbered things, you just want to weed out those without collection numbers (or weed out those with collection numbers)?  That's an odd request, but it certainly sounds simple.  I'll see what I can do.


why is this odd? isn't it perfectly normal to want statistics to work on the actual collection instead of some artificial constructs?!
I also think my way of numbering is the most common one (I number both Ben-Hur in the "set" (one being the parent) but I don't number the Indiana Jones box, only it's three children), at least I think I can remember polls showing just that

Quote:

Quoting hydr0x:
Quote:
and yet another thing:

Apparently the original title duplicate finder doesn't work 100% as it should. I have three editions of Amarcord on my wishlist (both criterions and a german one). All have the same original title (Amarcord) but only the two criterions show up as duplicates. My guess is that it doesn't use the original title alone but also the edition.


If you go to the Options screen, the third item down is "Display Edition".  When checked it will display Title: Edition.  So the duplicate title query will match on the title plus edition.  If that's not the behavior you're looking for, try unchecking that option so it just displays Title.  When I do that I go from 16 matches to 91.  I'd guess you're displaying the edition.


Yeah, I was displaying it, thanks. It doesn't seem logical to include the edition with the queries for original title or title though imho. It doesn't add any functionality but forces me to not show editions to make this work.
- Jan
DVD Profiler Unlimited RegistrantStar Contributornorthbloke
Registered: March 15, 2007
Reputation: High Rating
United Kingdom Posts: 5,459
Posted:
PM this userEdit postDirect link to this postReply with quote
Is there any chance you could add an "is blank" option to the querys?
So we can find fields that are empty (for example, sort title etc.)

Edit: I notice it's available on some fields (missing SRP), I just thought it'd be nice to have it on more of them.
 Last edited: by northbloke
DVD Profiler Desktop and Mobile RegistrantStar ContributorNewEnglander
Registered: 11/13/2003
Registered: March 13, 2007
Reputation: High Rating
United States Posts: 1,911
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
If I buy a box set, I number the box and not the children, since it was the same purchase.

If I buy the movies seperately and acquire the box, I number the children, because that's how they were bought.

Signature banned: Reason out of date...
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting hydr0x:
Quote:
doesn't help with Last Watched/Bought lists though


I see!  You're right.  I'll see what I can do to address that.

Quote:
why is this odd? isn't it perfectly normal to want statistics to work on the actual collection instead of some artificial constructs?!
I also think my way of numbering is the most common one (I number both Ben-Hur in the "set" (one being the parent) but I don't number the Indiana Jones box, only it's three children), at least I think I can remember polls showing just that


It's odd because it's not how I do things.  I number my boxes (assuming that's how I bought them).  I also tag all of my box sets so I can easily filter them out.  So the Tags filter was the first thing I added to the plug-in.  And it works awesome!

I'm used to doing things a particular way and wrote my plug-in to work with my collection.  I've done the best I could at trying to guess how other may use the program, and my plug-in, differently.  For example, some people use the Ordered and/or Wishlist tabs for all kinds of things like DVDs for sale or trade, rented movies, etc.  So I've added an option to allow those tabs to be treated differently.  I've tried to take those things into account where ever I could, but I obviously haven't thought of everything.  I know that my numbering scheme is in the minority.  But it never occurred to me that they would want to filter on that.  That makes it odd (because my way with tags make so much more sense to me). 

Quote:
Yeah, I was displaying it, thanks. It doesn't seem logical to include the edition with the queries for original title or title though imho. It doesn't add any functionality but forces me to not show editions to make this work.


Some people might not find it logical to automatically ignore the edition.  That's what I was talking about.  It's really hard to anticipate how others think and use the program.  I just had to do the best I could do and deal with the rest later.

Regardless, there's a really simple solution to this particular problem.  Look for it in version 1.2.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
 Last edited: by Mark Harrison
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting northbloke:
Quote:
Is there any chance you could add an "is blank" option to the querys?
So we can find fields that are empty (for example, sort title etc.)

Edit: I notice it's available on some fields (missing SRP), I just thought it'd be nice to have it on more of them.


For a lot of queries that option is already there if you use the regular expressions option.  But I learned during my beta testing that that was asking just a little too much from the average user.

I'll see what I can do about it.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantStar Contributorhydr0x
Registered: April 4, 2007
Germany Posts: 877
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:

It's odd because it's not how I do things.  I number my boxes (assuming that's how I bought them).  I also tag all of my box sets so I can easily filter them out.  So the Tags filter was the first thing I added to the plug-in.  And it works awesome!

I'm used to doing things a particular way and wrote my plug-in to work with my collection.  I've done the best I could at trying to guess how other may use the program, and my plug-in, differently.  For example, some people use the Ordered and/or Wishlist tabs for all kinds of things like DVDs for sale or trade, rented movies, etc.  So I've added an option to allow those tabs to be treated differently.  I've tried to take those things into account where ever I could, but I obviously haven't thought of everything.  I know that my numbering scheme is in the minority.  But it never occurred to me that they would want to filter on that.  That makes it odd (because my way with tags make so much more sense to me). 


;) Didn't think about the tag-filter. I can do it that way actually as I have all my movies tagged "movie". Great!!

Quote:

Quote:
Yeah, I was displaying it, thanks. It doesn't seem logical to include the edition with the queries for original title or title though imho. It doesn't add any functionality but forces me to not show editions to make this work.


Some people might not find it logical to automatically ignore the edition.  That's what I was talking about.  It's really hard to anticipate how others think and use the program.  I just had to do the best I could do and deal with the rest later.

Regardless, there's a really simple solution to this particular problem.  Look for it in version 1.2.



sounds good
- Jan
DVD Profiler Desktop and Mobile RegistrantStar Contributorlyonsden5
Hello old friends!
Registered: March 13, 2007
Reputation: High Rating
Posts: 2,372
Posted:
PM this userEdit postDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:


For a lot of queries that option is already there if you use the regular expressions option.  But I learned during my beta testing that that was asking just a little too much from the average user.


DVD Profiler Unlimited Registrantnuoyaxin
prev. known as ya_shin
Registered: March 13, 2007
Reputation: High Rating
Taiwan, Province of China Posts: 3,432
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting lyonsden5:
Quote:
Quoting Mark Harrison:
Quote:


For a lot of queries that option is already there if you use the regular expressions option.  But I learned during my beta testing that that was asking just a little too much from the average user.



Achim [諾亞信; Ya-Shin//Nuo], a German in Taiwan.
Registered: May 29, 2000 (at InterVocative)
DVD Profiler Unlimited RegistrantStar Contributorruineddaydreams
Registered: Dec. 2, 2002
Registered: March 14, 2007
United States Posts: 1,338
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
well I guess we know who the average users are - even if they are hiding....
-JoN
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting hydr0x:
Quote:
;) Didn't think about the tag-filter. I can do it that way actually as I have all my movies tagged "movie". Great!!


Hmm... The problem is I've already done the work.    I'm tempted to pull it out since it's a little clunky.  On the other hand, it does work.  And since I know the majority number the child profiles and not the box set, I suppose it could still be of use to others.  So I'll probably end up just leaving it in.

I used to have a "Movie" tag.  So I could track how many actual movies I have vs. documentaries, TV shows, kids stuff, etc.  But I found it to be a pain to keep updated.  So I finally got rid of it.  My primary tags are Box Sets, Groups and TV.  That handles 99% of my filtering needs and also works very well with my plug-in.  I've also tagged all my collections.  Like Fox Studio Classics, Walt Disney Treasures, Criterion, Hitchcock, etc.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantStar Contributorhydr0x
Registered: April 4, 2007
Germany Posts: 877
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
i've got easily over 100 tags so one or two more or less don't matter
- Jan
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting ruineddaydreams:
Quote:
well I guess we know who the average users are - even if they are hiding....


Yep, they're in hiding.  Of course they helped me realize where I needed to dumb things down (no offense to anyone hiding in a bag).  So there's no reason for them to hide.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting hydr0x:
Quote:
i've got easily over 100 tags so one or two more or less don't matter


I just used the plug-in to find all my duplicate titles and was able to use the results to populate a new tag called Duplicate.  Now I can filter those out which works great for listing the top actors in my collection.  Now I don't have Bruce Willis being counted twice for each Die Hard movie for example.

And for those who use the Top Actor query, version 1.2 will allow you to filter out voice actors and uncredited actors.  I had both in my top 10 and wasn't interested in seeing them.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
 Last edited: by Mark Harrison
    Invelos Forums->DVD Profiler: Plugins Page: 1... 5 6 7 8 9 ...36  Previous   Next