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: Desktop Feature Requests Page: 1 2  Previous   Next
"Common Names" Utility Tool
Author Message
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 collectionDirect link to this postReply with quote
Ken,

As we get deeper into creating a "Common Names" list for Invelos, we are going to run into a lot of situations where we already have someone in our local database who is entered many times in more than one format, such as "John Doe, Jr." and "John Doe Jr.", etc.

The only way to fix these today is to select one of the two as a "Common Name" and then change all of the other profiles to put in both the Common Name and the "as credited" name.  Then you need to delete the "Uncommon name" from the "Common Name" list.

It would be great if you could write a utility that would do a Global find and replace searching each profile for a name and replacing the "find" name with the "replace" name, while entering the "find" name into the "as credited" field.

I know you don't have anything else to do, but this would be a great help to us as we finalize how we are going to determine the "Common Name". 
Hal
 Last edited: by hal9g
DVD Profiler Unlimited RegistrantRifter
Reg. Jan 27, 2002
Registered: March 13, 2007
United States Posts: 2,694
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Quoting hal9g:
Quote:
Ken,

As we get deeper into creating a "Common Names" list for Invelos, we are going to run into a lot of situations where we already have someone in our local database who is entered many times in more than one format, such as "John Doe, Jr." and "John Doe Jr.", etc.

The only way to fix these today is to select one of the two as a "Common Name" and then change all of the other profiles to put in both the Common Name and the "as credited" name.  Then you need to delete the "Uncommon name" from the "Common Name" list.

It would be great if you could write a utility that would do a Global find and replace searching each profile for a name and replacing the "find" name with the "replace" name, while entering the "find" name into the "as credited" field.

I know you don't have anything else to do, but this would be a great help to us as we finalize how we are going to determine the "Common Name". 



Question:  Who gets to determine which "common name" to dump?  Doesn't that put us right smack back into the personal preference arena?
John

"Extremism in the defense of Liberty is no vice!" Senator Barry Goldwater, 1964
Make America Great Again!
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 collectionDirect link to this postReply with quote
Ken plans to provide us with a database search function which will tell us, based on entering the "as credited" name, what is the most frequent occurrence of that name in the Invelos main database.  That would then be the definitive "Common Name" for use in DVDP.

No personal preference of any kind.
Hal
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 collectionDirect link to this postReply with quote
Quoting Rifter:
Quote:
Quoting hal9g:
Quote:
Ken,

As we get deeper into creating a "Common Names" list for Invelos, we are going to run into a lot of situations where we already have someone in our local database who is entered many times in more than one format, such as "John Doe, Jr." and "John Doe Jr.", etc.

The only way to fix these today is to select one of the two as a "Common Name" and then change all of the other profiles to put in both the Common Name and the "as credited" name.  Then you need to delete the "Uncommon name" from the "Common Name" list.

It would be great if you could write a utility that would do a Global find and replace searching each profile for a name and replacing the "find" name with the "replace" name, while entering the "find" name into the "as credited" field.

I know you don't have anything else to do, but this would be a great help to us as we finalize how we are going to determine the "Common Name". 



Question:  Who gets to determine which "common name" to dump?  Doesn't that put us right smack back into the personal preference arena?



I agree, Hal. And John, that is precisely what I keep talking about in this area....but you knew that and so did Hal, i think.

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

Billy Video
DVD Profiler Unlimited Registrantgoodguy
Sita Sings the Blues
Registered: March 14, 2007
Reputation: Superior Rating
Germany Posts: 1,029
Posted:
PM this userDirect link to this postReply with quote
Quoting hal9g:
Quote:
Ken,
...
It would be great if you could write a utility that would do a Global find and replace searching each profile for a name and replacing the "find" name with the "replace" name, while entering the "find" name into the "as credited" field.


Well, I'm not Ken, but...

The next version of Name Variants (see this thread) is due within the next days.  You will then be able to pick one of the name variants for a person as the common name and the program will update all the affected DVDs accordingly to enable full cross-linking. The existing variants will be moved to the Credited As field.
Matthias
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 collectionDirect link to this postReply with quote
Quoting goodguy:
Quote:
Quoting hal9g:
Quote:
Ken,
...
It would be great if you could write a utility that would do a Global find and replace searching each profile for a name and replacing the "find" name with the "replace" name, while entering the "find" name into the "as credited" field.


Well, I'm not Ken, but...

The next version of Name Variants (see this thread) is due within the next days.  You will then be able to pick one of the name variants for a person as the common name and the program will update all the affected DVDs accordingly to enable full cross-linking. The existing variants will be moved to the Credited As field.


OM MY GAWD!

You rock!
Signature banned: Reason out of date...
DVD Profiler Desktop and Mobile RegistrantStar ContributorGadgeteer
Registered: March 13, 2007
United Kingdom Posts: 519
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Quoting goodguy:
Quote:
Quoting hal9g:
Quote:
Ken,
...
It would be great if you could write a utility that would do a Global find and replace searching each profile for a name and replacing the "find" name with the "replace" name, while entering the "find" name into the "as credited" field.


Well, I'm not Ken, but...

The next version of Name Variants (see this thread) is due within the next days.  You will then be able to pick one of the name variants for a person as the common name and the program will update all the affected DVDs accordingly to enable full cross-linking. The existing variants will be moved to the Credited As field.


Wow. You the man.

Can't wait 
Stuart
DVD Profiler Unlimited RegistrantStar Contributorsnarbo
Registered: March 13, 2007
United Kingdom Posts: 1,242
Posted:
PM this userDirect link to this postReply with quote
What, we have to wait a couple of days? 

Even Ken turns rounds updates quicker!

But seriously, you da man, you DA MAN.  


Steve
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 collectionDirect link to this postReply with quote
Quoting goodguy:
Quote:
Quoting hal9g:
Quote:
Ken,
...
It would be great if you could write a utility that would do a Global find and replace searching each profile for a name and replacing the "find" name with the "replace" name, while entering the "find" name into the "as credited" field.


Well, I'm not Ken, but...

The next version of Name Variants (see this thread) is due within the next days.  You will then be able to pick one of the name variants for a person as the common name and the program will update all the affected DVDs accordingly to enable full cross-linking. The existing variants will be moved to the Credited As field.



Very cool. 

I haven't played with this yet as I found the very idea to be way more daunting than I could face.

Assuming that this is run against your local db, it could generate different results for different people.  That coud be a problem if they start contributing them.
Hal
DVD Profiler Unlimited Registrantgoodguy
Sita Sings the Blues
Registered: March 14, 2007
Reputation: Superior Rating
Germany Posts: 1,029
Posted:
PM this userDirect link to this postReply with quote
It's done now. More infos in this thread.

Matthias
DVD Profiler Desktop and Mobile RegistrantStar Contributorm.cellophane
tonight's the night...
Registered: March 13, 2007
Reputation: High Rating
United States Posts: 3,480
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
Quoting hal9g:
Quote:
Assuming that this is run against your local db, it could generate different results for different people.  That coud be a problem if they start contributing them.

It evaluates your local data but you choose which of the names to make as the common name.
...James

"People fake a lot of human interactions, but I feel like I fake them all, and I fake them very well. That’s my burden, I guess." ~ Dexter Morgan
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 collectionDirect link to this postReply with quote
Quoting m.cellophane:
Quote:
Quoting hal9g:
Quote:
Assuming that this is run against your local db, it could generate different results for different people.  That coud be a problem if they start contributing them.

It evaluates your local data but you choose which of the names to make as the common name.


Yes, I understand.  I have installed the plug-in and taken a look at my own db.....a big mess!

With everyone having the ability to decide for themselves which
Common Name" to use, and no guidance from Invelos yet, we are going to perpetuate the existing problems in the main db, even if we do manage to clean up our local db's.
Hal
DVD Profiler Unlimited Registrantantolod
Since Dec 02, 2003
Registered: March 13, 2007
Reputation: High Rating
United States Posts: 940
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
While it will take some time, I plan on looking at the credits for a lot of the variants found in my db to check and see if the profiles are correct.  I think just creating a common name based on the fact that an actor seems to have 2 different credits is huge leap of faith in some cases. Some of the variants I've seen look like a middle initial is in the first name field (Bill W./ instead of Bill/W. ) which is an error and not a true variant. I have also found spelling errors in the profile, not the credits (I just submitted a bunch for 24, most of which I submitted originally).

So while the plugin is a great tool, it can not replace common sense and verification that the various names exist in the film credits. 

One interesting bit of trivia, have you noticed that a lot of the name variant people have their IMDB STARmeter index going up significantly in the last week? Looks like we are all trying to find out who some of these people are. 
Kevin
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 collectionDirect link to this postReply with quote
Quoting antolod:
Quote:
While it will take some time, I plan on looking at the credits for a lot of the variants found in my db to check and see if the profiles are correct.  I think just creating a common name based on the fact that an actor seems to have 2 different credits is huge leap of faith in some cases. Some of the variants I've seen look like a middle initial is in the first name field (Bill W./ instead of Bill/W. ) which is an error and not a true variant. I have also found spelling errors in the profile, not the credits (I just submitted a bunch for 24, most of which I submitted originally).

So while the plugin is a great tool, it can not replace common sense and verification that the various names exist in the film credits. 

One interesting bit of trivia, have you noticed that a lot of the name variant people have their IMDB STARmeter index going up significantly in the last week? Looks like we are all trying to find out who some of these people are. 


The nice thing about the "name or initial in the wrong field problem" is that this plugin will actually fix your local database when you pick the variant that has it in the right field.  It moves the "wrong one" to the "as credited" field for that profile and inserts the "correct one" that you selected into the "Common Name" field.  Since the "as credited" field doesn't have separate fields for first, middle and last name, it doesn't matter that they were originally in the wrong fields.
Hal
DVD Profiler Unlimited Registrantantolod
Since Dec 02, 2003
Registered: March 13, 2007
Reputation: High Rating
United States Posts: 940
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting hal9g:
Quote:
(bold added)
The nice thing about the "name or initial in the wrong field problem" is that this plugin will actually fix your local database when you pick the variant that has it in the right field.  It moves the "wrong one" to the "as credited" field for that profile and inserts the "correct one" that you selected into the "Common Name" field.  Since the "as credited" field doesn't have separate fields for first, middle and last name, it doesn't matter that they were originally in the wrong fields.


But that does not fix the mistake in the profile in the online db which needs to be corrected. I agree if I only wanted everything to link on my local it's great, but I try to contribute corrections when I find mistakes, and I hope others do also.
Kevin
DVD Profiler Unlimited RegistrantStar Contributornorthbloke
Registered: March 15, 2007
Reputation: High Rating
United Kingdom Posts: 5,459
Posted:
PM this userDirect link to this postReply with quote
Quoting goodguy:
Quote:
It's done now. More infos in this thread.



Can I ask - how do you get your report to look like this? When I open mine, I only get the raw data tree. I've tried opening it in IE7 and Firefox, Firefox adds a comment about there not being any style data.
    Invelos Forums->DVD Profiler: Desktop Feature Requests Page: 1 2  Previous   Next