Another tip to add is about place names in TMG. I have my fields in TMG customized to add "Twp." and "Co." when generating reports and in SS html. In RM this doesn't happen, so I will have to add Twp. and Co. to the actual place names in RM if I want them to print. For some it's probably not a big deal, but I have alot of farmers who didn't live in "towns" but rather townships so to see Kent Twp. Stephenson Co., IL is more meaningful than Kent, Stephenson, IL. Julei On Fri, Oct 3, 2014 at 10:02 AM, Barb M. via <tmg-refugees@rootsweb.com> wrote: > I would love to see tips to clean-up data. > > Here is my list - so far. > Please let me know if my assumptions are wrong. I’m just trying to figure > this all out, but it is a slow process. My Long List - is for importing to > RootsMagic. Who knows, as things change, I may end up somewhere else. > > ~ Barb > > Short List: > Create New Project without non-people > Get Rid of Roles I don’t use > Compare tags to other programs > Learn more > > > Long List: > 1. I used someone’s idea and made a new TMG Project. I did this by first > creating a new FLAG - and flagging all the people that I did not want to > import. I then created a list of people of everyone else - and used the > Option Feature: Secondary Output in TMG to create a new Project. This way, > I had my old TMG Project that I could continue to use for Second Site and > another Project to get ready to export to a new software program. In my new > Project, I did not include my Non-People, that I use for Second Site. I had > over 1000 non-people and it would have taken forever to delete them > individually. I had people for Cemeteries - people for Censuses, people for > Index-Research Names, etc… (Great suggestion - wish I could remember where > I got it from.) > > 2. Print off Show Role Usage list from TMG Utilities - and get rid of the > roles I don’t use - and make the necessary change to avoid using a role > only one or two times. (I will probably make similar changes in my old TMG > Project. Wish I would have realize before, that I could create this list > using TMG Utilities) > > 3. Skip Census Sources: I don’t have to make any changes in my census > sources that use split citations - because Tom Holden developed a SQLite > script for Roots Magic that deals with my split citations. I tested it out > and it worked great. Thanks Tom. He also developed a script to improve the > sentences - “it includes the [PlaceDetails] addition and suppression of > double prepositions for Date, Place, and PlaceDetails. I haven’t tested > this yet, but it is on my list of things to do. (Learning how to run > Scripts was a challenge, but fascinating on what the scripts will do. Need > to learn more about scripts.) > > 4. Compare my custom tags to RootsMagic. I used TMG Utilities to do this . > (Other - Export Data. Data to export: Sentences, Export format: HTML, > Stylesheet: Grid) I was able to open this file in Excel. With this > spreadsheet, I could easily compare the sentences to other programs. When I > looked at a Tag/Role/Fact in RootsMagic, I would copy and paste the RM role > into the spreadsheet - next to the one I imported. I also deleted from the > spreadsheet - all of the Roles/Sentences I wasn’t using (Role usage count > was from TMG Utilities) - and deleted all similar role/sentences - to get > down to a manageable spreadsheet. > > 5. Things I have learned about importing to RM. (Not sure, what kind of > adjustments I will make before importing.) > a. Witness facts are attached to witness - not P1. > b. It appears that RM adds parent witnesses to birth events, > whether they appear or not in TMG. (I believe you can turn off this option > in RM. I have tags that add the parents already - so I’m not sure if I’m > going to delete my tags or turn off this option in RM) > c. For the most part [M] is transferred to RM as [Desc] , but the > memo value is copied to the RM notes and the description field is left > blank. There are a few exceptions - such as Education and Occupation. > d. <[D]> transfers to RM okay, but adds “.” (period) > > 6. If you are headed to RM - then watch the Webinar - Cleaning Your Family > Tree in RootsMagic. Good ideas of what the program can do - and what you > don’t have to worry about in your import. > > > > On Oct 3, 2014, at 8:41 AM, Barbara Levergood via < > tmg-refugees@rootsweb.com> wrote: > > > > > > > Would the folks on this list find it helpful to start a list of tips for > data clean-up within TMG? If so, please share, and I will make a page for > it on the website. > > > > > > > > > > > > On 10/3/14, 8:10 AM, Barb M. via wrote: > > (I am now comparing my TMG sentences to what actually imports using RM > direct imports - and making some adjustments to my TMG sentences . And with > TMG Utilities - you can get a list of how many times you use each Role. I’m > amazed at how many times, I only use a role once. Time to start cleaning up > my data.) > >> > >> ~ Barb > >> > > *** > > To unsubscribe from the list, please send an email to > TMG-REFUGEES-request@rootsweb.com with the word 'unsubscribe' without the > quotes in the message subject and body. > > ------------------------------- > > To unsubscribe from the list, please send an email to > TMG-REFUGEES-request@rootsweb.com with the word 'unsubscribe' without the > quotes in the subject and the body of the message > > > *** > To unsubscribe from the list, please send an email to > TMG-REFUGEES-request@rootsweb.com with the word 'unsubscribe' without the > quotes in the message subject and body. > ------------------------------- > To unsubscribe from the list, please send an email to > TMG-REFUGEES-request@rootsweb.com with the word 'unsubscribe' without the > quotes in the subject and the body of the message >