* Importing Places and Addresses

[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

[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.

[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

[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.

[Woodg]

Thanks Helen. I'll give that a try tomorrow.

[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.

[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

[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.

[Woodg]

Thanks Mike. I'll check it out.

Glenn

[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.)

[ColeValleyGirl]

We'd love an article for the Knowledge Base!

[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

[ColeValleyGirl]

Understood and thanks