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 <
> [email protected]> 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"
