Page 1 of 1
Importing Places and Addresses
Posted: 30 Aug 2022 04:24
by Woodg
Hi All,
I'm, slowly, working on moving from Relatively Yours 3 (RY3) to FH7 and I have a question around Places and Addresses.
Just like FH7, RY3 has separate Place and Address fields. Unfortunately the RY3 GEDCOM export concatenates both fields into a PLAC tag (with no ADDR tag). So I end up with PLAC values like this:
Town, State, Country
Address, Town, State, Country
State, Country
Country
Cemetery_Name, Address, Town, State, Country
All depending on what data I have recorded.
I looked at the Rearrange Address and Place Parts plugin but I don't think that will help me split this variable combination.
Any suggestions?
I don't have all that many Address records so I might just correct them manually, but thought I'd ask in case there was some amazing automatic solution.
Glenn
Re: Importing Places and Addresses
Posted: 30 Aug 2022 06:53
by ColeValleyGirl
No amazing automatic solution for something so variable. However, look at
Working with Places and Addresses and think about your approach to using places and addresses before embarking on any rearrangement manually. Some users deliberately combine the address and place details in the place field so that they can geocode at the address level.
Re: Importing Places and Addresses
Posted: 30 Aug 2022 08:40
by Woodg
Hi Helen,
I didn't think there would be an automatic solution but thought I'd ask anyway.
I have read the article on Places and Address. (I had read this, and many other, articles before I decided on moving to FH.) I had decided that geocoding to the town level, rather than the actual address, is enough for me. It's what I have in RY3 so am used to that "limitation".
Thanks for your help,
Glenn
Re: Importing Places and Addresses
Posted: 30 Aug 2022 08:55
by ColeValleyGirl
You might be able to do something with the plugin if your 'place' is always three elements or less... and you don't have address details without a three-part place.
I have not tried this, but wonder if:
- Right justifying the place parts
- Mapping the last three parts to place parts 1 2 and 3
- Mapping everything else (if it exists) to Address parts
would work.
If you try it, try it on a copy of your project.
Re: Importing Places and Addresses
Posted: 30 Aug 2022 10:05
by Woodg
Thanks Helen. I'll give that a try tomorrow.
Re: Importing Places and Addresses
Posted: 30 Aug 2022 10:06
by tatewise
I am the Rearrange Address and Place Parts plugin author and Helen is absolutely correct, assuming that your examples are representative of the Place column parts you actually have.
Those examples have matching Place Part designations if they are right justified using a 5-column Place field.
i.e.
Cemetery, Address, Town, State, Country
................., Address, Town, State, Country
................., .............., Town, State, Country
................., .............., ........., State, Country
................., .............., ........., ........., Country
However, if those are not fully representative then there is a workaround.
The Rearrange Address and Place Parts plugin, Input Filter tab, allows a subset of Place records to be selected.
Then you can apply different corrective rearrangements to different groups of Place names.
Re: Importing Places and Addresses
Posted: 30 Aug 2022 10:37
by Woodg
Hi Mike,
There are no "extra" commas for missing data. For example an entry for just a country is simply:
Country
not , , , Country.
And if I have an Address and just a Country then I just have:
address, Country
But your suggestion about using the Filter tab may very well work. I will investigate.
Glenn
Re: Importing Places and Addresses
Posted: 30 Aug 2022 10:46
by tatewise
It does not matter about missing commas.
If for example, you choose to justify right then the preceding commas get inserted by the plugin automatically.
Similarly, if you chose to adjust Address, Country to ........, Address, ......, ......, Country format then the necessary commas will get inserted where needed.
Those rearrangement processes fundamentally involve simply juggling the commas.
Re: Importing Places and Addresses
Posted: 30 Aug 2022 11:17
by Woodg
Thanks Mike. I'll check it out.
Glenn
Re: Importing Places and Addresses
Posted: 01 Sep 2022 09:38
by Woodg
Thank you Helen and Mike. I can use some of your suggestions to clean up many Place formatting issues, the rest can do manually. Or I'll just edit the incoming GEDCOM as that may be quicker.
(Oh, BTW, when I'm finished the move from Relatively Yours 3 to FH7 I intend to create a Thread post documenting everything I've discovered so the information can be easily found by anyone else looking to move.)
Re: Importing Places and Addresses
Posted: 01 Sep 2022 09:40
by ColeValleyGirl
We'd love an article for the Knowledge Base!
Re: Importing Places and Addresses
Posted: 01 Sep 2022 10:33
by Woodg
Hi Helen,
No problems. It'll be a while though as I'm still finding GEDCOM import issues and need to find workarounds.
Glenn
Re: Importing Places and Addresses
Posted: 01 Sep 2022 10:35
by ColeValleyGirl
Understood and thanks