Home Page list
Events - Move Short Note to Description #events #tmg #notes
Do you have a lot of empty Description fields for facts or events that you would like to fill with short contents from the corresponding Note field? This might be the case for certain fact types after an import from TMG, directly or via GEDCOM. Or maybe you have chosen to enable the Description field for a fact type after adding many with sentence-useful content in the Notes. This script may help you with that chore.
The query moves content from Event Note to empty but enabled Event Description if the note is 100 chars or less for all such events of a selected Fact Type. To select a Fact Type, you must use a SQLite manager that supports SQLite run-time variables, such as SQLite Expert Personal (SQLiteSpy does not). When the query is run, a box will pop out prompting for the entry of the Fact Type's abbreviation. This is the label as seen in the Edit Person screen. By entering the wildcard character (%), all Fact Types having the Description enabled will be processed.
Some TMG users exploit its split-Memo capability in which the text is sub-divided by the "||" separator. It may be that a variant of this query would move only the first part (M1) to the Description field provided it is 100 characters or less.
Conversely, given that imported Descriptions may contain the separator, a query that would move everything after it from Description to Note might be useful.