* How to not mark the deceased without dates as living

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile. If your question fits in one of these subject-specific sub-forums, please ask it there.
User avatar
Jane
Site Admin
Posts: 8507
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: How to not mark the deceased without dates as living

Post by Jane »

In the TNG settings you can select if TNG uses the living flag.

When you import it sets the flag based on the settings in the import, but they can be changed after import, easily enough either manually or using sql to set them all to 0 and then set the living to living.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
User avatar
tatewise
Megastar
Posts: 28333
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: How to not mark the deceased without dates as living

Post by tatewise »

So, to try and summarise and simplify what is getting overly complex.
Just add empty Death Events to Individual records in FH (which will be retained indefinitely).
When exported to TNG those Individuals are NOT hidden as required. Is that correct?

Don't mess around with GEDCOM.
Don't know how you got 1 DEAT Y to show "Y" in the Death Date field because FH does NOT do that.
So wipe that from your mind.

The only outstanding issue is in which FH Diagrams & Reports you want to hide empty Death Events.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

I would like all diagrams and reports to work without empty death events.

If the TNG SQL settings can be over-ridden, that sounds the better option.

Rather than forcing one M/C to make alterations to get the other to work properly.

As always thanks for your efforts.

Regards
Keith
User avatar
tatewise
Megastar
Posts: 28333
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: How to not mark the deceased without dates as living

Post by tatewise »

Agreed.
It needed an experienced TNG user to identify the TNG settings that needed adjusting.
So, no changes are needed to FH at all.

I may add that cross-reference to the Export Gedcom File Plugin advice for TNG.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
Jane
Site Admin
Posts: 8507
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: How to not mark the deceased without dates as living

Post by Jane »

capnkeith wrote:Hi Jane,

My issue is not the living, it is those that are dead and have been for some considerable while, but are identified as living because they have no birth or death record. Are you telling me that you can separate them from the genuine living?

Regards
If you have read the link I posted you can see that on the import the living flag is set , you can set it manually in TNG or just set the field using SQL as I explained. So you can clear all the living fields in TMG and just set the ones you want.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

Jane,

It's a while since I used MYSQL and then it was just adding or deleting product types and codes etc into the tables. So first I need to refresh my way around in the tables etc. I have accessed MYSQL and can see the column of "living" and how your code would work but how do I go about clearing those wrongly set (around 1500) do I clear everything and then set living on the ones I want. Is it possible to do it with a Query or Plugin in FH. Which comes first, I will need guidance.

Regards
Keith
User avatar
Jane
Site Admin
Posts: 8507
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: How to not mark the deceased without dates as living

Post by Jane »

Just zero all the "Living" column

Code: Select all

UPDATE `tng_people` set `living` = '0' WHERE `gedcom` = 'Mullins'
Then set the ones you want. Whether it's worth writing a plugin will depend on how often you want to upload.

If it's only occasionally, Just use the query attached and then copy the results to a text editor and remove the new lines and the last comma before using in the SQL I already posted.
Living Record IDs for TNG.fhq
(588 Bytes) Downloaded 208 times
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

Hi Jane,

What is your query looking for. I made a named list last night of all those living, manually, can it pick that up?

Regards
Keith
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

Dont worry I've worked it out
Keith
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

Is there a way of copying a query result without it putting each line in " " inverted commas. Notepad Find doesn't seem to work on punctuation!
Keith
User avatar
Valkrider
Megastar
Posts: 1563
Joined: 04 Jun 2012 19:03
Family Historian: V7
Location: Lincolnshire
Contact:

Re: How to not mark the deceased without dates as living

Post by Valkrider »

Keith

Use the free Notepad++ it does work on any character.
User avatar
Jane
Site Admin
Posts: 8507
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: How to not mark the deceased without dates as living

Post by Jane »

Why make a Named list? Any way just set the Living flag using the Is in List query and set the flag from the Gear wheel.

You will make life much easier on yourself if you use a Text editor like NotePad++ or PSPad. That said Notepad has no problem replacing " with nothing.
2018-03-01_120914.png
2018-03-01_120914.png (5.44 KiB) Viewed 14125 times
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

I asked it to find " and it said it couldn't find ''' I gave up and did it by hand but I will look for one of the others you recommend.

Thanks for your help it is now all working, just checking and finding a few without birthdays that I missed.

Regards
Keith
User avatar
Jane
Site Admin
Posts: 8507
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: How to not mark the deceased without dates as living

Post by Jane »

fh_set_living.php

I have written a quick PHP script which you can upload to your TNG folder (I recommend deleting or renaming it when not in use).

If you call it and enter your gedcom name and the copied results from the Query it will run the two SQL statements to clear the ids and set the ones you want, you could also just type them in if you really wanted to (it removes the double quotes and the trailing comma , for you).
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

Thanks I'll give it a go next time I upload a gedcom, I've put five trees on there at the moment so it might not be too long. I've disposed of the named list and just flagged all the living.

Regards
Keith
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

Jane,

I've just tried it and it works a treat. Thanks very much.

Regards
Keith
User avatar
Jane
Site Admin
Posts: 8507
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: How to not mark the deceased without dates as living

Post by Jane »

Good news. I have add the Query and the script to

fhugdownloads:contents:utility_the_next_generation#setting_the_living_flag|> TNG - Setting the Living Flag
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

Hi Jane,

I know you are away on your hols soon so if you have no time please don't worry this can wait.
I have just tried to run fh_set_living.php and got this error? Does it mean anything to you?

Query: UPDATE tng_people SET living = 1 WHERE personID in ()

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1

Regards
Keith
User avatar
Jane
Site Admin
Posts: 8507
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: How to not mark the deceased without dates as living

Post by Jane »

Did you paste all the ids into the form?
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

It's been a while since I made an update to TNG and I think I might have done something in the wrong order. I cannot remember how to remove the quotes or comma in Notepad. I'll have another go this morning.
Keith
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

I think I have corrected all my errors
I hadn't used a Std UTF8 gedcom
Or pasted the IDs into the form - they look like this now 'I7178' with " ", deleted.

But none of the Living Flags have been set.

What have I missed?

I don't know but I just loaded the ids straight from the query and it now works. The only thing I can see is perhaps I should not have removed the comma.

Regards
Keith
User avatar
Jane
Site Admin
Posts: 8507
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: How to not mark the deceased without dates as living

Post by Jane »

Yes it needs the commas.

I could probably improve the php script, but I don't have time at the moment sorry.
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
User avatar
capnkeith
Famous
Posts: 190
Joined: 09 Mar 2009 17:15
Family Historian: V6.2
Location: Suffolk, England

Re: How to not mark the deceased without dates as living

Post by capnkeith »

Not a problem it's all done and working, thanks. If I used it more often I wouldn't forget how to use it.

Regards
Keith
Post Reply