Absolutely. You can write a query as simple or complex as you wish to pull the source records. Then additional comparison queries against the target system (or a form on the same system) to make sure you ignore/update/create if an existing record is found or not. You also have the ability to suppress workflow so your data does not change as you are loading it into the new system/form.
Admittedly we are just pretty new to it and have not used it extensively. I have written a few semi-basic scripts to get started. One of them will look to our home grown inventory form for IT assets (old environment) and create CI's in the correct class (new environment) based on the CTI from the source record. You can do conditional statements and loops as well as get data from multiple sources (forms and even do a look up against Excel in the same run) to build the new "asset" record in memory and then load it into the CMDB. You can also use regex to manipulate data while "building" the new record in memory. In the past I have written AR workflow to perform some type of data manipulation/parsing. Depending on the complexity it can take quite a few workflow objects and display only fields. In more recent history I have been known to write scripts that I call from ARS to manipulate data and pass a value back. That still has advantages and disadvantages as well as some limitations. With Meta-Update I can do the scripting pieces with actual lines of code (vs temp fields and workflow objects) as well as interact with the AR server while running the script. We are still working on many aspects of our migration path from Help Desk 6 with a ton of custom apps to ITSM 7.6 and during our meetings where we discuss "migration opportunities" with our customers I pick out pieces of the process where I plan to use Meta-Update to help with the transition. HTH, Jason (Yes Dave, I am off to bed now (WWRUG humor)) On Wed, Oct 20, 2010 at 5:05 PM, Elry <[email protected]> wrote: > Are you finding it useful for data ETL JOBS? > > We have custom applications that need movement of a lot of data based > on record status. Have you it in this capacity? > > > On Oct 20, 4:21 pm, Jason Miller <[email protected]> wrote: > > We are a new customer and are just starting to use it for our transition > > from a ton of custom apps and Help Desk 6 to ITSM 7.6 (two different > > environment where data needs to be "translated" before being copied). > Just > > like many software purchases you would have to contact Software Tool > House > > for pricing though. I don't want to speak on their behalf when it comes > to > > license model and pricing. > > > > Jason > > > > On Wed, Oct 20, 2010 at 10:09 AM, Elry <[email protected]> wrote: > > > Has anyone used this product or know the pricing/llicensing scheme? > > > > > > ___________________________________________________________________________ > ____ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" > > > > > ___________________________________________________________________________ > ____ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
