Search the Community

On my desktop I've been using Family Tree Maker as my preferred data entry software for about the last 10 years. For somewhat longer than that I've been using TNG, more recently integrated with Wordpress, to display it, although I also sync to Ancestry. I've always been disappointed I couldn't get media automatically allocated to the correct TNG Collection after importing a GEDCOM produced by FTM. Sadly, my TNG tree hadn't been updated for quite a while, partly because my media links were a mess, with many "File not found" errors, multiple links to the same file etc and I kept procrastinating about facing the challenge to tidy it all up . Over the Christmas/New Year break I bit the bullet, upgraded TNG from v. 11.x to 12.2 and spent some time modifying the CSS files to harmonise with my Wordpress theme (another thing I'd been putting off). Then I started researching the media collections issue; the excellent "gotchas" item in this very wiki was the hallelujah moment when I started to see light at the end of the tunnel! That article led me to Stephen Conner's FTM to TNG Gedcom Fixer program, and also Robin Richmond's GEDCOM Converter mod. Because I was more specifically interested in the media collections I focused on the former. So I spent days modifying the media filenames using FTM to match the requirements of Stephen's Fixer program, a process that's easy enough if quite tedious. I had replicated my website onto my desktop (in a WAMP environment) to fiddle with the CSS and some other mods, so I could test importing a new GEDCOM without jeopardising the live site. I deleted all the existing media files from the tng \media folder and copied the newly-renamed files from my FTM media folder into their respective new website folders. When I imported the fixed GEDCOM file (selecting the options Replace all current data and Import media if present) I was confused to see weird results eg only 12 out of 37 headstones correctly allocated in TNG, 50 out of 269 documents, etc. I spent more time researching and studying the GEDCOM files before & after the fixer program but couldn't see any issues. Then I used PHPMyAdmin to study the TNG database and noticed entries in the media table that didn't look right, and furthermore the number of rows didn't correlate with the number of files. It finally twigged that TNG doesn't clear (ie empty) the media tables when doing a GEDCOM import, even if the option to replace all data is selected. I came to realise that renaming the media files had therefore left things even more messy than previously, and that what I should do is clear all the media tables before doing an import so that TNG would rebuild it from scratch on import. With a view to helping other in the same predicament who may not have the expertise or inclination to play around in the database with PHPMyAdmin I quickly found an excellent backgrounder and tutorial by Bob Cumberbatch on doing it the easy way from within TNG itself (which also confirmed my thoughts). When I followed Bob's procedure to clear all the tables, but NOT restoring the media table (thereby forcing TNG to rebuild it) and re-imported the GEDCOM, Happy Days - all looks great! So if you've waded through all the background, here's my step-by-step takeaway to get your FTM media Categories reflected in TNG Collections. I've tried to pull together tips and procedures from several different places together with my experience into one resource. This has been produced with FTM 2019 and TNG 12.2, but I believe it should work with at least the immediately previous versions of both (but not FTM 2012). It worked for me, but use it at your own risk . NOTE: This should only be done if you use only Family Tree Maker (or Ancestry and sync to FTM) for your data entry and use TNG only to display it! NOTE 2: Sorry Mac users but this process will only work on Windows machines, because Stephen Conner's GEDCOM Fixer program only runs on Windows (though maybe OK using a Windows emulator? Anyone able to confirm please comment below!) I highly recommend replicating your online TNG site to your desktop and backing everything up (including all your media files, before renaming them) so you don't jeopardise your live site in case this doesn't work for you. Do all your modifications on your desktop site and check everything before going through the same steps on your live site. That's beyond the scope of this article, but if you Google or search YouTube for "WAMP" or "XAMPP" you'll find plenty of guides to get a local webserver set up. Also beyond the scope of this article you'll need to be familiar with a File Transfer Protocol (FTP) program. Google or YouTube "FileZilla" for a start. Read the "gotchas" article on this wiki and the detailed information available on Stephen Conner's page (with its linked help docs) and Bob Cumberbatch's page, all as linked above, so that you understand the issues and what the proposed fixes do. Using FTM, rename your media files to match the requirements of Stephen Conner's fixer program. This might take quite some time, depending on your individual situation. Do the following in TNG. In Administration | Setup | Configuration | General Settings, Paths & Folders, setup the new media folders eg: In Administration | Setup | Configuration | Import Settings, make sure the Local [*] paths match those used by FTM on your computer, eg on my system this is (where "XXX" is my Windows username and "YYY" is my tree name in FTM) - yours might be very different: If you're not sure what this path is, either open your GEDCOM file (see below) in Notepad or similar, scroll to the bottom where the media entries are located and look for a line like the following: 1 FILE D:\Users\XXX\Documents\Family Tree Maker\YYY Media\p_4 generations.jpg or in Family Tree Maker (assuming you're using the default database path) go to the Tools | Options menu, General tab, copy the database path, eg for me this is: paste it into the TNG box and add "\[your tree name] Media\" on to the end of it, replacing [your tree name] with the actual name of your FTM tree. Note that in FTM, all media files are stored in the one folder, so you'll use the same path for all of the TNG settings. This path will be removed from that recorded in the GEDCOM file by TNG for each media file so that it can store just the actual filename. In Administration | Trees, for your selected or only tree, click the "Clear" icon: and answer OK to the prompt. When you get to this step on your live site you'd use your selected FTP program (eg FileZilla) for these steps, but initially of course this should be on your local machine so you'd use Windows Explorer/My Computer on Windows or Finder on a Mac to delete all the files in yout TNG media folder, then copy all your renamed media files from the FTM media folder into their respective new folders on your TNG installation, as described in Stephen Conner's documentation. In FTM, select the File | Export menu. The important options are highlighted here, other options at your discretion: then at the next prompt select Other as the Destination: Note the filename chosen when you click OK; you'll need it next. Follow the procedures in Stephen Conner's documentation to setup and run the fixer program, including installing any necessary Windows support files (one-off). From TNG's Administration | Import/Export page, select your "fixed" file, making sure it's not the original one exported from FTM: Select the important options as highlighted below, other options at your discretion: and finally click Import Data. Wait for a short while, then verify what you expect to see. Hopefully like me, you'll be a happy person! Enjoy! A huge thank you to Stephen Conner, Robin Richmond and Bob Cumberbatch for throwing light on this area, and certainly not least Darrin Lythgoe for making TNG so flexible and such a capable environment for our purposes! Cheers Ian Davidson

Hello everyone, I'm currently having trouble uploading a GEDCOM file. It's taking several hours (including multiple clicks on "Continue") to import the people. So far (2 hours), 18,000 people out of 49,000 and 7,900 out of approximately 15,500 images have been uploaded. The images are uploaded, but they aren't being linked to all the people. I've also tried using an empty database. Why is this taking so long? Thank you for your help

After some discussion on the Sources and their significance I decided to develop a Mod that makes the changes considered there. If you have any comments regarding this Mod, feel free to share them in this thread.

It's been a while since I attempted to import a GEDCOM file into my site. I uploaded the file via FTP and went into TNG and went to select it. On both Safari and Firefox (on my Mac) clicking the select button just caused a new blank tab to appear in my browser? I can't figure out why. There was an easy workaround...I deleted the uploaded file and used the file select button, to upload from my Mac and import all in one go, but I'm trying to figure out why I can't select the GED file when it's been FTP'd. This is with TNG 15.0.3

I noticed that this issue has already been addressed in a couple of threads: does the import take into account the privacy or sensitivity of the data? (it seems not) Some programs allow you to tag exported data with the RESN tag according to the GEDCOM 5.5.1 standard, and there may be confidential / locked / privacy values in the description. TNG allows you to manually add such an RESN event, but (as I understand) it only has the meaning of a note, not limiting the visibility of the person/family/event to which it is subordinated. Am I correct? If so, is there a planned extension of this functionality? (Perhaps I should ask Darrin directly?) Michał

People's names in older records aren't always written the same way. @Michel KIRSCH made a great mod Alternate spellings - TNG_Wiki to allow you to show the alternative spellings of a person's name. Unfortunaly this mod doesn't allow you to attach a hyperlink to the different spellings so you can't see in which document etc. the alternative spelling can be found. Creating these hyperlinks can be achieved in at least two other ways. By adding the Event type/Attribute ALIA By editing the Nickname field. Both methods work fine. The 1st method is already discribed in TNG but the second isn't. The 1st method could look like this: or like this: The 2nd method will look like this: As you can see the Alternative Spellings in the 2nd method are placed right beneath the Name field and the name of the Nickname field has been changed into "Also known as" which IMHO is a better. Both methods support the hyperlink option and in my case it looks like this: Hendrikus Severiens - Henricus Severiens - Henrici Severijn - Joannes Severeijn - Johannes Severijn - Joannis Severeijn - Henrici Severijns - Hendricus Severin - <a rel="noopener noreferrer nofollow" style="color:#7b6241" href="showmedia.php?mediaID=563&medialinkID=758">Henrici Severin</a> - <a rel="noopener noreferrer nofollow" style="color:#7b6241" href="showmedia.php?mediaID=507&medialinkID=747">Jan Hendrik Severijn</a> - Joannes Henricus Severin Changing the Nickname field into "Also known as" is possible via the language files text.php. If you want the Nickname field to appear right beneath the Name field even if a Title, Prefix or Suffix is given you need to find this code in getperson.php if( $row['nickname'] ) $persontext .= showEvent( array( "text"=>$text['nickname'], "fact"=>$row['nickname'], "event"=>"NICK", "entity"=>$personID, "type"=>"I" ) ); And place it right above if( $row['title'] ) $persontext .= showEvent( array( "text"=>$text['title'], "fact"=>$row['title'], "event"=>"TITL", "entity"=>$personID, "type"=>"I" ) ); Hope this helps. Unfortunatly I'm not able to write mods but whenever getperson.php is updated you will need to redo the steps for getperson.php Any questions or remarks are welcome.

I have two instances of TNG-v14. One is on-line and another in Localhost (Laragon). I am suddenly having export errors in the local install. The Admin page shows progress as Exporting GEDCOM... If the export fails to run to completion, click here to resume. \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\r\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\nI10 I20 I30 I40 I50 I60 I70 I80 I90 I100 I110 I120 I130 I140 I150 I160 I170 I180 I190 I200 I210 I220 I230 I240 I250 I260 I270 I280 I290 I300 I310 I320 I330 I340 I350 I360 I370 I380 I390 I400 I410 I420 I430 I440 I450 I460 I470 I480 I490 I500 I510 I520 I530 I540 I550 I560 I570 N10 I580 I590 I600 I610 I620 I630 I640 N20 I650 I660 I670 I680 I690 I700 I710 I720 I730 I740 I750 I760 I770 I780 I790 I800 I810 I820 I830 I840 I850 I860 I870 I880 I890 I900 I910 I920 I930 I940 I950 N30 I960 I970 I980 I990 I1000 I1010 I1020 I1030 I1040 I1050 I1060 I1070 I1080 I1090 I1100 I1110 I1120 I1130 I1140 I1150 I1160 I1170 I1180 I1190 I1200 I1210 I1220 I1230 I1240 I1250 I1260 I1270 I1280 I1290 I1300 I1310 I1320 I1330 I1340 I1350 I1360 I1370 I1380 I1390 I1400 I1410 I1420 I1430 I1440 I1450 I1460 I1470 I1480 I1490 I1500 I1510 I1520 I1530 I1540 I1550 I1560 I1570 I1580 I1590 I1600 I1610 I1620 I1630 I1640 I1650 I1660 I1670 I1680 I1690 I1700 I1710 I1720 I1730 I1740 I1750 I1760 I1770 I1780 I1790 I1800 I1810 I1820 I1830 I1840 I1850 I1860 I1870 I1880 I1890 I1900 I1910 I1920 I1930 I1940 I1950 I1960 I1970 I1980 I1990 I2000 I2010 I2020 I2030 I2040 I2050 I2060 I2070 I2080 I2090 F10 F20 F30 F40 F50 F60 F70 F80 F90 F100 F110 F120 F130 F140 F150 F160 F170 F180 F190 F200 F210 F220 F230 F240 F250 F260 F270 F280 F290 F300 F310 F320 F330 F340 F350 F360 F370 F380 F390 F400 F410 F420 F430 F440 F450 F460 N40 F470 F480 F490 F500 F510 F520 F530 F540 F550 F560 F570 F580 F590 F600 F610 F620 F630 F640 F650 F660 F670 F680 F690 F700 F710 F720 P10 P20 P30 P40 P50 P60 P70 P80 P90 P100 P110 P120 P130 P140 P150 P160 P170 P180 P190 P200 P210 Finished Exporting GEDCOM Online export works fine. I have tried Restoring database using online backup replaced media replacing files admin_export.php, admin_gedcom2.php and gedcom.php. Nothing seems to work. Any ideas? 🙏🏾

Hello, I'm not quite sure anymore but I think there was (maybe still is) a mod that displayed the date format in the form dd.mm.yyyy. I can't find a mod for this. There is a “Multi Language Date Edit” where it is written: “TNG already allows one to enter dates in several formats. For example, dates like “25.12.2015” (European format), “12/25/2015” (US format) or “25 December 2015” are translated to 25 Dec 2015, the internal format used by TNG and by the GEDCOM format.” But the mod is for version 14.0.1 and I have 14.0.4 (want to update to 15). So I am looking for such a mod not only in the hope that the display of the data in this format (dd.mm.yyyy or d.m.yyyy) but also, what would be even more important to me, the GEDCOM export of the data in this format. Thank you for your help!

Good morning, I'm sorry if this question has already been answered. I searched the forums and WIKI without finding the answer. I have a database of more than 145,000 records with a few thousand media (obitums). The working file for our genealogist is Brother's Keeper. I exported to Gedcom, imported with MFT to correct some wrong date formats, exported the Gedcom and then processed with TNG. Everything works very well :-). With TNG, we have all the media we don't have in Brother's Keeper. So I want to export this gedcom and the media to recover them with MacFamilyTree and restart. Yes, we have this utility that I have already used in the past. When I click on "Export" nothing seems to happen. Is there one thing I don't understand. Thank you for your help and congratulations to the TNG community. I have rarely seen such dynamism in these volunteer exchanges. Jean-Pierre L. Quebec

I want to take a look at GEDmatch, but I want to mark all Living people in my TNG as Private before I export my TNG GEDCOM. Is there a way to mark all Living people as Private in TNG at once instead of doing it one by one in each person's profile?

Good morning, We have a fairly large database in TNG (140,000 records). We have integrated hundreds of photos through the TNG interface. Is there an already established procedure to import TNG data to the remote server and bring it back to my IMac with associated media ? Then, I want import this gedcom (and media) with MacFamilyTree/ Thank you and thanks for this great application. Jean-Pierre Levasseur

Hi there - Long time since I dont't know where to start, so I start here as you are the most friendly, fastest and most competent. A new version of Legacy has been released (version 10). And after that I see strange things in TNG. It is all a mess and I don't know how to clean it up(I use Legacy as master program on my PC and export Gedcoms to TNG). I've don so for years and years. Normally without troubles Here comes some of the the strange things: 1) Images are completely wrong and a mess. When I e.g. look at my dad there are images in TNG, that are not linked to him i Legacy. The wrong images have texts from his own correct images. I don't know how many people this has happened to. 2) Suddenly maps are wrong. You can see an example on my dad here. The text is, that Google cannot show the image correct and that the maps are for development purposes only. 3) I always show both source and the content of the source. Now the content from the source is not shown any more. If I check e.g. my latest person and his marriage: the details from the gedcom are included. Means it is exported to the Gedcom but not shown in TNG 1 HUSB @I5086@ 2 _PREF Y 1 WIFE @I5087@ 2 _PREF Y 1 MARR 2 _HTITL Mand 2 _WTITL Hustru 2 DATE 23 Nov 1745 2 PLAC Görlsdorf, , Brandenburg, Germany 2 SOUR @S267@ 3 PAGE Landeskirchliches Archiv der Evangelischen Kirche Berlin-Br 4 CONC andenburg-schlesische Oberlausitz, Kirchenkreis Seelow, Gör 4 CONC lsdorf, Gesamtkirchenbuch 1694-1834, Bild 427/508 3 QUAY 4 3 DATE 11 Jun 2024 3 NOTE 4 CONT "Gancke" => "Janke", på samme måde som "Gørken" => "Jørgen" 3 DATA 4 TEXT 1745. 5 CONT Den 23. Novemb. ist Mr. Martin Gancke Görlsdorffer Schmid m 5 CONC it Jungfr. Eve Maria Pechmannin hiesigen Kirchen Vorstehe 5 CONC r und ___stät mitterste Tochter nach 3mahliger Proclamat. a 5 CONC llhier in Görlsdorff copuliert worden. 1 CHIL @I5089@ I am not afraid of truncating the relevant tables in TNG from cPanel, and re-importing a Gedcom - but will that make me wiser/cleverer? Will it help? All the best Hanne, Denmark

I have some WebTags in RootsMagic which don't appear in TNG They are set to be output from RM in the gedcom I use to refresh my TNG database As are some other RMagic specific tags/facts/events call them what you will. They appear in the gedcom eg 1 _COLOR 9 1 _WEBTAG 2 NAME Chromosome Map for Lorna as at Aug 2014 2 URL http://surnames.lornahen.com/tng/dna/105164ChrMap.html 1 _WEBTAG 2 NAME Lorna's Living DNA results 2 URL https://my.livingdna.com/share/02fe9814-7d51-11e7-ab56-5254002fd1a4 1 EVEN http://surnames.lornahen.com/tng/dna/105164ChrMap.html 2 TYPE WebLink 2 DATE 11 MAR 2014 2 _SDATE 1000 (I'm experimenting on how best to link/show the data) The import is set as accept data for all new Custom Event Types The Replace in selected tree is set to All current data Custom Event types show _WEBTAB as accept for Individual and Source, with 116 and 374 events associated On my page Personal information doesn't show any _WEBTAG All info - ditto The EVEN type WebLink appears just fine, the _COLOR shows, but not the _WEBTAG Where else do I look to make these appear? The site is mostly private so none of this will be visible sorry.

I have been exporting GEDCOMs reguarly with no issues. I have made no changes to any software but now receive the following error on any attempt to export Query: INSERT INTO tng_saveimport (filename, offset, gedcom, media) VALUES("/home/lathbuka/public_html/scs_gedcom/FB1.ged", 0, "FB1", "0") You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, gedcom, media) VALUES("/home/lathbuka/public_html/scs_gedcom/FB1.ged...' at line 1

I had a family tree of about 600 people, in a PhpGedView database, hosted on my web server. Unfortunately, I lost the ability to import or export GEDCOMs due to a php upgrade. I rebuilt the database in Mac Family Tree 10 and imported the GEDCOM into TNG version 14. The GEDCOM imported correctly. Last week I connected Mac Family Tree to the LDS Family Search site using the integrated connection of Mac Family Tree. I added a number of people using their people match function. Unfortunately, I then over wrote the original GEDCOM which is now lost to the ether. Subsequent imports of the MFT GEDCOMS result in weird errors such as people married to themselves and original spouses erased from the database. This required lots of corrections for several generations until parents could be found with the add parents search function. Needless to say, I am hesitant to use this TNG GEDCOM for any import export since the original Mac Family Tree GEDCOM exports perfectly into other programs such as GRAMPS and Geneanet and I'm afraid to import the TNG GEDCOM into Mac Family Tree. Here's the corrupted family tree: http://www.sspfrance.com/gen/pedigree.php?personID=I20&tree=test Here's the corrected family tree: http://www.sspfrance.com/gen/pedigree.php?personID=I20&tree=tree1 Any insights or advice would be much appreciated. Thanks, Kevin

Dear Community maybe someone has experience with this or can help me with the problem, thanks During the first update from 13.1.1 to 13.1.2. I had forgotten to uninstall the MODs. My fault. When updating again, the instructions in the README file have now been followed exactly, I get the following error messages with a GEDCOM export. Everything else seems to work without problems as far as I can see. first and second error message 1. Query: INSERT INTO tng_saveimport (filename, fileoffset, gedcom, media) VALUES("/www/htdocs/w017e1cc/tng.brunk-net.de/GEDCOM/TNGB.ged", 0, "TNGB", "0") Unknown column 'fileoffset' in 'field list' 2. Query: SELECT filename, fileoffset, lasttype, lastid, icount, fcount, scount, ncount, rcount, mcount, pcount, media from tng_saveimport WHERE gedcom = "TNGB" Unknown column 'fileoffset' in 'field list'

My TNG software has worked properly for many years and shows well. However, since mid January (2024) I am not able to import gedcoms anymore. Even when I first upload them to the gecom folder and then import. The screen just says Opening xxxx.ged. The file size is only 6MB. My TNG version is 11.11.2 From the Diagnostic page: Diagnostics: all boxes are Green ticked. PHP 7.4.33 File upload: Permitted My SQL version: My SQL mysind 7.4.33 (client) MySQL 5.5.5-10.6.16-MariaDB-cll-lve (server) Webserver: Apache File/Folder Permission: Key folders are all read/write Configuration files are all read/write On importing in the Old Style it gave the following error message: 1-23-24.ged opened... An error has occurred in the TNG software. This could be due to a setup issue, an incomplete upgrade or a program bug. If you are the site owner, you may contact TNG support for help with this problem. Please copy the query below and paste it into your message. Query: INSERT INTO tng_saveimport (filename, icount, ioffset, fcount, foffset, scount, soffset, mcount, pcount, ncount, noffset, roffset, offset, delvar, ucaselast, norecalc, neweronly, media, gedcom, branch) VALUES("/home/p9rwpklyxiqt/public_html/vanosnabrugge.org/genealogy/gedcom-folder/1-23-24.ged", 0, "0", 0, "0", 0, "0", 0, 0, 0, "0", "0", 0, "match", 0, 1, 1, 1, "tree1", "") You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, delvar, ucaselast, norecalc, neweronly, media, gedcom, branch) VALUE...' at line 1 Can anybody please help me to solve this?

Hello everyone, I would like your help with a technical problem that I cannot solve myself despite many hours of research and trying. I run a German-language server at http://generation-boxheimer.de. A few days ago I deleted all the data here and completely reinstalled updated data. Since then, the connections (German: "Verbindung") to godparents are no longer displayed correctly - see e.g: http://generation-boxheimer.de/getperson.php?personID=26849994&tree=tree1 In the GEDCOM file here is the following entry, which refers to Felix Gutmann as godfather: 1 ASSO @54954894@ 2 RELA Godfather In TNG, however, this obviously refers to a family (German: "Familie) and not a person. I can change this manually in the user interface - but this is not practical with around 30,000 entries. Does anyone have any idea how I can fix this problem?

A few days ago I ran into a problem during import of a GEDCOM file. After importing about 1/4 of the content (it took only 2-3 minutes), the import stopped, and I received the following error message: User 'xxxxyyyy' has exceeded the 'max_updates_per_hour' resource (current value: 72000) I assume this means that the import procedure had generated 72,000 INSERT statements and thereby hit the resource limit, set by my webhost. The GEDCOM file in question was 12MB in size and contained 24,000 names, 5,608 families, 732 sources, 866 notes, 0 media and 3,052 places. I exported the file from Legacy Family Tree (v.9.0.0.443), and then copied it to the GECDOM-folder on my webhost's server. This was a clean install into an empty database. I have a shared web hosting plan, and the database is MariaDB 10.6. I contacted my webhost, and their assessment was that the GEDCOM import procedure most likely does not create BULK INSERTS, which would reduce the number of INSERT statements dramatically. Has anyone else run into this problem? Does my webhost have a valid point? The only work-around I found, was to pause the import after it had reached about 6.000 names (and before it generated the error message), then resume it again after an hour. I repeated this pause/resume procedure until the import was completed. So, in other words it took me a good 4 hours to finish a process that probably ought to take less than 15 min.

Hi all, I’m a new TNG-user, and just downloaded and installed TNG 14.0.3 on my WAMP-server (w/PHP 8.2.13, mySQL 8.2.5), using template 4. Installation runs smoothly, so with the GEDCOM-import. However, and as can be seen from the enclosed screeshot, I get some warnings/errors displaying e.g. individual person information : Warning: Trying to access array offset on value of type null in C:\wamp64\www\tng1403\personlib.php on line 417 Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in C:\wamp64\www\tng1403\personlib.php on line 417 What is strange, is that I only get this error for some individuals, not all. The data originates from a TMG GEDCOM export I just added a quickfix on line 417 in personlib.php : //TIE quickfix if (!is_null($xnote)) { $newfact[0] = trim( $xnote['note'] ); } else $newfact[0] =''; // $newfact[0] = trim( $xnote['note'] ); // TIE Two questions: 1) Do you see any side-effect of this fix? 2) Any ideas what has gone wrong here ? Could it be something with the source GEDCOM? Thank you ! Rgds, Tor

This post is an FYI for anyone interested. After all my trying of getting a gedcom from Ancestry.com and merging it with my tng gedcom and not messing with the IDs, I finally tried Family Historian. It has solved all that for me. It was easier than I thought it would be. Here are the steps I used to merge the 2 gedcoms: Installed Family Historian. ( I downloaded the 30 day trial version, but I'll be purchasing the full licensed version) Imported my TNG gedcom into a new project Downloaded my tree from Ancestry and saved it to my PC. Did a merge/compare files and chose the Ancestry gedcom on my PC and then merged it into my project with the TNG data. I kept all my TNG IDs in place and basically merged the existing data and added all the new data from ancestry that I didn't have in TNG. Exported a new gedcom from Family Historian and imported it to my local test site. No issues, no duplicates, it just worked..for me. When I was satisfied with the local host, I imported the new gedcom to my live site. I'm still learning what all Family Historian can do, but for me it's a keeper. Here's the link to Family Historian if anyone is interested: Family Historian v7 Screenshot included. Hope this may help someone.

For some time now I have not been able to complete the GEDCOM import. This has been running since 10 a.m.... it's now 1:35 p.m. The progress bar doesn't change! If I use another browser and look at the family trees, the import continues. Look here... some seconds later... When do I know when the import is finished???? thank you for your help I use TNG14.0.3, MySQL 5.7 and PHP 8.2

I have finally found a way to get my media files assigned to the proper custom media collections during the GEDCOM import process. It does require a "hack" to the gedimport_misc.php file, maybe someday the capability can be made standard by Darrin, or turned into a mod, but for now, this is a HUGE thing for me. I've never cared for the documents/video/recordings collections, always wanted to use my own collections and menu items. Since I use TNG just for display, and frequently clear the tree and reimport from GEDCOM, I needed the placement of files into collections to be automated and not manual. Now it is. I wrote it up in a longer blog post with lots of screen shots, and I'm afraid it probably still doesn't make too much sense, but thought I'd offer it here for anyone looking to do this. Say I have images of birth certificates and the like on my desktop in P:\Genealogy\exhibits\birth_records, and my genealogy program (RootsMagic) puts that entire path in the GEDCOM file. I really want to have a media collection and menu item called "Birth Records", and for the GEDCOM import to put those files in that collection for me. Here's how make the server folder structure similar to the desktop folder structure on desktop: P:\Genealogy\exhibits\birth_records on server: tng/documents/birth_records create the collection in TNG Admin>>Media collection ID: birthrec display title: Birth Records folder name: documents/birth_records add code to customconfig.php defining this collection and the gedcom file path $locimppath['birthrec'] = "P:\\Genealogy\\exhibits\\birth_records"; edit gedimport_misc.php to add this collection ID and import path info to the getLocalPathList function This is what gedimport_misc.php section looks like original: function getLocalPathList($mediatypeID) { global $locimppath, $mediatypes_locpaths; switch( $mediatypeID ) { case "photos": $locpath = $locimppath['photos']; break; case "histories": $locpath = $locimppath['histories']; break; case "documents": $locpath = $locimppath['documents']; break; case "headstones": $locpath = $locimppath['headstones']; break; case "recordings": case "videos": $locpath = $locimppath['other']; break; default: $locpath = isset($mediatypes_locpaths[$mediatypeID]) ? $mediatypes_locpaths[$mediatypeID] : ""; } return $locpath; } You need to add a "case" section for your new media collection. This is what you add: case "birthrec": $locpath = $locimppath['birthrec']; break; Do that for every additional media collection you have created. This is the longer blog post about this technique https://lptex.com/blog/tng-custom-media-collections-using-gedcom-import/ Here's what I see after I do a GEDCOM import and then run the secondary process to trim menus And this is what the menu looks like on the live site I'm working towards the TNG-WP integration and will not be using the TNG menus at all, so I didn't bother with any menu icons. I hope this helps others as much as it has me - this is something I've wanted for YEARS and finally sat down to figure out how to do it myself.

I undertook some remote testing with MySQL 8 on TNG 14.0.2 with some disastrous gedcom import times. I import all data, including media links, from desktop software periodically after 'clearing' the table with 'replace all data'. Connection to the database went well, with config.php set to required values. $database_host = "localhost"; $database_port = "3308"; $database_socket = "/tmp/mysql8.sock"; Database was set to: Storage engine = InnoDB Collation (and all tables) = utf8mb4_0900_ai_ci (recommended by ICDSoft, my provider). Diagnostic on Admin had all green check with the expected versions listed. With MySQL 5.7 , MyISAM storage engine and collation of "utf8mb4_general_ci" , my gedcom import of 15,000 persons and 3,000 media normally completes in a minute or so. The database was empty, and a gedcom import was started. With MySQL 8, I stopped the import after 1/2 hour when only 2,000 people had been imported. At that rate, I estimate the import would take roughly 4 hours. From looking around, there are apparently some SQL commands such as having no cache, and disabling commit, etc., that might shorten this time, but something seems seriously awry populating this transactional database. I did google about a bit and see that slow import is not uncommon but slower by a factor of 240:1 than MySQL 5? I didn't look yet at any logs to see what might be happening. Would like to hear from those who import all data with acceptable speeds on MySQL 8. I know the official expiration of MySQL 5 is this October, but support and maintenance updates will continue into 2026, do no short term urgency. However, MySQL was intially released nearly 5 years ago, so was shocked by the import times. Wanted to hear from the forum first, before pass a note to Darrin. I am hoping there's something to fix or improve in gedimport.php. Lastly, 5 of the 6 mods (listed) I use which creating tables did so with the proper collation. The one that did not was the "who is online" mod. It installs, but the table creation fails with a popup of "-1". Mod Table Created Tables properly with MySQL8 parameters Cousins tng inlaw marriages, tng cousin marriages Persistent Bookmarks tng bookmarks Show All Family tng show all family Sosa tng sosa Failed to create table Who is Online tng users online Created table but with SQL 5 storage engine and collation Treetops treetops

Hello Everyone. I've read most of the threads here about exporting a gedcom file from Ancestry and trying to import into the desktop software then export from that and import into TNG. But as a lot of you know, something in the ancestry.com gedcom and some of the other desktop apps changes your people and family IDs which is very annoying to say the least. I have a couple more thousand people and families in my Ancestry.com tree that I have in my TNG database and have tried several ways mentioned in the forums here without any luck. The IDs would always change. So, I put a support ticket into RootsMagic about this and with their permission here is the email comversation I had with Jackson at RootsMagic Support: Well that worked for me and I posted this to hopefully help others here on the form with the same issues. Like I said, this worked for me using RM8. I know alot of you guys and gals use different apps if you use one at all, so I can't say this will work for you. "Your mileage may vary" FYI, on my genealogy computer, I use RM8 running on a Dell Optiplex 790, and Windows 10 pro. I tested the gedcom created from RM8 on my local wampserver running PHP v7.4.33, which is what my sites at Simply Hosting is running