TMG-L Archives

Archiver > TMG > 2002-05 > 1020956010


From: Terry Reigel <>
Subject: Re: [TMG] Help with a filter?
Date: Thu, 09 May 2002 10:53:46 -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>


Jane Sarles wrote:

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

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




This thread: