I am just through two reports ,and found the last people I need to keep in my project before I am going to delete about 120000 people from my project. I wonder about two things.... First ID numbers: I have a lot of unused ID numbers (must be about 30000) after splitting out a new project last year. I haven`t renumbered the IDs ,and now I will soon delete about 120000 more people after going through those reports. I might still need the ID numbers intact because of some maintenance I have to do ,but would that be wise? And what about renumbering the IDs? ,would that reduce the size of the program?. What I had thought was to have my project copied ,having it all there (including IDnumbers intact) ,and then work in the other when it comes to deleting people ,and splitting out more etc.... Since the ID numbers are intact in the main project ,I could renumber the IDs in the project I am working in instead of the main project? Or.......is it any way of keeping the ID numbers ,but deleting the unused IDnumbers ,so if I shall add another person ,the IDs will always start at the first unused number??. Just now ,each time I might want to add any new person (which I will not ,because of the size) ,TMG automatically starts with the ID 1014496 since that was how long I had come before I split my project the first time..... Secondly.....deleting a lot of people: I am going to delete about 120000 people from my project ,but what`s the best way of doing that? List of people and creating a new project with those people? Or is it other possibilities? (in my eyes a dataset would be too much risk) After my first split ,I had about 20000 to delete. I don`t remember how I tried to delete those ,but wonder I got some errormessage trying to delete them by sending all of the 20000 to a new dataset. Of course because of the size ,it wouldn`t work sending those 20000 to a dataset since that dataset would be within a project which was already too large nearly up to the 2 GB limit. (I never tried to send them to a new project of course!). I was able to use the focus group with 3000 people at a time ,made a new dataset ,and deleted that dataset each time until I had no more left to delete. I bet it would be better making a new temporary project of those 120000 and not a dataset ,and then delete that project?..... The n.cdx project file is now 1.997.785 kB ,so I would guess to make any dataset would make everything worse.... So.....what`s the best way of deleting about 120000 from an already nearly too large project ,and is it possible to keep the IDnumbers intact as I have them now ,but still delete the unused IDs (after a possible renumbering if necessary)? Thanks , Erik

Erik Hov wrote: > And what about renumbering the IDs? > ,would that reduce the size of the program?. No.

At 2/8/2019 19:38, Erik Hov wrote >I have a lot of unused ID numbers (must be about 30000) after splitting out >a new project last year. I haven`t renumbered the IDs ,and now I will soon >delete about 120000 more people after going through those reports. >I might still need the ID numbers intact because of some maintenance I have >to do ,but would that be wise? Some people prefer to have no unused ID#s in their project. To others, it makes no difference. If you tend to use ID#s a lot to call up certain people, renumbering might be a problem. >And what about renumbering the IDs? ,would that reduce the size of the >program?. The TMG program itself would not be affected. Your project files would not be affected either. When a anything in TMG is deleted, the record is marked as deleted but is retained UNTIL you run the Optimize Maintenance function. Them all deleted records are removed and the file is "closed up" so that no empty records exist. >Or.......is it any way of keeping the ID numbers ,but deleting the unused >IDnumbers ,so if I shall add another person ,the IDs will always start at >the first unused number??. Just now ,each time I might want to add any new >person (which I will not ,because of the size) ,TMG automatically starts >with the ID 1014496 since that was how long I had come before I split my >project the first time..... TMG is designed to used the next highest ID# than is currently the highest. The only way to eliminate unused numbers is the renumber the data set or to manually renumber the individual persons to an unused ID#. For a small data set, this is conceivable, but in your case, no. >Secondly.....deleting a lot of people: >I am going to delete about 120000 people from my project ,but what`s the >best way of doing that? List of people and creating a new project with those >people? Or is it other possibilities? (in my eyes a dataset would be too >much risk) The only way to mass delete a large number of people would be to use the List of People report to either create a new data set or a new project of those persons that you want to keep. As to which way, that depends on what you want to do with the result. I would probably go the project route in your case. >After my first split ,I had about 20000 to delete. I don`t remember how I >tried to delete those ,but wonder I got some errormessage trying to delete >them by sending all of the 20000 to a new dataset. Of course because of the >size ,it wouldn`t work sending those 20000 to a dataset since that dataset >would be within a project which was already too large nearly up to the 2 GB >limit. (I never tried to send them to a new project of course!). I was able >to use the focus group with 3000 people at a time ,made a new dataset ,and >deleted that dataset each time until I had no more left to delete. I bet it >would be better making a new temporary project of those 120000 and not a >dataset ,and then delete that project?..... >The n.cdx project file is now 1.997.785 kB ,so I would guess to make any >dataset would make everything worse.... Have you Optimized the project? That would reduce the size of the files. Lee

Thanks very much for answering my questions. I now know what to do!. I will keep the ID numbers ,and delete the people by getting them in a new project and then delete that project. I may do the necessary edits in the project before actually deleting ,will see about that. Thanks again. -----Opprinnelig melding----- Fra: Lee Hoffman [mailto:azchief@bellsouth.net] Sendt: 9. februar 2019 03:54 Til: The Master Genealogist Rootsweb Email List <tmg@rootsweb.com> Emne: [TMG] Re: ID`s and the best way of deleting a lot of people?? At 2/8/2019 19:38, Erik Hov wrote >I have a lot of unused ID numbers (must be about 30000) after splitting >out a new project last year. I haven`t renumbered the IDs ,and now I >will soon delete about 120000 more people after going through those reports. >I might still need the ID numbers intact because of some maintenance I >have to do ,but would that be wise? Some people prefer to have no unused ID#s in their project. To others, it makes no difference. If you tend to use ID#s a lot to call up certain people, renumbering might be a problem. >And what about renumbering the IDs? ,would that reduce the size of the >program?. The TMG program itself would not be affected. Your project files would not be affected either. When a anything in TMG is deleted, the record is marked as deleted but is retained UNTIL you run the Optimize Maintenance function. Them all deleted records are removed and the file is "closed up" so that no empty records exist. >Or.......is it any way of keeping the ID numbers ,but deleting the >unused IDnumbers ,so if I shall add another person ,the IDs will always >start at the first unused number??. Just now ,each time I might want to >add any new person (which I will not ,because of the size) ,TMG >automatically starts with the ID 1014496 since that was how long I had >come before I split my project the first time..... TMG is designed to used the next highest ID# than is currently the highest. The only way to eliminate unused numbers is the renumber the data set or to manually renumber the individual persons to an unused ID#. For a small data set, this is conceivable, but in your case, no. >Secondly.....deleting a lot of people: >I am going to delete about 120000 people from my project ,but what`s >the best way of doing that? List of people and creating a new project >with those people? Or is it other possibilities? (in my eyes a dataset >would be too much risk) The only way to mass delete a large number of people would be to use the List of People report to either create a new data set or a new project of those persons that you want to keep. As to which way, that depends on what you want to do with the result. I would probably go the project route in your case. >After my first split ,I had about 20000 to delete. I don`t remember how >I tried to delete those ,but wonder I got some errormessage trying to >delete them by sending all of the 20000 to a new dataset. Of course >because of the size ,it wouldn`t work sending those 20000 to a dataset >since that dataset would be within a project which was already too >large nearly up to the 2 GB limit. (I never tried to send them to a new >project of course!). I was able to use the focus group with 3000 people >at a time ,made a new dataset ,and deleted that dataset each time until >I had no more left to delete. I bet it would be better making a new >temporary project of those 120000 and not a dataset ,and then delete that project?..... >The n.cdx project file is now 1.997.785 kB ,so I would guess to make >any dataset would make everything worse.... Have you Optimized the project? That would reduce the size of the files. Lee _______________________________________________ Email preferences: http://bit.ly/rootswebpref Unsubscribe https://lists.rootsweb.com/postorius/lists/tmg@rootsweb.com Privacy Statement: https://ancstry.me/2JWBOdY Terms and Conditions: https://ancstry.me/2HDBym9 Rootsweb Blog: http://rootsweb.blog RootsWeb is funded and supported by Ancestry.com and our loyal RootsWeb community

At 2/9/2019 08:35, Erik Hov wrote >Thanks very much for answering my questions. I now know what to do!. >I will keep the ID numbers ,and delete the people by getting them in a new >project and then delete that project. >I may do the necessary edits in the project before actually deleting ,will >see about that. No! Putting people in a new project and deleting the project will not delete people from the original project. You must put the people that you want to keep in the new project. Lee

<No! Putting people in a new project and deleting the project will not delete people from the original project. You must put the people that you want to keep in the new project.< Put the people I want to keep into the new project? The project I am going to delete people from is "Kladd". (The project I am working with and uses to split and delete from). It`s 121555 AAS=Y people in the Kladd project ,which I just have started a report sending them to a new project named "Sletting" ,for after that to delete the "Sletting" project ,and that way delete those 121555. Why should I put the people I want to keep in that new project instead of the the people with flag AAS=Y?

At 2/9/2019 11:09, Erik Hov wrote >Put the people I want to keep into the new project? >The project I am going to delete people from is "Kladd". (The project I am >working with and uses to split and delete from). >It`s 121555 AAS=Y people in the Kladd project ,which I just have started a >report sending them to a new project named "Sletting" ,for after that to >delete the "Sletting" project ,and that way delete those 121555. >Why should I put the people I want to keep in that new project instead of >the the people with flag AAS=Y? Creating a new project from an old project does _NOT_ change the old project. If you want the new project to have the same name as the old then create the new one, make sure the new one is correct, make a backup of the old one, then delete the old one, and the rename the new one to be the same as the old one. Lee

<Creating a new project from an old project does _NOT_ change the old project. If you want the new project to have the same name as the old then create the new one, make sure the new one is correct, make a backup of the old one, then delete the old one, and the rename the new one to be the same as the old one.< OK. I want to delete those 121555 with AAS=Y flag from my "Kladd" project ,so would the proper way doing that is to use the List of People to make a new project of all the people with AAS=N ,and then delete the Kladd project??

At 2/9/2019 13:11, Erik Hov wrote >OK. I want to delete those 121555 with AAS=Y flag from my "Kladd" project >,so would the proper way doing that is to use the List of People to make a >new project of all the people with AAS=N ,and then delete the Kladd >project?? If eneryone in your data set has the AAS Flag set to either Y or N and nothing else the putting the AAS=N people in the new project is the right way to go. That is, send the AAS =N people to a project named "Kladd2" Following this, review "Kladd2" to make sure it had who you want in it. Then make a backup of "Kladd" and then delete "Kladd". Now rename "Kladd2" to "Kladd". You wouolod use File +>Copy Project in TMG for this. With the "Kladd2" project open in TMG, select File=>Close Project. Then select File=>Copy Project. Copy project can also move the project to a different location at the same time which may be handy if you created "Kladd2" in a different location than "Kladd" and want to have the new project in the old location. Lee

<If eneryone in your data set has the AAS Flag set to either Y or N and nothing else the putting the AAS=N people in the new project is the right way to go. That is, send the AAS =N people to a project named "Kladd2" Following this, review "Kladd2" to make sure it had who you want in it. Then make a backup of "Kladd" and then delete "Kladd". Now rename "Kladd2" to "Kladd". You would use File +>Copy Project in TMG for this. With the "Kladd2" project open in TMG, select File=>Close Project. Then select File=>Copy Project.< Thanks!. Yes ,everyone in the Kladd project has AAS Flag set to Y or N. 121555 with Y and 874509 with N. Will name the new project with the AAS N people into something ,and then use the method you mentioned naming it back to Kladd after deleting the old Kladd project. ( I just took a backup of the Kladd project). To make a new project of 874509 people ,would I guess...take about 2 days.

At 2/9/2019 2:35 PM, Erik Hov wrote: >Thanks very much for answering my questions. I now know what to do!. >I will keep the ID numbers ,and delete the people by getting them in a >new >project and then delete that project. Uhm... That sounds a bit unclear and backwards... Putting people into a new project does not remove them from the original project, so "getting them in a new project and then delete that project" is a lot of disk activity for no gain. You would have to move the people you want to KEEP into the new project, and then delete the ORIGINAL project (maybe followed by renaming the new project back to the old name). I don't recall of ID numbers carry over when creating new projects, or if TMG fills the new records in sequential order.

<Putting people into a new project does not remove them from the original project, so "getting them in a new project and then delete that project" is a lot of disk activity for no gain.< Yes ,Lee just told me this. I haven`t done much of deleting many people at a time before ,so I have done it the wrong way ,but that somehow worked too. <You would have to move the people you want to KEEP into the new project, and then delete the ORIGINAL project (maybe followed by renaming the new project back to the old name).< That was what Lee mentioned too!. I am still learning!. I have started on making the new project with the people I want to keep ,and I assume it will take about two days for the report to finish. Erik