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 > _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"
