Thanks, Chris - good info as always. One correction - the EffectTech data load solution DOES offer the people/permission groups import, but only in the advanced solution that you pay for. The free download doesn't do that. I am told that they are working on a number of enhancements to the advanced product that will make the entire data loading process easier to do both from a startup and an ongoing basis.
Rick On 11/14/07, strauss <[EMAIL PROTECTED]> wrote: > > 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: arslist@ARSLIST.ORG > > 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"