Jump to content


Photo

RMtrix utilities updated

RMtrix SQLite Utility

  • Please log in to reply
1 reply to this topic

#1 TomH

TomH

    Advanced Member

  • Members
  • PipPipPip
  • 5538 posts

Posted 21 January 2013 - 10:27 PM

RMtrix has been updated with many of the SQLite queries developed over the last nine months on the SQLite Tools for RootsMagic wiki. It makes it possible for those not comfortable with using a SQLite manager, and convenient for those who are, to inspect and manipulate a database in ways not available in RootsMagic itself. The menu selection comprises:
  • Addresses > Identify Blank Names | How Used
  • Database > Analyze | De-Analyze | Integrity Check | Reindex | Properties| Vacuum
  • Events > Set same date sort order | Shared events with missing witnesses | Sharable events
  • | Birth Year Mismatch List | Death Year Mismatch List | UPDATE Birth and Death Years
  • | Convert Shared to Individual (SPLIT Shared to Individual | UNSHARE | UNDO Splits and RESHARE | HIDE Tracks)
  • Fact Types > View current outputs | Set all to GEDCOM | Snapshot current | View snapshot outputs | Restore from snapshot | Delete snapshot
  • Media > File Links | Media List | DELETE Unused | RESET Media Type
  • | Media Tags (COPY from Shared Events to Individual | DELETE Personals duplicating Events)
  • People > Duplicate Name Search | Resolved Duplicate Names | Multiple spouses | Nameless People - DELETE
  • | Alternate Names (List | Delete Orphans | SET Type "Married" | ADD "Married")
  • Places > Errors | Having Place Details | Unused Places | Orphaned Place Details (List | Delete) | DELETE Unused
  • Reports > Paragraphing (Strip | Add) | Dummy family (Add | Delete) | LifeLines
  • Sources > Master Sources | Source List | Invisible Name Citations (List | Convert to Personal Citations)
  • To-Do > To-do List
  • Tools > DELETE Phantoms
  • Web Tags > MAKE WebTags from citation Comments | COPY from Citations to Persons | DELETE Duplicates
​More description and download are at Bundled Utilities - RMtrix.

Tom user of RM7230 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> Rmtrix_tiny.png app, a growing bundle of RootsMagic utilities.


#2 R Steven

R Steven

    Advanced Member

  • Members
  • PipPipPip
  • 53 posts

Posted 20 March 2013 - 08:21 AM

Great work, Tom. Thanks for all of the effort you put into this!