I once did something similar with the older version of ITSM (when it was Viadyne owned) using a stored procedure, but if there is a tool out there (RRR) might as well use it instead of reinventing the wheel. The script took me over a good couple of days to write as it took me quite long to take an inventory of all the forms that have fields that have Company Name or the ID in them, and then write the SQL stored procedure to replace the name.
Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj Sent: Tuesday, August 20, 2013 1:47 PM To: arslist@ARSLIST.ORG Subject: Re: ITSM Company Name Change Challenge ** 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_ _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"
