An unfortunate set of circumstances caused me to lose my C-drive. Fortunately I do have backups of my data. I also have a DVD with TMG 9 and my registration information. I believe that I heard that somewhere in the community there exists the files to upgrade to 9.03. If they exist could some kind soul please point me to them? Thanks, Jim Campbell

John, I think that the Copy process is the safest. No matter what you do, you will still have to manually delete the second data set. The Merge process does not do that, contrary to what one might expect. Sorry about the wrong URL for my article - that was a copy and paste mistake on my part. Terry > On 11/24/2017 6:12 PM, Terry Reigel wrote: >> >> There is a detailed article about merging data sets on my website, at >> http://tmg.reigelridge.com/tmg/merging.htm#datasets >> >> Your other option is to Copy or Move everyone to the main data set, >> then delete the second data set. That is described in my article at >> http://tmg.reigelridge.com/copy-move.htm >> >> Terry Reigel >> 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 >> [email protected] with the word 'unsubscribe' without the >> quotes in the subject and the body of the message > > Thanks Lee and Terry. I haven't tried either approach just yet but  > both merge or copy appear straightforward.  Is one to be preferred > over the other? > > Terry the link http://tmg.reigelridge.com/tmg/merging.htm#datasets > doesn't work but, I found the info about merging at > http://tmg.reigelridge.com/tmg/merging.htm. > > John Wood > >

L.S. No longer a problem. It turned out that Bitdefender had blocked TMG while it tried to work in a protected map (Documents!). First time ever. Thanks in advance Harm

After I have downloaded the latest version of Windows 10, I get a strange message: File Access is denied C\users\harm\documents\the master genealogist v9\logs\registercontrol.log This is a 30 lines message. What has happened and what can I do to start TMG? This message comes on the screen while loading TMG and the serial-number is displayed! Then HALT. Harm 13-11-17, 23:29:36 > gcPathSystem32="C:\WINDOWS\SysWOW64\" 13-11-17, 23:29:36 > System32="C:\WINDOWS\system32\" 13-11-17, 23:29:36 >found "C:\WINDOWS\SysWOW64\cdintf400.dll" 13-11-17, 23:29:36 >found "C:\WINDOWS\system32\cdintf400.dll" 13-11-17, 23:29:36 > Registration some OCX & Dll. OS 13-11-17, 23:29:36 > Operating System - Windows 6.02 64 bit 13-11-17, 23:29:36 >-------------------------------------------------------------------------------- 13-11-17, 23:29:36 > Leadtools (images) 13-11-17, 23:29:36 >Test for "LTRVW14N". Error : "OLE error code 0x80040112: Klasse is niet gelicentieerd voor gebruik." 13-11-17, 23:29:36 2>LTRVW14N, C:\WINDOWS\system32\ was registered earlier. 13-11-17, 23:29:36 > 1 LTRVW14N.OCX, LEADRasterView.LEADRasterView.140 - PASS 13-11-17, 23:29:36 --------------------------------------------------------------------------------- 13-11-17, 23:29:36 > BBlist 13-11-17, 23:29:36 2>bblistViewV, C:\WINDOWS\system32\ was registered earlier. 13-11-17, 23:29:36 > 2 bblistViewV.ocx, bblistView.bbListView1Ctrl.2 - PASS 13-11-17, 23:29:36 --------------------------------------------------------------------------------- 13-11-17, 23:29:36 > DynaZip 13-11-17, 23:29:36 2>dzactx, C:\WINDOWS\system32\ was registered earlier. 13-11-17, 23:29:36 > 3 dzactx.dll, dzactxctrl.dzactxctrl.1 - PASS 13-11-17, 23:29:36 2>duzactx, C:\WINDOWS\system32\ was registered earlier. 13-11-17, 23:29:36 > 4 dUzactx.dll, duzactxctrl.duzactxctrl.1 - PASS 13-11-17, 23:29:36 --------------------------------------------------------------------------------- 13-11-17, 23:29:36 > Dialog 13-11-17, 23:29:36 >Test for "comdlg32". Error : "OLE error code 0x80040112: Klasse is niet gelicentieerd voor gebruik." 13-11-17, 23:29:36 2>comdlg32, C:\WINDOWS\system32\ was registered earlier. 13-11-17, 23:29:36 > 5 comdlg32.ocx, MSComDlg.CommonDialog.1 - PASS 13-11-17, 23:29:36 >-------------------------------------------------------------------------------- 13-11-17, 23:29:36 > Termometer 13-11-17, 23:29:36 2>MSCOMCTL, C:\WINDOWS\system32\ was registered earlier. 13-11-17, 23:29:36 > 6 MSCOMCTL MSComCtlLib.ProgCtrl.2 - PASS 13-11-17, 23:29:36 >-------------------------------------------------------------------------------- 13-11-17, 23:29:36 * Amyuni PDF Converter 13-11-17, 23:29:36 1) Location "C:\PROGRAM FILES (X86)\THE MASTER GENEALOGIST V9\PDF\" 13-11-17, 23:29:36 >Test for "CDINTF400". Error : "OLE error code 0x80040154: Klasse is niet geregistreerd." 13-11-17, 23:29:36 debug 2>found C:\WINDOWS\system32\CDINTF400.DLL 13-11-17, 23:29:36 1>Registration CDINTF400 13-11-17, 23:29:36 !>Unknown error during OCX registration! C:\WINDOWS\system32\CDINTF400.DLL 13-11-17, 23:29:36 > CDINTF400.DLL, CDINTFEX.CDINTFEX.4 - FAIL 13-11-17, 23:29:36 >--------------------------------------------------------------------------------

After I have downloaded the latest version of Windows 10, I get a strange message: File Access is denied C\users\harm\documents\the master genealogist v9\logs\registercontrol.log This is a 30 lines message. What has happened and what can I do to start TMG? This message comes on the screen while loading TMG and the serial-number is displayed! Then HALT. Harm

On 11/24/2017 4:30 PM, John and Lee Wood wrote: > I have a fairly large project that contains two data sets.  Set A, > contains 28.5 thousand people.  Set B contains fewer than 100 people. > I created data set B to explore a possible ancestry for a woman in > data set A. I'm now satisfied that the woman's ancestry as set forth > in data set B is correct and I would like to addher data set B > ancestry to her in data set A.  It appears that the only way to do > this is to merge the two data sets but, given the work I have done > over the years creating the 28.5 thousand people in data set A, I'm > reluctant to take the merge data sets step for fear of loosing > everything. > > I know I will have to back up my project before doing the merge but, > is there anything else I have to worry about?  I use a cloud backup > called Carbonite and I seem to remember warnings about cloud backups > and TMG. I'm using TMG 9.05 and Windows 7 64 bit professional. John, There is a detailed article about merging data sets on my website, at http://tmg.reigelridge.com/tmg/merging.htm#datasets Your other option is to Copy or Move everyone to the main data set, then delete the second data set. That is described in my article at http://tmg.reigelridge.com/copy-move.htm Terry Reigel

At 11/24/2017 16:30, John and Lee Wood wrote >I have a fairly large project that contains two >data sets. Set A, contains 28.5 thousand >people. Set B contains fewer than 100 >people. I created data set B to explore a >possible ancestry for a woman in data set A. I'm >now satisfied that the woman's ancestry as set >forth in data set B is correct and I would like >to addher data set B ancestry to her in data set >A. It appears that the only way to do this is >to merge the two data sets but, given the work I >have done over the years creating the 28.5 >thousand people in data set A, I'm reluctant to >take the merge data sets step for fear of >loosing everything. I know I will have to back >up my project before doing the merge but, is >there anything else I have to worry about? I >use a cloud backup called Carbonite and I seem >to remember warnings about cloud backups and >TMG. I'm using TMG 9.05 and Windows 7 64 bit professional. No TMG data folders should be included as part of the Carbonite cloud mapping. And when you create a TMG Backup, let it backup to the Backup folder in the TMG data folder (usually the User Directory (see the Data File Storage topic in TMG Help. After the TMG Backup SQZ file has been created, you may copy that file from the TMG Backup folder to a Carbonite protected folder or any external drive such as a thumbdrive.. As for the merging of date set B into data set A, you should not have any problems. I do this all the time. After the merge is complete, you will want to review data set A for persons that are now duplicates. You will want to merge each set of duplicates. After a duplicate set is merged, you will want to review the merged person and combine duplicate Tags. There is no merge Tag feature, so you will need to look at one Tag (call it Tag A)and add any "new" data to its duplicate (Tag B) and then delete Tag A. Be sure that you copy all data from Tag A to Tag B including Source Citations/Citation Details. Don't forget Witnesses. Keep in mind that both data sets have different Sources, Repositories, places, etc. So, you may want to do some cleanup in this area as well in data set A. Some of the Sources from data set B may be the same as data set A, so these can be merged. Similarly, Repositories. Once you have merge data sets, persons, Sources, Repositories, and combined Tags in the merged persons and all is OK, go to the Data Set Manager and delete data set B. I often find a few minor cleanup things for the next few days, but this pretty much completes the job.

I have a fairly large project that contains two data sets.  Set A, contains 28.5 thousand people.  Set B contains fewer than 100 people.  I created data set B to explore a possible ancestry for a woman in data set A. I'm now satisfied that the woman's ancestry as set forth in data set B is correct and I would like to addher data set B ancestry to her in data set A.  It appears that the only way to do this is to merge the two data sets but, given the work I have done over the years creating the 28.5 thousand people in data set A, I'm reluctant to take the merge data sets step for fear of loosing everything. I know I will have to back up my project before doing the merge but, is there anything else I have to worry about?  I use a cloud backup called Carbonite and I seem to remember warnings about cloud backups and TMG. I'm using TMG 9.05 and Windows 7 64 bit professional. Thanks, John Wood

At 10:18 AM 11/23/2017, Blah BlahBlah wrote: > Well, it's off-topic, but does anyone know what kind of database >and/or programs institutions like Ancestry or FamilySearch use to >manage the billions of names found in millions of records? I don't use those services, so I'm not familiar with how much data they track per person. Basic Name/BMDB/father/mother information doesn't require much (the only complication would be multiple marriages; and that's only because I think in TMG/UFT "marriage is an event" rather than most software where "marriage is a family") -- almost a single table would suffice. In "marriage is a family", the key data item is the "family" based on a pair of people A three generation web page (parents -> focus person/family -> children) is rather simple -- and last time I did have access to one of these web sites, that was about all one could see at a time. Following a chain of descent meant changing the focus and regenerating the web page. Pseudo-SQL Family(_ID_, title, spouse1ID, spouse2ID, date of marriage) Individual(_ID_, name, date of birth, date of death, date of burial, parentfamilyID) {expand "date of X" to include any other details for that event} select c.ID, c.name, s1.ID, s1.name, s1.DoB, ... , s2.ID, s2.name, s2.DoB, ... from Family join Individual as s1 on Family.spouse1ID = s1.ID join Individual as s2 on Family.spouse2ID = s2.ID join Individual as c on Family.ID = c.parentfamilyID where Family.ID = {focusfamilyID} gets child names and information for the "family"; getting the parents of the "family" would be another small SQL (or two -- spouse 1 and spouse 2) using the focus family to get the s1/s2 parentfamilyIDs, then following the new family spouseXID to get the names. -- [email protected] Dennis Lee Bieber HTTP://home.earthlink.net/~bieber.genealogy/

Hi, Wow, over a million. I'm jealous. Well, it's off-topic, but does anyone know what kind of database and/or programs institutions like Ancestry or FamilySearch use to manage the billions of names found in millions of records? Sam On Tue, Nov 21, 2017 at 11:06 AM, Erik Hov <[email protected]> wrote: > Yes ,it is the largest file in the project ,and I have 1.011.960 people in > the project. Since it takes time to search the name searchlist every time ,I > have TMG in two windows ,one with only the namelist ,and one with the other > info ,so I can easily go to the particular ID number. It saves much time > since I don`t have to wait for the namelist first. > > -----

Yes ,word 2013 takes doc files and can open them. The docx file or xlsx file is not an option to view among the output choices in my TMG 9.05`s list of people-report. Is it any possibility of adding xlsx and docx formats to the report listoutput in tmg 9? That would make a possibility of output to xlsx or docx. -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Michael J Hannah Sendt: 23. november 2017 00:41 Til: TMG-L submission address <[email protected]> Emne: Re: [TMG] 2Gb file limit For anyone following this thread, an important point. As Erik and I have discovered, there was a very important but subtle point to John Cardinal's advice earlier: > use a List of People (LoP) report.... > Configure the LoP to create a tab-delimited output file. On On the > Report Definition Screen, set "File type" to "Text (ASCII) Delimited > with Tab". Erik cannot have TMG create the Excel file directly since TMG uses as its Excel output the "old" style *.xls file type. That file type has a maximum of 64K lines, which is way too few for Erik. So creating a tab-delimited text file instead which has only a file-size limit is not only recommended, it is required. The new Excel with a larger max for its lines can then import this file containing many more than 64K lines. This intermediate format requirement via a tab-delimited text file for Excel import is similar to having to output to the intermediate format of *.rtf files and then import to the new Windows 10 version of Word. Michael 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 [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message

Erik Hov wrot: > Is it any possibility of adding xlsx and docx > formats to the report listoutput in tmg 9? That > would make a possibility of output to xlsx or > docx. Erik, Whether TMG supports xlsx or not doesn't matter. That's not the right format to use with the Set Person Field feature in TMG Utility. As described in my instructions, set "File type" to "Text (ASCII) Delimited with Tab". John

At 06:53 PM 11/22/2017, you wrote: >Yes ,word 2013 takes doc files and can open them. The docx file or xlsx file >is not an option to view among the output choices in my TMG 9.05`s list of >people-report. >Is it any possibility of adding xlsx and docx formats to the report >listoutput in tmg 9? That would make a possibility of output to xlsx or >docx. No... The various .*x formats of newer Office programs are zipped up packages of XML structured files. The older Office formats are custom binary formats. The only way to have TMG add those formats would be to have a new report writer... But it took years for Wholly Genes to replace the old report writer (as I recall that had still been a 16-bit module -- and was unusable on 64-bit OS). Since Wholly Genes is no longer producing software, this would appear to be something that will never happen. -- [email protected] Dennis Lee Bieber HTTP://home.earthlink.net/~bieber.genealogy/

Thanks for help with my "problem" on the list ,and to Michael for offering his help splitting!!. -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av John Cardinal Sendt: 22. november 2017 18:18 Til: TMG-L <[email protected]> Emne: Re: [TMG] 2Gb file limit Lee Hoffman wrote: > Of course, this makes it harder to automate plugging the ID# into the > Reference Field. John Cardinal may be able to suggest something that > would mitigate this problem using his TMG Utility. As Joyce mentioned, TMG Utility can be used to create a reference field value. The basic steps are to (1) create a data file with two columns: - ID of person - Value for reference field) ... and then (2) ask TMG Utility to use the data file to update your project via the "Set Person Field" feature. One way to make the data file is to use a List of People (LoP) report. You create a two-column list where both columns have the same value, the ID number. Configure the LoP to create a tab-delimited output file. On the Report Definition Screen, set "File type" to "Text (ASCII) Delimited with Tab". To make the second column values start with leading zeroes, you must edit the data file prior to using it with TMG Utility. One relatively easy way to do it is to open the data file in Excel or another spreadsheet program. Change the format of the second column to a number with a fixed-width. In Excel, you'd use a custom cell format of "000000000". Nine zeroes will handle IDs up to single-digit millions. To change the format of a column in Excel, right-click the column header and choose Format Cells. In the Format Cells window, change the Category to "Custom" and then key "000000000" in the "Type:" textbox. After you make that format change, save the file. Use "Save As" in Excel to make sure you save it as a tab-delimited file, which I think Excel calls "Text (Tab-delimited)".

Erik Hov commented: > Yes, word 2013 takes doc files and can open them. Yes, but there can be some problems, such as with tables. Just like Excel 2013 can take the smaller xls files. So for each there is a workaround alternate output to use (rtf and text tab-delimited). > The docx file or xlsx file is not an optionamong the output choices No, those are newer formats, and not available in TMG. > Is it any possibility of adding xlsx and docx formats No, because all support for TMG ended over three years ago on July 29, 2014. There are not going to be any further changes to TMG. As I noted privately, using John's recommendation of the intermediate text file type of tab-delimited instead of xls works just fine to create a file with more rows which the newer spreadsheet versions can handle. Michael

Lee and Joyce , The 001, 002, 003 etc is OK ,but I am not sure about numbers in reference field. It is right you can find someone with the reference numbers after splitting the large project ,but if I have 17 different projects ,those reference-numbers will not be "all in one" ,so you will not be able to find every number you look for..... If it is possible to someway make reference numbers for each person with their IDs example 0000001, 0000002 etc it could be used for references ,but if that may cause total corruption ,I don`t know. (by the way ,do you have to input reference numbers manually?) I don`t want to corrupt my database more either ,so must find a good way of dealing with both the editing as well as the splitting. Lee , The maintenance mostly don`t add new people ,just editing on existing ones or finding duplicates ,and maybe added one person if I deleted one. I will try in the large project I have ,but I will follow the cdx size and I am taking backups each day now ,storing them on my computer and then transferring them to an external harddisk. (I wrote: ">also have some records to go through from TMG 4 and get them into TMG 9 >which includes......editing certain special letters after gedcom import >,children out of wedlock ,adopted ,stillbirths ,twins/triplets etc >,editing addresses ,burials.") No ,this hopefully will not add any more people ,just adjustments on their tags etc. But after doing a split ,then I guess several of those projects would have some of the same people because they also are related to others of my ancestors. So if I decided to enter more people to a known family in one project that I hadn`t entered children for before ,and I also have the same family in another project also without children.....then I had to enter the same children in each project these families were in?. if so ,that would mean I can`t add any more people to the projects even if it is room for many more? Yes ,it seems I have to split somehow ,and soon ,and I have thought splitting in first in 1 down to 2 x greatgrandparents and then 16 for each greatgreat grandparent. Where the split occurs also of course decide how many people the new projects will get. I think 16 would be OK.....32 would be a bit too many..... Think I might continue to edit from the old genealogyprograms and keep watching the cdx file size and of course taking backups daily (I have 127 backups of that large project from TMG 9). Would be nice knowing when and how to split the project though ,and any suggestions on reference numbers ,and if it is an easy way to do editing after splitting without having to switch between all the new projects!. If it is any way of automatically give each person a reference number without corrupting the project more ,and then split it ,maybe it could be possible to make a list of people/reference from each project with ID numbers and project names with output to excel ,and then collect all of them in one excel document?? That way it should be possible to know which project that has each number?..... Erik -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Joyce Sendt: 22. november 2017 15:43 Til: 'The Master Genealogist Rootsweb Email List' <[email protected]> Emne: Re: [TMG] 2Gb file limit Yes, it would be much easier to do editing of the current project knowing who needs maintenance than trying to "re-find" those persons in split-out projects. From what you say, much of this will likely give you some added wiggle room IF the maintenance doesn't add any more than you take away. I usually find that in this kind of maintenance that for each person deleted (usually through merging of duplicates) I wind up adding one or to persons. If that holds for you, the prognosis is not that good as it would soon get you closer to disaster. Still, I think I would try it. But, I would create Backups often so that I could get back to a "safe" place if corruption begins. >also have some records to go through from TMG 4 and get them into TMG 9 >which includes......editing certain special letters after gedcom import >,children out of wedlock ,adopted ,stillbirths ,twins/triplets etc >,editing addresses ,burials. If this involves adding new persons -- particularly new name records then I'd wait until I had split the project. This might well make it harder to process in that you'd have to bring them into v9 and then split them out to the new split projects. But that would be better than losing it all. >Anyway ,I agree that it is much better to split the project I have in >16+1 different projects than having all in one with over a million people. >But first ,I have to know what to do with that "editing problem"....!!. >Should I keep on with editing in the large project which is the easiest >or split up and letting it be harder to edit the ones I want to edit? Of course, you know your data much better than I, but I think I would try splitting into fewer projects. I usually advocate a single project rather than multiple projects as it _is_ much easier to maintain and there are no duplicates to maintain. But, when faced with a limit as in your case, it really is not a choice except where the split occurs. Splitting into fewer subsets _usually_ requires fewer duplicates. It also makes working on the new projects to be much closer in feel to that of the current single project. On the other hand, if there are fewer inter-marriages/interactions between families in more project, then the 16+1 may be the way to go. I like the idea of the one umbrella project leading to the other 16 (or however many subset) projects. At this point, I think all we can do is make suggestions as we don't really know your data. But, as I noted above, the one thing that is paramount is to make backup often. And good luck! Lee Joyce has a good idea here and also a good warning about how numbers are treated in the Reference field as opposed to how numbers are normally treated. You can get textual numbers sorted in the proper sequence IF all numbers have the same number of characters. You would do this by adding zeros prefixing the numbers -- like 001, 011, 012, 002, 021, 023, 003, etc. This would allow sorting to be normal. Of course, this makes it harder to automate plugging the ID# into the Reference Field. John Cardinal may be able to suggest something that would mitigate this problem using his TMG Utility. Lee Erik, You might consider using the Reference field to store each person's ID numbers. The Reference field is searchable using TMG's Search function (from the menu: Edit / Find a Person / Search by Reference Number). Then once you split the database you can still find someone with that search. It's also possible to include the reference number in the picklist (pull up the picklist and select the Options button)... the only issue there is that the reference number is an alpha-numeric field and sorts as text rather than as a number, so you would get an order like 1, 11, 111, 2, 21, 211, 3, etc... no good for sorting but might be handy for your purposes. I'm pretty sure there's a way to use John Cardinal's TMG Utility to get the ID numbers loaded into the Reference number field. I think it involves outputting your ID numbers using a TMG List of People report, then importing using a TMG Utility function. I don't know if doing that will expand the size of the large table and corrupt your database or not. It might be safer to do the import after splitting the database, just to keep from corrupting the database, but it would take a better expert than me to guide you through that process if you need help with it. Good luck with your database! Joyce Rivette

For anyone following this thread, an important point. As Erik and I have discovered, there was a very important but subtle point to John Cardinal's advice earlier: > use a List of People (LoP) report.... > Configure the LoP to create a tab-delimited output file. On > On the Report Definition Screen, set "File type" to > "Text (ASCII) Delimited with Tab". Erik cannot have TMG create the Excel file directly since TMG uses as its Excel output the "old" style *.xls file type. That file type has a maximum of 64K lines, which is way too few for Erik. So creating a tab-delimited text file instead which has only a file-size limit is not only recommended, it is required. The new Excel with a larger max for its lines can then import this file containing many more than 64K lines. This intermediate format requirement via a tab-delimited text file for Excel import is similar to having to output to the intermediate format of *.rtf files and then import to the new Windows 10 version of Word. Michael

I am not too technical into all this ,but if 4 GB is the limit ,then I should have no problem..... -----Opprinnelig melding----- Fra: TMG [mailto:[email protected]] På vegne av Dennis Lee Bieber Sendt: 22. november 2017 14:50 Til: The Master Genealogist Rootsweb Email List <[email protected]> Kopi: TMG-L submission address <[email protected]> Emne: Re: [TMG] 2Gb file limit At 07:48 PM 11/21/2017, Michael J Hannah wrote: >Dennis Lee Bieber replied: >>VFP can only address bytes 0 to 2147483647. >>At best, it will refuse to save any record that would require >>exceeding the 2GB boundary. >>At worst, it wraps around and corrupts data ... a negative offset > >Actually, as a retired computer geek who was involved in the Y2K >issues, wrap around can be even worse. Rather than a negative offset >it is more likely to truncate, overwriting your oldest data. >2147483647+1 => 0 2147483647+2 => 1 ... Y2K wrap around was due to the use of an implied century with a 2-digit /decimal/ year. The 2GB limit is due to use of a /signed/ binary 32-bit integer rather than an /unsigned/ binary 32-bit integer (which would give a 4GB limit). The positive range of the integer uses 31-bits, it becomes negative when it overflows into the 32nd bit. {It's also a problem with anything written in Java -- which does not have an unsigned data type; and I don't know if it supports 64-bit integers either.} -- [email protected] Dennis Lee Bieber HTTP://home.earthlink.net/~bieber.genealogy/ 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 [email protected] with the word 'unsubscribe' without the quotes in the subject and the body of the message

At 11/22/2017 10:58, Erik Hov wrote >It is right you can find someone with the reference numbers after splitting >the large project ,but if I have 17 different projects ,those >reference-numbers will not be "all in one" ,so you will not be able to find >every number you look for..... No, you make the change to the Reference Field _before_ splitting the project. >If it is possible to someway make reference numbers for each person with >their IDs example 0000001, 0000002 etc it could be used for references ,but >if that may cause total corruption ,I don`t know. (by the way ,do you have >to input reference numbers manually?) No, you can use the John Cardinal's TMG Utility using the procedure he described. >I don`t want to corrupt my database more either ,so must find a good way of >dealing with both the editing as well as the splitting. Make a backup, copy the ID#s to the Reference field using the TMG Utility and then check things to make sure there are no problems. I am not sure, but I don't think this will affect the N file (and its index) at all. The Reference field information is stored in a difference file. Something that has not been mentioned is whether you already make use of the Reference field. You may not have entries is every Reference field (I probably only use it for about a quarter of the people in my project). If you do, you could still do something similar by adding a Reference Tag with the ID# in the Tag Memo field. This would leave your current Reference field alone. Lee

I think that, if I had to split my own project, I would spit it into father's line and mother's line and have one project for each, at least, if the didn't have a lot of ancestors in common. On Wed, Nov 22, 2017 at 1:18 PM, Michael J Hannah <[email protected]> wrote: > Erik has a very unique problem with his million-plus people project. > > I am offering to personally help him accomplish his splitting, but suggest > it may be time to continue this discussion and provide suggestions off-list > directly with Erik. > > By the way, you need a current version of Excel to handle the list of ID > numbers of his quantity of people, and even Excel can barely handle his list > as its max is only 1,048,576 rows. > > Michael > > 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 > [email protected] with the word 'unsubscribe' without the quotes in > the subject and the body of the message