TMG-L Archives

Archiver > TMG > 2002-05 > 1020954735


From: "Jane Sarles" <>
Subject: Re: [TMG] Help with a filter?
Date: Thu, 9 May 2002 10:32:25 -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> <3CDA8728.B51EA8D4@reigelridge.com>


The problem is, they aren't related. Many have no parent, sibling or child.
Some have just one parent. I can't gather them all by using ancestor, or
father ID, or anything I can think of. Only by List of citation = #166,
which will not allow me to set a flag.

Jane

> 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
>
>
>
> ==== TMG Mailing List ====
> Visit the TMG Tips web site <http://www.tmgtips.com>; for items of interest
to TMG users.
>
>


This thread: