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... 37 38 39 40 41 ...44  Previous   Next
New plugin: Cinematic Collection Viewer Plugin (Awards/Episodes)
Author Message
DVD Profiler Unlimited RegistrantLowpro
Registered: March 14, 2007
Reputation: Great Rating
United States Posts: 295
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
New version: v3.7

Update for Profiler 3.9 using new Plugin API features:
New: Show awards for selected person (for person selected in Profiler cast/crew windows)
New: Add awards as HTML Header vars (like in CCViewer), workaround via ActiveX call not needed anymore


DVD Profiler Unlimited RegistrantStaNDarD
Registered: March 31, 2007
Germany Posts: 662
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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.
DVD Profiler Unlimited RegistrantSidnei Novais
Abunai!!
Registered: July 12, 2009
Brazil Posts: 49
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantStaNDarD
Registered: March 31, 2007
Germany Posts: 662
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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...
DVD Profiler Unlimited RegistrantSidnei Novais
Abunai!!
Registered: July 12, 2009
Brazil Posts: 49
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with 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
DVD Profiler Unlimited Registrantgardibolt
digitally Obsessed
Registered: March 13, 2007
Posts: 1,414
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantStaNDarD
Registered: March 31, 2007
Germany Posts: 662
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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...
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantStaNDarD
Registered: March 31, 2007
Germany Posts: 662
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with 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?
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with 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.


 Last edited: by TomGaines
DVD Profiler Unlimited RegistrantStaNDarD
Registered: March 31, 2007
Germany Posts: 662
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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?


DVD Profiler Unlimited RegistrantStaNDarD
Registered: March 31, 2007
Germany Posts: 662
Posted:
PM this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
You've got a PM.
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
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.


    Invelos Forums->DVD Profiler: Plugins Page: 1... 37 38 39 40 41 ...44  Previous   Next