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 ...36  Previous   Next
Database Query - Version 3.0 now available
Author Message
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
Quoting Mark Harrison:
Quote:
The filters work the same way they do in the main program.  If your goal is to filter out Television from the results, leave all the genres alone.  Don't check them, don't uncheck them.  They should all be the blue boxes.  Then uncheck Television.  That's it.


Thanks for the help, now it works as I want and again, great plugin!
DVD Profiler Unlimited Registrantsmeehrrr
Registered: March 26, 2007
Posts: 196
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
I'm doing better percentage-wise on Blu-Rays:

Total SRP: $909.00
Total Purchase Price: $216.00
Percent Saved: 76.2%
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
What I would like to see is a way to filer owned and ordered and leave out wishlist. As it is now, you can have one or all three.
Signature banned: Reason out of date...
 Last edited: by NewEnglander
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
Also, when using the filter to see how much you've saved... Might want to check your child profiles and make the SRP's $0 or it will return false information.
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 NewEnglander:
Quote:
What I would like to see is a way to filer owned and ordered and leave out wishlist. As it is now, you can have one or all three.


Thanks, that's a good idea.

Quoting NewEnglander:
Quote:
Also, when using the filter to see how much you've saved... Might want to check your child profiles and make the SRP's $0 or it will return false information.


So you mean for those cases where the child profiles are sold separately and have an SRP and the parent has an SRP as well?  Yeah, I guess that would be a bug.  And it can be a nasty one to fix as well.  Because from the point of view of the data, a "box set" could be something like the Alien Quadrilogy (a true box set) versus a user created profile simply used to group other items together.  I guess the rule should be if the parent has a price, ignore the children.  Otherwise go down a level and try again. Hmmmm... That might do the trick.  I'll have to think about it some more.

Of course when I make this fix, that means the total SRP should come down while the total purchase price should stay the same.  The means the percent saved figure should go down as well.  Reality sucks.
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,321
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
I hate when people start posting these - because then I need to Look

Total SRP: $37,414
Total Purchase Price: $13,794
Percent Saved: 63.1%

Blu-Ray Only

Total SRP: $5,155
Total Purchase Price: $585
Percent Saved: 88.7%
-JoN
DVD Profiler Unlimited Registrantsmeehrrr
Registered: March 26, 2007
Posts: 196
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting ruineddaydreams:
Quote:
Blu-Ray Only

Total SRP: $5,155
Total Purchase Price: $585
Percent Saved: 88.7%

You must tell me where you're getting your blu-rays.  I thought I was doing well, but you're kicking my butt.
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
Is it possible to copy your query results on clipboard and paste em for example to notepad? If not, that feature would be nice.
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:
Is it possible to copy your query results on clipboard and paste em for example to notepad? If not, that feature would be nice.


I don't know if that's possible or not.  Or why you'd want to.

But I'm working on version 1.1 and I will investigate.  I suspect that if it's possible, it was be extremely easy.

Actually, I just ran a Google search on the topic and it appears to not be an issue.  Would copying the entire result set be sufficient?  Or do you need the ability to just copy particular rows?
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
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
I think selectable copy would be best if it is not too hard to implement.
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 NewEnglander:
Quote:
I think selectable copy would be best if it is not too hard to implement.


Yeah, after posting, I realized that it would be silly to only go halfway.  Of course the real question is if you should be able to only select by rows like it is today, or if you should be able to select by columns as well.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
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:
I think selectable copy would be best if it is not too hard to implement.


Yeah, after posting, I realized that it would be silly to only go halfway.  Of course the real question is if you should be able to only select by rows like it is today, or if you should be able to select by columns as well.



Both would be nice, so if I was copying the purchase data I could get either the filtered or the total sections instead of just everything.
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 NewEnglander:
Quote:
Also, when using the filter to see how much you've saved... Might want to check your child profiles and make the SRP's $0 or it will return false information.


I've given this one some more thought and I'm reversing my original position.  I think it's working correctly and it shouldn't be changed.

Here's why.  I bought all three extended editions of the Lord of the Rings movies.  When I got the third one, I sent off for the "box" to house them all.  In my particular case, the "box" should have 0 for SRP and purchase price.  It's the child profiles that should hold that data.  Of course other people waited and just bought the entire set.  In their case the box should have the data and the child profiles should be blank.

I know Jurassic Park had a similar deal.  And I believe some anime has funky configurations as well (buy 1 or 2 discs, get a mostly empty box, then add future volumes as you purchase them).

So I think rather than coding around potentially bad data, the better solution is to provide a new query or two that will help you to identify the bad data so it can be cleaned up, thus giving you more accurate totals.

Does that sound right?  It makes sense to me.
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 NewEnglander:
Quote:
Quoting Mark Harrison:
Quote:
Quoting NewEnglander:
Quote:
I think selectable copy would be best if it is not too hard to implement.


Yeah, after posting, I realized that it would be silly to only go halfway.  Of course the real question is if you should be able to only select by rows like it is today, or if you should be able to select by columns as well.



Both would be nice, so if I was copying the purchase data I could get either the filtered or the total sections instead of just everything.


It sound like you're talking about copying data off the Summary tab.  That would be more of a challenge since it's not in a datagrid.  I think I'd have to manually populate the clipboard data.  Is that really a requested feature?  I thought we were just talking about datagrids here.  I can't imagine a valid reason for wanting to copy the handful of fields on the Summary tab to the clipboard.  But I can look into that if that's what people really want.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
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
Re: The SRP issue

You're right, it's all dependent on how box sets came to be in the specific collection.

I also sent away for the LOTR box as well as the Jurassic Park Box.

What I did last night was edit all my Blu-ray profiles to remove SRPs from those profiles that should not have one for my collection. After doing that, I was still shocked at the numbers.
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
Working with this plugin now for some days and still finding out new possibilities.

It's really a great job you did here. Thank you so very much  

Just one minor wish: Since I have DVDs from several localities with different currency units, I'd like to see the ability to change the presented currency (e.g. switch from € to $) which then should filter the DVDs matching this currency.
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
    Invelos Forums->DVD Profiler: Plugins Page: 1 2 3 4 5 6 ...36  Previous   Next