**
The Data Management tool is no longer one 26 sheet Excel File.
 
For ITSM 7.0.3 customers it is a patch that contains around 13-14 workbooks, each covering a topic like company, people, location, etc. Once you get data in the workbooks, there are macros to convert the workbooks to CSVs and an ARSystem based console from which you run a command that imports the CSVs in to staging tables. From here the data can be validated with pretty good messaging that tells you what you need to fix before it goes in the destination tables. You can do the fixes right there in the staging tables. No need to fix in the Excel and repeat the whole process. Once all the data is validated, you click one button and the data is populated in to all the forms. This is known as Patch 9005.
 
For ITSM 7.5 the patch has moved in to the product and is now called Data Management. It has grown to 26 workbooks and covers everything from foundational data like before through templates, rules, all the way up to incident/problems/changes. The same basic concept of the workbooks > csv > staging > promotion exists. It has been enhanced even beyond the additional workbooks. Now the macro conversion is also a one click step. There is a license checker to see if you have enough licenses to add what you were planning to add even before you add the people. Complimentary to this function the Data Management utility also has a feature called Data Wizard. It will search out and CHANGE the value of certain existing data - Company, Login, etc. Very handy if there is an aquistion and you need to change your company name, someone decides the corporate logins should go from 8 char first initial and 7 char of last name to some numbering scheme. There is so much more.
 
Added bonus - instead of staring at blank copies of these forms and trying to figure out "what on earth did BMC mean by {insert criptic field name here}?" there are a set of workbooks available with our sample data in them already. Every tab is filled in so you can follow the flow. You can download these workbooks and have a look without even having ITSM 7.5! It might help you as you are beginning to consider the move. We hope it makes life easier rather than trial and error. This can be found at http://developer.bmc.com/communities/docs/DOC-5882
 
Kelly Deaver
[email protected]
(Yes, I work for BMC. This post reflects the opinions of the poster and not the official opinion of BMC)
 
 
-------- Original Message --------
Subject: Re: ARS 6.3 and Remedy Helpdesk 5.6- what to do next . . .
From: Ben Chernys <[email protected]>
Date: Fri, January 30, 2009 12:54 pm
To: [email protected]

Well. There are two parts to this question:

1) the ITSM 7 Implementation
2) the data transfer

There should be some history on this list for ITSM 7 Implementation Costs.
ITSM 7 Implementations tend to be long and with a high cost. The ITSM
product is itself expensive.

Implementations can be short but that is a very rare circumstance.

The Configuration data spreadsheet alone is a daunting task. This is part
of the Data Management Tool. It's a 26 sheet Excel file where you define
companies, support groups, roles, people, assignments, approvals,
categorizations etc. You need to manually ensure the records are correct
whilst filling this out. I've seen 3 months personally and I attended a RUG
where it was stressed over and over again to "not underestimate the effort
involved in the foundation data".

Again, there will be plenty of different examples of upgrades on the list
and really you would need to establish a survey of sorts to guestimate
costs. The three month effort above had about a 9 month * 6 consultant
effort. I was hired only to migrate the data for a fixed price and am not
counted in that effort.

My current project is a new implementation with no data migration whatsoever
but many custom classes and some customisations in a complex server
environment. That effort is about 10 people * 8 months counting managers,
java developers, students, etc. Total ITSM 7 development staff 3.

It IS expensive. And that generally does NOT include data!

2) The data transfer is not always needed and is impossible to do with the
current crop of tools. It is also something I specialise in and sell a tool
that can completely automate that transfer. I also offer fixed price
transfers after an initial chargeable consultation which leads to a data
summery and migration plan.

For the above company, the production system went down on a Friday evening
and I ran my Meta-Update scripts over the weekend. On Monday, ITSM 7 was
(almost) fully loaded and all tickets and changes were in the right state to
continue to be worked on by the same people in completely different groups
and structures. This was a customised ITSM 6 -> 7 migration.

Another client implemented his own migration scripts with an off-shore team
and completed a customer by customer migration of a "heavily customised"
ITSM 5.5 to ITSM 7 set of scripts in less than three months.

IF and when you need to move data, I'd be willing to provide a one hour
conference call to introduce Meta-Update and our migration service to you.


Cheers
Ben Chernys

Senior Software Architect
Software Tool House Inc.

Canada / Deutschland / Germany
Mobile: +49 171 380 2329 GMT + 1 + [ DST ]
Email: mailto:Ben.Chernys@softwaretoolhouse.com
Web: http://www.softwaretoolhouse.com

A free notepad for Diary fields:
http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm
An ARS API scripting tool used for migrations, integrations, imports,
reports, extracts, batch jobs:
http://www.softwaretoolhouse.com/products/SthMupd





-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brad Terhune
Sent: January 30, 2009 6:38 PM
To: [email protected]
Subject: ARS 6.3 and Remedy Helpdesk 5.6- what to do next . . .

Hello list!
I'm going to go ahead and throw it out there- my ARS is a total dinosaur.
I'm running ARS 6.3 on Windows Server 2003 on a remote Oracle database. We
now have a Remedy Helpdesk application that is on version 5.6.

Overall I'm pretty happy with the system except for the support costs.
I have not had to go get any support for the product for almost 18 months
though I still pay for it.

And now, the rub. I have no idea what ARS 7 much less ARS 7.5 looks like,
or what it costs. I'm pretty sure there is no longer a Helpdesk
application.
And I am dreading doing an upgrade, and I'm not even sure what we'd have to
pay to make one happen.

Has anyone moved from ARS 6.3 and Helpdesk to the new ARS and some other
Helpdesk-like product? How did the costs change? Was it very difficult?

I only have basic support through BMC so I'm having trouble getting the
information I need though I will be calling them this afternoon to find out
what my options are.

They certainly did not have a problem selling me support this year . . .

Thanks,
Brad Terhune

____________________________________________________________________________
___
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"
__Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___

Reply via email to