Thanks Mark, That's not specifically how we gathered the data,,, :( so I'll have to figure that out.. they loaded the people and put in what permission groups they should belong to...
so this is definitely going to be a challenge... :( thanks for your feedback Mark! Mary On Wed, Mar 18, 2009 at 8:43 AM, Mark Lev <mark....@rightstarsystems.com>wrote: > My understand is if you're going to make the person a support person, then > there must be an associated template, either in Remedy already, or in the > spreadsheets. > > This is because workflow will not allow a new person to be saved as a > Support Person, if they don't have proper permissions, roles and Support > Groups associated. > > We created the templates prior to import, so we could test accuracy and > eliminate side effects of importing both at the same time. > > I think BMC Support misstated in that you do not need them if Support > Person is No, but you need templates if Yes. > > I hope that clarifies. If not, let me know. > > Thanks, > Mark > > Mark Lev > Sr. Systems Consultant > 703-672-4390 > 732-859-5827 (cell) > mark....@rightstarsystems.com > ----------------------------------------------------------- > RightStar Systems, Inc. > 100 East Street SE, Suite 202 > Vienna, VA 22180 > USA > ----------------------------------------------------------- > > ________________________________ > > From: Action Request System discussion list(ARSList) on behalf of Mary > Dollus > Sent: Wed 3/18/2009 8:04 AM > To: arslist@ARSLIST.ORG > Subject: Fwd: Data Management Tool Error > > > ** > Hi Mark, > > You're welcome,,, I have a question for you,,, you're beyond the point > where I am with the tool and I have a question regarding the spreadsheets > themselves; specifically People.xls. For tab 03 CTM-PeoplePermissionGroups, > do you have a Template Name specified on there? When I talked to BMC about > this Monday they said if we didn't use any of the tabs, such as templates, > then don't worry about the tab,,, so that would mean we could skip tab 01 > CTM-PeopleTemplate. however in reading the admin guide,,, it says to add > support people you have to use Templates... ? so I'm thoroughly confused... > > any insight you can shed on this would be awesome. > > thanks!! hope you're having a great day... > > Mary Dollus > SAIC > > > ---------- Forwarded message ---------- > From: Mark Lev <mark....@rightstarsystems.com> > Date: Tue, Mar 17, 2009 at 8:48 PM > Subject: Re: Data Management Tool Error > To: arslist@arslist.org > > > ** > Thanks Mary, > > I will see if I can find a machine to do this on. We have a work around, > by manually importing the CSV into the staging forms, so all is good. > > Thanks, > Mark > > > > > ________________________________ > > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] On Behalf Of Mary Dollus > Sent: Tuesday, March 17, 2009 6:50 PM > To: arslist@ARSLIST.ORG > > Subject: Re: Data Management Tool Error > > > ** > Hi Mark, > > Sorry if you already got a response to this and I'm repeating it. I just > had this issue today and I was told that it will work if you fall back to > the 7.0.01 patch 004 Admin tool... just put it in a different directory so > you don't wipe out the settings for your current patch. > > Mary Dollus > SAIC > > > On Fri, Mar 13, 2009 at 10:15 AM, Leonard Neely - FOJ < > lne...@focusonjobs.com> wrote: > > > ** > > Mark, > > > > What version on Data Management tool (DMT) are you using? Make sure > that there are no extra columns at the end of the spreadsheet templates you > are importing. > > > > Leonard > > > > From: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] On Behalf Of Mark Lev > Sent: Friday, March 13, 2009 7:37 AM > To: arslist@ARSLIST.ORG > Subject: Data Management Tool Error > > > > ** > > Hello, > > > > I am having a problem with Data Management Tool, and was hoping > someone could help. > > > > ARS 7.1 > > ITSM 7.03 > > Windows OS > > SQL Server > > All latest patches > > > > Error occurs when trying to Import CSV Files. The convert worked. > > > > Following is the error: (I've xx'd out the password) > > ... > > <ACTL> Checking DLD:DIP:Import_ProcessBatch (100) > <ACTL> -> Passed qualification -- perform if actions > <ACTL> 0: Set Fields > > <ACTL> Process: "C:\Program Files\BMC Software\BMC > Remedy ITSM Data Management Tool\Data Load\Import.bat" > C:\Program?Files\AR?System\Admin > C:\Program?Files\BMC?Software\BMC?Remedy?ITSM?Data?Management?Tool Skittles > CTM-LoginID 2693 0 ? xxxx Foundation > <ACTL> z1D Char02 (1000000066) = **** > > **** Unable to load mappings from file. > > 1 > > ... > > I would greatly appreciate anyones help. > > > > Thanks, > > Mark > > > > __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > html___ > > __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > html___ > > > __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ > __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ > > __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"