Hi Jack - At 4/26/2017 15:30, Jack D. Lovelace wrote >There is a software program named "AniMap Plus", a County Boundry >Historical Atlas. It is a series of maps for each state by >year. By starting at the latest year and working back, you can see >boundary changes for a particular county. As I remember, it costs >about $30.00. > >With this program, if you are so inclined, you can add start and end >dates to the TMG Place database for a place in a county. I started to mention Ani-Map, but mostly it just tells the year (which may be when the legislature passed the law and not) when the actual creation took place (although even that is included for some). AniMap is pretty much useless as to what locations are in which county -- either before or after the county splits. I use the program often. But if won't tell if Clay City, KY is/was in Clark, Montgomery or Powell County. At the best, it can only tell when the county was formed/split and from there you must seek other resources. For that matter, Clay City may have originally been in Bourbon County with some settlers there before that -- in Fayette County. Lee

At 02:00 PM 4/26/2017, Ed Hotchkin wrote: >The errors that I can not find by looking at the list is the wrong >County for a location. I think that I have found most all of the typing errors. > >Can anyone tell me where I can find the Place Lists files in TMG and >can I remove them and run checks on them and then put them back in TMG? The trick is that they don't exist as a "place list"... Places are stored as a list of place ID place FieldLabel place Value so you end up with 1 1 detail 1 2 address 1 3 city etc. (and the FieldLabel is a lookup to where labels are defined, which specifies the order of the field labels)... Oh, and since only fields with provided data are stored, later adding some item to an existing place can result in the new field being at the end of the database. You basically have to do self joins to create a "place list": select d.val as Detail, a.val as Address, ci.val as City, co.val as County from xxxx_P as d join xxxx_P as a on d.ID = a.ID and d.FieldLabel = 1 and a.FieldLabel = 2 join xxxx_P as ci on d.ID = ci.ID and d.FieldLabel = 1 and ci.FieldLabel = 3 etc. Unfortunately, with the new drive and Win10/Office 2016 I seem to have lost the ability to open DBase/VFP tables in Access via ODBC. I think the place information is in the _P.dbf file. -- bieber.genealogy@earthlink.net Dennis Lee Bieber HTTP://home.earthlink.net/~bieber.genealogy/

At 4/26/2017 15:08, Michael J Hannah wrote >As I understand it, the Place List is a set of three Foxpro database >files (*_P.DBF, *_P.FPT, and *_P.CDX) with direct indexed links into >and out of those files to each other and with other project database files. Yes, the Master Place List in TMG is not a single file. TMG creates the Master Place list from about a _dozen_ files (P, PD, PPT, and PPV). These are very interconnected and depend on each other to properly work. If one is off, TMG may not be able to properly create the Master Place List. Lee

At 4/26/2017 14:00, Ed Hotchkin wrote >The errors that I can not find by looking at the list is the wrong >County for a location. I think that I have found most all of the typing errors. Basically a good atlas will help for most of this, as will just looking up the location in Google Earth/Google Maps other some other site. The hard part is when a location was in one county and then "moved" to another county when the original county was split/re-named. I have some people that lived all their lives in one location, but were in five different counties over time. You can use the Start Year (SY) and End Year (EY) fields in the Master Place List to help control these. Using this will make it appear that Jones City is in multiple counties in the Picklist, but the Master Place List will help plus picking the wrong one will make TMG remind yor that a different entry should be selected for the use. >Can anyone tell me where I can find the Place Lists files in TMG and >can I remove them and run checks on them and then put them back in TMG? I can tell you what the file structure is for TMG. I have it basically described at <http://www.tmgtips.com/dbnames2.htm>. This is primarily for TMG v7 and earlier. But the basics still hold. Having said this, I strongly recommend that you make changes to places either in TMG and the Master Place List or using the TMG Utility. The thing is that there are some 80 files to a project and most are very tightly interconnected with each other.. So, making changes to project files outside of TMG can really mess up your project and could make it completely unuseable. Lee

You have a couple of suggestions, but one which I very much like is SecondSite. I add a user item of Places and find it gives a good visual indication of some anomalies. I am not sure what errors you are looking for but this will quickly show places not in their correct hierarchy and if you have multiple versions of the same place etc. Just another tool to consider. Of course you may well know the errors and just looking for the easiest way to correct them, SecondSite wont help you there. Regards Graeme Simpson >It seems that I once had a piece of software to check the Master Place >List. I have thousands of Place Locations in it and I must have created >many errors over the years that I would like to correct. I am using TMG >9.05 on a 64 bit computer with Win 10 installed. > >Ed Hotchkin\ --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

Ed Hotchkin asked: > The errors that I can not find by looking at the list > is the wrong County for a location... > Can anyone tell me where I can find the Place Lists files > in TMG and can I remove them and run checks on them > and then put them back in TMG? Ed, As I understand it, the Place List is a set of three Foxpro database files (*_P.DBF, *_P.FPT, and *_P.CDX) with direct indexed links into and out of those files to each other and with other project database files. But I would *not* recommend "messing" with the innards of such files. Have you looked at the TMG report "List of Places"? As part of that Report Definition you can output "All Places", and choose any or all of the Place fields to output up to nine fields. I know there are potential of fourteen Place fields if you include the Short Place, Start/End Year and Comment fields, but most of us do not actually use all of them. However if you really need all fourteen you could run two reports with enough common fields to have a common sort, where the columns of the two reports could be combined afterwards. While this report can be sorted however you wish, for your purposes I would probably choose a sort order and output the report as either Microsoft Excel (XLS), or Comma Separated Value (CSV) for input to a Spreadsheet program. Such a program would make it easy to combine columns from two reports as described above if that is necessary. In that program the first thing I would do is add a column that numbered the rows in their original sort order. That will let you resort the rows in the spreadsheet however needed to make whatever changes required. When done, simply resort back in the original order using the added numbered column. Now you can open the TMG Master Place List and make the corresponding row-by-row changes in TMG. Run an Optimize on the project and the Master Place List will be resorted and any entries which are now exact duplicates will be merged. To make the TMG update easier, I suggest changing the background color of the added row number cell as I made any changes to that row so it would be easy to tell which spreadsheet rows had changed. Only those corresponding rows will need changing in TMG. Hope this gives you ideas, Michael

There is a software program named "AniMap Plus", a County Boundry Historical Atlas. It is a series of maps for each state by year. By starting at the latest year and working back, you can see boundary changes for a particular county. As I remember, it costs about $30.00. With this program, if you are so inclined, you can add start and end dates to the TMG Place database for a place in a county. On 4/26/2017 12:12 PM, Lee Hoffman/KY wrote: > Basically a good atlas will help for most of this, as will just looking > up the location in Google Earth/Google Maps other some other site. The > hard part is when a location was in one county and then "moved" to > another county when the original county was split/re-named. -- Jack D. Lovelace

Some of those can be found by having the Master Place list sort first by town, then by state, then by county. Duplicate towns in the same state may show different counties.....this assumes that you have at least one entry for each town with the correct county. That said, as I mentioned before, there are towns that changed counties over time, so to check that a county is actually incorrect you may have to go to the entries for the questionable county to see what the source was and then check that source entry to verify the county at that time. Dave Ball -----Original Message----- From: TMG [mailto:tmg-bounces+dgballtmg=shaw.ca@rootsweb.com] On Behalf Of Ed Hotchkin Sent: Wednesday, April 26, 2017 10:41 AM To: The Master Genealogist Rootsweb Email List Subject: Re: [TMG] Checking Master Place List The errors that I can not find by looking at the list is the wrong County for a location. I think that I have found most all of the typing errors.

The errors that I can not find by looking at the list is the wrong County for a location. I think that I have found most all of the typing errors. Can anyone tell me where I can find the Place Lists files in TMG and can I remove them and run checks on them and then put them back in TMG? On 4/26/2017 10:41 AM, Ed Hotchkin wrote: > The errors that I can not find by looking at the list is the wrong > County for a location. I think that I have found most all of the > typing errors. > -- Ed Hotchkin hotchkinfamilyhistory.com

The errors that I can not find by looking at the list is the wrong County for a location. I think that I have found most all of the typing errors. On 4/25/2017 8:41 PM, Graeme Simpson wrote: > You have a couple of suggestions, but one which I very much like is > SecondSite. > > I add a user item of Places and find it gives a good visual indication > of some anomalies. I am not sure what errors you are looking for but > this will quickly show places not in their correct hierarchy and if > you have multiple versions of the same place etc. > > Just another tool to consider. > > Of course you may well know the errors and just looking for the > easiest way to correct them, SecondSite wont help you there. > > Regards > Graeme Simpson > > >> It seems that I once had a piece of software to check the Master Place >> List. I have thousands of Place Locations in it and I must have created >> many errors over the years that I would like to correct. I am using TMG >> 9.05 on a 64 bit computer with Win 10 installed. >> >> Ed Hotchkin\ > > > --- > This email has been checked for viruses by Avast antivirus software. > https://www.avast.com/antivirus > > The TMG archive is found here: > http://archiver.rootsweb.ancestry.com/th/index/TMG/ > Instructions on how to subscribe to TMG: > http://lists.rootsweb.ancestry.com/index/other/Software/TMG.html > ------------------------------- > To unsubscribe from the list, please send an email to > TMG-request@rootsweb.com with the word 'unsubscribe' without the > quotes in the subject and the body of the message -- Ed Hotchkin hotchkinfamilyhistory.com

I have used Map My Family Tree by Progeny Software. It reads the TMG Master Place List file and maps them. It produces a list of all places it considers to be errors. It's file is out of date and it is far from perfect but I still find it very useful to look for errors. I do not use it for the maps. Back when I first acquired it it was free. Now they sell it. Gary Kueber On 4/25/2017 5:14 PM, Ed Hotchkin wrote: > It seems that I once had a piece of software to check the Master Place > List. I have thousands of Place Locations in it and I must have > created many errors over the years that I would like to correct. I am > using TMG 9.05 on a 64 bit computer with Win 10 installed. > >

At 4/25/2017 18:14, Ed Hotchkin wrote >It seems that I once had a piece of software to check the Master >Place List. I have thousands of Place Locations in it and I must >have created many errors over the years that I would like to >correct. I am using TMG 9.05 on a 64 bit computer with Win 10 installed. The only program designed to work with TMG projects other than TMG (and its Master Place List functions as David suggests) is John Cardinal's TMG Utility. It may not be what you are looking for however. It is best used for making multiple and global changes. For example, you may have entered some states with their full names and some as abbreviated. On the other hand, while TMG Utility can correct many of the minor typos and other simple errors, those usually tend to be only one or two errors rather than many. The TMG Utility can be overkill and even awkward for these. I would suggest reviewing the Master Place List to see what kinds of errors/inconsistencies you have. Make note of the global types errors and correct them with TMG Utility. Then fix the odd errors within TMG's Master Place List. This is something that I need to do with my main project. I have over 8000 places and I expect that I have a few hundred errors that need corrected. Unfortunately most of these will be in the category of minor typos. Still, it really won't take all that long and will go a lot faster that it might first appear. Lee

Ed, Maybe someone else has some faster techniques, but the basic steps are to open TMG and from the options across the top select "Tools" and then "Master Place List". TMG will take a while to organize the list by your default priority settings. You can then go to the right side of that screen and click on "Sort" to choose how you want to see the list organized. What I periodically do is to do various different sorts to help spot something out of whack. Such as to sort by city, then county, then state to find cities displayed with either the county or the state wrong. Note that some towns do switch county affiliations over time, so when I find something that looks odd, I click on the "Events" button to see if maybe the difference only occurred in a census or in a graveyard listing. There are very small errors that are tough to spot, like period vs no period for the abbreviation "Co." or one letter missing in the spelling of an entry, but the clue is usually two seemingly identical entries, when there only should be one in the master list.....by that I mean the same in every column. Choosing different combinations of priority in sorting columns can often highlight errors even when you have a long list of places (my list has over 1,000 different) Not a quick process, but can be interesting. I do like the RootsWeb town/county look up at http://resources.rootsweb.ancestry.com/cgi-bin/townco.cgi to check county names. Enter some starting letters of the town and the 2 letter state abbreviation, hit "submit", and matching towns and their counties will show. The town/county pairing are as currently existing, not historical when those pairings may have been different, but still a great help. Dave Ball -----Original Message----- From: TMG [mailto:tmg-bounces+dgballtmg=shaw.ca@rootsweb.com] On Behalf Of Ed Hotchkin Sent: Tuesday, April 25, 2017 3:15 PM To: The Master Genealogist Rootsweb Email List Subject: [TMG] Checking Master Place List It seems that I once had a piece of software to check the Master Place List. I have thousands of Place Locations in it and I must have created many errors over the years that I would like to correct. I am using TMG 9.05 on a 64 bit computer with Win 10 installed. -- Ed Hotchkin hotchkinfamilyhistory.com

It seems that I once had a piece of software to check the Master Place List. I have thousands of Place Locations in it and I must have created many errors over the years that I would like to correct. I am using TMG 9.05 on a 64 bit computer with Win 10 installed. -- Ed Hotchkin hotchkinfamilyhistory.com

Thanks Lee, I’ll give this a go! Robin in Short Pump > On Apr 20, 2017, at 3:32 PM, Lee Hoffman/KY <azchief@bellsouth.net> wrote: > > At 4/20/2017 14:57, Robin Kaspar wrote >> I successfully used a report to create a flag. Yay, me. > > Uhh - I think you mean that you used the report to _set_ a Custom Flag that you had created. > >> Now I need to create a report to find the people whose flag is set to No and report on their names, ID #, death dates/places and burial places. If the people don’t have a death tag, I don’t want them on the report. If they don’t have a burial tag, that’s ok. (Specifically, I want to find people I need to search on Findagrave and I used the flag to set yes for those who have that source ID) I’m always confused about which is the best “list of” report to use for this. > > I think you want a filter like this in Project Explorer or a List of People report: > FLAGNAME =Equals N AND > # of Death Group Tags <> Does Not Equal 0 END > > Select the desired data columns in the [Options...] window Output Columns tab. > > Note that this looks at the Death Tag Group. So if you have created a Custom Tag in that group then you may want to do more filtering. In such a case, you might want to set another Custom Flag to change the setting on your present Flag to something else then run another filter using the List of Events report filtering for the new setting and the presence of the other Death Tag Group Tags and then reset the Flag. > > Lee > > > The TMG archive is found here: http://archiver.rootsweb.ancestry.com/th/index/TMG/ > Instructions on how to subscribe to TMG: http://lists.rootsweb.ancestry.com/index/other/Software/TMG.html > ------------------------------- > To unsubscribe from the list, please send an email to TMG-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message

At 02:23 PM 4/20/2017, Sue and Nick Dugo wrote: >I use TMGv9 on my PC, but I also have it installed on my Laptop. In >preparation to try to use the Laptop this summer at our cottage I wanted to >update the Projects on the Laptop. I did backups on the PC, copied the "update the Projects" implies you already have an (out-of-date) project of the same name on the laptop. >Every time I have tried it I get the message "Someone else is using the >select project and it is not possible to restore." No one else is using TMG >on my PC and nothing else is open on my laptop. Is there any possibility you have the project open in TMG when you attempt to do the restore? If so, close the project (maybe open the demo project). THEN try to restore. -- bieber.genealogy@earthlink.net Dennis Lee Bieber HTTP://home.earthlink.net/~bieber.genealogy/

At 4/20/2017 14:23, Sue and Nick Dugo wrote >I use TMGv9 on my PC, but I also have it installed on my Laptop. In >preparation to try to use the Laptop this summer at our cottage I wanted to >update the Projects on the Laptop. I did backups on the PC, copied the >backups to a thumb drive, copied the backups to the Backup folder under TMG9 >on my laptop and then tried to do a Restore to my laptop project. > >Every time I have tried it I get the message "Someone else is using the >select project and it is not possible to restore." No one else is using TMG >on my PC and nothing else is open on my laptop. In TMG, go to Help=>Access Folders=>Current project folder. Highlight that and click [Open]. Click [OK] on the Warning window. This will open File Explorer. Go back to TMG, [Close] the window and exit TMG. Back in File Explorer, make sure that the project files you are working with is displayed. Click on the Type colume header to sort the folder by the File Type. Scroll down to find the CDX Files for your project. The file name of the first file should end in "$" and the last will end in "XD". Highlight all these files, right-click and select Delete. Be sure only CDX files for your project are selected. Now open TMG and select the project. It should open and re-create the CDX files. Lee

At 4/20/2017 14:57, Robin Kaspar wrote >I successfully used a report to create a flag. Yay, me. Uhh - I think you mean that you used the report to _set_ a Custom Flag that you had created. >Now I need to create a report to find the people >whose flag is set to No and report on their >names, ID #, death dates/places and burial >places. If the people don’t have a death tag, >I don’t want them on the report. If they >don’t have a burial tag, that’s ok. >(Specifically, I want to find people I need to >search on Findagrave and I used the flag to set >yes for those who have that source ID) I’m >always confused about which is the best “list of” report to use for this. I think you want a filter like this in Project Explorer or a List of People report: FLAGNAME =Equals N AND # of Death Group Tags <> Does Not Equal 0 END Select the desired data columns in the [Options...] window Output Columns tab. Note that this looks at the Death Tag Group. So if you have created a Custom Tag in that group then you may want to do more filtering. In such a case, you might want to set another Custom Flag to change the setting on your present Flag to something else then run another filter using the List of Events report filtering for the new setting and the presence of the other Death Tag Group Tags and then reset the Flag. Lee

I successfully used a report to create a flag. Yay, me. Now I need to create a report to find the people whose flag is set to No and report on their names, ID #, death dates/places and burial places. If the people don’t have a death tag, I don’t want them on the report. If they don’t have a burial tag, that’s ok. (Specifically, I want to find people I need to search on Findagrave and I used the flag to set yes for those who have that source ID) I’m always confused about which is the best “list of” report to use for this. Robin in Short Pump

I use TMGv9 on my PC, but I also have it installed on my Laptop. In preparation to try to use the Laptop this summer at our cottage I wanted to update the Projects on the Laptop. I did backups on the PC, copied the backups to a thumb drive, copied the backups to the Backup folder under TMG9 on my laptop and then tried to do a Restore to my laptop project. Every time I have tried it I get the message "Someone else is using the select project and it is not possible to restore." No one else is using TMG on my PC and nothing else is open on my laptop. Susann --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus