Search the Community

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

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

I am wondering if the results displayed when I "Search People", under TNG's, FIND menu item, can be modified. I was curious as to who died after a certain year and would like to add and AGE column. Age is calculated on an individuals page, so it would a matter of adding that field to the data displayed. Thanks, Jim

In the Whats New- report I would like to implement an extra section of ACTIVE (PUBLIC) reports. Can someone realize that for me ?? (I am not able to code it myself) Thanks, Jan

Hi all, A general query - Why is it so common that admin_addreport.php gives a 403? Is it quite picky or is my SQL that bad? I'm really struggling with it and only the simplest queries are accepted. For example I'm trying to weed out invalid dates Thanks Thanks Simon

Hello all, maybe someone can help me further. I am using TNG 13.1.2 and wanted to create a report. So far so good, but every time I call the report, I get the person displayed, but I also get the following error message. SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,firstname, lastname,firstname, tng_people. personID, tng_people.gedcom, nameorder FROM (tng_people ) WHERE (lastname = "Klatte" ) AND tng_people.gedcom = "tree1" ORDER BY lastname I have attached a screenshot of how the report looks like. Thank you very much for your help. Many greetings Huber

Good morning, Under a new law, in Quebec, we should no longer publish data on people who died less than 30 years ago. Is there a utility option or program that a user would have developed for TNG to hide this data? Our base file contains this information. We would like to hide them except for the site administrators. Any help will really be accepted with great gratitude. Jean-Pierre Levasseur

I have just installed this mod and imported my first DOM file. It worked great! However when I click in the view Image tab I get a message that it can't find the server because the Url created looks like this: https://www.ancestry.ancestry.com/imageviewer/collections/62308/images/43290879-Nevada-088197-0005 Notice that ancestry is in the URL twice. If I manually delete one of them I an take directly to the image. What have I done to make ancestry show up twice? Thanks. Marc

Solved for me... I`ve installed an older Version (v13.1) of showreport.php The only difference is in line 591 v13.1: v13.1.1: The older version works well ! _______________________________________________________________________________________________________________________________________________________________________ I recognized yesterday, that some of my reports do not work anymore. Especially, when I want to display persons with their partner (spouse or husband), marriage date, etc ... (Reports were o.K. in TNG v13.1) For example a simple report with Name and birthday of all "Michael"s is working... but, when I add Name of Spouse, it will not work anymore: Count of records seems to be o.K. (could be higher, because some of the Michaels were married twice or more) ... but unfortunately no results in the table..