Fine... I looked it up for you. I was pretty sure it was in 7.6.04 but don't have that version system handy. Pg. 91 of the 7.6.04 Data Management Administration Guide talks about the Data Wizard.
Jason On Wed, Jul 16, 2014 at 2:16 PM, Joe D'Souza <jdso...@shyle.net> wrote: > ** > > That’s an 8.0 Wizard isn’t it? Is something like that available for 7.6.04? > > > > Sure if the documentation of that Wizard, speaks of all the forms it > changes, we might be able to use that information to create something for > 7.6.04 – assuming that those forms exist on 7.6.04 too, else we may have to > rely on SQL to find all forms that have the Company name set to a field and > then change it from behind API layer. > > > > Joe > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller > *Sent:* Wednesday, July 16, 2014 4:07 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Company Name change in ITSM 7.6.04... > > > > ** > > Hey Joe, > > > > Have you looked at the Data Wizard? > > > > https://docs.bmc.com/docs/display/public/itsm80/Overview+of+the+data+wizard > > > > Here are some screenshots I took from our Dev (has an orange skin) that > shows you can rename a company, the forms it touches and the record counts > in each form. > > > https://docs.google.com/document/d/1fNwkJPuAdzGmUngGk5GNaIS7RuixSNylIUBogaUn65E/pub > > > > Jason > > > > On Wed, Jul 16, 2014 at 12:15 PM, Joe D'Souza <jdso...@shyle.net> wrote: > > ** > > Has anyone attempted this successfully? If so do you have a whole list of > places where this name might be needed to be changed? > > > > I have noticed that the design of the ITSM application is not very > consistent about where it uses the Request ID (Entry ID or Field 1) or > instanceID or some GUID to relate such data and where it uses something > like Company Name itself to relate data. For e.g. in the SIT:Site Company > Association table, it looks like the Company Name is used in the > relationship, while in some other places either the Company Entry ID or the > instanceId is used. > > > > This could mean that a name change could possibly break a few data > relationships, if the name change doesn’t propagate to all the forms that > use the name in the relationship.. > > > > Does anyone have a complete list of forms where this relationship might be > broken in the event one needs to change the Company Name? I’m suspecting > there is no OTB workflow, which would propagate this change to all forms > that might need to reflect this change. > > > > > > > > A simple SQL search show 737 forms that have data fields that Company in > the field name where the field is a data field. > > > > SQL> select count(*) from aradmin.arschema where schemaid in (select > schemaid from aradmin.field where fieldname = 'Company' and fieldtype = 1) > order by name; > > 458 > > > > SQL> > > SQL> select count(*) from aradmin.arschema where schemaid in (select > schemaid from aradmin.field where fieldname like '%Company%' and > fieldtype = 1) order by name; > > 737 > > > > > > Regards > > > > Joe > > > > PS: Does ITSM 8.x handle name change of a company better than 7.6.04?? > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > _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"
