the 25 tab workbook is REALLY old. You need to go to patch 9005 if you are on 7.0.3 ITSM or use the one that comes with the installer.
That old workbook had serious issues with templates.
You can either create the templates ahead of time, directly from the App Admin Console - simpler if you are not familiar with the process.
Or you can create the templates as part of the People.xls workbook.
Either way, you then link the people to the templates.
Kelly Deaver
(Yes, I work for BMC. This post reflects the opinions of the poster and not the official opinion of BMC)
__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___-------- Original Message --------
Subject: Re: Fwd: Data Management Tool Error
From: Mary Dollus <mdollus...@gmail.com>
Date: Wed, March 18, 2009 8:54 am
To: arslist@ARSLIST.ORG
**Thanks Kelly,,, :)I downloaded the templates,,, but am still a bit confused because this is a totally new dataload. Do I need to create the templates ahead of time,, before I do the dataload and then reference them?We originally gathered the data in the BMC Foundation Data Workbook, that 26 tab workbook. I didn't realize that was not being used any longer,,, so all of our data is in there and we need to move it to the spreadsheets used by the Data Managment tool.and of course,, it needs to be done yesterday.. :) so I need to come up to speed asap.thanks again for your reply...On Wed, Mar 18, 2009 at 7:58 AM, Kelly Deaver <kdea...@kellydeaver.com> wrote:
**If you already have the templates in your server, you can just reference the name of the existing template to create a support person. Otherwise, yes you need to use the templates tab.On the BMC Developer Network, there is a set of workbooks for ITSM 7.5 that have the data filled in - http://developer.bmc.com/communities/docs/DOC-5882 You can use these as a guide for how BMC intended the workbooks to be used or you can actually use them with 7.5. These set is not for use with 7.0.x/patch 9005. There will be a set specific to that version posted soon.Kelly Deaver(Yes, I work for BMC. This post reflects the opinions of the poster and not the official opinion of BMC)-------- Original Message --------
Subject: Fwd: Data Management Tool Error
From: Mary Dollus <mdollus...@gmail.com>
Date: Wed, March 18, 2009 7:04 am
To: arslist@ARSLIST.ORG
**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 DollusSAIC---------- 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:arslist@ARSLIST.ORG] On Behalf Of Mary Dollus
Sent: Tuesday, March 17, 2009 6:50 PM
To: arslist@ARSLIST.ORG
Subject: Re: Data Management Tool ErrorHi 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 DollusSAICOn 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.LeonardFrom:Action Request System discussion list(ARSList) [mailto:arslist@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.1ITSM 7.03Windows OSSQL ServerAll latest patchesError 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_____Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___
__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___
