Finding duplicated person

[Marla]

Is there any reports that create for finding duplicated person? 

[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

 

 

[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....

[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....

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.  

[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

[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