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... 4 5 6 7 8 ...36  Previous   Next
Database Query - Version 3.0 now available
Author Message
DVD Profiler Unlimited Registrantnuoyaxin
prev. known as ya_shin
Registered: March 13, 2007
Reputation: High Rating
Taiwan, Province of China Posts: 3,436
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting goblinsdoitall:
Quote:
Quoting Mark Harrison:
Quote:
I have a question for all those with multiple currency types.  Is it possible (valid) to have the SRP in one currency and the purchase price in another?


Yes it is possible.
I have a release of "Sin City" with location Australia (SRP currency AUS$) which was bought at Amazon.de and thereby paid in €. The program accepts this.

By the problem you just showed up, I got confused too. But you're correct, in cases like mine you won't get any valuable results.
So forget I asked.

I have another "worse" example: I purchased a Japanese DVD in Germany: SRP: ¥4800 Purchase Price: €59.90

I also often purchase R1 DVDs in Hong Kong...
Achim [諾亞信; Ya-Shin//Nuo], a German in Taiwan.
Registered: May 29, 2000 (at InterVocative)
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
Good stuff! Thanks for all your hard work.

Any particular upgrade instructions? Or just uninstall existing and install the new download?

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 Desktop and Mobile RegistrantStar Contributorhal9g
Who is John Galt?
Registered: March 13, 2007
Reputation: High Rating
United States Posts: 6,635
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
Quoting hal9g:
Quote:
Mark,

I have a profile showing up as a "Child Profile"" on the summary page when I filter on my Blu ray discs.

How do I figure out which one it thinks is a "Child Profile"?


I am assuming that you are looking at the fact that it is listed as a "sub-profile" to a boxset, yet I do not own any Blu ray boxsets currently.

I'm stumped.

Edit:  I tried creating a "manual"profile and adding all of my Blu ray profiles as children, thinking the offending profile would not allow me to add it since it is already" a child profile, but it let me add all of them, which tells me that none are actually "child profiles".

The plug-in still says one is!


I'd get version 1.1, set the media type filter to Blu-ray only, the Box Sets filter to Child Profiles only, then run something like any profile with a runtime greater than 0 or something similar.  See if it will show you the profile that way.


Thanks, Mark.

It's Stargate.  I have created a manual "Boxset" for all of my Stargate DVDs and this one is a member.

Plug-in working perfectly! 
Hal
DVD Profiler Desktop and Mobile RegistrantStar Contributorhal9g
Who is John Galt?
Registered: March 13, 2007
Reputation: High Rating
United States Posts: 6,635
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Astrakan:
Quote:
Good stuff! Thanks for all your hard work.

Any particular upgrade instructions? Or just uninstall existing and install the new download?

KM


It's always best to use Control Panel to remove the previous version and then install the new, but I believe you can just install over the old if you wish and it will work fine.
Hal
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Astrakan:
Quote:
Good stuff! Thanks for all your hard work.

Any particular upgrade instructions? Or just uninstall existing and install the new download?

KM


I think Hal pretty much nailed it.  It's always good to uninstall and reinstall the new code.  But it shouldn't be necessary.
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
    Thanks, Mark. I think. I am running it now, I am probably going to get ill.

Skip
ASSUME NOTHING!!!!!!
CBE, MBE, MoA and proud of it.
Outta here

Billy Video
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
Oh NO, No, NO!!!!!!! Even if I factor the error genetrated by Runtime-Child/Runtime Parent...it doesn't help. Almost 1.4 MegaMinutes.<GULP>!!!!

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,321
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:
Even if I factor the error genetrated by Runtime-Child/Runtime Parent...


Funny you should mention that.  Not more than 5 minutes ago it occurred to me that there ought to be a way to identify when the parent and child both have run times assigned.

I'll see what I can come up with for version 1.2.

I've already started working on 1.2.  This morning I tweaked the way the right-click works on a datagrid for selecting rows to copy to the clipboard.  Basically, if you right click on a row, it should select it unless you already have multiple rows selected.  Very, very minor fix, but it was bugging me.  I just opened Excel and mimicked their behavior.

And I've fixed a bug where the watched/unwatched queries were including Wishlist items.  By default, those queries should automatically ignore Ordered and Wishlist items (regardless of the filters) since it makes no sense to have watched something that you don't physically possess.

I'm also still waiting to hear back from any people who buy discs from a variety of currency types.  If the SRP is one currency and you purchased in a different currency, how should those be handled in the SRP / purchase price totals on the Summary tab?  Not being in that situation, I don't know the best way to handle that scenario.  So it will stay the way it is (the purchase price is treated as the same currency as the SRP) until I get some input.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
 Last edited: by Mark Harrison
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
Mark:

You will have to reach me in the hospital, I am still in shock over the runtime. I will take the laptop with me and let you know.          

No I am not serious.

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,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
Quoting skipnet50:
Quote:
Even if I factor the error genetrated by Runtime-Child/Runtime Parent...


Funny you should mention that.  Not more than 5 minutes ago it occurred to me that there ought to be a way to identify when the parent and child both have run times assigned.


After refreshing myself with what the rules say, it looks like what is needed is perhaps a query to identify when the run time on the parent profile doesn't equal the run time of all the children profiles.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
 Last edited: by Mark Harrison
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
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:
You will have to reach me in the hospital, I am still in shock over the runtime. I will take the laptop with me and let you know.          


Mine isn't too bad at all.  At only around 147 days, I'm not even in the 6 months club.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantStar ContributorSrehtims
Registered: March 13, 2007
United States Posts: 1,796
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
We don't need stinkin' IMDB's errors, we make our own.
Ineptocracy, You got to love it.
"Nearly all men can stand adversity, but if you want to test a man's character, give him power." - Abraham Lincoln
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionEdit postDirect link to this postReply with quote
I added two new queries for the next version today.  The first finds box sets where the running time doesn't match the combined running time of the child profiles.  The other finds box sets where the production year doesn't match the earliest production year of the child profiles.  Both gave me a disturbingly large number of results in my testing.

I never realized just how bad my data was until I started working on this project.

My favorite bit of bad data so far (and I don't see how it could be topped) is from the bad name query.  It found "John Clair / Cl / Clair" in The Roaring Twenties, (012569-690820). I'm not familiar with all the old actors, but I can't believe that it's correct.  I'd fix it myself, but it makes me laugh and I'm busy working on the next version.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantStar Contributorhydr0x
Registered: April 4, 2007
Germany Posts: 887
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
wow, I like this

Could you probably include an option to use the "original title" instead of "title" like dvdp does? Seeing the German titles instead of the original ones really confuses me
- Jan
DVD Profiler Unlimited RegistrantStar Contributorhydr0x
Registered: April 4, 2007
Germany Posts: 887
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Another request, although I might just be missing it: I'd love another filter: profiles with collection numbers

the reason is that I sometimes number the boxset and sometimes the children and basically filtering for numbered items would be the perfect filter
- Jan
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
Mark..

Will the new query give us the correct total running time if it differs?
Signature banned: Reason out of date...
    Invelos Forums->DVD Profiler: Plugins Page: 1... 4 5 6 7 8 ...36  Previous   Next