* Moving Place data to Address Field

Questions regarding use of any Version of Family Historian. Please ensure you have set your Version of Family Historian in your Profile
Post Reply
avatar
jayef
Newbie
Posts: 2
Joined: 23 Nov 2012 20:21
Family Historian: None

Moving Place data to Address Field

Post by jayef » 23 Nov 2012 21:16

I have been sent an FH database containing a goodly amount of my family history data - 380 individuals - (lucky me!). I see that ALL the 'location' data has been entered into the Place fields and the Address fields are blank.

As I understand: Place should contain the Town, County, Country information and the 'details' (Church name, Street Address etc) should be in the Address field. And I can see the logic for this so would like to standardise this data before I add more.

As all the data is basically present is there some way that I can automate or simplify the necessary editing and avoid individually editing the records and re-entering data which already exists (but in the wrong place)? I can see that the 'Tools/Work with Data' feature may be relevant but couldn't see how to use it to address this problem.

I have many years of IT experience so happy with something reasonably technical if that's what's needed.

(I found a number of posts about Place/Address usage but couldn't find anything specifically addressing this problem)


ID:6606

User avatar
PeterR
Megastar
Posts: 1051
Joined: 10 Jul 2006 16:55
Family Historian: V6.2
Location: Northumberland, UK

Moving Place data to Address Field

Post by PeterR » 23 Nov 2012 21:53

I would think that a Plugin could be written, but you would have to be able to specify how many comma-separated parts at the start of the Place field should be moved to the Address field.  Obviously this specification would have to apply either to all records or to a specified subset of records, e.g. if you could specify which records need one rather than two Place parts moved.  It might be easier to specify how many parts at the end of the Place field should be retained, with the remainder moved to the Address.

Obviously you should experiment with a copy of your data until satisfied with the result.

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

Moving Place data to Address Field

Post by tatewise » 23 Nov 2012 22:35

Now that is an interesting challenge !

The one thing you cannot do is transfer entries from Tools > Work with Data > Places to Tools > Work with Data > Addresses as these are simply a summary of what is currently in all the Place and Address fields.

The solution partly depends on how organised, or disorganised, the Place data is, and how many different entries exist in Tools > Work with Data > Places.

I suspect the best initial option is to write a small Plugin to copy every Place field to its associated Address field.
If the current Place data is in organised Columns, then some left-hand Columns could be removed from every Place and some right-hand Columns removed from every Address during the copying process.

See Tools > Plugins > More>> > How to Write Plugins + How to Write Plugins and the rest of this help for starters.
See Plugin Code Snippets for coding ideas.

After that use Tools > Work with Data > Places and Tools > Work with Data > Addresses to refine individual entries further.

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

Moving Place data to Address Field

Post by tatewise » 24 Nov 2012 00:09

The Copy Place to Address ATTACHMENTS Plugin below will copy every PLAC field to its associated ADDR field providing it's empty.

To manipulate only comma separated parts:
Use strText = fhGetValueAsText(ptrItem) to obtain Place string.
Use Split A Line Using A Separator i.e. tblPart = strText:split(',')
Then join the left-hand split parts together using strText = tblPart[1]..','..tblPart[2]..','..tblPart[3]
Use isOK = fhSetValueAsText(ptrAddr,strText) to save the result
To join right-hand split parts use strText = tblPart[#tblPart-2]..','..tblPart[#tblPart-1]..','..tblPart[#tblPart]
where #tblPart is the size of the table

avatar
jayef
Newbie
Posts: 2
Joined: 23 Nov 2012 20:21
Family Historian: None

Moving Place data to Address Field

Post by jayef » 24 Nov 2012 11:09

Mike

Thank you so much. What an excellent team is clearly on board here. Further vindicates my selection of FH

Something like that plugin is /exactly/ what was in the back of my mind and I have enough programming background to get my head round it and tweak if required. It would have taken me some time to generate myself from a standing start (but you have whetted my appetite!)

When I have the data duplicated it should be fairly straightforward to edit the two fields, probably using the Work With Data tools. I had deduced, as you confirm, that it was not possible to use this facility to transfer data between the fields.

Thanks again for such a prompt and helpful response (and Peter for your insight also)

Post Reply