Bulk Update??

uktony · Post by **uktony** » 14 Jul 2011 19:22

For some months now, I have been recording 'residence' and attributing it to the contents of the census info I have found. I now want to change my mind and record such 'residence' as a census indicator.

Is it possible to run a database wide script to say something along the lines of

' if residence > blank and attribute = census 1841, then replace residence fact with census fact.

If it is, what should the syntax look like?

Any thoughts and help appreciated.

Apologies if I'm not very good at saying what I mean.

Tony

ID:5238

YouTube · Post by **Jane** » 14 Jul 2011 20:30

Unfortunately Family Historian does not currently have a scripting tool built in, but as it uses a simple gedcom (text) file to store the information you can do a prompted search and replace on your file (as always make a safe copy first) and search for RESI all upper case and then you can replace it with CENS when you need to. I would recommend an editor like PSPad, and avoid work processing tools like Word.

uktony · Post by **uktony** » 14 Jul 2011 22:08

Thanks Jane

I'll give it a go.carefully!

uktony · Post by **uktony** » 15 Jul 2011 17:45

Jane

I can see that @S7@ translates in to my source Census 1851 (I changed one record to see what would happen).

Can I assume (before I go too far!) that S = source and 7 = record id and that @S6@ would equate to my 1841 census, etc. etc.

Presumably the @ is just part of the syntax.

Tony

YouTube · Post by **Jane** » 15 Jul 2011 17:55

Yes, @..@ is a record or a record link.

S = Source
I = Individual
F = Family
etc,

If you are changing them be careful not to change the actual record ID as well.

uktony · Post by **uktony** » 15 Jul 2011 18:00

[smile]

uktony · Post by **uktony** » 15 Jul 2011 20:28

All done

Thanks for your help

Family Historian User Group

* Bulk Update??

Bulk Update??

Bulk Update??

Bulk Update??

Bulk Update??

Bulk Update??

Bulk Update??

Bulk Update??