Applying for Membership

Be sure to confirm your email address (respond to the email requesting you to do so) else you will not receive notification that your application has been accepted nor receive notices from the wiki. You may need to set your spam filter to trust messages from

Latest Pages

2016-02-12 Statistics added. A start; reports the male and female having the maximum children total with all spouses.
2016-02-07 Media - Bulk Rename and Relink added. Converts structured media filenames to another structure and relinks them.
2016-02-04 Language other than English added. Demonstrates current limitations, working in French.
2016-02-01 Reports - Point Form Narratives Setup added. Makes the Narrative format less verbose, easier to scan.
2016-01-29 Maps - markers proportional to number of events added
2016-01-21 Relationships fast Kinship List added
2016-01-17 Facts - Split Shared to Individual edited: added version without RIN displayed
2016-01-16 RIN MRIN - add Reference Number fact to all persons added
2016-01-10 Spouse Order - Global Sort by Marriage or First-Birth SortDate added
2016-01-08 Source Citation Sort added
2016-01-07 Roles - Sort Alphabetically added
2015-12-31 Nickname Manipulations added
2015-12-19 Citations Invisible - Reveal and Revert added (of interest to migrants from FTM)
2015-11-24 Recursive Queries - Ancestors and Descendants rev (gender filter for genetic lines)
2015-10-18 Children - Set Lineage to Birth added (so RootsMagic ancestor reports follow birth lines)
2015-03-30 TMG to RootsMagic Migration added (index and summary of useful pages for the TMG emigre)
2015-02-16 Marriages, Length of added (answers how long each marriage lasted)
2015-01-25 Living Flag - Set Globally added (can correctly set/clear living flag without Death fact in most cases)
2015-01-23 Children - Needing Manual Arranging added (lists families in which one or more children lack Birth or Christen facts)
2015-01-22 Children - Set Order by Birth SortDate added (batch sorting of children in birth order)
2015-01-21 Places - Conversion of Place Details to Places added (for when you need to export to other software)
2015-01-05 SQLite Managers for Mac OS added

Earlier queries

Welcome to SQLite Tools for RootsMagic!

This wiki style site is intended to enhance our use of RootsMagic 4 and above with queries and reports not provided from within the program. RootsMagic 4, 5 and 6 use SQLite 3 as their database engine so the .rmgc database files each creates are readable using third party SQLite management and development tools.

We explore collaboratively the RootsMagic 4+ databases with some of these SQLite managers and develop SQL queries that attempt to answer questions that cannot be answered or are difficult to answer using the RM application. Become a Member with full privileges to create and edit pages, discuss them, upload files, and help make our wiki better! Be sure to confirm your email address when applying to join else you will not receive notice of approval or other messages from the wiki.

The site has features, such as file storage, essential to such development and not available from the RootsMagic Forums. All other RootsMagic topics should continue there.

RootsMagic SQL Queries

How to Query RootsMagic - Experiences of novice users and an example using SQLiteSpy to do a database integrity check.
RM SQLite Queries - Plunge right in, if you have an idea of what you are doing.
Problem Queries - Post your problem for discussion.
SQLite Managers - Choose from one of these tools to run your queries.
MS Access - Or connect to your database with Access and Excel for great looking reports.
Open Office - Use the same ODBC driver as described for MS Access to connect OpenOffice to a RM database. Not recommended!

Find Pages by Tag

  1. Ahnentafel
  2. FTS()
  3. Notes
  4. RIN
  5. TMG
  6. admin
  7. alternate names
  8. ancestors
  10. application
  11. backup
  12. batch
  13. birth
  14. blanks
  15. blob fields
  16. broken
  17. census
  18. charts
  19. child
  20. citations
  21. color coding
  22. compare
  23. config
  24. conversion
  25. county
  26. crystal reports
  27. custom
  28. data definitions
  29. database
  30. database properties
  31. date
  32. death
  33. delete
  34. descendants
  35. developer
  36. duplicates
  37. editable
  38. events
  39. fact types
  40. family
  41. file types
  42. filenames
  43. ftm2012
  44. ftm2014
  45. gedcom
  46. geo-coding
  47. google maps
  48. index
  49. integrity
  50. links
  51. living
  52. marriage
  53. media
  54. merge
  55. metadata
  56. mrin
  57. ms access
  58. ms excel
  59. multimediatable
  60. named group
  61. names
  62. odbc
  63. paragraphing
  64. pdf generator
  65. person
  66. phantom
  67. place details
  68. places
  69. pragma
  70. rar
  71. recursive
  72. refno
  73. relationships
  74. replace
  75. reports
  76. request for help
  77. rmnocase
  78. roles
  79. search
  80. shared event
  81. sortdate
  82. source templates
  83. sources
  84. speed
  85. split tree ancestors leaves
  86. spouse
  87. sql
  88. sqlite expert
  89. sqlite managers
  90. sqlitespy
  91. sub-queries
  92. tasks
  93. to do list
  94. tools
  95. update
  96. visual basic
  97. visual c#
  98. webtags
  99. webtrees
  100. xml

External Resources

Torture Files
Management Tools

Users Mailing List

PoorSQL formatter

The PoorSQL formatter does a pretty good job of cleaning up scripts to make them more readable but is written for T-SQL so does not support SQLite SQL fully. It puts a space between double character operators such as <<, >>, ==; these can be readily searched and replaced in a text editor such as PSPad.

Thank you, Donors!

Our Wikispace subscription is paid up to Nov 2016. Fundraising for 2014 for the new charges on our Wikispaces subscription has paid for two years and is now closed until October 2016. Full report at Support SQLite Tools for RootsMagic wiki.