2 replies to this topic

[Holly Kilpatrick]

Is there some view in RM, or some query in SQLite Expert where I can list Person, Facttype where the sentence for that Person/Facttype is a local customization?

 

I am cleaning up TMG data, and it seems like the direct import brings in all my Facttypes (Tags) and their sentence templates, and when the sentence has a local customization at the person level, the customization is there.  I am trying to find a way to identify those records with local customized sentences, without checking every one manually.

 

Thanks,

Holly

[TomH]

Have a look at http://sqlitetoolsfo...tsMagic screensand run script #1. Then examine the temp tables EventWay and WitnessWay. Any non-empty Sentence cell is a custom local sentence. The tables should give you enougb info to find the person and event in that database through the RM interface

[Holly Kilpatrick]

Tom, thank you so much, that was very helpful.  I was able to get a list with that script.  Haven't checked it yet, but it looks like all the expected culprits, so I think it is what I need.

 

Holly