Author |
Message |
Registered: March 14, 2007 | Reputation: | Posts: 299 |
| Posted: | | | | Thanks for the suggestion SpaceFreakMicha. I'll give that a try and report back. And not sure if this is helpful, but prior I had no headshots in my database. Prior to attempting the export I had just imported all the headshots per the 17 or so dpb files I downloaded from the " Headshots Masterdatabase v10" thread. Any known issues perhaps with the content of any of those dpb files? Everything looks fine in DVD Profiler anyway. If I could only determine which title profile the export function of CCV is getting hung up on. Could always clear out the cast and crew for said profile at that point to see if the export would complete successfully. | | | My DVD/Blu-ray Collection | | | Last edited: by Lowpro |
|
Registered: March 13, 2007 | Reputation: | Posts: 2,005 |
| |
Registered: March 31, 2007 | Posts: 662 |
| Posted: | | | | Quoting TomGaines: Quote: New: Show awards for selected person (for person selected in Profiler cast/crew windows)
This isn't working for me... As you can see, Sandra Bullock and Melissa McCarthy have won / been nominated for several awards. (No person selected right now.) When I select Melissa McCarthy, there will no awards be shown. Selecting now Sandra Bullock, there will be no awards either. Even just moving the slider on cast/crew or switching between cast and crew will remove all awards from the award window. | | | |
|
Registered: July 12, 2009 | Posts: 49 |
| Posted: | | | | I suspect it's because these two actresses have birth years registered. In this case the award(s) itself has to be edited in order to show it properly:
Award Name Year Category Won/Nominated Movie Name (Birthyear)
[]'s |
|
Registered: March 31, 2007 | Posts: 662 |
| Posted: | | | | Quoting Sidnei Novais: Quote: I suspect it's because these two actresses have birth years registered. I guess you're right: But this would be too bad, since roundabout 50% of the persons in my database have (fake) birthyears attached and (as far as I know) none in the awards databases... | | | |
|
Registered: July 12, 2009 | Posts: 49 |
| Posted: | | | | It's one of the side effects of birth years usage. Even myself using it only when strictly necessary, this means my entire award database is customized in order to relate names and birthyears correctly so I can't automatically download updates for awards I already have to avoid losing all my previous edits.
If you really care about showing awards for people with birth year (fake or not), this the only way at this point (as far I know).
[]'s |
|
Registered: March 13, 2007 | Posts: 1,414 |
| Posted: | | | | I tried the Online Award Update and got an error message: "Object reference not set to an instance of an object"
Is this not operational yet?
EDIT: Never mind; reinstalled the plugin and it works now. | | | "This movie has warped my fragile little mind." | | | Last edited: by gardibolt |
|
Registered: March 13, 2007 | Reputation: | Posts: 2,005 |
| Posted: | | | | Quoting Sidnei Novais: Quote: It's one of the side effects of birth years usage. Even myself using it only when strictly necessary, this means my entire award database is customized in order to relate names and birthyears correctly so I can't automatically download updates for awards I already have to avoid losing all my previous edits.
If you really care about showing awards for people with birth year (fake or not), this the only way at this point (as far I know).
[]'s Currently the person awards search works like this: If birthyear is given, then it is used for awards search and shows only awards where birthyear matches. If not given, all awards for persons with that name are shown (irregardless if awards have a birtyear). I could change, that if birthyear is given, then all awards where birthyear matches or birthyear is not given in the award data, are shown. Would that be better? Edit: Though taking a look at it, it is more rework than I thought it would be. | | |
| | | Last edited: by TomGaines |
|
Registered: March 31, 2007 | Posts: 662 |
| Posted: | | | | Quoting TomGaines: Quote: I could change, that if birthyear is given, then all awards where birthyear matches or birthyear is not given in the award data, are shown.
Would that be better? It would be better for me. Maybe you could make it optional? Quoting TomGaines: Quote: Edit: Though taking a look at it, it is more rework than I thought it would be. Really? I would have thought this is just a change of the query you run against the database... | | | |
|
Registered: March 13, 2007 | Reputation: | Posts: 2,005 |
| Posted: | | | | Quoting StaNDarD: Quote:
Really? I would have thought this is just a change of the query you run against the database... Yes, that is what I thought at first, too. But the way the award nominees are saved in the database is tricky. Something like this as one string: Name 1 (1955), Name 2, Name 3, Name 4 (1954) Query looks like this: With BY: WHERE Nominee LIKE %Name 1 (1955)% Without BY: WHERE Nominee LIKE %Name 1% If I would change the first one to: WHERE Nominee LIKE %Name 1 (1955)% OR LIKE %Name 1% it would return the name with every birthyear. Edit: I have another idea though, which I will try out. | | |
| | | Last edited: by TomGaines |
|
Registered: March 31, 2007 | Posts: 662 |
| Posted: | | | | Quoting TomGaines: Quote: If I would change the first one to: WHERE Nominee LIKE %Name 1 (1955)% OR LIKE %Name 1% Why do you search for "LIKE %Name 1%"? WHERE Nominee = "Name 1 (1955)" OR Nominee = "Name 1" This should do the trick - or do I miss something? | | | |
|
Registered: March 13, 2007 | Reputation: | Posts: 2,005 |
| Posted: | | | | Quoting StaNDarD: Quote: Quoting TomGaines:
Quote: If I would change the first one to: WHERE Nominee LIKE %Name 1 (1955)% OR LIKE %Name 1% Why do you search for "LIKE %Name 1%"?
WHERE Nominee = "Name 1 (1955)" OR Nominee = "Name 1"
This should do the trick - or do I miss something? Because nominee field is not only one nominee. Like I said, the content of this field looks like this: Name 1 (1955), Name 2, Name 3, Name 4 (1954) First I look for possible entries via "LIKE" and then I make further evaluations, if it is really the person I am looking for. | | |
| | | Last edited: by TomGaines |
|
Registered: March 31, 2007 | Posts: 662 |
| Posted: | | | | Quoting TomGaines: Quote: Quoting StaNDarD:
Quote: Quoting TomGaines:
Quote: If I would change the first one to: WHERE Nominee LIKE %Name 1 (1955)% OR LIKE %Name 1% Why do you search for "LIKE %Name 1%"?
WHERE Nominee = "Name 1 (1955)" OR Nominee = "Name 1"
This should do the trick - or do I miss something?
Because nominee field is not only one nominee. Like I said, the content of this field looks like this: Name 1 (1955), Name 2, Name 3, Name 4 (1954)
First I look for possible entries via "LIKE" and then I make further evaluations, if it is really the person I am looking for. Ah, I see, there might be multiple nominees in one row... Then this should work: WHERE Nominee LIKE "%Name 1 (1955)%" OR Nominee LIKE "%Name 1,%" OR Nominee LIKE "%Name 1"First you check with birthyear. Second you check w/out birthyear, but somebody following. Last you check w/out birthyear on the last person in the row. Edit:Well I see this wouldn't work either because there could be something like this: Al Alborn (Warner Bros.)This will make it hard to find a simple query... | | | | | | Last edited: by StaNDarD |
|
Registered: March 13, 2007 | Reputation: | Posts: 2,005 |
| Posted: | | | | Quoting StaNDarD: Quote: This will make it hard to find a simple query... I have already implemented another solution, but not really tested yet. Do you want to give it a try? | | |
|
|
Registered: March 31, 2007 | Posts: 662 |
| Posted: | | | | You've got a PM. | | | |
|
Registered: March 13, 2007 | Reputation: | Posts: 2,005 |
| Posted: | | | | Seems to work how expected. Thanks Question to others: Should this new behavior be optional, or are you okay, if this new behavior is the default one? To make this optional, is a little more effort. | | |
|
|