Ben, When you are doing an ad for your product, Please prefix with AD: or ADV: in the subject line.
I suggest you just show up at WWRUG09 in November and get a booth. Then you can show people live what it does and sell it there. .... Daniel -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ben Chernys Sent: June 26, 2009 8:05 AM To: [email protected] Subject: Re: How to export data (PROCESSES) from BMC Remedy User tool No worries Rick. Indeed that was the point that Axton was trying to make. I know the point well as I've done had to do many of these tasks myself. The only problem with your approach you suggest is that the original problem of incorrect references in the data is not addressed. To extend your idea to handle that would require importing into staging forms and all the necessary filters to push to the real forms, or, of-course, using the API. IF and only if you maintain request ids, then this step could be avoided. Otherwise, you'll be faced with either the API or the above development project. I have found maintaining Ids across systems to be virtually impossible once systems go live. To whit, see the Data Management Tool to load foundation data. This is a huge tool with an inordinate number of forms and filters and took a horrendous amount of time to develop and comes with its own set of patches and fixes. All this just to load data into an application? Yes, the API would solve the problem nicely. But that carries the requirement to have a programmer - most ARS administrators are not programmers - and costs and time associated with maintaining source code. With Meta-Update, any ARS administrator/developer/consultant can develop API level scripts in very short order. Many scripts are already developed. It is this development time that Meta-Update saves. In addition, Meta-Update is replete with value transformation functions in its assignments, including a LookUp facility, a regex pattern extracts, SQL, ARS queries and the like. It can read CSV files that Excel or the BMC Import tool cannot. It can export CSV files and other files. All these result in a company gaining incredible control over ITSM foundation and other data with minimal development. Why don't you take a look yourself? Cheers Ben _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

