ARUtilities also has a diary field editor. But the arx method works and is free :)
You can safely (if I am wrong please correct me) replace parts of a string in a diary field at the db level. Where issues can come into play is where the diary field entries for a record start and stop. In your example with an SSN say the diary field has the string "customer's SSN is 111-22-3333." You could update it to "customer's SSN is xxx-xx-xxxx.". This comes with all of the normal warnings when you make changes at the db level. Jason On Wed, Apr 21, 2010 at 2:24 PM, LJ LongWing <lj.longw...@gmail.com> wrote: > ** > > Agreed, > > > > On the side note. There are programs out there, one I keep handy is called > ‘Diary Editor’….allows editing of diaries….it’s unsupported, but uses > supported API calls….works good J > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Rabi Tripathi > *Sent:* Wednesday, April 21, 2010 3:07 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Logic in active links vs. filters > > > > ** > > Hmm...lets see. > > *Database* (old) value of a diary field, nothing/nobody can change. > > *Transaction* value (valued added this time) of a diary field: > With an Active Link, you CAN change anything, such as wipe it out, add to > the beginning of it. > With a filter you can only add to the end. > > Agree? > > Side note: if you really have to change old contents of a diary field on a > record...what do you do? > Say somebody put a social security number (if you're not in the US, that's > sort of a not so secret number assigned to everybody that everybody tries to > keep secret anyway) in the work log diary field and some higher up is mad? > This actually happened one time. > > Messing with database is...messy. The easiest solution (that somebody else > came up with), was to export the worklog (and entry id) in arx format. Edit > the exported file in a text editor, import it back. Done. > > On Wed, Apr 21, 2010 at 4:48 PM, LJ LongWing <lj.longw...@gmail.com> > wrote: > ** > > Cool….I just wanted to make sure you weren’t saying/thinking that you could > replace the entire contents of the diary via AL J > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Rabi Tripathi > *Sent:* Wednesday, April 21, 2010 2:26 PM > > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Logic in active links vs. filters > > > > ** > > LJ, you're not off base. That's exactly what I meant. > > On filters, if you do a set field on a diary field such as: > Diary Field = "new string" + Diary Field > Diary Field = "new string" > > The result is as if you had done > Diary Field = Diary Field + "new string" > > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
