Set IPTC Data - fixed bug in IPTC.dll that was causing multiple APP14 segments to be written to the JPG. Anyone who has used this LTool after installing 1.2.31 should restore their JPGs from their backup and rerun this LTool if they ran it multiple times on the same JPGs. If you only ran it once you should be OK.

• "Marriages - Find Unknown Spouses w/o Children"

UpdateQueries.csv - added to the canned UPDATE queries for Run Raw SQL:

• "Individuals - Tag Cremated"
• "Marriages - Tag Unknown Spouses w/o Children"

Check for Updates - added a message that will inform the user that LTools was unable to check for the update due to a problem with the internet connection.

Set IPTC Data - enhanced to also update IPTC Headline, Copyright, and CaptionWriter fields in addition to the Caption field. Now has a "mapping" feature which will allow the user to control where Legacy Caption, Desc, and Date are placed within these IPTC fields. See the Help file for more details.

Set IPTC Data - changed references from IPTC Description to IPTC Caption. This seems to be what most people call this field.

Set IPTC Data - changed the default Action to Copy to all IPTC fields.

Set IPTC Data - removed the requirement to install Microsoft Pro Photo Tools by developing my own VB.Net code for reading/writing IPTC data. I did this because the Microsoft DLLs that I was using added a couple of megabytes to the size of the update. Additionally, I did not like the idea of requiring users to install another software package just to get one particular LTools feature to work. After installing this update you may uninstall Microsoft Pro Photo Tools if you desire.

Because I "rolled my own" code for updating IPTC data, please be sure to make backups of your images prior to running Set IPTC Data!!! I am not responsible for any loss of data!!!

Set IPTC Data - added the option to Backup Image Files.

Run Raw SQL - fixed problem with uncaught exception when user cancelled from the "Enter Parameter" dialog.

Find Unattached Multimedia - some code clean-up.

Tidy Legacy HTML - added the ability to hide the Family Links box when there are none. After installing this update you should edit your pedigree.css file and insert the following class:

/* style for empty Family Links table */
table.t5 { width: 200px; background-color: black; border-spacing: 0px; display: none; }

It should look identical to table.t3 except for the "display: none;". If you have made your own customizations to table.t3, make sure to make corresponding changes in table.t5.

Removing the "display: none;" style will make the Family Links box visible again.

Care should be taken to backup your Legacy images before running this LTool.

NOTE: Without getting into detail, you will need to install Microsoft Pro Photo Tools on your PC in order for Set IPTC Data to work. The installation of Microsoft Pro Photo Tools seems to configure something on the PC that eliminates a certain COM error. What is funny is that you can immediately uninstall Microsoft Pro Photo Tools and Set IPTC Data will continue to work. So it appears that whatever Microsoft Pro Photo Tools adds during installation it does not remove during uninstallation. Probably a registry key.

SelectQueries.csv - added "Individuals - Find Cremated" to the canned SELECT queries.

UpdateQueries.csv - added to the canned UPDATE queries for Run Raw SQL:

• "Marriages - Tag All Marriages"
• "Marriages - Tag Marriages by IDSR"
• "Marriages - Tag Marriages by Source Name"

LTools.xml - added code to recover from a corrupted LTools.xml config file during startup. The corrupt config file will automatically be emailed to dennis@zippersoftware.com for examination.

Run Raw SQL and View Legacy Tables - cosmetic changes.

Run Raw SQL - allow '*' or '%' to be used as wildcard characters in LIKE clause.

Tidy Legacy HTML - coding efficiencies made to ConvertToEntities logic.

Sort Marriages by Date - cosmetic changes.

Tidy Legacy HTML - added an option to convert ASCII characters that are greater than 127 to HTML entities (with a few exceptions). For example, by setting the ConvertToEntities option to TRUE under Options|Preferences, the character 'Å' will be converted to "Å" everywhere in the output.

Help - a few updates to the Help file.

Tidy Legacy HTML - placed the LTools link text on the Tidy Legacy HTML dialog window rather than require a prompt every time. You will still get prompted if you choose to add the LTools link without any associated text.

No LTools Bulletin issued.

Main Window - display name of config file on Title bar.

Tidy Legacy HTML - fixed a few glitches with the launch index.htm* logic.

No LTools Bulletin issued.

Tidy Legacy HTML - allow international users to customize various phrases that the program keys on to make its changes. These phrases include:

• "Another name for" (AKA)

Tidy Legacy HTML - work around Legacy bug where Legacy inserts double colons in some international versions.

Tidy Legacy HTML - now prompts the user to launch index.htm* in the default browser upon completion.

Options|Preferences - added an option to suppress the newpedigree.css warning when Tidy Legacy HTML is done.

Address Converter - made removing the link to the Address record (tblAR) optional.

Set Special User IDs - added the ability to generate de Villiers numbers. This particular implementation of the de Villiers numbering system does not propagate down thru the female lines.

Options|Preferences - added the default text for the optional LTools link in Tidy Legacy HTML to Options|Preferences.

Options|Preferences - changed XmlConfig.dll to save LTools.xml using Windows-1252 encoding so that special characters used by international users can be entered and saved in the Tidy Legacy HTML section of the Options|Preferences dialog.

Tidy Legacy HTML - made a few minor changes to the following:

• Checking/unchecking the Add LTools link to Legacy footer checkbox will now reset the added text to the default value.
• Minor change to the LTools META tag that gets inserted in the output.
• Now includes my own custom version of tidy.exe (built from the source code at http://tidy.sourceforge.net/) It contains a couple of minor tweaks that makes it more compatible with what I am using it for). The only change you should see is in the META tag that tidy.exe inserts in the output.

Tidy Legacy HTML - allow international users to customize various phrases that the program keys on to make its changes. These phrases include:

• "Cause of" (cause of death)
• "Other names for" (AKA)
• "This Web Site was Created" (Legacy footer)
• "Spouses/Children" (in Family Links box)
• "Parents" (in Family Links box)
• "Sources" (Sources section at bottom of pages)

You can change the values of these key phrases by going to the Tidy section under Options|Preferences. If you are generating Legacy web pages for non-English users and don't change these phrases, Tidy Legacy HTML may not convert the web pages properly.

Tidy Legacy HTML - tweaks to the code that appends an LTools link to the Legacy footer.

No LTools Bulletin issued.

/* style for table which contains the subject's data */
table.t4 { width: 95%; text-align: center; }

The pre-processor will change everything between these tags into one giant comment. That way, when the HTML Tidy phase runs, it will totally ignore your custom code (because it sees it as a comment). Finally, the post-processor will uncomment the code between these tags.

To put it another way, any custom code between the <!-- start custom html --> and <!-- end custom html --> tags will no longer be modified by the HTML Tidy phase.

Please keep in mind that the custom html feature is not implemented for index, name, and surname pages.

Tidy Legacy HTML - will use the copy of tidy-pedigree-settings.cfg (config file for HTML Tidy) in the Application Data folder if it exists. Your Application Data folder is located:

• For XP: C:\Documents and Settings\<username>\Application Data\Zipper Software\LTools\
• For Vista/Win7: C:\Users\<username>\AppData\Roaming\Zipper Software\LTools\

If one is not found in the Application Data folder, it will use the one found in the folder where you installed LTools. This allows custom settings to be retained between LTools upgrades. Just copy the file from the installation folder to the Application Data folder and make any customizations to the latter.

Warning - use caution when making changes to this file, as changes you make can break things in the post-processing phase.

Tidy Legacy HTML - added an option to add an HTML link to LTools in the Legacy footer.

Help - minor changes to the Help file.

Registration - fixed bug in registration logic.

• Find Unattached Multimedia
• Backup/Restore USR Files

Tidy Legacy HTML - minor fix to replace extra space at start of "Cause of Death" line with CSS class 'P2'.

Tidy Legacy HTML - minor fix to replace extra space at start of "Other names for" line with CSS class 'P3'.

Tidy Legacy HTML - changed to send index.htm* thru the "HTML Tidy" phase. If you don't want this file processed by the "HTML Tidy" phase, rename it to index.xxx  or move it somewhere safe prior to running Tidy Legacy HTML.

Tidy Legacy HTML - made a few minor changes which affect the appearance of names*.htm* files...

• centered the top alphabet index bar
• centered the top [FROMSURNAME-TOSURNAME] line
• eliminated the trailing ", " on the alphabet index bars

• Find Unattached Multimedia
• Backup/Restore USR Files
• RegEx GEDCOM
• Tidy Legacy HTML

No LTools Bulletin issued.

Find Unattached Multimedia - fixed additional problems dealing with sound, video, and document types.

Note: An "Everyone" installation will not upgrade a previous "Just me" installation and vice versa. So try to always choose the same one each time you run the setup program. The easy way to remember what you used last time is to just click thru the installation dialogs and take all the defaults.

No LTools Bulletin issued.

Find Unattached Multimedia - changed program to look in tblBR.PicSoundName column in addition to tblBR.PicName for the filename.

Minor tweaks/cleanup to various LTools.

Find Unattached Multimedia - fixed a minor bug which was causing some marriage events to be reported as individual events.

No LTools Bulletin issued.

Tidy Legacy HTML - added CSS class "td9" to align individual data to the left.

Minor tweaks to:

• Set Marriage User IDs
• Merge Basic to SourceWriter Sources

Find Unattached Multimedia - fixed problem with the dialog initially displaying the incorrect "Root Multimedia Folder".

No LTools Bulletin issued.

This LTool goes thru your database looking for individuals that are flagged as living and are without a birth or baptism date. It then tries to estimate a birth date for the individual based on his/her parent's birth, baptism, marriage, death, and burial dates. If unable to do so, it will do the same using the individual's spouses. It will make additional passes thru your database until it encounters a clean pass or reaches the limit that you set. It does this because an individual whose birth date could not be estimated on an earlier pass might have more data to work with on a subsequent pass (their parent's/spouse's birth date was estimated on the earlier pass and is now available on the subsequent pass). That being said, unless you have a very lengthy family tree, you will probably never need more than two or three passes. For large databases, this LTool may take several minutes to run.

A log of the changes this LTool makes to your database is displayed when processing is complete.

This LTool does NOT replace Legacy's Advanced Set Living feature. It should be used in addition to it.

NOTE: This LTool is designed to catch many situations that Legacy's Advanced Set Living feature misses. But it will not catch them all.

Help - fixed to allow Help window to be placed underneath other LTools windows (as opposed to always on top).

List Events - fixed minor problem with window resizing.

View Legacy Tables - changed window style to non-modal or modeless.

Run Raw SQL - changed window style to non-modal or modeless.

NOTE: Making these two windows non-modal allows them to stay open while you are doing other things in LTools. As a matter of fact, you can now open multiple copies of these two windows.

Edit Preferences - additional tweaks to the PropertyGrid control.

Edit Preferences - changed the dialog to make use of a PropertyGrid control.

Tidy Legacy HTML - added the ability to specify the name of the CSS file used for pedigree style web pages. This filename can be set in the Edit Preferences dialog (see the TidyPedCSS property).

RegEx GEDCOM - fixed problem when RE contained "\/" (escaped forward slash).

Edit Preferences - fixed bug with color preferences causing an unhandled exception.

Set Special UserIDs - fixed additional bugs with Ahnentafel numbering and split lines of ascent that lead back to same ancestor. Same with Henry and d'Aboville numbering and split lines of descent.

UpdateQueries.csv - added several new "canned" UPDATE queries.

Renamed Basic Version to Standard version.

Main Window - has a new look! Now uses several TreeView controls instead of a TabControl with buttons. Just double-click your favorite LTool to bring up that LTools' dialog. Includes a few minor changes to several dialog names.

Edit Preferences - added the ability to set color preferences.

Check for Updates - Changed shortcut to Alt+C due to conflict with another shortcut.

View Legacy Tables - added "Select All" and "Add Query to MySelectQueries.csv" to the context menu. Changed to evaluate {parameter-name} when Run is clicked, and only prompt once if a {parameter-name} occurs more than once in the SQL. Also made a few modifications re parsing SelectQueries.csv and MySelectQueries.csv.

Run Raw SQL - added "Select All" and "Add Query to MyUpdateQueries.csv" to the context menu. Changed to evaluate {parameter-name} when Run is clicked, and only prompt once if a {parameter-name} occurs more than once in the SQL. Also made a few modifications re parsing UpdateQueries.csv and MyUpdateQueries.csv.

Set Special UserIDs - fixed bug with Ahnentafel numbering and split lines of ascent that lead back to same ancestor. Same with Henry and d'Aboville numbering and split lines of descent. Also fixed bug in Ahnentafel where long ancestral lines were causing an arithmetic overflow. Really long ancestral lines could still have a problem if the Ahnentafel number exceeds the capacity of a 64-bit integer.

Sort All Children - fixed to point at the correct Help page.

MySelectQueries.csv - added several new "canned" SELECT queries.

UpdateQueries.csv - added several new "canned" UPDATE queries. They include queries to change an individual's gender per Denise L. Moss-Fritch's instructions at http://www.moss-fritch.com/legacy_7.html. I do not recommend this method, but include it for those who wish to use it.

Run Raw SQL - added some new "canned" SQL UPDATE queries. You can refresh UpdateQueries.csv with the latest copy from the Internet at any time by entering Ctrl+U from the main LTools window. If you have already added your own queries to UpdateQueries.csv, a copy will be saved as UpdateQueries.bak. In the future, adding your own UPDATE queries to MyUpdateQueries.csv will eliminate the problem of separating the "canned" queries that come with LTools from the ones that you add yourself.

View Legacy Tables - added Cut, Copy, Paste to context menu.

Run Raw SQL - added Cut, Copy, Paste to context menu.

Run Raw SQL - added a context menu (right-click) to the SQL text box. This context menu will contain some "canned" SQL INSERT/UPDATE/DELETE queries that I have created and that have been contributed by other users. If you wish to add your own you may do so by editing the UpdateQueries.csv file in your LTools Application Data folder (in XP: C:\Documents and Settings\<userid>\Application Data\Zipper Software\LTools). Queries may contain parameters ({parameter-name}). When LTools encounters a parameter it will prompt the user to enter some text. The text entered will replace {parameter-name} in the resulting query.

NOTE: Any updates you make to SelectQueries.csv or UpdateQueries.csv will not get overlaid when you install a new version of LTools. By the same token, any new queries that are included in an LTools upgrade will not be visible to you. To see the versions of SelectQueries.csv or UpdateQueries.csv that are distributed with any new version of LTools, look in the LTools program installation folder (C:\Program Files\Zipper Software\LTools).

If you have queries that you think might be useful to other users, you can send them to me and I will consider adding them to the SelectQueries.csv and UpdateQueries.csv files that are distributed with LTools.

Advanced DNA Tagging - combined Tag Y-DNA Descendants and Tag Mitochondrial Descendants into a single LTool.

Set Picture Captions - new Deluxe LTool which fills blank (or all) individual and marriage Picture Captions of tagged individuals with the names of the individual or married couple. Optionally, this LTool will place the individual's birth/death date, or the married couple's marriage date, in the Picture Description field (if empty). Commissioned by Bob Bashford.

Main Window - now displays a warning if you are not running the latest version of LTools.

Check for Update - added this menu item to the Help menu.

For example, you can use RegEx GEDCOM with the following two REs to remove quoted nicknames from your GEDCOM file:

/^(1 NAME .*)\".*\"(.*$)/$1$2/
/^(2 GIVN .*)\".*\"(.*$)/$1$2/

In the example below, the following two REs will convert a quoted nickname to the nickname followed by an asterisk (*):

/^(1 NAME .*)\"(.*)\"(.*$)/$1$2*$3/
/^(2 GIVN .*)\"(.*)\"(.*$)/$1$2*$3/

You can even use it to insert lines in the GEDCOM:

/^(1 NAME .*)\"(.*)\"(.*$)/$1$3\n2 NICK $2/
/^(2 GIVN .*)\".*\"(.*$)/$1$2/

REs are very intimidating, but are also a very powerful tool!

Help with writing REs can be found in many places on the Internet, or you can ask for help on the LTools User Group.

P.S. This tool will actually work on any text file, not just GEDCOMs.

Various internal tweaks. Nothing a user should notice (I hope).

• Converts a Basic Source to a SourceWriter Source in place.  Only the Master Source record is changed. All Source Detail records still point to the original Basic Source (now a SourceWriter Source). In essence, it performs the MS Access steps that Richard Van Wasshnova describes in this LUG post.
• Combines a Basic Source with a SourceWriter Source. In Legacy, this is verboten.  All Source Detail records that used the Basic Source will now point to the SourceWriter Source. The Basic Source is then removed.

This LTool is very rudimentary and you will still have much work to do to whip your SW Sources into shape. If you are going to try this LTool, be sure to do so on a COPY of your Legacy database and report any problems to me ASAP. I am not a V7/SourceWriter user so I cannot say whether this LTool is a help or a hindrance. It has been given a brief spin by Richard Van Wasshnova and he has reported no problems to date.

Set Reminders - added a tab for Death reminders (Legacy V7 only).

Sort Children - renamed to Sort Children of Tagged Individuals.

List Events - increased the height of the rows in the Results table.

Ctrl-M - shortcut which clears the MRU List of all but the currently open database.

List Events - added the ability to customize the title of the printed report.

List Events and View Legacy Tables - added the ability to show/hide columns for display, print, and CSV export.

List Events - added Age column to output.

Help - replaced the web-based Help with HTML Help (LTools.chm file included).

Find Unattached Multimedia - fixed bug where program gagged on filenames which contained an apostrophe.

View Legacy Tables - placed quotes around CSV values.

CSV generation - changed to export " as "".

Changed dialogs which allow selection of Tag # to default to Tag #1.

Find Unattached Multimedia, Search File IDs, Search Citations - added some tblSX.Type's that I hadn't known about before.

Tag Y-DNA Descendants - added option to include daughters and their spouses.

Tidy Legacy HTML - fixed problems in routines which converted events to lists.

Tidy Legacy HTML - changed code to only convert events to unordered lists. Converting events to ordered lists was never working properly anyway for events with photos.

Tidy Legacy HTML - fixed problem in routine which adds the CSS (additional spouses in Spouses/Children box were being assigned span.f5 when they should have been assigned span.f8).

Additional Win64 support.

Renamed Set Source Detail Surety Level to Set Source Surety Level.

Added Help menu items for Make a suggestion and Report a bug.

Tidy Legacy HTML - added a warning when tidy.exe terminates with exit code 2 (encountered when Legacy generated HTML contains invalid markup).

Tidy Legacy HTML - changed post-processing to move the <TITLE> tag to immediately follow the <HEAD> tag.

Renamed Set Minimum Report Surety Level to Print Best Sources (Surety).

Tidy Legacy HTML - changed post-processing to make the conversion of sources to <OL>...</OL> format optional.

Tidy Legacy HTML - changed post-processing to optionally convert individual and marriage event lists to <OL>...</OL> or <UL>...</UL> as appropriate.

Tidy Legacy HTML - added the following style to the generated HTML and to pedigree.css for individual and marriage event lists:

   li.li2 { margin-left: 0.33in; margin-top: 0.5em; margin-bottom: 0.5em }

Tidy Legacy HTML - changed to insert the contents of pedigreeHead.txt into the <HEAD>...</HEAD> section of all HTML pages.

Tidy Legacy HTML - fixed bug which was causing this LTool to stop updating the progress bar while large numbers files were being processed. The files were being processed but the lack of movement in the progress bar made it look as if the process had stalled.

Added default styles for generic hyperlinks.

Tidy Legacy HTML - added the ability to bypass CSS post-processing for custom headers and footers.

Sort Children - tweaked sort criteria to include Baptism/Christening date if Birth date not present.

View Legacy Tables - added the ability to send the query output to a CSV (comma separated value) file.

Sort Marriages - tweaked the secondary sort criteria.

Sort Events - tweaked the secondary sort criteria.

Sort Events - added the ability to untag individuals/marriages whose events are already sorted. The user then has the opportunity to go back to Legacy and review any remaining tagged individuals/marriages before proceeding.

Set Marriage User IDs - added ability to pad the MRIN with leading zeroes.

Add Events - added the ability to attach a source citation to the events that are added.

Add Events - added the ability to add marriage events.

Added a menu item for editing a few preferences like fonts, display of tooltips, and backup warning.

Changed Open Database dialog to start in the appropriate folder.

Added a Help button to all dialogs that have online help. The Help button is the "?" on the right side of the caption bar.

Added tooltips to the various buttons.

Modified the installer to remove the previous version automatically. You will no longer be required to use the Windows Control Panel to remove old versions prior to installation.

Set Individual User IDs, Set Special User IDs, MRIN Filing Helper - fixed bug where User IDs for AKAs were not being set. This causes Legacy's Check/Repair to find problems, which it promptly fixes. It is advisable to run a Check/Repair on your database to correct any leftover problems.

License - updated to allow non-simultaneous use of software on more than one PC.

License - fixed bug in dialog that was causing an exception to be thrown when viewing license after opening Legacy database.

Main Window - fixed bug which was causing LTools to open full screen after closing LTools from the Windows Taskbar while minimized.

Search Citations - added ability to clear the tag before searching.

Search File IDs - added ability to clear the tag before searching.

Add To-Do's - changed %name substitution to {NAME}.

Set Individual User IDs - renamed to Set Special User IDs.

Set Individual User IDs - new LTool which allows the setting of individual User IDs of only tagged individuals.

Set Special User IDs - added check to make sure Starting RIN is ≥ zero.

Set Marriage User IDs - added ability to set marriage User IDs of only tagged marriages.

MRIN Filing Helper - fix to correct problem when Text was present without including {MRIN} substitution string.

Find Unattached Images - renamed to Find Unattached Multimedia.