Question Missing data

I wish a rewrite for report "missing data" or a new form for list. In this current form it is NOT a work tool but just a report.
Ex. getting a clickable link at the indi or at least getting the ID no. in a column. Here in Denmark we have alot of similar names; like Jens Hansen. I can have 150 with this name in my tree. And 10x mentioned Jens Hansen in the list - Where to look? Then I have to search and I get all the 150.

In kiwitrees we had the links at stat pages if this way is a better one. (just a suggestion)

I'm not entirely sure what your goal is with that report, but I have the following procedure.

From the main menu select Lists - Branches and enter a popular surname of your tree.
I then work from the bottom of the list upwards to find parents by doing proper research. Some I already have in my tree.
Also in the list (you do need to pay attention) you can spot missing birth / marriage / death dates.

Side note: the "reports" which render to html or pdf are very old and are hard to maintain. A rewrite is needed. But it is good to know which ones are often used and which not. So this feedback is valuable to Greg.

My goal is to find ex. missing death/funerals
And since I have no idea which name/id miss those I would like to have a list where I can see them without knowing name/indi no. As report or list or as clickable link at stats. I do not care. Here in this list I can choose which one I will try to find. Atm I have no idea beside having knowledge about the indi. I use my system to show data and as a working space. I know about todo - I also use them but for other stuff but not for my 900 missing funerals

I sometimes use SQL commands to get info from my database.
Here's how I could find folks with no death record.
Someone more ambitious than me could make a module with it and make the output prettier:

Put this SQL command in a file called MD.sql —
SELECT i_gedcom
FROM ug_individuals
WHERE i_gedcom NOT LIKE '%DEAT%';

# Run that SQL and put the results in temp.ged
mysql -u DB -pPASSWORD DBU < ~/MD.sql > temp.ged

# DB is the name of your database
# PASSWORD is the password to it—and there must be NO space after the -p
# DBU is the DB username
# You can find all three strings in your config file.

# convert the escaped line breaks to real ones
perl  -p -i -e  's:\\n:\n:g;'  temp.ged

# and fix the Windows line breaks (if any)
perl  -p -i -e  's:\r::g;'    temp.ged
# Assuming you're not running on Windows

# Now get the ID and name of each of the persons.
egrep "(INDI|NAME)"   temp.ged

Example (with private info changed to asterisks):
unigen.us:~$ mysql -u **  -p**  **  < MD.sql  > temp.ged
unigen.us:~$ perl  -p -i -e  's:\\n:\n:g;'  temp.ged
unigen.us:~$ perl  -p -i -e  's:\r::g;'    temp.ged
unigen.us:~$ egrep "(INDI|NAME)"   temp.ged | head -8
0 @EAP@ INDI
1 NAME Emma /**/
0 @EEB1912@ INDI
1 NAME Edith /**/
0 @FAC@ INDI
1 NAME Juan /**/
0 @HJM@ INDI
1 NAME Jane /**/
 

Thank you. I am familiar with sql - but what about those who is not?

Those who are not familiar with SQL will hopefully realize when they see it that they don’t understand it and be wise enough to pass on by.

Those who do understand it still have the choice to try it or skip it.

Those who understand it AND aren’t as lazy as I am might even try to improve on it.

Jacoline wrote:

My goal is to find ex. missing death/funerals
And since I have no idea which name/id miss those I would like to have a list where I can see them without knowing name/indi no. As report or list or as clickable link at stats. I do not care. Here in this list I can choose which one I will try to find. Atm I have no idea beside having knowledge about the indi. I use my system to show data and as a working space. I know about todo - I also use them but for other stuff but not for my 900 missing funerals

 

Maybe you have seen that I am working on an updated report module. When I saw your message here I realized that it would be really easy to add a link to the names where some data is missing. You can try my demo site, torstendahl.se/demo/ to see how it works. If you think it would useful you can grab the attached file new-reports.zip, unpack it and replace the corresponding files in your installation with their new versions. They work well with version 2.1.16, 2.1.17 and 2.1.18 of webtrees.
 I am trying to get these additions included in the official webtrees release!

The file new-modules.zip contains new report modules that can be installed under module_v4/ in your site.

Translation of some new phrases are missing, that is another process, so they will be given in English.
 

sevtor wrote:

Excellent - thanks! Would it be possible to change the heading of the second column from just "Event" to "Missing event" and say "source of <event>" instead of just "source" because if dates and places exist, but sources don't, it currently just says s.th. like "source, source". It would be nice to see "source of birth, source of marriage", etc.

Absolutely! I will spend a couple of hours on this.

Looks promissing. TYVM. Just annoying I only have the choice to use proband. Because I do not get all because of that choice. In my system I also having the hubbys family. And in this way I can not see those 

@Jacoline: I can select any person in my tree as a proband for that report. Can you show us a screenshot of where you are when you find your problem, please?

hermann wrote:

@Jacoline: I can select any person in my tree as a proband for that report. Can you show us a screenshot of where you are when you find your problem, please?

See enclosed - I can only choose proband (since it is my name - I had to crossed it over)   
Same for all 4 trees

You are at the right place. Click to the field with your name. Type two or three characters of the name of the desired Proband for that report. Select the right one. Does it work?

hermann wrote:

You are at the right place. Click to the field with your name. Type two or three characters of the name of the desired Proband for that report. Select the right one. Does it work?

Ah yes that works - I did not know I had to do like that. TYVM (stupid me) 

But all the links not working - just getting empty page (the 404 page)
I use "pretty urls" in my setup and have 4 trees - if that helps

Sir Peter wrote:

sevtor wrote:

sevtor post=103891 userid=10326

Now I have spent some time on this and have now a redesigned the report of missing data. The demo site can be use to see the effect.
The links to persons with missing information are generated when the report is in html format.
Currently translation of new phrases and words are missing, but when choosing English it is ok.  I will work more on this. A new version of the new-report.zip file is attached, the only difference is the file missing_facts_report.xml.
Better new-report.zip file can be found in later messages, the enclosed version is deleted!

sevtor wrote:

Sir Peter wrote:

sevtor wrote:

sevtor post=103891 userid=10326

Now I have spent some time on this and have now a redesigned the report of missing data. The demo site can be use to see the effect.
The links to persons with missing information are generated when the report is in html format.
Currently translation of new phrases and words are missing, but when choosing English it is ok.  I will work more on this. A new version of the new-report.zip file is attached, the only difference is the file missing_facts_report.xml.

Ty - but link still not working at html format - just a 404 page. It seems the link is missing /subfolder/tree/tree-name cause the link only show domain/individual/no

It sound as if you have the original version of app/Report/ReportParserGenarate.php. Have you updated app/Report/ from the zip archive?

sevtor wrote:

It sound as if you have the original version of app/Report/ReportParserGenarate.php. Have you updated app/Report/ from the zip archive?

I downloaded from your last comment - see enclosed images for which files I uploaded

 

This is very confusing! I have tried different browsers on both Linux and Windows but it works. So I think this can be a problem that comes from the web server. When I looked at your profile and I found out that your site is hosted by webhosting.dk, and when I looked up their site I could get PHP information which says that they use PHP 7.3.33.
Can you please check this for you webtrees! Go to Control panel end select Server information. There you can see which PHP version your webtrees is using.

Beware that webtrees requires PHP 8.x! I had some trouble before my webhost changed!