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"
