Re: ITSM Company Name Change Challenge
After playing with the RRR|LoginConvert tool for a little while, I've encountered an issue. When running it on a Windows 2008 R2 Standard server with ARS 7.6.04 SP1, it crashes on certain forms. Among the forms we've found that it crashed are AAS:Activity, AAS:CFG Rules, HPD:Help Desk and AAS:WorkInfo. It will crash consistently on these and other forms. We are running it with the -noupdate and -nodiary flags. We've tried a few different combinations of flags as well. This is a crash report: Problem signature: Problem Event Name: APPCRASH Application Name: rrrLoginConv.exe Application Version: 1.0.0.0 Application Timestamp: 4cf31f18 Fault Module Name: ntdll.dll Fault Module Version: 6.1.7600.16915 Fault Module Timestamp: 4ec49d10 Exception Code: c005 Exception Offset: 00032a10 OS Version: 6.1.7600.2.0.0.272.7 Locale ID: 1033 Additional Information 1: 0a9e Additional Information 2: 0a9e372d3b4ad19135b953a78882e789 Additional Information 3: 0a9e Additional Information 4: 0a9e372d3b4ad19135b953a78882e789 Has anybody else seen this? Any ideas on how we can work through this? This tool seems to do what we want, otherwise. Thanks, Tiffany Alexander On Tue, Aug 20, 2013 at 2:00 PM, Misi Mladoniczky 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 a
Re: ITSM Company Name Change Challenge
Thank you, LJ and Misi! This looks like just what we need! On Tue, Aug 20, 2013 at 2:00 PM, Misi Mladoniczky 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"
ITSM Company Name Change Challenge
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"