Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Plugins Page: 1 2 3 ...36  Previous   Next
Database Query - Version 2.9 now available
Author Message
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,276
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Update March 14, 2015: Version 2.9 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.cellophane
ya_shin
lyonsden5
hal9g
Addicted2DVD

Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
 Last edited: by Mark Harrison
DVD Profiler Desktop and Mobile RegistrantStar Contributorm.cellophane
tonight's the night...
Registered: March 13, 2007
Reputation: High Rating
United States Posts: 3,479
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
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
DVD Profiler Desktop and Mobile RegistrantStar ContributorNewEnglander
Registered: 11/13/2003
Registered: March 13, 2007
Reputation: High Rating
United States Posts: 1,911
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
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...
DVD Profiler Unlimited RegistrantStar ContributorWinston Smith
Don't be discommodious
Registered: March 13, 2007
United States Posts: 21,610
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with 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
ASSUME NOTHING!!!!!!
CBE, MBE, MoA and proud of it.
Outta here

Billy Video
 Last edited: by Winston Smith
DVD Profiler Desktop and Mobile RegistrantStar ContributorNewEnglander
Registered: 11/13/2003
Registered: March 13, 2007
Reputation: High Rating
United States Posts: 1,911
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
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...
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,276
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with 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.  
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,276
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
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.
DVD Profiler Desktop and Mobile RegistrantStar Contributorwilliamperryiii
Know No Limits
Registered: March 29, 2007
United States Posts: 77
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Just had to give my 2 cents worth....  EXCELLENT plugin!   
DVD Profiler Unlimited RegistrantStar ContributorWinston Smith
Don't be discommodious
Registered: March 13, 2007
United States Posts: 21,610
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,276
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
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.
DVD Profiler Unlimited RegistrantStar ContributorWinston Smith
Don't be discommodious
Registered: March 13, 2007
United States Posts: 21,610
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantStar Contributorpdf256
PC, iOS and Android
Registered: March 13, 2007
United States Posts: 810
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
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
DVD Profiler Desktop and Mobile RegistrantStar ContributorNewEnglander
Registered: 11/13/2003
Registered: March 13, 2007
Reputation: High Rating
United States Posts: 1,911
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
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...
DVD Profiler Unlimited RegistrantStar Contributorruineddaydreams
Registered: Dec. 2, 2002
Registered: March 14, 2007
United States Posts: 1,306
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
wow... that is IMPRESSIVE
-JoN

Blu-Ray Disc Supporter
My PHP DVD Profiler
DVD Profiler for iOS currently in use
DVD Profiler Unlimited RegistrantAstrakan
Registered: Feb 12, 2000
Registered: March 28, 2007
Reputation: High Rating
Canada Posts: 1,299
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
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.
DVD Profiler Unlimited Registrantnuoyaxin
prev. known as ya_shin
Registered: March 13, 2007
Taiwan, Province of China Posts: 3,334
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
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]
Registered (at Intervocative): May 29, 2000
    Invelos Forums->DVD Profiler: Plugins Page: 1 2 3 ...36  Previous   Next