TMG-L Archives

Archiver > TMG > 2002-05 > 1020954392


From: Terry Reigel <>
Subject: Re: [TMG] Help with a filter?
Date: Thu, 09 May 2002 10:26:48 -0400
References: <20020507.212127.-16714553.1.steven.chall@juno.com> <5.1.0.14.2.20020508004009.034160e8@pop3.norton.antivirus> <001401c1f6a3$54d45bf0$3684dc0c@Sarles1> <001e01c1f75f$b64e1990$3684dc0c@Sarles1>


Jane Sarles wrote:

> I have 322 people in my data base, many of whom are not related to each
> other, that I wish to delete. They all came in with a gedcom that I should
> never have added. I can get a list of them with the "list of citations"
> report, but that won't let me set a flag which will enable me to get rid of
> them. I have not found a filter on "list of people" that will enable me to
> select those that have the citation of the gedcom, so that I can set the
> flag. Perhaps this is not doable? and I must just delete the whole 322 one
> by one?

If what you want to find is all people that have no connection at all to the main group in your dataset, there is a way. How difficult it is to apply
depends on how many people you have in the dataset, and how complex their relationships are. Here's how:

1. Create a flag -- I'll call it Connected, with values of N,Y

2. Run the List of People (LoP) report, with secondary output to change Connected to Y. Use the filter:

Is an Ancestor of person number XXX

where XXX the ID of one of the youngest person in your line. Below, check to add Spouses, Ancestors, and Descendants, and set the number of generations
to a number larger than the number of generations in you dataset. Allow the LoP to set the flag.

3. Run the LoP again, with the same secondary output, but a filter of:

Connected Flag Equals Y

and the same additions below.

4. Repeat step 3, looking at the number of people being added, which is shown on the screen after the filter runs. Keep doing it until no people are
added.

When no more people are being added, the only people left are those not connected by birth or marriage to your main line. (But do use a LoP report to
check who is still marked with a Connected = N before you do anything rash <g>)

The problem with this method is it can take a long time to run each report if you have a large dataset, depending on the capabilities of your computer. So
this process could take several hours if you have say, over 10,000 people, and a slow computer.

If you only want to find individuals that are not related to anyone, it's easier to filter for people with no parents and no children. But I don't think
that will work for you, because I assume the people you want to find include small groups of related people.

Terry Reigel


This thread: