Exploit your RootsMagic family tree database with SQLite Tools
RootsMagic 6.3.3.2 imports TMG Citation Detail memo field into CitationTable.Fields as the field [CD] defined in the SourceTemplateTable.Fields regardless of TMG memo splitter “||”. An issue which I’m sure many will detect is that sentences for sources with split Citation Detail (CD1, CD2,..) do not contain any of the Citation Detail. The full value is…
RootsMagic version 6.3.2.0 and later supports the direct import of project databases from The Master Genealogist. These programs have many similarities and, of course, many differences. They both support witness tags/shared events, sentence templates for facts, footnotes and bibliography and text formatting but names of variables, syntax, codes and database structure differ. Not all can…
RootsMagic 6.3.2.0 imports the TMG_ID into a custom fact type TMG_ID. This fact type cannot be displayed after the name of the person. Some users would prefer that it did, either by having it as RIN or by a new feature specifically for TMG. (See also TMG-RM Convert TMG_ID to Record Number) This procedure makes…
TMG has dual Principal, non-spousal events that RM does not support. Direct import converts these events to Individual type and variables of Spousal type may get through, i.e., [Spouse], [Husband], [Wife], which are invalid for a RM Indiv event. The name of the variable is outputted instead of nothing when it is unrecognised for a…
This is NOT SQLite! Rather, RMπ (RMpi) is a little application that tweaks a GEDCOM file you want imported into RootsMagic for potentially more complete data transfer. More development may come later but it could be useful now, especially to early emigres from The Master Genealogist 9.0.3 and earlier. Perhaps equally importantly for exchanges between…
To “Unreverse” something is to restore it from a reversed state. Names inadvertently entered into a name type field in a templated source in “reverse” order, i.e., surname, given are not properly handled by RootsMagic 7 and earlier. The resulting sentences for the Footnote, Short Footnote and Bibliography are screwed up. RootsMagic wants entries for…
This page provides an overview of the utilities available on this wiki that may help you with your migration of a TMG Project to a RootsMagic database. An example of what TMG Refugee Mike James did is described at https://lists.rootsweb.com/hyperkitty/list/tmg-refugees.rootsweb.com/thread/199856/. It is important to note that there may be considerable cleanup and data manipulation to…
Why? RootsMagic 6.3.3.2+ imports the TMG_ID into the standard RootsMagic Reference No. fact type (REFN). While this fact type can be displayed after the name of the person in main views and reports, it cannot be displayed in the sidebar Index and in some other places. Some users would prefer that it did; the only…
After importing a TMG project, there is considerable cleanup to be done in the resulting RootsMagic database. There are differences in their respective sentence template languages that cannot translate well or could be translated better (improvement possible in the direct import process). This script addresses some of these outcomes and some unwanted artifacts that could…
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…