I also haven't had to do this but it is NOT impossible. I regularly manipulate all foundation data with Meta-Update. Renaming a company just involves more queries and updates. SQL could do it - at a significant development cost. As could Meta-Update - at much less development cost. But as I have not had to do it I have no scripts ready for it. And as you have already the plan to put four people on it Friday - and it is very late here - and Germany has just beaten Turkey (is civil war about to break out?) in the EU football semi-final - and there is soooooo much noise on the streets, I cannot write such a script in time. Good luck. PS: I agree with Axton. This is what you get for using such a key! /Ben www.softwaretoolhouse.com
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierson, Shawn Sent: June 25, 2008 7:28 PM To: [email protected] Subject: Re: Renaming a company in ITSM 7 ** I'm fortunate in that I haven't had to do this yet. However, if I did, I would probably do it all in SQL via a stored procedure. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McClure, Don Sent: Wednesday, June 25, 2008 10:23 AM To: [email protected] Subject: Re: Renaming a company in ITSM 7 ** Hi-posting information for the University & Christopher Strauss across the hall: Short Version: No way to change a company name once configured (because full fan-out is impracticable). Full Details: first-where a new company structure is required for any reason, I created the new company/groups/organizations, then moved effected support staff to the new company. Ensure that both home organization and support-group relationships are established to new company, and severed from old company. second-I de-activate the old company (probably 'offline'). third-modify/validate relationships for location, categorization(s), assignment/ownership rules. In the case of an already configured company where Incidents/Change Requests are present: they bear the old company name. We have not found a convenient way to migrate those records to the new company, short of a utility from BMC (hinted at, but not yet available). And, our policy for foundation items in current operation: We can create new items for foundation structures; but will not even try to modify old items for: companies support groups organizations categorizations locations and probably some other foundational goodies I do not currently recall. So, any Incidents/Problems/Changes which were related to the old foundation data, will remain so. Don W. McClure, P.E. Data Administrator & System Engineer Computing & IT Center, Call Tracking Administration University of North Texas, Denton dwmac_at_unt.edu "That which counts cannot necessarily be counted: that which can be counted will not always count." -- Albert Einstein From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Wednesday, June 25, 2008 10:07 AM To: [email protected] Subject: Re: Renaming a company in ITSM 7 ** Ah, ok J no problem! _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, June 25, 2008 10:06 AM To: [email protected] Subject: Re: Renaming a company in ITSM 7 ** Sorry, I meant Chris Strauss, who said he has already done this. ;-) Was hoping he had some insight on any gotchas that the rest of us could benefit from. Rick On Wed, Jun 25, 2008 at 7:48 AM, Moore, Christopher Allen <[EMAIL PROTECTED]> wrote: ** Rick, I didn't have any specific concerns- just trying to do this in a non-tedious way. As I can see it (and the way I've been told this was done here previously) is that a new company is created, people who belong to the 'old' company are set to the new company, tickets are set to the new company, and user access restrictions are set to both companies (in case something was missed). We're doing it Friday- there are four of us working on it- one for each company that needs to be renamed, so it hopefully won't take too long. Thanks! Chris _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, June 25, 2008 9:40 AM To: [email protected] Subject: Re: Renaming a company in ITSM 7 ** Seems like there ought to be a way to quickly export, modify, and import the config data with the new company name in it, and that it wouldn't take all that long to create. Chris, did you use some automated setup for this; perhaps one of the ITSM data import utilities? Or are there other concerns that that approach would miss or mishandle? Rick On Wed, Jun 25, 2008 at 7:23 AM, Moore, Christopher Allen <[EMAIL PROTECTED]> wrote: ** Thanks Rick- that's what I figured but I figured it was worth asking. Chris _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, June 25, 2008 9:20 AM To: [email protected] Subject: Re: Renaming a company in ITSM 7 ** The only other option is to create a nickname for the company, and use that. I remember them telling us to do that in class, because you can change the nickname whenever you want with no real impact, but you cannot change the name without having to redo your entire config data, because all of the records for Company A have that hard-coded in them. Rick On Wed, Jun 25, 2008 at 7:03 AM, Moore, Christopher Allen <[EMAIL PROTECTED]> wrote: ** Hey everyone- I've been asked to look into renaming a few companies in our system. It's not something you can just do from the company form obviously.has anyone had any experience trying this? Will I just end up having to create new companies and setting all the people associated with the old ones to the new companies? ITSM 7.0 Thanks, Chris __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Private and confidential as detailed here <http://www.sug.com/disclaimers/default.htm#Mail> . If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
