SQLite Tools for RootsMagic

Exploit your RootsMagic family tree database with SQLite Tools

List of Pages imported from Wikispaces Site

Posted on by Tom Holden
  1. Home
  2. A Migration Test Page
  3. A Proposal for a Named Group and Color Manager
  4. A Query for a To Do List in a Grid Format
  5. A Sample Query Created with Views
  6. Adding Virtual Columns to an RM4 Table
  7. Addresses – How Used
  8. Ahnentafel 64 generations
  9. All Citations & Dupes Count – Query
  10. All Citations – Query
  11. AllCitations.sql Error
  12. Alternate Names List
  13. An Example of Using SQLite Views
  14. Ancestors Named Group
  15. Ancestors Query
  16. Ancestors Query – Recursive
  17. Ancestry TreeShare – Impact
  18. Ancestry.com and RootsMagic 5
  19. Ancestry.com Sync
  20. Another version of a Set Living query
  21. Backup Media with Database – 7Zip
  22. Backup Media with Database – RAR
  23. Birth Year Mis-Match
  24. Births – Add from Christening or Baptism
  25. Births – Share with Parents
  26. Births of children as facts
  27. Bundled Utilities – Example content
  28. Bundled Utilities – Groupings
  29. Bundled Utilities – RMtrix
  30. Bundled Utilities Project
  31. Bundled Utilities Project Name
  32. Census Needed – Named Group
  33. Check RootsMagic Database Integrity
  34. Check RootsMagic Database Integrity on Opening
  35. Children – Needing Manual Arranging
  36. Children – Set Lineage to Birth
  37. Children – Set Order by Birth SortDate
  38. Citations – Delete Duplicates
  39. Citations Invisible – Reveal and Revert
  40. Citations Invisible Revealed
  41. Color Code by Consanguinity Degree
  42. Comparing Two RM Databases
  43. Complete List of Pages on this Site
  44. ConfigTable RecID 1
  45. Convert Database to NOCASE
  46. Copy Fact to Group
  47. COPY FamilySearchID to REFN fact
  48. Copy RIN to REFN
  49. Corrupt Database Recovery
  50. County Check
  51. Data Definitions
  52. Database – Copy Master Lists to Shell
  53. Database Design Spreadsheets
  54. Database is locked
  55. Database Properties List – Query
  56. Database System Catalog
  57. Date Decoder
  58. Date Formats
  59. Date Last Edited
  60. Dates – Same Day Sort Order
  61. Dates – SortDate Algorithm
  62. Death Year Mismatch
  63. Delete Many
  64. Delete Phantom Citations – Query
  65. Delete Phantoms
  66. Depopulate but keep Customs, Places, Sources
  67. DNA Test results list
  68. Download wPDF300A.DLL
  69. Duplicate Name Search – query
  70. Duplicate Search Merge Database
  71. Earlier Queries by Date
  72. Event – Add Marriage to Couples Without
  73. Events – Add to all Children a Parent event shared with parents
  74. Events – Merge
  75. Events – Move Description to Note
  76. Events – Move Short Note to Description
  77. Events with no Media attached
  78. Exporting Data
  79. Fact Inclusion Controls
  80. Fact Type – Convert Census to yyyy Census and back
  81. Fact Types
  82. Facts – Add custom MRIN event to each family
  83. Facts – Change Fact Type
  84. Facts – Reference Numbers for person, spouse and parents.
  85. Facts – Sort Order Problems
  86. Facts – Split Shared to Individual
  87. Facts Having Place Details – Query
  88. File Question
  89. File Types
  90. Four Little Queries
  91. FTM import – restore Event description from Place Details
  92. FTM to RootsMagic Migration
  93. Future of SQLite Tools for RootsMagic wiki
  94. Future of SQLite Tools for RootsMagic wiki 2016-17
  95. GEDCOM & DnD Event Description Length Anomalies & Bugs
  96. GEDCOM & DnD transfer losses
  97. Gedcom Help
  98. Genealogy Software Comparison
  99. Geo-Lifelines Query
  100. Group – Ancestors
  101. Group – Descendants
  102. Group – Persons with Duplicate Events
  103. Group – Persons with Text Dates
  104. Group – Population statistic
  105. Group – Unconnected Persons
  106. Groups – Extract most everything for one to a new database
  107. How to Query RootsMagic
  108. Identifying Events with Individual Sentence Template Customization
  109. Language other than English
  110. LifeLines
  111. Living Flag – Set Globally
  112. MapEvents-KML query
  113. Maps – Geo-Pedigree, plotting your ancestors’ birth places
  114. Maps – markers proportional to number of events
  115. Marriages, Length of
  116. Media – Bulk Rename and Relink
  117. Media – Delete Unused
  118. Media – Preserve Captions et al from RM4 to RM5
  119. Media – Set Primary Photo for Persons
  120. Media Comparison & Attach Utility
  121. Media List Query
  122. Media Metadata, Read, Write, Compare with Picasa
  123. Media Repair Queries
  124. Media Type Reset
  125. Media Users List Query
  126. MediaTags – Copy Shared Facts Media To Sharee Personal
  127. MediaTags – Delete Personal Having Fact Duplicates
  128. Merge Duplicate Single Parent Couples
  129. Migrating from Wikispaces
  130. Missing Media
  131. MS Access Engine
  132. MS Access Engine – Event Query
  133. MS Access Engine – EXCEL Pivot Tables
  134. MS Access Engine – The BLOB Fields
  135. MS Access Engine – Using EXCEL
  136. MS Access, SQLite, and Don Quixote
  137. Multiple Spouses query
  138. Name Find query
  139. Named Group – Mark or Unmark List refresh
  140. Named Group Refresh
  141. Names – Add Married
  142. Names – Delete Duplicate Alternate Names of Type ‘Married’
  143. Names – Edit NameTable with SQLite Expert
  144. Names – married name in death sentences
  145. Names – Move Prefix to empty Suffix
  146. Nickname Manipulations
  147. Notes Invisible Revealed
  148. Open Office
  149. Paragraphing
  150. People View Error – at most 64 tables in a Join
  151. People Who Share a Fact with a Principal List – Query
  152. People Who Share A Fact with a Principal, But Who Are Not in a Tree in The File List – Query
  153. Phantom Spouses – Unnamed and childless
  154. Place Details without a Place
  155. Place Errors
  156. Place Names – parse and recombine
  157. Places – Conversion of Place Details to Places
  158. Places – Count People and Events for a Group
  159. Places – Delete Unused
  160. Places – first name exploit for improved narratives
  161. Places – Frequency of Use
  162. Places – Recombine Fractures from FTM 2012
  163. Places to Place Details Conversion
  164. Places without Geo-codes for Named Groups
  165. Possible Orphaned Records in the Event Table
  166. Privatize Living
  167. Problem Adding Entries to MediaLinkTable
  168. Problem Query Example
  169. Pulling Together All the Events for An Individual
  170. Query – All Names in Tree
  171. Query for Sources Without Media
  172. Query is taking a very, very long time
  173. Query Menu
  174. Query to Add Parents Events to RM Database
  175. Question with respect to Changing a Master Source to a Different Source Template
  176. Questions about RM4 Tables
  177. Quick Start for Dummies
  178. Rebuild Indexes and Update Birth and Death Years
  179. Rebuttal by Jeff La Marca
  180. Recursive Queries – Ancestors and Descendants
  181. Relationships
  182. REMATCH to FamilySearch ID in REFN fact
  183. Removing media from one person
  184. Reporting Missing Census Information
  185. ReportNon_proven
  186. Reports – Concordances for Indexes
  187. Reports – New Paragraph for General Note
  188. Reports – Point Form Narratives Setup
  189. Reports, Narrative, Jerry Bryan Trick
  190. RIN MRIN – add Reference Number fact to all persons
  191. RM Database Design
  192. RM Infrastructure to support FSFT
  193. RM4 To Do List
  194. RM5 Database System Catalog
  195. RM5 Table Summaries
  196. RM5 Version Monitoring
  197. RM6 Database System Catalog
  198. RM6 Version Monitoring
  199. RMGC Tables Row Count
  200. RMGC_Properties – Query
  201. RMNOCASE – faking it in SQLite Expert, command-line shell et al
  202. RMNOCASE – faking it in SQLiteSpy
  203. RMNOCASE – Nunicode Extension
  204. RMpi GEDCOM Pre-Import Tweaker for RootsMagic
  205. Role Types
  206. Roles-Sort Alphabetically
  207. RootsMagic 7
  208. Scope of Names in Queries and Sub-queries
  209. Scrapbook Files Status
  210. Search & Replace
  211. Search – Find Almost Everywhere
  212. Search – wayfinding from data tables to RootsMagic screens
  213. Set Living Flag
  214. Sharable Events – Find and Convert to Shared
  215. Shared Events – Sort Witnesses by Consanguinity plus Name
  216. Shared Events With Missing Witnesses
  217. Site Page Popularity
  218. Source Citation Sort
  219. Source Detail View (Parsing XML)
  220. Source List Query
  221. Source Template List – Query
  222. Source Template, A Better Free Form
  223. Source Templates
  224. Source Templates – Convert Builtins to Editable, Split, Import
  225. Source Templates – Field Count
  226. Source Templates – Merge Duplicates
  227. Source Templates – Revision Utilities
  228. Source Templates – Set Quotation Punctuation to ‘UK’ or ‘Logical’ Placement
  229. Source Templates – Versatile Free Form Hybrids
  230. Source Templates by Origin
  231. Sources – Adventures in Extreme Splitting
  232. Sources – Copy Repository Name, Address from Repository List
  233. Sources – Merge Duplicate Masters
  234. Sources – Unreverse Author Names
  235. SplitTree
  236. Spouse Order – Global Sort by Marriage or First-Birth SortDate
  237. SpouseID Invalid
  238. SQLite Expert Personal Edition Version 5.2.2.240 (x64) problem
  239. SQLite Managers for Mac OS
  240. SQLite Queries
  241. SQLite Question – SELECT WHERE IN
  242. SQLiteManagers
  243. Statistics
  244. Submit Your Problem
  245. Table Summaries
  246. TestPaste
  247. Thanks for your help!
  248. TMG to RootsMagic Migration
  249. TMG-RM Check for False Spousal Event Sentences
  250. TMG-RM Convert TMG_ID to Record Number
  251. TMG-RM Convert TMG_ID to Reference Number
  252. TMG-RM Fact Sentence Tweaks
  253. TMG-RootsMagic Sentence Variables & Format Codes
  254. TMG-RootsMagic Split Citation Details
  255. To-Do List – filter by locale
  256. Tools – Problem Search – Spouse Order Questioned
  257. TreeShare – Link Pasted Ancestry Sources
  258. TreeShare – Rename Cryptic Filenames for Citation Media
  259. Update Media Paths
  260. Utilities by R. Steven Turley
  261. Version Monitoring
  262. WebTags – Consolidate
  263. WebTags – convert to Notes et al
  264. WebTags – from Ancestry.com and FTM
  265. WebTrees Website – Pre-Processing Tools using SQLite in Visual Basic et al
  266. Where is the data stashed
  267. Where is this data?
  268. Which Platform for RootsMagic Utilities?
  269. Wish List

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.