Web based family history software

Question Missing data

  • Jacoline
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
11 months 1 week ago #1 by Jacoline
Missing data was created by Jacoline
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)

Still a noob
(1st installation at 7-21-2010)

Attachments:

Please Log in or Create an account to join the conversation.

  • bertkoor
  • Offline
  • Platinum Member
  • Platinum Member
  • Greetings from Utrecht, Holland
More
11 months 1 week ago - 11 months 1 week ago #2 by bertkoor
Replied by bertkoor on topic Missing data
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.

stamboom.BertKoor.nl runs on webtrees v2.1.20
Last edit: 11 months 1 week ago by bertkoor.

Please Log in or Create an account to join the conversation.

  • Jacoline
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
11 months 1 week ago #3 by Jacoline
Replied by Jacoline on topic Missing data
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

Still a noob
(1st installation at 7-21-2010)

Please Log in or Create an account to join the conversation.

More
11 months 1 week ago #4 by WGroleau
Replied by WGroleau on topic Missing data
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 /**/
 

--
Wes Groleau
UniGen.us/

Please Log in or Create an account to join the conversation.

  • Jacoline
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
11 months 1 week ago #5 by Jacoline
Replied by Jacoline on topic Missing data
Thank you. I am familiar with sql - but what about those who is not?

Still a noob
(1st installation at 7-21-2010)

Please Log in or Create an account to join the conversation.

More
11 months 6 days ago #6 by WGroleau
Replied by WGroleau on topic Missing data
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.

--
Wes Groleau
UniGen.us/

Please Log in or Create an account to join the conversation.

More
9 months 1 week ago - 9 months 1 week ago #7 by sevtor
Replied by sevtor on topic Missing data

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.
 

webtrees 2.1.18, php 8.1.27, torstendahl.se/demo/
Attachments:
Last edit: 9 months 1 week ago by sevtor. Reason: Updated the enclosed files!

Please Log in or Create an account to join the conversation.

More
9 months 1 week ago #8 by Sir Peter
Replied by Sir Peter on topic Missing data

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.

Peter

Please Log in or Create an account to join the conversation.

More
9 months 1 week ago #9 by sevtor
Replied by sevtor on topic Missing data
Absolutely! I will spend a couple of hours on this.

webtrees 2.1.18, php 8.1.27, torstendahl.se/demo/

Please Log in or Create an account to join the conversation.

  • Jacoline
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
9 months 1 week ago #10 by Jacoline
Replied by Jacoline on topic Missing data
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 

Still a noob
(1st installation at 7-21-2010)

Please Log in or Create an account to join the conversation.

More
9 months 1 week ago #11 by hermann
Replied by hermann on topic Missing data
@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
Designer of the custom module "Extended Family"

webtrees 2.1.20 (all custom modules installed, PHP 8.2, MariaDB 10.6) @ ahnen.hartenthaler.eu

Please Log in or Create an account to join the conversation.

  • Jacoline
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
9 months 1 week ago - 9 months 1 week ago #12 by Jacoline
Replied by Jacoline on topic Missing data

@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

Still a noob
(1st installation at 7-21-2010)

Last edit: 9 months 1 week ago by Jacoline.

Please Log in or Create an account to join the conversation.

More
9 months 1 week ago #13 by hermann
Replied by hermann on topic Missing data
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
Designer of the custom module "Extended Family"

webtrees 2.1.20 (all custom modules installed, PHP 8.2, MariaDB 10.6) @ ahnen.hartenthaler.eu

Please Log in or Create an account to join the conversation.

  • Jacoline
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
9 months 1 week ago #14 by Jacoline
Replied by Jacoline on topic Missing data

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) 

Still a noob
(1st installation at 7-21-2010)

Please Log in or Create an account to join the conversation.

  • Jacoline
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
9 months 1 week ago #15 by Jacoline
Replied by Jacoline on topic Missing data
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

Still a noob
(1st installation at 7-21-2010)

Please Log in or Create an account to join the conversation.

More
9 months 1 week ago - 9 months 1 week ago #16 by sevtor
Replied by sevtor on topic Missing data

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!

webtrees 2.1.18, php 8.1.27, torstendahl.se/demo/
Last edit: 9 months 1 week ago by sevtor.

Please Log in or Create an account to join the conversation.

  • Jacoline
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
9 months 1 week ago - 9 months 1 week ago #17 by Jacoline
Replied by Jacoline on topic Missing data

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

Still a noob
(1st installation at 7-21-2010)

Last edit: 9 months 1 week ago by Jacoline.

Please Log in or Create an account to join the conversation.

More
9 months 1 week ago #18 by sevtor
Replied by sevtor on topic Missing data
It sound as if you have the original version of app/Report/ReportParserGenarate.php. Have you updated app/Report/ from the zip archive?

webtrees 2.1.18, php 8.1.27, torstendahl.se/demo/

Please Log in or Create an account to join the conversation.

  • Jacoline
  • Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
9 months 1 week ago #19 by Jacoline
Replied by Jacoline on topic Missing data

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

 

Still a noob
(1st installation at 7-21-2010)

Attachments:

Please Log in or Create an account to join the conversation.

More
9 months 1 week ago #20 by sevtor
Replied by sevtor on topic Missing data
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!

webtrees 2.1.18, php 8.1.27, torstendahl.se/demo/

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum