* 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. If your question fits in one of these subject-specific sub-forums, please ask it there.
avatar
Gowermick
Megastar
Posts: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Change census date from Year to full date

Post by Gowermick »

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

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
johnmorrisoniom
Megastar
Posts: 901
Joined: 18 Dec 2008 07:40
Family Historian: V7
Location: Isle of Man

Re: Change census date from Year to full date

Post by johnmorrisoniom »

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

See ancestralsources:tutorial:tools:census_flag_date_tools#census_date_check|> Ancestral Sources > Census Date Check.
avatar
Gowermick
Megastar
Posts: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick »

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

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
johnmorrisoniom
Megastar
Posts: 901
Joined: 18 Dec 2008 07:40
Family Historian: V7
Location: Isle of Man

Re: Change census date from Year to full date

Post by johnmorrisoniom »

Just download and install, it's free.
avatar
AndyC
Gold
Posts: 23
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 »

I used the' Search and Replace' plugin when I changed my census dates from a year to the exact date.
avatar
Gowermick
Megastar
Posts: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick »

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

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
tatewise
Megastar
Posts: 28340
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise »

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: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick »

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

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
tatewise
Megastar
Posts: 28340
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise »

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: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick »

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

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
tatewise
Megastar
Posts: 28340
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise »

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 13323 times
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
avatar
Gowermick
Megastar
Posts: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick »

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

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
tatewise
Megastar
Posts: 28340
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise »

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: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick »

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

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
tatewise
Megastar
Posts: 28340
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise »

Yes, that sounds good.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
User avatar
jsphillips
Megastar
Posts: 582
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 »

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: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick »

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

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
dewilkinson
Superstar
Posts: 286
Joined: 04 Nov 2016 19:05
Family Historian: V7
Location: Oundle, Northamptonshire, England
Contact:

Re: Change census date from Year to full date

Post by dewilkinson »

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 13194 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: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick »

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 13182 times
Mike Loney

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
Jane
Site Admin
Posts: 8508
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: Change census date from Year to full date

Post by Jane »

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 13175 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: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick »

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

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
Jane
Site Admin
Posts: 8508
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Re: Change census date from Year to full date

Post by Jane »

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: 28340
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise »

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: 1702
Joined: 13 Oct 2015 07:22
Family Historian: V7
Location: Swansea

Re: Change census date from Year to full date

Post by Gowermick »

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

Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
User avatar
tatewise
Megastar
Posts: 28340
Joined: 25 May 2010 11:00
Family Historian: V7
Location: Torbay, Devon, UK
Contact:

Re: Change census date from Year to full date

Post by tatewise »

^ 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 plugins:understanding_lua_patterns|> Understanding Lua Patterns that are similar to Regular Expressions.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Post Reply