I have just developed a SQLite script to improve the resulting sentence templates. It includes the [PlaceDetails] addition and suppression of double prepositions for Date, Place and PlaceDetails. See http://sqlitetoolsforrootsmagic.wikispaces.com/TMG-RM+Fact+Sentence+Tweaks Another recent one not listed in the Sep 24 message below moves the Note value for a fact/event to its Description field, if that field is enabled. See http://sqlitetoolsforrootsmagic.wikispaces.com/Events+-+Move+Short+Note+to+Description Tom On Wed, Sep 24, 2014 at 10:04 AM, Tom Holden <ve3meo@gmail.com> wrote: > One of the virtues of RootsMagic is its readily accessible database. I > have been developing SQLite queries that can be run against it post-import > to affect some things not handled by the import. They demonstrate what > benefit (or complication) might be achieved were a similar process > incorporated in the import while leaving it to the user to decide which > outcome is better. Currently available are: > - Help finding sentences and notes having extant TMG variables and > formatting codes > - Support for split Citation Detail > - Map the TMG_ID (the person number familiar to you in TMG) to a Reference > Number fact for optional display after the name > - Replace the RootsMagic RIN with the TMG_ID number > Coming, I think, will be: > - Help finding sentences for individual events that contain variables for > couple events, e.g., [spouse] > - Add [PlaceDetails] variable to sentences constructed from TMG [L] > variable > - Modify [Date] variable to [Date:Plain] in sentence templates if a > leading preposition is detected > > Developed queries can be found via this link: > http://sqlitetoolsforrootsmagic.wikispaces.com/space/content?tag=TMG > > Tom > > >