Search the Community

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

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.

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!

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? 🙏🏾

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 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ł

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 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

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 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

I am helping a friend with an installation of TNG 14. His gedcom files contain TITL tags, and when you select a person in TNG, the titles show up in front of the names (e.g., Dr. med. so-and-so). Can that be suppressed, so that titles are shown only as events/properties? Henning, Copenhagen

hello forum, In order to be able to carry out a controllable and as complete as possible GEDCOM import, a log file of the rejected tags would be useful. Many other programs output messages with the following content after the import process is complete: Import from My_gedcom_file.ged from 11/11/2023 Read #99999 rows 8888 lines accepted 9999 rows rejected 99 people 99 families 99 sources 99 notes 99 media 99 places successfully imported. Details can be found in the log file "Import.log" The log file could be stored in TNG's GEDCOM directory. and have the following structure, for example: Log file for importing My_gedcom_file.ged from 11/11/2023 99999 rows read 8888 lines accepted 9999 rows rejected ================================================== ========= Line 345 reject "Line Text" Line 541 reject "Line Text" Line 712 reject "Line Text" End of log file Please check whether this idea can be implemented. Thank you very much Johannes

In order to be able to check or improve the import process, it would be helpful to receive a log file about the import process. Unfortunately I can't find any. Where is such a file, where can I find it? Thank you Johannes Addition on 14.8.2023 Interesting: no reaction so far..... Does anyone have trouble importing a GEDCOM file (I can't believe this!)? I miss hints which GEDCOM tags and their combinations are rejected by the omput routine. In the case of address data (line1 and line2), I was lucky enough to find out that the pairing ADDR in connection with CONT is not accepted by the routine, but that the tags ADR1 and ADR2 must be used. Unfortunately, there seem to be several TAGS and their combinations that the import routine does not accept. A reference to this in a log file or something similar would be very helpful. I would be grateful for an answer/opinion from the forum users. <g> John

Hello everyone, since I updated to 14.02, the import of the gedcom file doesn't work, either not at all or hangs (it takes several hours) Now he had finally made it, but I can see in the family tree that he is empty!!! The import window says the import is complete. See the pictures! Can someone help me with this problem? Thanks in advance...