Jump to content
TNG Community
Marla

Finding duplicated person

Recommended Posts

Marla

Is there any reports that create for finding duplicated person? 

Share this post


Link to post
Share on other sites
Mark

I use the below report to return people with the same first and last names, birth and death dates :

SELECT 
p.personid, 
p.firstname, 
p.lastname, 
p.birthdate, 
p.deathdate,
p.gedcom
FROM tng_people p
WHERE EXISTS
(
SELECT * FROM tng_people p2
WHERE p2.personid <> p.personid
AND p2.firstname = p.firstname
AND p2.lastname = p.lastname
AND p2.birthdatetr = p.birthdatetr
AND p2.deathdatetr = p.deathdatetr
)
AND p.lastname <> ''
ORDER BY p.firstname, p.lastname

 

 

Share this post


Link to post
Share on other sites
tokyojef

Thats a good one! :)

now it brings up the issue in my tree anyway of duplicate lines and where do you see

to disconnect or delete without losing a branch....:lol::shock:

Share this post


Link to post
Share on other sites
Marla
On 3/4/2017 at 10:42 PM, tokyojef said:

Thats a good one! :)

now it brings up the issue in my tree anyway of duplicate lines and where do you see

to disconnect or delete without losing a branch....:lol::shock:

Thank you for this.  It surely would help me to identify duplicated people! But how can I make it in each tree?  I have three trees and this report in all trees gave me a lot of confusion.  

Share this post


Link to post
Share on other sites
tokyojef

Hi Marla!

I know anyway from trying to sort lines out in Ancestry.com;

1. I had to look at the root (oldest ancestor of the duplicates)

of both trees downward. As well, I guess you could move back up and notice chances and 

make decisions that way.

2. I looked at comparing what was duplicated and checking if one could be deleted

of the less important line duplicate, or merging of individuals where necessary.

Then

3. Once one line of duplicates had everyone needed in another,

I could go down and delete individuals out of that duplicate ,

and end up with 1 duplicate less.

Then repeat it for another duplicate tree.

There might be more considerations to whether both people need to appear in both trees,

then that needs to be considered; and asked if you can share that individual between trees

or you have to keep one of each if the tress are split.

 

In TNG it would seem sql query scripts would help

you to find the duplicates.

how to view the ancestors and descendants in a large over view

in TNG the best way to accomplish this in the same way other desktop softwares do,  I'm not sure. 

If you have a split view of each tree

it seems it would give you a better view of where you were in each place of a tree at the same time.

I just open a duplicate instance of my ancestry tree in another window,

and make them the same size next to each other.

When you find the right view/approach in TNG to see your tree,

then you could do a split screen by using 2 windows as above.

 

This is just my newbie thoughts on an approach. I am sure veterans of TNG,

must know sql queries and/or tips to do what I am suggesting in an easier way

or different approach.

In my case I have just 1 tree with duplicate lines to unravel and sort the keepers.

the need is the same in both our cases.

Perhaps as well sorting things out in your usual desktop software

(FH, Legacy, Rootsmagic, FTM, or by hand etc.)

then reimporting your gedcom (with certain options chosen on the import),

wmight be the way that is suggested by others.

 

Hopefully, someone will have time to input on this thread for suggestions! :)

Jeff

Share this post


Link to post
Share on other sites
Marla
On 3/8/2017 at 12:10 PM, tokyojef said:

Hi Marla!

I know anyway from trying to sort lines out in Ancestry.com;

1. I had to look at the root (oldest ancestor of the duplicates)

of both trees downward. As well, I guess you could move back up and notice chances and 

make decisions that way.

2. I looked at comparing what was duplicated and checking if one could be deleted

of the less important line duplicate, or merging of individuals where necessary.

Then

3. Once one line of duplicates had everyone needed in another,

I could go down and delete individuals out of that duplicate ,

and end up with 1 duplicate less.

Then repeat it for another duplicate tree.

There might be more considerations to whether both people need to appear in both trees,

then that needs to be considered; and asked if you can share that individual between trees

or you have to keep one of each if the tress are split.

 

In TNG it would seem sql query scripts would help

you to find the duplicates.

how to view the ancestors and descendants in a large over view

in TNG the best way to accomplish this in the same way other desktop softwares do,  I'm not sure. 

If you have a split view of each tree

it seems it would give you a better view of where you were in each place of a tree at the same time.

I just open a duplicate instance of my ancestry tree in another window,

and make them the same size next to each other.

When you find the right view/approach in TNG to see your tree,

then you could do a split screen by using 2 windows as above.

 

This is just my newbie thoughts on an approach. I am sure veterans of TNG,

must know sql queries and/or tips to do what I am suggesting in an easier way

or different approach.

In my case I have just 1 tree with duplicate lines to unravel and sort the keepers.

the need is the same in both our cases.

Perhaps as well sorting things out in your usual desktop software

(FH, Legacy, Rootsmagic, FTM, or by hand etc.)

then reimporting your gedcom (with certain options chosen on the import),

wmight be the way that is suggested by others.

 

Hopefully, someone will have time to input on this thread for suggestions! :)

Jeff

Hi, Jeff,

Sorry for a long delay.  Thank you for your advice.  I found the other way. It is Family Tree Analyzer and it is a wonderful tool to find any errors.  

Marla 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×