Search the Community

TNG 15.0.2 Hello, folks, Would it be possible to somehow create a TNG report that lists all places in my TNG database, but have it displayed in reverse order? Rather than try to explain it, here is an example (generated by Legacy) of what I'm talking about: And although not a necessity, it would be nice if each of the above lines included a hyperlink to each. Would that be doable? Or would anyone already have such a report? Thanks in advance. Regards, John

I have a very large database with 44,000+ places. Several thousand have names indicating a particular burial place. In order for me to focus on building the Cemetery functions in TNG, I need to capture those Places that have the largest numbers of Burial entries (eliminating Burial counts that just contain more generalized "city, county, state, country" entries or the hundreds of cemeteries having only one or two burials recorded.) I need some help with a script for a report that would select all Places containing "cemetery", "memorial", "burial" generate a count of all Burial events associated with the selected Places sort the selected Places in descending order of Burial count preferably allowing for an input variable for minimum Burial count (but with at least a minimum count of 25 -- I could manually modify the script if needed) This should be a fairly simple script, but I'm not totally up to date on script writing.

TNG 15.0.2 Hello, folks, I have some TNG reports that were created using TNG's Report Writer, and other reports that were created using direct SQL SELECT statements. When I go into phpMyAdmin and select Reports, those reports that were created using TNG's Report Writer have info in the display, criteria & orderby fields. And those reports that were created using direct SQL SELECT statements have info in the sqlselect field. I know absolutely nothing about MySQL, so I'm wondering if there is a way that I can somehow create direct SQL SELECT statements from information in display, criteria & orderby fields. I have a need to use some SQL SELECT statements directly in some of my custom TNG pages, but I have no idea how to convert the above... or if it's even possible. Thank you in advance & have a great day. Regards, John

I've been doing manual data entry for a large well-known family organization, and I need to run some data-verification reports. The needed report does not exist in the Data Validation tab or TNG WIFI. I know a little about SQL, but since the database structure has not been published, I don't know the tables and field names. Heres: my problem. In my review of the records, I'm finding many realtionships between the children & the parents (Birth, Adopted, Stepchild, etc.) are blank. Other than manually going through each record to find those blank fields, there must be a way to write a SQL query report to do that. Does anyone have such a report, or can someone clue me in to the table name & data elements to use. I know a little SQL, ut I'm a novice for sure. Thanks, Carol

TNG version: 14.0.6 and 15.x Data source: Legacy Family Tree v10 Hello MySQL experts, Firstly, I took a look at all of the reports written by Henny Savenije, and also the reports list here in the Wiki, but unfortunately none of them are what I am looking for. Background: When I first got into Genealogy more than 25 years ago, I was very lax setting new users to either Living or Not Living. As a result, I have many (possibly thousands of) people in my tree who lived many centuries ago, but currently show in TNG as Living because there are no birth/dates associated with them. Both Legacy and TNG can set/display users as Living or Not Living, based on settings & utilities/processes, but they can only do so when dates are known. I have my TNG sites set to correctly protect (not display certain things), based on if users are logged in or not. That is not the problem, and not what I am inquiring about here. Problem: As mentioned above, I have many (possibly thousands of) people in my tree who lived many centuries ago, but currently show in TNG as Living because there are no birth/dates associated with them. An example of where this becomes sorta comical (but also annoying!) is when displaying ancestor charts. I've randomly come across some ancestor charts on my site, which has one or more individuals showing birth and/or death dates from centuries ago (example, dates in the 1700s), but above them is listed an ancestor showing as Living (because I have no dates for that ancestor). To illustrate easily what I am trying to explain, I temporarily removed all dates from one of my ancestors in order to make the below screenshot. Look at the below screenshot, and note on the 2nd generation from the top, the husband of Israel MEADEN. Even though he lived in at least the 1600s and possibly 1700s too, and therefor would've died about 300 years ago, in TNG he is still showing as Living : In the above example, the problem is NOT with TNG... TNG is correctly displaying what it is setup to display. The problem is with my Legacy program exporting that person as still living, so I need to manually change that & similar people in situations like that to Not Living in Legacy. But how can I know, which individuals who lived 125+ years ago, are set in my Legacy database as still Living? Using TNG's report-writer, I very-easily created a basic report to display all people on my TNG site who do not have a born/baptized/died/buried date. However, many of those individuals displayed using that report were born less than 125 years ago, so could quite possibly still be alive. Solution: I am hoping that a MySQL expert can help me create a report, which will display all users: with NO died/buried date; and who have a spouse and/or children who have ANY date associated with them that was more than, say, 110 years ago. By dates associated with them, the dates could be for any of the following (but at least one of those dates): born/baptized/died/buried; any alternate date; any other date, such as: census, education, marriage, residence, marriage, etc. So for criteria 2 (above), rather than the MySQL report searching for specific dates, hopefully the MySQL code can just search for ANY date associated with those spouses & children which were more than 110 years ago. Would such a report be doable? If yes, then I could run that report myself, which will tell me which specific individuals in my Legacy database that I need to individually change from Living to Not Living manually . Thank you in advance, and have a great day. Regards, John

I'm just beginning to create new reports. Is there a way to create a report that provides the information stored in the Cemetery list. I would like the report to provide all the information in each cemetery entry including the notes section. Any help is appreciated. Jim

Since I installed TNG v15, some reports no longer work, but those that worked under v14.0.6 still work. For example, I created a report that shows all the "famous people" in my family. You can take a look at it on my test page (see here)... I entered it again exactly as I did under v14.0.6! But I only get this (See here, my second test page) To take a look at the report, I have created an Login for you: Username: demo15 Password: demo15demo15 I hope you can help me! Thank you in advance. Michael

We have a few family members who like to send birthday greetings. I have been asked to produce a report for next month's birthdays so they have enough time to get the greeting in the post. I have This Month's Birthdays report working fine. However, when I try to increment the Current Month with "+1" it falls apart. Does anyone know how to show next month's? Here is the SQL code produced using the report builder for The Month's Birthdays, which is working perfectly. SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,lastname, firstname,birthdate,birthplace, tng_people.personID, tng_people.gedcom, nameorder, LPAD(SUBSTRING_INDEX(birthdate, ' ', 1),2,'0') as dayonlybirthdate, LPAD(SUBSTRING_INDEX(birthdate, ' ', -1),4,'0') as yearonly FROM (tng_people ) WHERE (birthdate LIKE "%JUL%") AND tng_people.gedcom = "1" ORDER BY dayonlybirthdate,yearonly,lastname,lastname Attached are the screenshots of the working This Month's Birthdays in the Report Builder.

Some of my relatives want me to make a Report on our famous relatives or "famous kin" (as on FamousKin.com). I don't mind doing this. I can make a simple report listing such relatives, but I can't figure out how to sort them by relatedness. The famous kin.com page lists lineal relatives first (e.g. 9th - 10th great grandparents) followed by collateral "famous" relatives in their order of relatedness (e.g. 4th cousin 6 times removed coming before 4th cousin 7 times removed). Any suggestions? Also, it would be nice if such a report could be customized to the user logging in.

TNG v14.0.4 Legacy Family Tree Deluxe v9.0.0.456 Hello, folks, When adding/modifying individuals in Legacy, there are 2 fields at the bottom of the window, that we are able to populate if the individual has a record on FamilySearch and/or Find-a-Grave: When exporting from Legacy, the GEDCOM contains the following information: 1 _FSFTID LKSL-6QY 1 _FSLINK https://www.familysearch.org/tree/person/details/LKSL-6QY 1 _FGRAVE 113220854 1 _FGLINK https://www.findagrave.com/memorial/113220854 TNG imports the above successfully: Note that in TNG, I renamed _FSFTID, _FSLINK, _FGRAVE and _FGLINK above , but the point is that TNG is importing the links correctly, and in TNG on the getperson page those 2 links above are clickable. Now, I recently created a couple of reports, one that lists all individuals in my TNG that have a FamilySearch ID/link, and the other that lists all individuals in my TNG that have a Find-a-Grave ID/link. However, in those reports, the URLs are just text, and not a clickable hyperlink. As an example HERE, note that none of the URLs are clickable hyperlinks. I don't know if the problem is with Legacy, or with TNG. I assume that the problem is not with Legacy, as it is exporting those links that TNG is displaying correctly on some pages (such as on getperson). So would it be safe to assume that the problem is within showreport.php ? I am not a coder, but if the problem is indeed in showreport.php , would anyone be able to figure out what I can do (change) in that file so that those links all show up as clickable hyperlinks? Thanks in advance & have yourselves a great day. Regards, John

Dear everyone, I already had a topic with this idea, but after deeper examination it went to "difficult to generate" state. Therefore I made an other Attribute Type and gave every persons an exact "level (L-06,L-07,...)" so I could make a report with. I need help how it is possible to make a page type like "First Name List", but with the selected leveled persons, separated with levels? Or any other nicer way than report... or last in a "Report" with also persons pictures in it. Thanks for any help, regards, Balazs

Dear everyone, I use the TNG-14 for my tree and I really proud to show my/our extended family (with so far 230 person) with it. I always wanted to show all member together somehow as well, but unfortunately it cannot possible in this moment with "tree view". I just think it may be possible with a kind of query (I already try with built in report maker), but I think it is not possible to manage these data vertically in leveled 2 or more lines. After I came up an idea, should make list all member horizontal (with picture and data) selected by their "level". That can help me to show every person who included in my tree and even more importantly show the cousins to each other. I would like to ask help if somebody have an idea how to make a kind of "level full view of cousins" or query.

Hello, I have many TNG reports on my site and at one time they were all working. At some point in time 1 or 2 years ago, maybe longer, some of them stopped working. I am just now getting around to trying to fix them. I am having trouble with reports that have "Choose Fields to Display" or "Choose Criteria" for the ":Fact" part of some facts or events: _MILT: Fact Residence: Fact Some customs events created in my Ancestry.com tree, and exported by GEDCOM to TNG. An example name is "ISSUE …", so "ISSUE …: Fact" Setting aside the use of this :Fact part in the Choose Criteria for the moment, it appears the query is not even finding and displaying the ": Fact" data even though the data is shown on person profiles that should be returned by the query. This 1775 Military Events in Massachusetts report has: "Choose" Criteria" : (_MILT: Date contains "1775") AND (_MILT: Place contains "Massachusetts") Fields to Display includes: _MILT: Fact If you run the report, you see the _MILT: Fact column empty. Interestingly, the title for that column is displayed as "_MILT" instead of "_MILT: Fact" or something like that. If you then click on any of the persons listed in the report, you can see the "_MILT: Fact" data displayed in their profile. Any suggestions as to what is wrong or next steps to debug this will be greatly appreciated. Best regards Ken SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,e9.eventdate as eventdate9,firstname, lastname,birthdate,deathdate,e9.info as info9,e9.eventplace as eventplace9, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_events e9 ON tng_people.personID = e9.persfamID AND tng_people.gedcom = e9.gedcom AND e9.eventtypeID = "9" WHERE (( e9.eventdate LIKE "%1775%" ) AND ( e9.eventplace LIKE "%Massachusetts%" )) AND tng_people.gedcom = "OurFamilyTree" ORDER BY e9.eventdatetr,lastname,firstname,birthdatetr

In reports, what is the difference between birthdate and birthdatetr?

I don't Know if it is possible to make a new Page (php) based on sql. I have a report with sql to select all thé persons with thé same birthday (including surname, firstname, deathdate). Can I put that in a new php, so I can ad there thé possibility to edit, delete persons... Goal as to check double persons.

I created a report as an administrator and there I can see it. But in the 'visitors' page there are no reports in the list.

Hello dear helpers, I would like to use Report Manager to create your report that includes alternative spellings. But I can't get this. Can anyone help me or give me a tip? But I think this can only be done using an SQL query, but I'm out of that... (I need these facts to display: Person ID, full name, alternative spellings, occupation fact, birth date, death date, tree, if necessary notes Choose Criteria: Comment 1:Fact contains "Famous Person") Thanks in advance

Hello everyone, I would like to create a report with more or less famous people from my family tree. The standard photo (thumb) of the person should be visible at the beginning of each line! How do I do that?? Can you help me? This is the SQL text so far, but without a picture..... SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,sex,lastname, firstname,e16.info as info16,birthdate,birthplace,deathdate,deathplace, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_events e16 ON tng_people.personID = e16.persfamID AND tng_people.gedcom = e16.gedcom AND e16.eventtypeID = "16" LEFT JOIN tng_events e19 ON tng_people.personID = e19.persfamID AND tng_people.gedcom = e19.gedcom AND e19.eventtypeID = "19" WHERE (e19.info LIKE "%famous%") AND tng_people.gedcom = "KLERC" ORDER BY lastname Thanks in advance

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

I am having some trouble with adding personID in this SQL. I am not sure where I should add this 'personID'. Also, I don't want to calculate their ages of deaths manually. It is really time-consuming by calculating their individuals' ages. How can the ages be calculated in the reports automatically? I want to keep their surnames in order. See attached below

Could someone please explain this error log excerpt to me in dumbass user terms? line 2 of index.php include($cms['tngpath'] . "surname_cloud.class.php"); line 9 of index.php tng_header($sitename ? "" : $text['mnuheader'], $flags);

I'm trying to create a report using the sql statement field in the report builder but no matter what I do it keeps generating a "FORBIDDEN You don't have permission to access to this resource." If the report is created by using the field selectors in the report builder all works just fine. The sql statement below is copied from the executed report created using the field selectors in the report builder. SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,firstname,lastname,birthdate, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (DAYOFMONTH(birthdatetr) = "13" AND MONTH(birthdatetr) = substring(SUBSTRING_INDEX("05", ' ', -2),1,3) AND Living=TRUE) AND tng_people.gedcom = "Sev1" ORDER BY birthdatetr I've tried changing the permissions of the admin_newreport.php and admin_addreport.php to 664 but without any positive results. Any help is appreciated.

Is it possible to return an image in a report? This is a subset of Photos in that it only returns those images in a certain folder - in this case photographs of people. I have written a report that returns the URL of the image that I want to display. But what I would like to do is show the actual image. Many thanks Dave

I have many Military Veterans in my tree. Has anyone created a report with the following criteria: Name, Last, First, MI DOB Military Branch War/Battle Branch and/or Location Thank you, Mike Quill mdqsr@verizon.net

I have made 2 custom events, 1 (“Nevnt”) associated with “Personal” and 1 (“Forhold”) with “Family”. Translation: “Nevnt” = “Mentioned” and “Forhold” =”Affair” When making reports, the Personal Event “Nevnt” appear as an option in “Field to Display”/”Choose Criteria”/”Choose sort Fields”. However, the Family Event “Forhold” is missing: Here is the Custom Event Types table: How can I make the custom event "Forhold" active in the Report/Choose Fields to Display? Regards Ole Bjørn