| Author |
Message |
| Registered: March 13, 2007 | Reputation:  |  Posts: 3,321 |
| | Posted: July 17, 2008 2:55 AM | | | | Quoting Mike: Quote:
Am I missing something how do I check how much Ive spent per store? First, make sure you're running at least version 1.4. Older versions can't do it. Second, click on the Personal Information tab, choose Purchase Place for the field and "Count profiles by purchase place" for the query. Before running it, check the "Display financial data" checkbox in the Query Parameters section. Then run the query. For each store you'll get Total SRP, Total Purchase Price and % Saved. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: March 13, 2007 | | Posts: 453 |
| | Posted: July 17, 2008 3:11 AM | | | | ok I got it! |
|
| Registered: May 9, 2007 |  Posts: 1,536 |
| | Posted: July 17, 2008 7:47 AM | | | | Great plugin! However, maybe I am just stupid, or did not look in the proper places, but I can't seem to handle some queries properly.
For example, in cast, when you select "Name, custom query" and then "Full Name contains ...", and run the query to "find all profiles", I get a list with one or more actors, but not any profiles indicated.
The non-custom queries do show profiles.
edit: Okay, I get it, I just use Person search for that, no need for a custom query. | | | | Hans | | | | Last edited: July 17, 2008 7:55 AM by Staid S Barr |
|
| Registered: March 14, 2007 |  Posts: 2,337 |
| | Posted: July 17, 2008 11:42 AM | | | | Found a small bug. Plugin counts all Blu-ray discs as NTSC Video Format. |
|
| Registered: March 15, 2007 | Reputation:  |  Posts: 5,459 |
| | Posted: July 17, 2008 1:35 PM | | | | Quoting Kulju: Quote:
Found a small bug. Plugin counts all Blu-ray discs as NTSC Video Format. This may be a Profiler problem. I just noticed recently that even though you can't select a video format for HD discs one still seems to be added to the profile. For example, I made a couple of changes to an HD profile then asked to "Preview Changes" to see what changes I'd done. In among the changes was a change of format from PAL to NTSC even though those options are greyed out in the edit screen. |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: July 17, 2008 4:33 PM | | | | Quoting Kulju: Quote:
Found a small bug. Plugin counts all Blu-ray discs as NTSC Video Format. That's something I could easily filter out. But at this point I'd think it would be better to wait for 3.5 to see if there are any changes in that area that might make a fix completely unnecessary. Until then, if it really bothers you, go to the Filters window and filter out Blu-ray discs. Then the numbers should be more accurate. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. | | | | Last edited: July 17, 2008 4:34 PM by Mark Harrison |
|
| Registered: May 9, 2007 | | Posts: 1,536 |
| | Posted: July 17, 2008 8:41 PM | | | | It's awesome to have total runtime. But now that I know, the question immediately comes up how this splits up over watched/unwatched...  | | | | Hans |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: July 17, 2008 9:04 PM | | | | Quoting Staid S Barr: Quote:
It's awesome to have total runtime. But now that I know, the question immediately comes up how this splits up over watched/unwatched... Interesting... I'll have to think of the best way to do this, but I'm currently leaning towards doing another drop-down like the "List prices for:" thing. Anyway, I've added this to the list.  But I'm waiting for 3.5 at this point unless some big bug is discovered before then. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: May 26, 2007 | | Reputation: | | Posts: 599 |
| | Posted: July 17, 2008 9:28 PM | | | | Quoting Mark Harrison: Quote:
Ok. Version 1.5 is up. Thanks for the uncredited actor search. |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: July 17, 2008 11:04 PM | | | | Quoting Antares: Quote:
Quoting Mark Harrison:
Quote:
Ok. Version 1.5 is up.
Thanks for the uncredited actor search. Not a problem. I hope it's helpful. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|
| Registered: May 26, 2007 | | Reputation: | | Posts: 599 |
| | Posted: July 17, 2008 11:39 PM | | | | Quoting Mark Harrison: Quote:
Quoting Antares:
Quote:
Quoting Mark Harrison:
Quote:
Ok. Version 1.5 is up.
Thanks for the uncredited actor search.
Not a problem. I hope it's helpful. It is, I only go by credits listed in the film. This allows me to delete all those roles that aren't in the credits. Take that, Bess Flowers! |
|
| Registered: May 9, 2007 | | Posts: 1,536 |
| | Posted: July 21, 2008 9:39 AM | | | | I have been working to correct bad roles, and this plugin is what makes it possible in the first place.
Useful addition: check for roles starting with "as"?
Small oddity: all words in parentheses starting with "v" give a false positive for (voice). | | | | Hans |
|
| Registered: March 13, 2007 | | Posts: 88 |
| | Posted: July 21, 2008 9:55 AM | | | | Quoting Staid S Barr: Quote:
Useful addition: check for roles starting with "as"?
You can do that by using this regular expression: ^as\s |
|
| Registered: May 9, 2007 | | Posts: 1,536 |
| | Posted: July 21, 2008 11:02 AM | | | | Quoting Takaikkuna: Quote:
Quoting Staid S Barr:
Quote:
Useful addition: check for roles starting with "as"?
You can do that by using this regular expression:
^as\s Thanks. That does not look too complicated, but in general the whole idea of "regular" expressions is rather daunting... | | | | Hans |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: July 22, 2008 3:08 AM | | | | Quoting Staid S Barr: Quote:
Small oddity: all words in parentheses starting with "v" give a false positive for (voice). I look for "(u" or "(v" as I recall. If I looked for "(voice)", you'd miss lots where they ran out of space and just entered "(voi". I have lots in my database that are just partial "(uncredited)" or "(voice)". That's why you get the false positives. There's not a lot that can be done. | | | 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: July 22, 2008 3:08 AM | | | | Quoting Takaikkuna: Quote:
Quoting Staid S Barr:
Quote:
Useful addition: check for roles starting with "as"?
You can do that by using this regular expression:
^as\s Yay! Someone finally gets the regular expressions option. I was beginning to think I was the only one who would find it useful.  | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|