TMG-L Archives

Archiver > TMG > 2002-05 > 1020956724


From: "Jane Sarles" <>
Subject: Re: [TMG] Help with a filter?
Date: Thu, 9 May 2002 11:05:34 -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> <000401c1f766$56b7de60$3684dc0c@Sarles1> <3CDA8D7A.505CC662@reigelridge.com>


Terry,

But wouldn't that lose the spouses of siblings of ancestors and/or their
children, and witnesses who are not related? Also candidate children &
parents?

Jane


>
> That's the point of the method I described -- you are not filtering for
the people who are not related, but you are filtering for everyone who _is_
> related. Those who are left out are the ones you looking for.
>
> Terry
>
> > > 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.
> > >
> > >
> >
> > ==== TMG Mailing List ====
> > Please remove any "Reply-To:" address in your e-mail program. Including
a "Reply-To:" prevents others from benefiting from replies to your
questions.
>
>
>
>
>
> ==== TMG Mailing List ====
> FTST has been released. Check the Wholly Genes web site
<HTTP://www.whollygenes.com>; for more information.
>
>


This thread: