 |
|
|
|
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 |
| Registered: March 26, 2007 | | Posts: 196 |
| | Posted: July 2, 2008 4:17 PM | | | | 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: July 2, 2008 4:19 PM by smeehrrr |
| | Registered: March 13, 2007 | Reputation:  |  Posts: 3,321 |
| | Posted: July 2, 2008 4:33 PM | | | | 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. |
| | Registered: March 26, 2007 | | Posts: 196 |
| | Posted: July 2, 2008 4:38 PM | | | | 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. |
| | Registered: May 19, 2007 | Reputation:  |  Posts: 6,730 |
| | Posted: July 2, 2008 6:40 PM | | | | 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: July 2, 2008 6:40 PM by Lewis_Prothero |
| | Registered: March 13, 2007 | Reputation:  | | Posts: 1,911 |
| | Posted: July 2, 2008 6:59 PM | | | | 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... |
| | Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: July 2, 2008 7:42 PM | | | | 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: July 2, 2008 7:42 PM by Mark Harrison |
| | Registered: May 19, 2007 | | Reputation: | | Posts: 6,730 |
| | Posted: July 2, 2008 8:25 PM | | | | 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: July 2, 2008 8:29 PM by Lewis_Prothero |
| | Registered: March 13, 2007 | | Reputation: | | Posts: 1,911 |
| | Posted: July 2, 2008 8:32 PM | | | | 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... |
| | Registered: March 13, 2007 | Reputation:  | | Posts: 17,343 |
| | Posted: July 2, 2008 8:33 PM | | | | 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 |
| | Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: July 2, 2008 8:38 PM | | | | 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: July 2, 2008 8:40 PM by Mark Harrison |
| | Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: July 2, 2008 8:48 PM | | | | 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: July 2, 2008 8:55 PM by Mark Harrison |
| | Registered: March 13, 2007 | | Reputation: | | Posts: 1,911 |
| | Posted: July 2, 2008 8:49 PM | | | | 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: July 2, 2008 8:51 PM by NewEnglander |
| | Registered: March 26, 2007 | | Posts: 196 |
| | Posted: July 2, 2008 9:25 PM | | | | Total SRP: $45,949.00
Total Purchase Price: $14,923.00
Percent Saved: 67.5%
My wife can never see this. |
| | Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: July 2, 2008 11:31 PM | | | | 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: July 2, 2008 11:31 PM by Mark Harrison |
| | Registered: March 14, 2007 |  Posts: 2,337 |
| | Posted: July 3, 2008 10:45 AM | | | | 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: July 3, 2008 10:48 AM by Kulju |
| | Registered: March 13, 2007 | | Reputation: | | Posts: 3,321 |
| | Posted: July 3, 2008 3:27 PM | | | | 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
|
|
|
|
|
|
|
|
|
|
 |