TMG-L Archives

Archiver > TMG > 2008-08 > 1219539148


From: "John Cardinal" <>
Subject: Re: [TMG] Change data based on Flag
Date: Sat, 23 Aug 2008 20:52:28 -0400
In-Reply-To: <00c601c90195$58f92e50$640fa8c0@BKDesktop>


LadyBonita (USA) wrote:
> I just realized after I merged several of the databases that I have
> the wrong REFERENCE FIELD associated. Since there are almost 800
> individuals that are marked incorrectly, I was hoping there would be
> a way in TU7 to select based on a flag and then make a correction. I
> tried everywhere I could think (even Change Parts -- name and place)
> but found nothing. Am I missing a way to do this? If I had not
> merged all the datasets together I could go back and use TU7 to reset
> the PERSON FIELD ... unfortunately, I can not use the Find and
> Replace since there is also another 1000 people with the same
> REFERENCE number that should not be changed.

Bonita,

If you can make a data file that includes a record for each person whose
Reference field you want to change, then you can use the "Set Person Field"
feature in TMGU to do what you want. Assuming that you want person number
56, 57, and 81 to have the value "ABC" in the reference field, the data file
would look like this:

56<tab>ABC
57<tab>ABC
81<tab>ABC

Note that you would replace "<tab>" with an actual tab character.

You can make such a file by creating a "List of People" report in TMG and
using its filtering capabilities to limit the list to the people of
interest. Then use MS Excel to modify the list so that it has two columns as
shown above. Save the MS Excel file as a tab-delimited text and then use
that with TMGU.

See: http://www.johncardinal.com/tmgutil/setpersonfield.htm#stepbystep1

John


This thread: