| Author |
Message |
| Registered: March 16, 2007 | | Posts: 50 |
| | Posted: | | | | I'm quite sure that sorting my collection by number of times watched is not currently an option. I have a rather large collection (26 short of 3000 DVD's & Blu-Rays) and out of curiosity would like to know what I have watched the most. Is there a way to get this information in Profiler that I'm not aware of?
Edit: Actually what I'm more interested in is the number of times I've watched movies (not just simply sorting the collection to see what I've watched the most...I want to know the number of times for each.) | | | | Last edited: by bbmountain |
|
 | Muckl | | That's my common name. |
| Registered: April 9, 2009 | Reputation:  |  Posts: 858 |
| | Posted: | | | | I like this idea. AFAIK there's no way to do that with DVDP itself. You have to use Mark Harrison's Database Query plugin (download here). That's a great tool, BTW  Install plugin --> open DVDP --> Tools --> Database Query... --> load database (without cast & crew) --> Other --> Field: Watched --> Query: Watched Movies --> Watched by: you  --> Run Query (bottom of window) --> Click on the column header for "Times Watched" to sort the list. | | |
 1.0.1, iPhone 3GS, iOS 4.1.0
Trivia v0.3.1
My HSDB v5 additions, HTML windows and other stuff | | | | Last edited: by Muckl |
|
| Registered: March 16, 2007 | | Posts: 50 |
| | Posted: | | | | Thanks! I'll give it a try |
|
| Registered: March 16, 2007 | | Posts: 50 |
| | Posted: | | | | OK...I installed the database query plugin. When I launch it, I unchecked the load actors & crew, and then clicked on "begin". I keep getting the error message:
"Object reference not set to an instance of an object"
I'm not sure what I'm doing wrong...there are no other options to try or select from at that beginning screen! |
|
| Registered: May 19, 2007 | Reputation:  | | Posts: 6,730 |
| | Posted: | | | | On the first run of DBQuery keep the "load actors and crew" checked. | | | 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 | | | | Last edited: by Lewis_Prothero |
|
| Registered: March 16, 2007 | | Posts: 50 |
| | Posted: | | | | Actually, keeping the load cast/crew checked for the first run didn't help...I immediately got the same message as before after clicking on "begin"... |
|
| Registered: April 4, 2007 | | Posts: 887 |
| | Posted: | | | | Try running the database repair utility first to make sure that's not causing the problem. | | | | - Jan |
|
| Registered: March 16, 2007 | | Posts: 50 |
| | Posted: | | | | Same results after running the database repair utility. Maybe I don't need to see which movies I've watched the most after all lol! |
|
| Registered: May 22, 2007 | Reputation:  |  Posts: 1,033 |
| | Posted: | | | | might want to head over to the plugin forum, there should be an official database query plugin thread that the plugin author (Mark Harrison) probably monitors. He's probably going to be your best option since it's probably an issue with the plugin and not the program.
-Agrare |
|
| Muckl | | That's my common name. |
| Registered: April 9, 2009 | | Reputation: | | Posts: 858 |
| | Posted: | | | | Quoting bbmountain: Quote:
OK...I installed the database query plugin. When I launch it, I unchecked the load actors & crew, and then clicked on "begin". I keep getting the error message:
"Object reference not set to an instance of an object"
I'm not sure what I'm doing wrong...there are no other options to try or select from at that beginning screen! If I remember correctly, I got the same error with the BulkEdit plugin last week. Didn't have the time to ask for help then. Now it works again. So, perhaps just use your database for some days as normal and do a couple of database repairs  Of course that's no real solution. Do what Agrare suggested. | | |
1.0.1, iPhone 3GS, iOS 4.1.0
Trivia v0.3.1
My HSDB v5 additions, HTML windows and other stuff |
|
| Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: | | | | Some people have reported this problem. Seems to be related to large collections. And there's nothing I can do about it. Hopefully the new SDK for 3.6 will solve this issue. | | | Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection. |
|