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 4 5 ...36  Previous   Next
Database Query - Version 3.0 now available
Author Message
DVD Profiler Unlimited Registrantsmeehrrr
Registered: March 26, 2007
Posts: 196
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
When I run a query against my cover scans (looking for missing or matching), DVD Profiler crashes with the following truly useless native call stack:

> ntdll.dll!RtlUnwind(void * TargetFrame=0x00081760, void * TargetIp=0x759c8ac2, _EXCEPTION_RECORD * ExceptionRecord=0x0008138c, void * ReturnValue=0x00000000)  Line 706 + 0x15 bytes C
msvcr80.dll!_UnwindNestedFrames(EHRegistrationNode * pRN=0x00081760, EHExceptionRecord * pExcept=0x0008138c)  Line 241 C++
msvcr80.dll!CatchIt(EHExceptionRecord * pExcept=0x0008138c, EHRegistrationNode * pRN=0x00000000, _CONTEXT * pContext=0x000813dc, void * pDC=0x00081360, const _s_FuncInfo * pFuncInfo=0x7a35ee50, const _s_HandlerType * pCatch=0x7a39e528, const _s_CatchableType * pConv=0x00000000, const _s_TryBlockMapEntry * pEntry=0x00000000, int CatchDepth=0, EHRegistrationNode * pMarkerRN=0x00000000, unsigned char IsRethrow='Ð')  Line 1259 C++
msvcr80.dll!FindHandlerForForeignException(EHExceptionRecord * pExcept=0x0008138c, EHRegistrationNode * pRN=0x00081760, _CONTEXT * pContext=0x000813dc, void * pDC=0x00081360, const _s_FuncInfo * pFuncInfo=0x7a35ee50, int curState=1, int CatchDepth=0, EHRegistrationNode * pMarkerRN=0x00000000)  Line 974 + 0x1c bytes C++
msvcr80.dll!FindHandler(EHExceptionRecord * pExcept=0x0008138c, EHRegistrationNode * pRN=0x00081760, _CONTEXT * pContext=0x000813dc, void * pDC=0x00081360, const _s_FuncInfo * pFuncInfo=0x7a35ee50, unsigned char recursive=0, int CatchDepth=0, EHRegistrationNode * pMarkerRN=0x00000000)  Line 866 + 0x19 bytes C++
msvcr80.dll!__InternalCxxFrameHandler(EHExceptionRecord * pExcept=0x0008138c, EHRegistrationNode * pRN=0x00081760, _CONTEXT * pContext=0x000813dc, void * pDC=0x00081360, const _s_FuncInfo * pFuncInfo=0x7a35ee50, int CatchDepth=0, EHRegistrationNode * pMarkerRN=0x00000000, unsigned char recursive=0)  Line 524 + 0x19 bytes C++
msvcr80.dll!__CxxFrameHandler3(EHExceptionRecord * pExcept=0x00081760, EHRegistrationNode * pRN=0x000813dc, void * pContext=0x00081360, void * pDC=0x000816d0)  Line 311 + 0x19 bytes C++
ntdll.dll!ExecuteHandler2@20()  Line 228 Asm
ntdll.dll!ExecuteHandler@20()  Line 188 Asm
ntdll.dll!_KiUserExceptionDispatcher@8()  Line 467 Asm
mscorwks.dll!EEHeapAllocInProcessHeap(unsigned long dwFlags=0, unsigned long dwBytes=512)  Line 571 + 0xa bytes C++
mscorwks.dll!operator new[](unsigned int n=512)  Line 769 + 0xb bytes C++
mscorwks.dll!SBuffer::ReallocateBuffer(unsigned int allocation=512, SBuffer:reserve preserve=DONT_PRESERVE)  Line 43 C++
mscorwks.dll!SString::Resize(unsigned int count=255, SString::Representation representation=REPRESENTATION_UNICODE, SBuffer:reserve preserve=DONT_PRESERVE)  Line 2372 + 0x10 bytes C++
mscorwks.dll!SString::LoadResourceAndReturnHR(int resourceID=8289, int quiet=1)  Line 50 C++
mscorwks.dll!SString::LoadResource(int resourceID=8289, int quiet=1)  Line 19 + 0xb bytes C++
mscorwks.dll!EEPolicy::LogFatalError(unsigned int exitCode=2147943401, unsigned int address=2046958903, const unsigned short * pszMessage=0x00000000, _EXCEPTION_POINTERS * pExceptionInfo=0x00000000)  Line 1050 + 0xf bytes C++
mscorwks.dll!EEPolicy::HandleFatalError(unsigned int exitCode=2147943401, unsigned int address=2046958903, const unsigned short * pszMessage=0x00000000, _EXCEPTION_POINTERS * pExceptionInfo=0x00000000)  Line 1214 C++
mscorwks.dll!Thread::RestoreGuardPage()  Line 11742 + 0x14 bytes C++
mscorwks.dll!EEPolicy::LogFatalError(unsigned int exitCode=2147943401, unsigned int address=2046958903, const unsigned short * pszMessage=0x00000000, _EXCEPTION_POINTERS * pExceptionInfo=0x00000000)  Line 1071 C++

[tons more of this junk deleted]


I will try to get a managed debugger on this and see if it makes any more sense.
 Last edited: by smeehrrr
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 smeehrrr:
Quote:
When I run a query against my cover scans (looking for missing or matching), DVD Profiler crashes with the following truly useless native call stack:


That's bizarre.  I'm just grabbing the path to the image.  If there's an actual path, I then use the FileInfo object to read the file size (Ken's "missing image" image is 11683 bytes).  If it's exactly that size, I then create an image from Image.FromFile.  I then check the width and height (Ken's image is 200x277).  If that matches, I call it a missing image.  If you can't get it sorted out, I'll add some try/catches around that code in the next version and hopefully that will help.  In fact, I'll add those anyway.

Interesting .NET trivia: Originally I checked the image dimensions first, then the file size.  By flipping those two checks around, it went from several minutes of processing time to several seconds on my machine/collection!
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited Registrantsmeehrrr
Registered: March 26, 2007
Posts: 196
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
DVD Profiler is thwarting me, I'm having trouble getting a managed debugger to actually break at the right point.  From the native call stack, it looks like it's crashing in the jitter, which can't be right.

This is on Vista x64, which may be part of the problem.  I'll try on a 32-bit XP machine and see if I get the same result.
DVD Profiler Unlimited RegistrantStar ContributorLewis_Prothero
Strength Through Unity
Registered: May 19, 2007
Reputation: Superior Rating
Germany Posts: 6,730
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Compared to smeehrrr my problem is quite small.
In the "summary"-window I don't get the "Total SRP" and the "Total Purchased Price" shown. I'm told that I saved 76.1 % though.
Probably a minor bug resulting from my currency unit (€)?
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
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
Quoting goblinsdoitall:
Quote:
Compared to smeehrrr my problem is quite small.
In the "summary"-window I don't get the "Total SRP" and the "Total Purchased Price" shown. I'm told that I saved 76.1 % though.
Probably a minor bug resulting from my currency unit (€)?


I don't see it as well, I think mine is because I have two currencies in use. Maybe it's a feature, not sure.
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,321
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:
Quoting goblinsdoitall:
Quote:
Compared to smeehrrr my problem is quite small.
In the "summary"-window I don't get the "Total SRP" and the "Total Purchased Price" shown. I'm told that I saved 76.1 % though.
Probably a minor bug resulting from my currency unit (€)?


I don't see it as well, I think mine is because I have two currencies in use. Maybe it's a feature, not sure.


You guys need to read the first question on this page.
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 ContributorLewis_Prothero
Strength Through Unity
Registered: May 19, 2007
Reputation: Superior Rating
Germany Posts: 6,730
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
EDIT: Thanks for the hint. 

Read first ask later would have been the idea
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
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
Quoting Mark Harrison:
Quote:
Quoting NewEnglander:
Quote:
Quoting goblinsdoitall:
Quote:
Compared to smeehrrr my problem is quite small.
In the "summary"-window I don't get the "Total SRP" and the "Total Purchased Price" shown. I'm told that I saved 76.1 % though.
Probably a minor bug resulting from my currency unit (€)?


I don't see it as well, I think mine is because I have two currencies in use. Maybe it's a feature, not sure.


You guys need to read the first question on this page.


DOH!

I read the questions, but didn't bother to comprehend what I was reading at the time.
Signature banned: Reason out of date...
DVD Profiler Unlimited RegistrantStar ContributorAddicted2DVD
Registered: March 13, 2007
Reputation: Highest Rating
United States Posts: 17,334
Posted:
PM this userEmail this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
Quoting NewEnglander:
Quote:
Quoting goblinsdoitall:
Quote:
Compared to smeehrrr my problem is quite small.
In the "summary"-window I don't get the "Total SRP" and the "Total Purchased Price" shown. I'm told that I saved 76.1 % though.
Probably a minor bug resulting from my currency unit (€)?


I don't see it as well, I think mine is because I have two currencies in use. Maybe it's a feature, not sure.


You guys need to read the first question on this page.


Thanks Mark...
see now I had to peek and sorry I did! 

Total SRP: $49,966.00
Total Purchase Price: $13,454.00
Percent Saved: 73.1%

At least I take solace in the fact that my percent saved is up over 70%

ok... anyone else brave enough to peek and share? 
Pete
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:
It could potentially also be implemented in such a way that it could help identify instances where the name has been parsed differently. Meaning there may be two cast profiles for the same person where one of them has the persons middle name in the last name field, and the other has it in the middle name field.


I just re-read your entire post.  I still recommend the Name Variants plug-in.  But my plug-in does have something that will try to identify bad names as well.  Go to either Cast or Crew.  Pick Name for the field, and then look for "Find potential bad names".  It will filter out valid items like Captain, Reverand, Jr., Sr. and a whole bunch more.  Then it will look for anything with more than one name in either first or last.  There's also a query in the same place called "Find missing names".  It will look for people missing a first and/or last name.  A lot of times a missing last name isn't a big deal (i.e. Queen Latifa or Sting).  But a missing first name is a big no-no.

It's been ages since I've played with the Name Variants plug-in.  But I don't believe it looks for these types of problems (apologies to Goodguy if I have my facts wrong).  So using the two plug-ins together should help you weed out a ton of bad data.
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 Addicted2DVD:
Quote:
Thanks Mark...
see now I had to peek and sorry I did! 

Total SRP: $49,966.00
Total Purchase Price: $13,454.00
Percent Saved: 73.1%

At least I take solace in the fact that my percent saved is up over 70%

ok... anyone else brave enough to peek and share? 


Cheer up Pete.  My numbers are a lot worse than yours.

Total SRP: $33,459.00
Total Purchase Price: $13,130
Percent Saved: 60.8%

By the way, for those of you who purchase with different currencies, this data on the Summary tab is totals for the most popular currency in your database only.  So if you have $10,000 US and $5,000 Canadian, your totals will show only $10,000.

If you go to the Personal Information tab, pick Purchase Price Currency for field, and choose "Count profiles by purchase price currency", you can get totals for all the various currencies you use.  Or go to General Information, SRP Currency and "Count profiles by SRP currency" to get the same information for SRP.

Since I only buy R1 titles, this was the best I could do.  If I've done something wrong or it doesn't make sense the way I've done it, let me know.
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 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
On second thought, maybe I should have left that option off         


Total SRP: $56,326.00
Total Purchase Price: $20, 950.00
Percent Saved: 62.8%
Signature banned: Reason out of date...
 Last edited: by NewEnglander
DVD Profiler Unlimited Registrantsmeehrrr
Registered: March 26, 2007
Posts: 196
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Total SRP: $45,949.00
Total Purchase Price: $14,923.00
Percent Saved: 67.5%

My wife can never see this.
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 smeehrrr:
Quote:
My wife can never see this.


That's easy.  Go back to the Options screen, turn those figures off again and if she ever looks she won't see the numbers.  Tell her that's a bug in the plugin.
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 ContributorKulju
Registered: March 14, 2007
Finland Posts: 2,337
Posted:
PM this userView this user's DVD collectionEdit postDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
The option is already there.  Open the Filters window by clicking either the button on the toolbar or right-clicking and picking Change Filters from the popup menu as seen below


If I select all other genres except television check "OR" filter and then go to crew section and put:

Field: Name
Query: Top X People
Query parameters: Return top 10 director.
-> Run query

Most of the people listed after that query are only credited on TV-Shows in my collection, because all of the TV-shows have some another genre too. How to exclude profiles which has a television as a genre?
 Last edited: by Kulju
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
The filters work the same way they do in the main program.  If your goal is to filter out Television from the results, leave all the genres alone.  Don't check them, don't uncheck them.  They should all be the blue boxes.  Then uncheck Television.  That's it.

And if you do want to do something like all comedy that aren't television, you would probably want to use And instead of Or.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
    Invelos Forums->DVD Profiler: Plugins Page: 1 2 3 4 5 ...36  Previous   Next