| Author |
Message |
| Registered: March 13, 2007 | Reputation:  |  Posts: 3,321 |
| | Posted: | | | | 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 |
| |
| Registered: May 9, 2007 |  Posts: 1,536 |
| | Posted: | | | | 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: by Staid S Barr |
|
| Registered: March 14, 2007 |  Posts: 2,337 |
| | Posted: | | | | Found a small bug. Plugin counts all Blu-ray discs as NTSC Video Format. |
|
| Registered: March 15, 2007 | Reputation:  |  Posts: 5,459 |
| | Posted: | | | | 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: | | | | 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: by Mark Harrison |
|
| Registered: May 9, 2007 | | Posts: 1,536 |
| | Posted: | | | | 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: | | | | 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: | | | | 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: | | | | 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: | | | | 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: | | | | 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: | | | | 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: | | | | 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: | | | | 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: | | | | 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. |
|