It appears I don't have sufficient permissions to see the link you posted. Is this restricted to certain people? I would find it helpful to see your sample data. Thanks, Mark
________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kelly Deaver Sent: Saturday, January 31, 2009 7:50 AM To: [email protected] Subject: Re: ARS 6.3 and Remedy Helpdesk 5.6- what to do next . . . ** 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:[email protected] <http://email.secureserver.net/compose.php#Compose> Web: http://www.softwaretoolhouse.com <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:[email protected] <http://email.secureserver.net/compose.php#Compose> ] 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 <http://www.arslist.org/> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" __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"

