* Change census date from Year to full date
Change census date from Year to full date
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?
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
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- johnmorrisoniom
- Megastar
- Posts: 904
- Joined: 18 Dec 2008 07:40
- Family Historian: V7
- Location: Isle of Man
Re: Change census date from Year to full date
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.
See ancestralsources:tutorial:tools:census_flag_date_tools#census_date_check|> Ancestral Sources > Census Date Check.
Re: Change census date from Year to full date
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
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- johnmorrisoniom
- Megastar
- Posts: 904
- Joined: 18 Dec 2008 07:40
- Family Historian: V7
- Location: Isle of Man
Re: Change census date from Year to full date
Just download and install, it's free.
Re: Change census date from Year to full date
I used the' Search and Replace' plugin when I changed my census dates from a year to the exact date.
Re: Change census date from Year to full date
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!
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
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Change census date from Year to full date
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
Ancestral Sources is a free install.
I add all these features as requested, but few seem to be able to see them
Ancestral Sources is a free install.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Change census date from Year to full date
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
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
Mike Loney
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Change census date from Year to full date
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.
I'll have a look at your suggestion.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Change census date from Year to full date
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! )
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! )
Mike Loney
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Change census date from Year to full date
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...
It offers a more natural progression from Search Scope down through Basic Filters and the Search Mode...
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
Re: Change census date from Year to full date
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
Nice work
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
Nice work
Mike Loney
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Change census date from Year to full date
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
Re: Change census date from Year to full date
I get that, but to describe Search and Replace as part of the Search Mode feels wrong!
Perhaps Search Criteria would be a better term.
Perhaps Search Criteria would be a better term.
Mike Loney
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Change census date from Year to full date
Yes, that sounds good.
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- 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
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 ??
works and is reproduced on reports ??
Re: Change census date from Year to full date
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
The plugin from Miketate achieves this brilliantly.
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
The plugin from Miketate achieves this brilliantly.
Mike Loney
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- 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
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"?
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
Deterioration is contagious, and places are destroyed or renovated by the spirit of the people who go to them
Re: Change census date from Year to full date
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
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
- Attachments
-
- Search and Replace.jpg (130.41 KiB) Viewed 13290 times
Mike Loney
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- Jane
- Site Admin
- Posts: 8514
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Re: Change census date from Year to full date
You should be able to use a Lua pattern to match the start of the string
Jane
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
Re: Change census date from Year to full date
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 ), that if you have OCCU facts not associated with CENS, they will be full dates, not just years.
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 ), 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
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- Jane
- Site Admin
- Posts: 8514
- Joined: 01 Nov 2002 15:00
- Family Historian: V7
- Location: Somerset, England
- Contact:
Re: Change census date from Year to full date
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."
My Family History : My Photography "Knowledge is knowing that a tomato is a fruit. Wisdom is not putting it in a fruit salad."
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Change census date from Year to full date
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.
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
Re: Change census date from Year to full date
Thanks Mike, didn’t want to show my ignorance of LUA pattern matching. I thought ^1841 meant something else (like ending 1841)
Mike Loney
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
Website http://www.loney.tribalpages.com
http://www.mickloney.tribalpages.com
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Change census date from Year to full date
^ 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.
$ 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