Author |
Message |
Registered: March 13, 2007 | Reputation: | Posts: 3,321 |
| Posted: | | | | Update December 10, 2017: Version 3.0 is now available here.Database Query is now available to download from the Downloads -> Plugins menu. This was originally intended to be two different plug-ins, but they were so similar, I just combined them into one. Part one is for fun. It allows you to query your database to check out tons of interesting statistics. Part two is for cleanup. It will assist you in finding bad data in your database. This can then be edited or you can save the results to a flag set for later work. Between the two, this plug-in will let you examine every field in the database that I could get access to. There are a lot more details on my website including a few screen shots, so I won't go into great detail here. If you have any questions, feel free to post them here and I'll answer them as soon as I can. I'm also open to requests. I've already scoured the forums looking for ideas and have incorporated as many as I could, but I'm sure there's still a lot of great ideas out there. In fact, after working on this for 3 1/2 months, just a few days ago someone posted something that I hadn't ever thought of in all that time (searching for a person will show you which dividers they're listed under which is awesome for TV sets). Finally, I'd like to thank 5 people who have spent the past 1 1/2 months testing this with me, giving me new ideas and without their help, there a lot that would be missing from what you see today. So thanks to: m.cellophaneya_shinlyonsden5hal9gAddicted2DVD | | | Get the CSVExport and Database Query plug-ins here. Create fake parent profiles to organize your collection. | | | Last edited: by Mark Harrison |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,480 |
| Posted: | | | | I'm a big fan of this plugin. Thanks for the privilege to preview it. Now I can't wait for all of the new things that others think up for you to add. | | | ...James
"People fake a lot of human interactions, but I feel like I fake them all, and I fake them very well. That’s my burden, I guess." ~ Dexter Morgan |
|
Registered: March 13, 2007 | Reputation: | Posts: 1,911 |
| Posted: | | | | Nice... took 3 minutes from the time I hit begin to the time I could play. Very impressed, I was expecting a wait of about 3 times longer.
More impressions will follow! | | | Signature banned: Reason out of date... |
|
Registered: March 13, 2007 | Posts: 21,610 |
| Posted: | | | | Summary page is frightening, at least you didn't include<gulp>a total runtime. Having a total Disc Count is just way too scary. Skip | | | ASSUME NOTHING!!!!!! CBE, MBE, MoA and proud of it. Outta here
Billy Video | | | Last edited: by Winston Smith |
|
Registered: March 13, 2007 | Reputation: | Posts: 1,911 |
| Posted: | | | | I love this plugin... my favorite! I like that you can change the font, very nice feature. I also like the ability to edit the profile while the plugin is open, I will get a lot of use out of this. Thanks Mark. Two | | | Signature banned: Reason out of date... |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,321 |
| Posted: | | | | Quoting skipnet50: Quote: Summary page is frightening, at least you didn't include<gulp>a total runtime. Having a total Disc Count is just way too scary.
Skip Ohhh. There's the first thing I didn't consider. Total running time! That will be in the next version. | | | 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: I like that you can change the font, very nice feature. Thanks. The fonts gave me so much pain. Just when I thought I had them figured out, I'd find another place where they were wrong (and there's probably a few places still). That and the name coloring. Anyway, during the testing they were so annoying that I was thinking at least one person better appreciate them or I'd bang my head into the wall, so now I feel much better! Quote: I also like the ability to edit the profile while the plugin is open, I will get a lot of use out of this. You can thank the people who helped me test. That was all their idea. They pushed and pushed and pushed until I gave in. Really, had it not been for their requests, I wouldn't have thought of it. | | | Get the CSVExport and Database Query plug-ins here. Create fake parent profiles to organize your collection. |
|
Registered: March 29, 2007 | Posts: 77 |
| Posted: | | | | Just had to give my 2 cents worth.... EXCELLENT plugin! |
|
Registered: March 13, 2007 | Posts: 21,610 |
| Posted: | | | | Quoting Mark Harrison: Quote: Quoting skipnet50:
Quote: Summary page is frightening, at least you didn't include<gulp>a total runtime. Having a total Disc Count is just way too scary.
Skip
Ohhh. There's the first thing I didn't consider. Total running time! That will be in the next version. I don't think I want to know, Mark. It tells me I have 6300+ total discs...I almost passed out. Skip | | | ASSUME NOTHING!!!!!! CBE, MBE, MoA and proud of it. Outta here
Billy Video |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,321 |
| Posted: | | | | Quoting skipnet50: Quote: I don't think I want to know, Mark. It tells me I have 6300+ total discs...I almost passed out.
Skip Well, keep in mind, that number is only as accurate as the data it was computed from. If you have profiles with no disc information, then it won't be counted as a DVD (which would be correct for a box set naturally). Of course you can use the plug-in to figure out which profiles have no disc information. Also, is that you're entire collection or your "owned" profiles? | | | Get the CSVExport and Database Query plug-ins here. Create fake parent profiles to organize your collection. |
|
Registered: March 13, 2007 | Posts: 21,610 |
| Posted: | | | | That should be just owned, since my total with wishlist is 6500+ and addind discs to that total...<gasp>Thump....sorry...I fainted.
Skip | | | ASSUME NOTHING!!!!!! CBE, MBE, MoA and proud of it. Outta here
Billy Video |
|
Registered: March 13, 2007 | Posts: 810 |
| Posted: | | | | Mark,
Very nice!
But I have found a small bug; if you filter by standard and child profiles only (remove box set profiles) and you have box sets of box sets, it will include the child that is a parent.
I have a box set of Marx Bros. movies that has seven movies on five disks, each disk has its own keepcase with an UPC. I broke it up into three levels to get one film per profile. I think that the filter should remove the top parent and the two child-parents, but they are included.
As I said, a small bug that not too many should run into, but if you used grandparent-parent-child for a tv show as some have done you would see it.
pdf | | | Paul Francis San Juan Capistrano, CA, USA |
|
Registered: March 13, 2007 | Reputation: | Posts: 1,911 |
| Posted: | | | | Oh, that reminds me... The page that breaks down the stats to show how many child profiles, would it be posssible to even dig further down to grandchildren and great grandchildren. | | | Signature banned: Reason out of date... |
|
Registered: March 14, 2007 | Posts: 1,338 |
| Posted: | | | | wow... that is IMPRESSIVE | | | -JoN |
|
Registered: March 28, 2007 | Reputation: | Posts: 1,299 |
| Posted: | | | | I love it. Thanks a tonne for your hard work.
KM | | | Tags, tags, bo bags, banana fana fo fags, mi my mo mags, TAGS! Dolly's not alone. You can also clone profiles. You've got questions? You've got answers? Take the DVD Profiler Wiki for a spin. |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,436 |
| Posted: | | | | It was a pleasure doing some testing and seeing this plugin grow. There is donate button on Mark's site; I just used it and it seems to work now (there seemed to be a problem when the site was set up...). | | | Achim [諾亞信; Ya-Shin//Nuo], a German in Taiwan. Registered: May 29, 2000 (at InterVocative) |
|