Author |
Message |
Registered: March 14, 2007 | Posts: 2,337 |
| Posted: | | | | 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! |
|
Registered: March 26, 2007 | Posts: 196 |
| Posted: | | | | I'm doing better percentage-wise on Blu-Rays:
Total SRP: $909.00 Total Purchase Price: $216.00 Percent Saved: 76.2% |
|
Registered: March 13, 2007 | Reputation: | Posts: 1,911 |
| Posted: | | | | 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 |
|
Registered: March 13, 2007 | Reputation: | Posts: 1,911 |
| Posted: | | | | 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... |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,321 |
| Posted: | | | | 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. |
|
Registered: March 14, 2007 | Posts: 1,339 |
| Posted: | | | | 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 |
|
Registered: March 26, 2007 | Posts: 196 |
| Posted: | | | | 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. |
|
Registered: March 14, 2007 | Posts: 2,337 |
| Posted: | | | | Is it possible to copy your query results on clipboard and paste em for example to notepad? If not, that feature would be nice. |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,321 |
| Posted: | | | | 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. |
|
Registered: March 13, 2007 | Reputation: | Posts: 1,911 |
| Posted: | | | | I think selectable copy would be best if it is not too hard to implement. | | | Signature banned: Reason out of date... |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,321 |
| Posted: | | | | 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. |
|
Registered: March 13, 2007 | Reputation: | Posts: 1,911 |
| Posted: | | | | 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... |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,321 |
| Posted: | | | | 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. |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,321 |
| Posted: | | | | 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. |
|
Registered: March 13, 2007 | Reputation: | Posts: 1,911 |
| Posted: | | | | 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... |
|
Registered: May 19, 2007 | Reputation: | Posts: 6,730 |
| Posted: | | | | 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 |
|