That's something I may need to do too as its not a 1 rename if I have to do it. It would be a multiple rename.
I prefer SQL too as its quicker and doesn't touch timestamps - not that timestamps is very important in this case but nonetheless.. I've never used the Data Wizard before for anything and only heard of its features so am hoping it would tell me enough of where to go to do what and I can take back enough with me to build a small script for that change if its deemed necessary.. Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Janie Sprenger Sent: Monday, August 04, 2014 5:50 PM To: [email protected] Subject: Re: Impact of renaming Sites in ITSM 7.6.04.. ** We did this in 8.1 and opted to use SQL to do so. We considered an Atrium Integrator job and also the Data Wizard. While the data wizard feature allows you to rename one at a time, we had 140 sites that had to be updated to include a translated site name in a foreign language. We used a series of SQL searches and Data Wizard investigations to find all the tables where the site name was located, generally based on the field id. We don't have SRM installed and came up with 38 forms, 5 of which we actually had data in them. After we wrote and tested the scripts, we had some pretty basic usability tests that we put into place, all of which passed when we tested them. hth, Janie On Mon, Aug 4, 2014 at 10:29 AM, Joe D'Souza <[email protected]> wrote: ** Has anyone gone through the exercise of renaming Sites for whatever reasons? I would like a comprehensive list of forms (both foundation and other ITSM/CMDB application data) it has an impact on? I may not have to actually do it, but I see it as a possible solution to an automatic feed of new SIT:Site data that we have a requirement for to reconcile older Site Names to new ones that may be created now or in the future so a duplicate won't occur. Joe _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
