Thank you, LJ and Misi! This looks like just what we need!
On Tue, Aug 20, 2013 at 2:00 PM, Misi Mladoniczky <m...@rrr.se> wrote: > Hi, > > Yes, it is called RRR|LoginConv: > https://www.rrr.se/cgi/tools/main?tool=rrrLoginConv > > It can do a dry-run that reports fields with occurrences of a specific > string. > > It will take some time if you do this on all forms in all fields though. > > You could maybe search for fields containing the string "comp" or something > like that, and then use RRR|LoginConv to scan those fields only. You might > even find some archive forms or similar that you will skip entirely. > > When you have found the fields you want to change, RRR|LoginConv can do a > merge-update of the records that need updating leaving > modify-by/modify-date > unchanged, and all filter skipped. > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > > > Tiffany, > > You may want to contact RRR to find out if this is possible...but they > have > > a tool named something along the line of 'Login Convert'....it goes > through > > all character fields in all forms (that you specify, I think you can have > > it just 'scan' and converts text string 'x' to 'y'....this may be > possible > > to use it to change your Company name in all records in all forms.....one > > way or another, this is a huge change, and will take significant time to > > change all of the values...but I think this may be an option for you. > > > > > > On Tue, Aug 20, 2013 at 11:27 AM, Tiffany Alexander < > > tiffanyaalexan...@gmail.com> wrote: > > > >> ** > >> Hello List! > >> > >> I've encountered an interesting challenge. > >> > >> The name of my company has changed. It is not optional that we change > or > >> remove all visible references to the old company name. This includes > the > >> company for all support groups, the company for all assets, the company > for > >> all products, the company for all people, etc. > >> > >> Our company name is the Operating Company in ITSM and most of our data > is > >> associated with it. We run ITSM, SRM, and SLM. All are version 7.6.04 > >> (either SP1 or SP2 depending on the module). Since the Operating > Company > >> is so pervasive, this is something we want to approach carefully. > >> > >> We researched the Data Wizard and we've tried it in a test environment. > >> The Data Wizard appears not to change all records (only enabled > records in > >> some cases). It does not touch all ITSM or SRM forms. It does not > update > >> SLM. We have also had issues with the Data Wizard hanging during simple > >> updates in the past, so we are tentative about this as an option. > >> > >> The other thing we have considered is hiding/defaulting the Company name > >> where possible rather than changing the Operating Company value. This > would > >> involve changing a large number of forms, modifying tiered menus > containing > >> Company, removing Company fields from auditing, and there are additional > >> considerations for menus where another company is a valid option as > well as > >> the Operating Company, such as with Products. This looks like a bigger > and > >> bigger project the more we look at it. > >> > >> We have limited resources and would like to minimize the time we have to > >> spend on this, and each option would involve significant time and > testing. > >> > >> So, List, we turn to you for ideas. Has anyone successfully changed the > >> company name with the data wizard? What issues did you run into with > it? > >> What options outside of this list do you see as viable? > >> > >> Thanks! > >> > >> Tiffany Alexander > >> Remedy Admin > >> > >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > "Where the Answers Are, and have been for 20 years" > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"