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 ...36  Previous   Next
Database Query - Version 3.0 now available
Author Message
DVD Profiler Unlimited RegistrantAstrakan
Registered: Feb 12, 2000
Registered: March 28, 2007
Reputation: High Rating
Canada Posts: 1,299
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
I don't know if this is a bug, or if I'm just not understanding the data correctly.

In my Summary tab it says I have:

Number of Discs: 1415
Profiles: 1400
Standard Profiles: 1400
Boxset Profiles: 0
Child Profiles: 0

It's the "Number of Discs" number that's confounding me a little. I was really surprised to see that I only had 15 profiles (or fewer) with more than one disc, so I clicked on the Discs tab and ran a query where I showed all profiles where the Disc Count was greater than 1. It returned 167 profiles, several of which had more than 2 discs per profile.

From what I understand that doesn't jive with the "Number of Discs" in the summary tab.

Or am I misunderstanding something?

KM
Tags, tags, bo bags, banana fana fo fags, mi my mo mags, TAGS!
Dolly's not alone. You can also clone profiles.
You've got questions? You've got answers? Take the DVD Profiler Wiki for a spin.
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
You may have a lot of profiles that have no discs currently assigned. Run a report going that way.
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 pdf256:
Quote:
But I have found a small bug; if you filter by standard and child profiles only (remove box set profiles) and you have box sets of box sets, it will include the child that is a parent.


I know exactly what you're talking about.  I have some profiles 5 levels deep (TV -> Babylon 5 Universe -> Babylon 5 -> Babylon 5: The Movie Collection -> Babylon 5: In the Beginning  ).

It's not a bug, it's by design.

Seriously, in that case, the profile is both a child and a parent (box set).  So it's just a question of what should be done with them.  It shouldn't be too hard to switch it if that's a more proper behavior.  I guess the question is, should it simply be switched or is there a good reason to have the behavior be optional sp you could go either way?  I don't honestly have an answer at this point.
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 Astrakan:
Quote:
I don't know if this is a bug, or if I'm just not understanding the data correctly.

In my Summary tab it says I have:

Number of Discs: 1415
Profiles: 1400
Standard Profiles: 1400
Boxset Profiles: 0
Child Profiles: 0

It's the "Number of Discs" number that's confounding me a little. I was really surprised to see that I only had 15 profiles (or fewer) with more than one disc, so I clicked on the Discs tab and ran a query where I showed all profiles where the Disc Count was greater than 1. It returned 167 profiles, several of which had more than 2 discs per profile.

From what I understand that doesn't jive with the "Number of Discs" in the summary tab.

Or am I misunderstanding something?

KM


That doesn't sound right to me.  Are you applying any weird filters?  Sometimes I got odd numbers only to find out I was filtering something out I shouldn't have been.  Or as NewEnglander says, could you have a lot of profiles without discs?

Here's what I just did.  If first cleared all filters, then I went to the Disc tab, picked Disc Count for the field, and searched for all profiles where disc count = 0 and added that to disc count greater than 0.  I get 1264 profiles which is exactly what the Summary page gives me for my profile count and what the All tab says in DVD Profiler.  Do yours add up correctly?

It might be interesting to see how the Disc Count breaks down.  Like how many have 0, how many have 1, etc.
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 NewEnglander:
Quote:
Oh, that reminds me...

The page that breaks down the stats to show how many child profiles, would it be posssible to even dig further down to grandchildren and great grandchildren. 


How about a query somewhere else other than the Summary tab?  I only ask because I have discs 4 and 5 levels deep in some places.  It would be hard to predict how deep it needs to be on the Summary tag.  A query on the Box Set Contents tab could easily handle an unlimited number of levels.  Plus you could click on a link and see all the profiles at that level.  That seems far more flexible.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantStar Contributorruineddaydreams
Registered: Dec. 2, 2002
Registered: March 14, 2007
United States Posts: 1,339
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
bug (or rather logic needs correction)

Purchase Price - Missing Purchase Price

this query returns your entire wishlist as price paid 0.00 - i suspect it should omit wishlist titles from that search query automatically.
-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 ruineddaydreams:
Quote:
bug (or rather logic needs correction)

Purchase Price - Missing Purchase Price

this query returns your entire wishlist as price paid 0.00 - i suspect it should omit wishlist titles from that search query automatically.


Nope, that is a genuine bug. I'll have it fixed in the next version.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantStar ContributorDedcap
Registered: March 14, 2007
France Posts: 159
Posted:
PM this userEdit postDirect link to this postReply with quote
it looks great

i will try it soon
DVD Profiler Unlimited RegistrantStar ContributorKulju
Registered: March 14, 2007
Finland Posts: 2,337
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Very,very nice, I'll have a tons of use for this one. On the "Fun" side of the plugin, I would love to see an option to exclude television genre. I would like to see my Director/Actor top-stats without that genre included.
DVD Profiler Unlimited RegistrantAstrakan
Registered: Feb 12, 2000
Registered: March 28, 2007
Reputation: High Rating
Canada Posts: 1,299
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting NewEnglander:
Quote:
You may have a lot of profiles that have no discs currently assigned. Run a report going that way.

Turns out this is exactly right. Good thinking. Thanks.

Quoting Mark Harrison:
Quote:
It might be interesting to see how the Disc Count breaks down.  Like how many have 0, how many have 1, etc.


I ran a few "disc count equals to" queries and this is what it came up with:

0 = 162
1 = 1071
2 = 163
3 = 0
4 = 3
5 = 1
6+ = 0

Add all those profiles up, and you get 1400, which is my total number of profiles right now.

Looks like I have some work to do capturing disc IDs.

KM
Tags, tags, bo bags, banana fana fo fags, mi my mo mags, TAGS!
Dolly's not alone. You can also clone profiles.
You've got questions? You've got answers? Take the DVD Profiler Wiki for a spin.
 Last edited: by Astrakan
DVD Profiler Unlimited RegistrantAstrakan
Registered: Feb 12, 2000
Registered: March 28, 2007
Reputation: High Rating
Canada Posts: 1,299
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Feature Request: A pre-defined query identifying people with the same name.

This would help in finding individuals who are in the Db twice, once with birth year and once without. Sometime that will obviously be legit, other times the birth year simply hasn't been propagated yet.

It could potentially also be implemented in such a way that it could help identify instances where the name has been parsed differently. Meaning there may be two cast profiles for the same person where one of them has the persons middle name in the last name field, and the other has it in the middle name field.

I am notoriously bad at not finding features, so if this is already possible please point me in the right direction.

KM
Tags, tags, bo bags, banana fana fo fags, mi my mo mags, TAGS!
Dolly's not alone. You can also clone profiles.
You've got questions? You've got answers? Take the DVD Profiler Wiki for a spin.
 Last edited: by Astrakan
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
Quoting Mark Harrison:
Quote:
Quoting NewEnglander:
Quote:
Oh, that reminds me...

The page that breaks down the stats to show how many child profiles, would it be posssible to even dig further down to grandchildren and great grandchildren. 


How about a query somewhere else other than the Summary tab?  I only ask because I have discs 4 and 5 levels deep in some places.  It would be hard to predict how deep it needs to be on the Summary tag.  A query on the Box Set Contents tab could easily handle an unlimited number of levels.  Plus you could click on a link and see all the profiles at that level.  That seems far more flexible.


That sounds great!
Signature banned: Reason out of date...
DVD Profiler Unlimited RegistrantStar ContributorLewis_Prothero
Strength Through Unity
Registered: May 19, 2007
Reputation: Superior Rating
Germany Posts: 6,730
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Astrakan:
Quote:
Feature Request: A pre-defined query identifying people with the same name.
[...]
I am notoriously bad at not finding features, so if this is already possible please point me in the right direction.

Try goodguy's plugin NameVariants
It all seems so stupid, it makes me want to give up!
But why should I give up, when it all seems so stupid?


Registrant since 05/22/2003
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 Kulju:
Quote:
Very,very nice, I'll have a tons of use for this one. On the "Fun" side of the plugin, I would love to see an option to exclude television genre. I would like to see my Director/Actor top-stats without that genre included.


The option is already there.  Open the Filters window by clicking either the button on the toolbar or right-clicking and picking Change Filters from the popup menu as seen below:



The third tab on the Filters window is Genre.  And it ought to work pretty much exactly like the Genre filters in the main program.
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 Astrakan:
Quote:
Quoting NewEnglander:
Quote:
You may have a lot of profiles that have no discs currently assigned. Run a report going that way.

Turns out this is exactly right. Good thinking. Thanks.


Glad to hear that things are working correctly.
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 Astrakan:
Quote:
Feature Request: A pre-defined query identifying people with the same name.


I see you found the NameVariants plugin already (thanks goblinsdoitall).  That's a great plug-in and I saw no reason to try to cover the same ground twice.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
    Invelos Forums->DVD Profiler: Plugins Page: 1 2 3 4 ...36  Previous   Next