Find-and-Replace and Less Easily Solved Problems

When writing in Register format, many abbreviations are used in the child-list sections: b., m., d., and bur. are used instead of the words born, married, died, and buried. Any month with more than five letters is abbreviated - with a period after the abbreviation: Jan., Feb., Aug., Sept., Oct., Nov., and Dec. Notice that the abbreviation for September adds an extra wrinkle; it's four letters long, not three. The names of states are abbreviated - with the standard abbreviation, not the postal abbreviation. None of these abbreviations can be easily programmed into TMG's output. Editing these can be automated in Word, however, with a Find and Replace feature many users don't know.

Take a look at Word's Find and Replace dialogue screen. Did you know that you can add formatting to the words or characters you want to find or replace? Since the child-list is the only text formatted with the 11-point font size, adding that criterion to the "Find what" area limits all changes to the child-list. It won't take long to replace complete words with the appropriate abbreviations.

Did you notice the brackets around the footnote reference numbers in the Register report? This quickly differentiates a footnote reference from a generational number, but it's another thing that cannot be programmed into TMG's output. It's very easy to create a Word macro, though, that reproduces these brackets with a simple keystroke. It doesn't take long to go through the report and quickly add these brackets to each footnote reference number.

There are some differences between this report and ones created automatically by TMG that can only be corrected by manual editing. The most significant, in my opinion, is the fact that the vital events in a person's genealogical summary follow this order in all publication style reports: birth, death, burial, followed by marriage, then birth and death of spouse. TMG's genealogical summary output is controlled by the sort order, which is chronological by default: birth, marriage, death, burial - and spouse events are written in a separate paragraph. There are cumbersome ways to get around this, but I'm a lazy person and find it easier to simply edit my report. This topic has been discussed on the Wholly Genes forum, and readers might find it interesting.

TMG produces the correct typography in the parenthetical lineage lists: italicized names and standard type for generation indicators in Register format, standard type for names and italicized generation indicators in NGSQ format. In the latter format, generation indicators are attached to the given names of all persons listed in a parenthetical lineage list, and TMG reproduces this correctly. In Register format, this generation indicator is placed after the birth surname of a married woman. This must be manually edited in the final report, if one wants to faithfully reproduce the Register format.

I use TMG for its database and analysis features, but there are many users who love exploring ways to make TMG create the perfect narrative. One of the best online examples is the study done by Terry Reigel. His report, "Producing a 'Publishable' Article," compares an actual NGSQ article with a TMG report reproducing that article, and it covers the problems he encountered and the solutions he discovered. If you want to produce a "publishable" article, you must read Terry's report.

Improving a Register Report: Microsoft Word Tips

Do you use Microsoft Word? If so, have you experimented with Word templates and Word styles? Templates and styles are not unique to Word, so if you use another word processor, the principles in this blog will be applicable, but the details will probably not be.

Take another look at the NGSQ-NEHGR-TMG styles comparison chart. Do you see all those references, "Apply styles," in the Suggestions column?

• Both the Register and the NGSQ have specific methods of formatting the first appearance of certain names in a subject's biography and in the genealogy's child lists. Although one can specify some name formatting in TMG's Report Options screen in the Names tab, one can't specify the different formatting required throughout the report. By creating styles that reproduce the required formatting, it's a fairly simple matter to apply those styles to TMG's Journal report after it's been sent to a Word file.
• Although TMG does allow one to define the fonts used in a report (Report Options > Fonts and Colors), one can't differentiate between fonts used in the report's biography section (12 point) and the report's child list section (11 point). One also can't differentiate between the font size of Memo fields used in sentences in the text (12 point), Memos that appear in footnotes or endnotes (10 point), or footnotes/endnotes themselves (10 point). Applying Word styles specifically designed to reproduce the proper formatting for the various sections of each Journal report allows the user to convert those sections to true Register (or NGSQ) style quickly and easily.
• One can also create a style for the report's title, for the author's name, for all the headings and subheadings, and even for page headings. Group all these styles together and create a Word template, with margins and everything, and save it under the appropriate name. The next time you want a professional-looking Register report, copy your TMG report into this template, and apply the appropriate styles. Voila!

Helen Schatvet Ullman was my inspiration for creating Word templates for my TMG reports. Her updated Register style template is available on AmericanAncestors.org, and it can be downloaded here. My template starts with Ullman's, then adds additional styles for all parts of the TMG report. It also includes this example report and detailed instructions on converting a TMG-formatted report to one that matches Register style. I've also created a Word template that converts TMG's NGSQ-style Journal output to something that comes much closer to the formatting used by the NGSQ. If you would like a copy of either template, please feel free to contact me. My e-mail address is available in my Blogger profile.

Manual editing was still required to get this report to this final stage. The final blog on this topic gives a quick overview of some of the editing that should be done on each report and a few tricks to make that editing go a little faster.

TMG's NGSQ and NEHGR Reports

Have you ever printed a Journal report using TMG's default settings for Register (NEHGR) or Record (NGSQ) style? If so, you might have said to yourself, "This doesn't look much like an article from one of those journals." Face it. No matter how sophisticated and powerful your genealogy software is, it's designed to help you think. It cannot do your thinking for you. If you want to create a professional genealogy, you need to engage your brain in the process. TMG and a word processor, though, can help. We investigated both the NEHGR and NGSQ styles in our January 2013 meeting. Because it requires a few more interesting tricks, this blog will report only our NEHGR findings.

We first created a two-generation genealogy Journal report using TMG's default Register (NEHGR) style options. This style choice restricts some of the available report options. These are the unrestricted options we chose.

1. In the Sources tab, we checked "Footnotes" and "Combine consecutive footnotes/endnotes."
2. In the Memos tab, we checked "Footnotes."
3. In the Tags tab, we checked "Selected" and checked only "Birth," "Burial," "Divorce," "JournalConclusion," "JournalIntro," "Marriage," and "NarrativeChildren."
4. In the Dates tab, we checked "Months spelled out."
5. In the Places tab, we checked "Use place styles."
6. In the Names tab, we checked "None" under Identifiers.
7. In the Fonts and Colors tab, we changed all fonts to 12-point Times New Roman, with the exception of the Title, which was changed to 14-point, bold, Times New Roman.

Comparing that output to articles in the October 2012 issue of the New England Historical and Genealogical Register led to some quick changes in these default options. To change these options, it's necessary to change the style from Register (NEHGR) to Custom.

1. In the Names tab in the Report Options screen, we checked "Include surname" under Child names.
2. In the Miscellaneous tab in the Report Options screen, we checked "Include spouse events" under Format.

Here's a PDF of the resulting report. Although the generation numbers and the generation line in this report are (almost) correctly formatted, it still doesn't really look like an article from the NEHGR. The differences are really too numerous to list in this blog, but most of them are enumerated in this comparison chart. Note that this is not an official comparison chart; it's one I compiled after studying the references listed at the end of the chart and comparing them to TMG's NGSQ and NEHGR reports.

Although creating a professional genealogy report in an approved style will always require manual writing, or rewriting, combining some great TMG features with the styles feature in Word (or your own favorite word processor) will allow us to come much closer to that approved style. Here's our final computer-driven report. Doesn't it look a lot more like an article in the NEHGR? Check out the next post to see how this report was created.