Cleaning up imported data

[Vicki 0]

I have been using John Cardinal's utility program to movedaddress data that was 'dumped' into the country field when I imported from FH years ago. The utility program works great!

 

As I review the log generated, I need to determine if the 'Frederick Co VA' currently in the country field is the city or county of Frederick. I open the ID # listed on the log, but there is no record of the city, county, state data. Or am I looking in the wrong place? I have not tried to add an address tag as it was much too late last night to begin a new thought process. I am assuming that I will need to add an address tag to all those entered in my old program.

 

Does anyone have a clue on how to manage my dilemna? I did try the address filter option, but nothing was selected, which leads me to believe I will create address tags for all but those entered since using TMG.

 

Vicki

[Jim Byram 0]

I would suggest looking at an appropriate individual in TMG.

 

First, optimize your project to clean up the Master Place List.

File / Maintenance / Optimize

 

You can open the Master Place List and select a place in question and then use the [Events] button to get a list of events linked to that place. From this list, you can edit an event or navigate to a person with the event. This is an easy way to work through all events linked to one place. Or you can edit the place in the Master Place list once you see an event that is is linked to.

 

Occasionally, you actually need to look at your data in TMG to get some perspective on modifying the data outside of TMG.

[Bob R. 0]

sometimes you may need to step outside the box I googled frederick va and frederick co va ... my conclusion it's Frederick County VA www.co.frederick.va.us

[Vicki 0]

I would suggest looking at an appropriate individual in TMG.

 

First, optimize your project to clean up the Master Place List.

File / Maintenance / Optimize

 

You can open the Master Place List and select a place in question and then use the [Events] button to get a list of events linked to that place. From this list, you can edit an event or navigate to a person with the event. This is an easy way to work through all events linked to one place. Or you can edit the place in the Master Place list once you see an event that is is linked to.

 

Occasionally, you actually need to look at your data in TMG to get some perspective on modifying the data outside of TMG.

 

 

Thank you. I will try the Optimize option, and hopefully it will work for me. My problem (one anyway) is just finding a big block of time to work with the program.

 

Vicki

[Vicki 0]

I would suggest looking at an appropriate individual in TMG.

 

First, optimize your project to clean up the Master Place List.

File / Maintenance / Optimize

 

You can open the Master Place List and select a place in question and then use the [Events] button to get a list of events linked to that place. From this list, you can edit an event or navigate to a person with the event. This is an easy way to work through all events linked to one place. Or you can edit the place in the Master Place list once you see an event that is is linked to.

 

Occasionally, you actually need to look at your data in TMG to get some perspective on modifying the data outside of TMG.

Thank you for suggesting I look outside the box. I have not been able to work with my database for an extended period of time, which makes getting my thoughts etc., organized and implemented.

 

Vicki

[John Cardinal 0]

As I review the log generated, I need to determine if the 'Frederick Co VA' currently in the country field is the city or county of Frederick. I open the ID # listed on the log, but there is no record of the city, county, state data. Or am I looking in the wrong place?

The record numbers are place record numbers, an internal number used by TMG but not usually visible to end-users. I include them in the log because they are the only unique identifier for place records. There are circumstances where it would be helpful to have the record numbers, but probably only for me, and not for TMG Utility users.

 

You can use the Master Place List in TMG to browse through place records and from there you can find the events that use those records.

 

I have not tried to add an address tag as it was much too late last night to begin a new thought process. I am assuming that I will need to add an address tag to all those entered in my old program.

There is no requirement to add Address tags. You might want to add Address tags if you keep contact information for living people in your TMG project. There are probably other uses for the Adress tag, but that's the main one as far as I know. For other places, such as the location of a BMDB event, the place is entered via the event. So, for example, when you enter a Birth tag, you can enter the place where the birth occurred. In real life, an "address" isn't an event in the same way that a birth, marriage, or death is an event, and so I suspect that typical TMG users don't have many Address events in their projects.

 

I hope this makes sense...

[Vicki 0]

sometimes you may need to step outside the box I googled frederick va and frederick co va ... my conclusion it's Frederick County VA www.co.frederick.va.us

 

Thank you Bob! Yes, now that I have reviewed the log from John's utility program, it is clear (not crystal) on how I should continue moving the city, county, state into the appropriate fields from the country field. When I first began entering data into Family History many years ago, the only consistency was my inconsistency.

 

Vicki

[Vicki 0]

As I review the log generated, I need to determine if the 'Frederick Co VA' currently in the country field is the city or county of Frederick. I open the ID # listed on the log, but there is no record of the city, county, state data. Or am I looking in the wrong place?

The record numbers are place record numbers, an internal number used by TMG but not usually visible to end-users. I include them in the log because they are the only unique identifier for place records. There are circumstances where it would be helpful to have the record numbers, but probably only for me, and not for TMG Utility users.

 

You can use the Master Place List in TMG to browse through place records and from there you can find the events that use those records.

 

I have not tried to add an address tag as it was much too late last night to begin a new thought process. I am assuming that I will need to add an address tag to all those entered in my old program.

There is no requirement to add Address tags. You might want to add Address tags if you keep contact information for living people in your TMG project. There are probably other uses for the Adress tag, but that's the main one as far as I know. For other places, such as the location of a BMDB event, the place is entered via the event. So, for example, when you enter a Birth tag, you can enter the place where the birth occurred. In real life, an "address" isn't an event in the same way that a birth, marriage, or death is an event, and so I suspect that typical TMG users don't have many Address events in their projects.

 

I hope this makes sense...

 

John,

 

Yes it all makes sense now. Especially now that I know what the number on the log represents.

 

Thank you for taking the time to respond.

 

Vicki