* Change census date from Year to full date

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
avatar
Gowermick
Megastar
Posts: 725
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Change census date from Year to full date

Post by Gowermick » 30 May 2019 08:14

I'm sure this has been covered before, but as I can't find answer anywhere, I'll ask anyway.

Currently I use just the year for census dates, but feel it would be better if I changed these to actual date of Census.
e.g. Change 1841 to 7 June 1841.

Is there a simple way to achieve this using find and replace?
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
johnmorrisoniom
Megastar
Posts: 768
Joined: 18 Dec 2008 07:40
Family Historian: V6.2
Location: Isle of Man

Re: Change census date from Year to full date

Post by johnmorrisoniom » 30 May 2019 08:20

If you have recorded the census as a census event, then the date checker in AS can do that for you.

See Knowledge Base > Ancestral Sources > Census Date Check.

avatar
Gowermick
Megastar
Posts: 725
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick » 30 May 2019 09:17

Thanks John, but there's the rub. I don't use or have Ancestral Sources
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
johnmorrisoniom
Megastar
Posts: 768
Joined: 18 Dec 2008 07:40
Family Historian: V6.2
Location: Isle of Man

Re: Change census date from Year to full date

Post by johnmorrisoniom » 30 May 2019 11:04

Just download and install, it's free.

avatar
AndyC
Silver
Posts: 7
Joined: 07 Oct 2018 13:29
Family Historian: V6.2
Location: St Albans, Herts.

Re: Change census date from Year to full date

Post by AndyC » 30 May 2019 12:04

I used the' Search and Replace' plugin when I changed my census dates from a year to the exact date.

avatar
Gowermick
Megastar
Posts: 725
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick » 30 May 2019 13:48

I looked at that Andy, but how did you restrict the dates to just census dates!
With 19,000 individuals, I don't want to confirm every change!
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
tatewise
Megastar
Posts: 16863
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise » 30 May 2019 14:21

In the Plugin just restrict the Scope to Census Events (CENS) and filter on Dates.
I add all these features as requested, but few seem to be able to see them :o

Ancestral Sources is a free install.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
Gowermick
Megastar
Posts: 725
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick » 30 May 2019 14:56

Miketate,
Thanks for that, I’ll try again with a bit more confidence, knowing only census dates are covered.

Can I point out that I am using version 2.9, which according to plugin store was updated 4Jun 2018, but plugin states it was last updated 9 Feb 2018.

If people are missing the scope option (me included), perhaps it is because it is on the right, mixed in with the radio button options.

Personally I’d give it more prominence, possibly in its own box, on the left hand side, above the search and replace boxes, ( do these boxes need to be so large?). Just a thought :D
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
tatewise
Megastar
Posts: 16863
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise » 30 May 2019 17:14

Can't remember why Plugin Store and Plugin dates differ, but I was aware, and V2.9 is the latest.

I'll have a look at your suggestion.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
Gowermick
Megastar
Posts: 725
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick » 30 May 2019 17:56

Thanks Mike,
I like to add an update, your plugin worked a treat, and even flagged those entries I had already entered full date (plus one where I had entered wrong date! :D )
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
tatewise
Megastar
Posts: 16863
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise » 31 May 2019 11:55

Would the Plugin dialogue layout shown below be an improvement?

It offers a more natural progression from Search Scope down through Basic Filters and the Search Mode...
SearchAndReplaceScope.png
SearchAndReplaceScope.png (25.46 KiB) Viewed 1498 times
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
Gowermick
Megastar
Posts: 725
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick » 31 May 2019 16:32

I think that's a lot better, at least Seach Scope has a bit more prominence, and shouldn't be overlooked

I would just comment that the Search and Replace fields being contained within the Search Mode box doesn't seem right somehow.

Perhaps they could be in their own Search & Replace box, leaving just the Radio buttons within a Search Mode box?

But that could just be me being picky :D

Nice work
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
tatewise
Megastar
Posts: 16863
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise » 31 May 2019 17:09

They are there because the radio buttons on the right have a direct impact on them.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
Gowermick
Megastar
Posts: 725
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick » 31 May 2019 17:43

I get that, but to describe Search and Replace as part of the Search Mode feels wrong! :D
Perhaps Search Criteria would be a better term.
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
tatewise
Megastar
Posts: 16863
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise » 31 May 2019 17:51

Yes, that sounds good.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

User avatar
jsphillips
Superstar
Posts: 416
Joined: 13 Aug 2006 16:00
Family Historian: V6.2
Location: Near Sevenoaks Kent

Re: Change census date from Year to full date

Post by jsphillips » 01 Jun 2019 16:35

When entering census data I click on add fact then click on Census and add full date ie 30 March 1861 , 7 April 1861 etc it

works and is reproduced on reports ??

avatar
Gowermick
Megastar
Posts: 725
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick » 01 Jun 2019 17:08

Jsphillips,
But, had you used just the year when you started out (20 years ago in my case), and now decided in hindsight that you should have used full date, you’d now have an extremely large amount of facts that need their dates correcting! (They say hindsight is 20-20 vision)

It does not help if I put full date in for new data, as the old data still needed correcting :D

The plugin from Miketate achieves this brilliantly.
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
dewilkinson
Famous
Posts: 150
Joined: 04 Nov 2016 19:05
Family Historian: V6.2
Location: Oundle, Northamptonshire, England
Contact:

Re: Change census date from Year to full date

Post by dewilkinson » 02 Jun 2019 05:52

I thought this would be a useful way of correcting incomplete census date entries where historically we have only entered the year. But as we now have 000s with the full date this doesn't help. See attached image. Is it possible to add to the search criteria "ignore 6th June 1841"?
Capture.JPG
Capture.JPG (43.95 KiB) Viewed 1369 times
David Wilkinson researching Bowtle, Butcher, Edwards, Gillingham, Overett, Ransome, Simpson, and Wilkinson in East Anglia

Deterioration is contagious, and places are destroyed or renovated by the spirit of the people who go to them

avatar
Gowermick
Megastar
Posts: 725
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick » 02 Jun 2019 07:04

You could do it in two passes!
1. Change all "6 June 1841" to "1841", to bring all back to the same starting point
2. Change all "1841" to "6 June 1841"

OR

Create a named list for those with just "1841", then used the Named list to restrict the Scope of the Find and Replace

Note the change of Search Mode box, which now reads Search Criteria - apologies to MikeTate :D
Attachments
Search and Replace.jpg
Search and Replace.jpg (130.41 KiB) Viewed 1357 times
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
Jane
Site Admin
Posts: 7782
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: Change census date from Year to full date

Post by Jane » 02 Jun 2019 07:54

You should be able to use a Lua pattern to match the start of the string
2019-06-02_085350.jpg
2019-06-02_085350.jpg (99.1 KiB) Viewed 1350 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."

avatar
Gowermick
Megastar
Posts: 725
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick » 02 Jun 2019 08:37

Jane,
Whilst your suggestion would be OK for census dates, (all dates for a specific CENS year would be the same) it wouldn’t work for the accompanying OCCU fact, as there may be other dates in 1841, which you wouldn’t want to change!

I am assuming (dangerous I know :D ), that if you have OCCU facts not associated with CENS, they will be full dates, not just years.
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
Jane
Site Admin
Posts: 7782
Joined: 01 Nov 2002 15:00
Family Historian: V6.2
Location: Somerset, England
Contact:

Re: Change census date from Year to full date

Post by Jane » 02 Jun 2019 08:54

If you really wanted to you could simply prompt for all the OCCU ones and skip the ones you wanted to leave or write your own plugin to check the source for the event and then check the source information to see where the item was sourced.
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: 16863
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise » 02 Jun 2019 09:38

Mike, Jane's proposal of ^1841 will only match OCCU that have just 1841 as the Date.

Any more complete Date such as Jan 1841 or 6 June 1841 will NOT match the criteria.

Also, if that still needs further filtering, then use the Named List technique mentioned earlier, and then Select Records allows the Named List entries to be chosen.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

avatar
Gowermick
Megastar
Posts: 725
Joined: 13 Oct 2015 07:22
Family Historian: V6.2
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick » 02 Jun 2019 11:18

Thanks Mike, didn’t want to show my ignorance of LUA pattern matching. I thought ^1841 meant something else (like ending 1841) :oops:
Mike Loney

Using FH 6.2.7, with CC 6.7.37 Windows 10.0.14393 Build14393, LibreOffice 6.1.4.1(x64), Firefox 67.0.1(64Bit) & Thunderbird 60.7.0
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com

User avatar
tatewise
Megastar
Posts: 16863
Joined: 25 May 2010 11:00
Family Historian: V6.2
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise » 02 Jun 2019 13:08

^ is the pattern magic code that anchors the pattern to start of string
$ is the pattern magic code that anchors the pattern to end of string

So the search pattern could be ^1841$ and that would eliminate any Approx, Calc, Est qualifiers that might follow the year, assuming you wanted to exclude them.

See Knowledge Base > Understanding Lua Patterns that are similar to Regular Expressions.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry

Post Reply