If it is bad enough, maybe you should load up the new data management application (ITSM Patch 9003) and export your data to match the spreadsheets, clean it up in the spreadsheets, then load a new installation of ITSM with it? We are planning to build our production 7 server that way, and will first test it by exporting data from our prototype server and loading it onto a test server to see if it works as advertised. It's brand new, so there will probably be some glitches (like the default client install is useless on a Vista workstation due to directory lock-down and Excel 2007 security), but if you have to start over on foundation data, that is what this tool is supposed to be for. The advantage would be that after you clean the data and load it into a fresh install of ITSM, you should be free of the records that are in error or obsolete that you can't easily remove in the current application. We are abandoning a lot of prototype Company and related data that we decided not to use by doing it this way, without (we hope) having to re-create everything manually. We were going to use the EffectTech solution, but it does not handle Support Staff/groups/permissions (which is most of the work); the new tool from BMC claims to import that data as well.
BTW, watch out if you have forms that were part of deployable applications and got lost somehow (I lost some Change Management join forms when uninstalling Approval Server 7.0.01 to install 7.1). They are basically IMPOSSIBLE to replace via either import or Migrator from a system that still has them installed correctly. I am now told that you should NEVER uninstall Approval Server once Change Management has been installed (no, it's not documented anywhere, but they did file a defect for that). If you have any problems with the basic laydown of foundation and application forms, you will need to reinstall - which makes the ability to reload the foundation and support staff data from files extremely valuable. I would rather rebuild from scratch than go live on a system that was covered with band-aids... Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Russell, James C > Sent: Wednesday, November 14, 2007 11:37 AM > To: [email protected] > Subject: Help zeroing permission/support group data in > ARS7.1/ITSM 7.0.02? > > Howdy listers! > > A blown migration between ARS 7.1, ITSM 7.0.02 (Unix/Oracle > to Win2003/SQL) servers has caused some interesting > company/support group/people permissions errors, and we'd > like to zero everything and start over (Re-migrating with > Migrator hasn't worked out correctly, and we need to change > support company structure, anyway). > > The problem...there are more background foundation forms for > this purpose than any number of sticks may be shaken at, so > far as I can tell. Not to mention those concerning > assignment, notification, aliases...the list goes on. > > Have any of you grand folks run across this before? If I had > a clean database image to roll back to, that'd be ideal...but > we don't have one that contains all the installed > applications without some corrupt data in (last time *that* > will happen!). We tried zeroing it by poring over forms and > deleting what we'd added, but miss a form here or there, and > it corrupts subsequent data entry. > > Just now, we're running across assignment problems--I did > find a load of bad/left over data in CTM:People Permission > Groups, and am fixing that. > Several other forms have already been 'fixed,' like > CTM:SYS-Access Permission Grps, and some have good data > already, like CTM:Support Group Associations (yet assignment > still fails). > > A small bit of past experience with this already suggests > that the problem with assignments and access restrictions > aren't going to be fixed with this data update, either..and > time is a-tickin'. > > Any ideas, suggestions, or advice is most welcome--if there > are any other details I can supply that would help, I'll be > more than happy to. > > Thank you! > > ~james > > ____________________________________________ > [] James C Russell 512.475.9262 | [] Remedy > Development Team 512.475.9400 | > [] The University of Texas, ITS | > [] [EMAIL PROTECTED] | > ~~ > > > > ______________________________________________________________ > _________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
