This is an ‘upgrade’ from RMGC_Properties – Query #database for pre-RM8 databases. It provides an expansion over the information provided on the RM8 Home – File Properties screen. With a SQLite manager that supports runtime variables, a summary report can be given (just those variables with no leading hyphen).
It ATTACHes a reference empty, unused RM8 database that you provide from your up-to-date version of RM8 against which certain built-in items are compared, e.g., Fact Types and Source Templates, from your database under test. You’ll need to edit a line in the script to point to that empty database on your system.
Here’s an example of the script’s output for a database that was created around the time of the first public release:
| Value | Variable | Remark |
|---|---|---|
| 6000 | Version | vs Control version 8000 |
| – pre/post RM8 release | WARNING! Database from a pre-release version of RM8 | |
| 1608 | People | all records in PersonTable |
| 0 | – Nameless People | no record in NameTable for that RIN |
| 153 | – Unresolved Duplicate Name Pairs | pairs of Given and Surnames, not flagged as “Not a Problem” |
| 20 | – Resolved* Duplicate Name Pairs | flagged as “Not a Problem” – flags lost on transfer |
| 5 | – Unresolved Duplicates with Media Links | secondary persons’ links lost on merge |
| 257 | Alternate names | all records in NameTable where IsPrimary=0 |
| 0 | – Orphaned Alternate names* | no Primary name record found |
| 551 | Families | all records in FamilyTable |
| 69 | Fact Types | no. of records from FactTypeTable |
| 5 | – Custom Fact Types | no. of custom Fact Types |
| 9 | – Customised Built-in Fact Types | no. of built-in Fact Types modified |
| 34 | – Unused Fact Types | no. of Fact Types not used |
| 0 | – Blank Fact Type Names | FactTypes must be named |
| 0 | – Blank FactType Sentences | FactType needing definition |
| 6733 | Events | all records of EventTable |
| 0 | – Orphaned Events | events for which no person or family match in respective tables |
| 138 | – Event Witnesses | All records in WitnessTable of persons sharing events |
| 17 | — Nominal Witnesses | not Persons from database, but named in WitnessTable as sharing an event |
| 0 | — Headless Witnesses | PersonID (RIN) in WitnessTable missing from PersonTable |
| 0 | — Witnesses to Lost Events | EventID in WitnessTable cannot be found in EventTable |
| 0 | — Witnesses with blank Role | no role has been assigned from RoleTable or the RoleTable role is empty |
| 5 | — Witnesses with Custom Sentence | a custom sentence has been assigned, unique to this witness |
| 26 | — Witnesses with Note | a note has been entered for this witness to an event |
| 84 | — Roles | no. of records from RoleTable |
| 26 | — Custom Roles | no. of custom roles |
| 1 | — Customised Built-in Roles | no. of built-in roles modified |
| 54 | — Unused Roles | no. of roles not used |
| 0 | — Blank Role Names | Roles needing definition |
| 2 | — Blank Role Sentences | Roles needing definition |
| 1485 | Total Places | all records in PlaceTable incl Places and Place Details (Sites) |
| 177 | – System Places | system supplied Places: LDS Temples |
| 1081 | – User Places | user defined Places excl Sites |
| 330 | — Used, having Geo-coordinates | non-empty Lat or Long |
| 42 | — Unused User Places* | not used by EventTable, will be dropped in a transfer |
| 227 | — User Place Details | user defined Sites |
| 22 | — Used, having Place Detail Notes* | Site Notes will be lost in a transfer |
| 60 | — Used, having Geo-coordinates | non-empty Lat or Long |
| 13 | — Unused Place Details* | Sites will be lost in a transfer |
| 833 | Source Templates | # of records from SourceTemplateTable |
| 418 | – Custom Source Templates | # of custom Source Templates |
| 415 | – Unupdated Built-in SourceTemplates | # not matching reference database |
| 392 | – Unused Custom SourceTemplates* | lost on transfer |
| 1 | – Incomplete Source Templates | missing part of definition |
| 256 | Total Sources | all records from SourceTable |
| 3 | – Unused Sources* | SourceTable records unused by CitationTable |
| 6080 | Total Citations | all records from CitationTable |
| 6080 | Total Citation Links | all records from CitationLinkTable |
| 11 | – Duplicate Citations | identical in most respects, cluttering reports |
| 0 | – Sourceless Citations* | no SourceTable record for this CitationTable record |
| 54 | – Headless Citations* | CitationTable records for which no Person, Event, Family, AltName found; cleaned on transfer |
| 18 | Repositories | all records from AddressTable of type Repository |
| 827 | Multimedia items | all records from MultimediaTable |
| 7 | – lacking thumbnail | probably an imported reference to an image file that has yet to be found |
| 0 | – duplicate multimedia filenames | probably having different paths |
| 25 | – with Date & Description* | (TBC) if a record has both, the Description is lost in a transfer |
| 3894 | Multimedia links | all records from MediaLinkTable |
| 0 | – duplicate multimedia links | image appears multiple times for person, fact |
| 26 | Addresses | all records from AddressTable of type Address |
| 0 | – blank names | Name field of AddressTable record is blank |
| 43 | Tasks | all records from TaskTable |
| 2 | – Research Log | all records from TaskTable of Type 1 |
| 41 | – ToDo | all records from TaskTable of Type 2 |
| 0 | – Correspondence | all records from TaskTable of Type 3 |
| 1 | Folders | all records from TagTable of Type 1 |
| 34 | Groups* | all records from TagTable of Type 0 |
| * NOT TRANSFERABLE | via GEDCOM or Drag&Drop to another RM database |
Future additions could include information about the FamilySearch and Ancestry linkages.