Search the Community
Showing results for tags 'reports'.
-
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
-
what is the difference between birthdate and birthdatetr?
Jean-Luc Lauzon posted a topic in Creating Reports
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);
-
Creating a report using the SQL stetement keeps failing.
Rob Severijns posted a topic in Creating Reports
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
-
Custom Family Event – missing in Report/Fields to Display
OBD posted a topic in Questions and Answers
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 -
Can results displayed after "Search People" under FIND...
JimW posted a topic in Search Engine Questions
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
-
Census Plus International - Beta for 1950 US / 1921 UK Census TNG 13.0 censusplus_v13.0.0.13_beta-1
marcirish posted a topic in TNG Modifications
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> some reports don't work anymore with TNG v13.1.1
MichaelM posted a topic in Questions and Answers
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.. -
***SOLVED by using E31.EVENTDATETR field which is a date format I have a report created using an event from Family Tree Maker. It looks like the event (which has a date) is showing as a string field as the date is not sorting. Some dates are just years e.g. 1843 and some are full dates e.g. 11 April 1930. I have tried numerous SQL sorts and it just bombs out. Can someone help with what I need for the ORDER BY statement to show in YYYY MMM DD order. The e31.eventdate is the thing I am wanting to fix. SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,lastname, firstname,e31.eventdate as eventdate31,e31.eventplace as eventplace31,e31.info as info31, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_events e31 ON tng_people.personID = e31.persfamID AND tng_people.gedcom = e31.gedcom AND e31.eventtypeID = "31" WHERE (e31.eventdatetr AND e31.eventplace LIKE "%Australia%") AND tng_people.gedcom = "tree1" ORDER BY e31.eventdate
-
I would love to have a report that shows the number of years married for 'families' where both parents are stilling living and either or both are deceased. Me and mysql are not compatible. I have found this, could it be modified to suit?? Is someone able to help please? Thanks in advance.
-
I am working already some time with persondata. Now i want to generate reports of persons. When i input the lastname in criteria it works fine. Now i would like to have a universal report where i will be asked for the lastname. When i insert just the field lastname i get the header of the report but no box asking me to input the name. Is it possible to input a operator and a string and what might be syntax? Edit: Maybe my engish is not good enough to explain what i like to get: i like to have a namelist which asks me which name of persons in database should be listed. The name should be a variable in criteria. The fields to be displayed and the fields to be sorted should be inserted into reportgenerator. As i am not familar with SQL-Sintax i cannot write a complete sqlrequest in the lower box of reportgenerator. I have some experience in programming so i would be able to customize values. Uli