Gerald,
I agree with you that trying to manually modify GEDCOM in Excel would me an impossible task. That’s why I wrote Visual Basic for Applications (VBA) code (i.e., Excel macros) to do the modifying automatically. Think of the macro-enable spreadsheet as a GEDCOM preprocessor in going from Legacy to TNG. Access is a database that can read and edit the Legacy .fdb file, which is an Access database. LTools is an example of a program that uses Access to edit the Legacy data. I have it, but haven’t been able to use it very much because it cannot handle shared events, which I routinely use because of the time it saves on data input. I have used Access directly to view various Legacy database tables, mainly to check for inconsistencies in my data input. But any changes that need to be made have been done directly in Legacy. Don Quigley 945 Halecrest Drive Escondido, CA 92025 (H) 760-746-5887 (M) 925-367-5609 From: gerald [mailto:g...@representative.com] Sent: Friday, March 27, 2015 12:50 AM To: Don Quigley Subject: Re: RE: [LegacyUG] TNG and Shared Events Don, I tried what you suggest --save to GEDCOM and then open in Excel to edit. But there is so much extraneous data, it would take memonths to edit! I would give up. You also mention a VBA code, and I have no idea what that is. Would you be able to explain this a bit more? How is this different from Access which I have read others use for editing? Do then provide this Excel file to your particepants, or some other format? Sent: Thursday, March 26, 2015 at 2:15 PM From: "Don Quigley" <dwquig...@cox.net> To: legacyusergroup@LegacyUsers.com Subject: RE: [LegacyUG] TNG and Shared Events John, I replied to a similar question a month or so ago. I currently "distribute" the shared events to all participants by taking the GEDCOM exported from Legacy and modifying it in an Excel spreadsheet using VBA code I prepared. Takes about 20 min to process my 3700-person family tree, with a GEDCOM over 300,000 lines. I'm willing to share with others by email (can't include attachment in the LegacyUsers messages). Don Donald Quigley Escondido, CA Quigley Doyle Family Tree http://www.donquigley.net -----Original Message----- From: John B. Lisle [mailto:leg...@johnlisle.com] Sent: Thursday, March 26, 2015 12:45 PM To: legacyusergroup@LegacyUsers.com Subject: [LegacyUG] TNG and Shared Events Legacy TNG Users, How are you handling your shared events when you export your Gedcom for TNG? Is it important for you to have your Shared event displayed on your TNG web site? Currently, TNG does not support importing shared events even though both Legacy 8 and Roots Magic export shared events with basically the same Gedcom. When Legacy 8 was released in Nov 2013, TNG's developer Darrin seemed to commit to supporting shared events by TNG 11. However, since making that commitment, he has not heard from you that you want them supported so he is no longer committed to doing it. If you want shared events in TNG, it is time to write him and say that you are expecting this support soon. Just this past week, I had a contact buy Legacy and TNG so he could move from FTM and use shared events. I know there are many more people with this interest. As my principal publishing is done on the Web with TNG, shared events are useless to me until TNG can support them. Please let your voices be heard.... :-) john. Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://support.legacyfamilytree.com Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://support.legacyfamilytree.com Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://support.legacyfamilytree.com Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp