Jump to content


Places - batch streamlining in narrative reports

places reports narrative sqlite

  • Please log in to reply
1 reply to this topic

#1 TomH


    Advanced Member

  • Members
  • PipPipPip
  • 5633 posts

Posted 30 March 2013 - 09:04 PM

Without much customisation of event sentences, the default sentences for events and roles result in RootsMagic-generated narrative reports having overbearing repetition of full place names of the form city, county|shire, province|state, country. Ultimately, intense customisation must be done to give more variety and colour to narrative reports thus reducing the appearance of rote computer generation. For some, however, a utility I have developed may satisfy a basic need. It revises the database in a blink (or two) of the eye to use just the first name of the Place (i.e., city from the aforementioned full Place name) for all sentences for a person's events in a place save for the earliest occurrence which gets the full place name. The full description, an example, and the downloadable SQLite script are at Places - first name exploit for improved narratives.

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 Vyger


    Advanced Member

  • Members
  • PipPipPip
  • 2981 posts

Posted 31 March 2013 - 04:20 AM

Thank you TomH for continuing to provide such useful help utilities, these save so much time and effort.

Whilst some of these might highlight shortcomings within Rootsmagic there will always be a need for such utilities which will never be part of the program, IMHO.

Keep em coming

“The best preparation for tomorrow is doing your best today"


Current user of Rootsmagic version, Family Tree Maker 2014 and Legacy 7.5 on Win 10


Excel to Gedcom conversion - simple getting started tutorials here