Technically you could do this from under the covers, using an SQL script and thus skip all the BS, but it would not be 'recommended' by support should something go wrong, so its not something that someone with just average DB scripting and ARS data relationship knowledge should attempt..
Joe ________________________________ From: Jason Miller <jason.mil...@gmail.com> To: arslist@ARSLIST.ORG Sent: Tue, July 20, 2010 3:05:05 PM Subject: Re: Updating People Records issue ** I wonder though, could you import records into the appropriate forms to have the name change processed? I have seen people mention where they have automation that populates the CTM Load forms to create new people records (we plan on doing this with Meta-Update) but I am not sure how different the Data Wizard is from the Data Load Wizard in this respect. Jason On Tue, Jul 20, 2010 at 11:00 AM, Boyd, Rebecca E. <boy...@wfu.edu> wrote: ** >FWIW, look at the Data Wizard Console under the Application Administration >Console > Foundation > Data Management Tool. > >Person Name is one of the items that can be changed with this tool. This isn’t >feasible for a mass update like you have, but you could use it to look at the >workflow BMC designed for name changes. > >Rebecca > > >From:Action Request System discussion list(ARSList) >[mailto:arsl...@arslist.org] >On Behalf Of Vianna Vianna >Sent: Tuesday, July 20, 2010 1:31 PM >To: arslist@ARSLIST.ORG > >** >Thanks Joe. So do you recommend against me doing an export from and import to >the User form with the full name modified to proper case to match the >People form? Also in the CTM: Support Group Association form? I just don't >want to modify the work flow right now because the data feed has been stopped >so >I only need to do a one time bulk update to correct the records. > >Thanks again for your response > >Vi > > ________________________________ >Date: Tue, 20 Jul 2010 10:09:53 -0700 >From: joe_rem...@yahoo.com >Subject: Re: Updating People Records issue >To: arslist@ARSLIST.ORG > >** >Vi, > >It is as designed.. The Full Name gets populated only when it is NULL by >concatinating the values of the First Name, Middle Initials and Last Name.. > >If you want to change that, you will need to customize the out of the box flow >to set the full name even when not null to what it does out of the box.. > >Cheers > >Joe > > ________________________________ >From:Vianna Vianna <vianna...@hotmail.com> >To: arslist@ARSLIST.ORG >Sent: Tue, July 20, 2010 10:25:52 AM >Subject: Updating People Records issue > >** Hello >We're using ITSM 7.5. We had an integration feeding our people records which >corrupted a majority of them and overwrote them with some bad data. One of >the >issues we had was the system modified the First name and Last name to all CAPS >rather then proper case. We've since disconnected the external feed and I >exported the people data, modified the First & last names to proper case and >reimported it. I suppose I should have made the change in the user form >instead >as now the people form and user form are inconsistent as the FULL NAME in the >user form remains as all caps where as the first and last name in the People >Record is now proper case. I'm wondering if anybody can suggest how to >correct >this? Should I modify in the user form as well and are there any other forms >feeding support group etc. that I should modify. Will that cause a problem for >existing tickets that are assigned to people who's name is in different case? > > >Any suggestions will be very appreciated. > >Thanks > >Vi > >Subject: Re: Updating People Records issue _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"