After two years spent studying Elizabeth Shown Mills' Evidence Explained, our group needed a break. We decided that there is no better way to discover all that The Master Genealogist (TMG) can do than to explore its powerful custom report writer. If you would like to participate in the Tri-Valley TMG User Group's adventures as we examine the best ways to input data to make full use of TMG's wide range of reporting possibilities, please feel free to comment and share your ideas.

The Tri-Valley TMG User Group is associated with the Livermore-Amador Genealogical Society (L-AGS), and we meet in Pleasanton, California. Information on our meetings - location, date, time, and topic - is always available on the home page of the L-AGS web site. Our three-hour meetings are actually hands-on workshops in which up to fifteen computers are connected to a digital projector allowing customized personal assistance to attendees. In the past, the group has systematically studied Lee Hoffman's Getting the Most out of The Master Genealogist, Terry Reigel's A Primer for The Master Genealogist, and Elizabeth Shown Mills' Evidence Explained.

For further details on the reports we create, please visit our website. The section dealing with TMG reports begins at the page, "Exploring TMG's Report Menu."

Start following our new blog, "The Continuing Adventures of the TV-TMG User Group." This will detail our 2014 project.

Saturday, May 13, 2017

Creating a "Census Candidates" Search List I

"I want a list of people in my database for whom I have no 1850 census record." That seems like a pretty simple project, right?

  • The name itself tells us what TMG report we probably want: a List of People report.
  • We don't want a list of all the people in the database. We want a filtered list of people.What people belong in this report? The subjects of this report must meet two criteria.
    1. They must have been living on 1 June 1850, the official census date.
    2. The database must be missing 1850 census information for those people.
Let's take a look at the first part of the filter. Here's what I use for this part. It's simple, but it still merits some discussion.
  • The first line is: Birth Group... | Date | <= Does not come after | [?]. First, note the [?] in the field value space. This tells TMG to ask me what value should be there before it runs the filter. This allows one to save a filter and run it over and over again with different values.
  • The Birth Group field includes such tags as Birth and Baptism. Any person who has a birth or baptism date that comes on or before the date I enter, will stick to the filter. Anyone who was born after the selected date will fall out of the filter.
  • I use the official census date for this birth/baptism value (1 June 1850 for this census). That's the date census takers were told to use when they asked about the family composition. I know it will come as a shock to many of you, but not everyone answered the census taker correctly.☺ Still, I find this a good starting point when querying my database. You may choose another date, or you may choose to use Year for the subfield, rather than Date.
  • If the little box that precedes this line is checked, TMG will use only the primary birth group value for its filter.
  • The second line is very similar: Death Group... | Date | > Comes after | [?]. If a person was living on the official census date, they were supposed to be reported as part of the family, even if they died the next day. If a person has a death date that comes after the selected date, they will stick to the filter. If not, they will fall out of the filter.
  • TMG uses a subset of Boolean logic. Boolean logic includes three operators: AND, OR, and NOT. TMG allows only the first two operators. The AND operator requires that a person meet all criteria to stick to the filter. In this filter, someone who was born 18 August 1812 (matches the first filter line), but died 6 May 1849 (fails the second filter line), would fall through the filter and would not be included in the report.
My non-genealogy husband asked a critical question. "What happens if you're missing a birth date or a death date?" Good question. One can construct an additional filter to catch some of those people, but is it necessary? In my database, my list of people missing census tags with this filter is long enough that I'm not ready to go searching for extra people - yet. We will get to that filter, but let's examine the second criterion, no 1850 census tag, first.

No comments:

Post a Comment