Ben:
Please send to my office address.
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys
Sent: Tuesday, May 02, 2006 8:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: Importing to CMDB w/ correct Relationships
Meta-Update is well suited to perform the function you desire. Further,
developing a reliable CMDB import is at least an order of magnitude faster
then with any other method. Period.
I have a presentation available that describes how it was done in one
heavily modified case of the CMDB.
Meta-Update also handles "difficult" CSV files:
Think of a CSV with a field value containing an embedded line feed as in
"some field value","another value","status value","some data value
that continues
and finally ends","more fields"
Meta-Update will handle this no problem and the data will be inserted into
ARS correctly containing the <nl> character. Neither the ARS import tool
nor Excel, can import files like this.
Meta-Update will also allow you to translate the "status value" to match
those used in the CMDB and optionally to either create addition records
depending on a specific status or say ignore records during import for some
specific statuses.
Meta-Update can be thought of as a scripting language for the data portion
of the API with robust import file handling capabilities.
For the CMDB, as long as an ARS query can be formulated to pull both assets
belonging to a relation, the relation can be built.
So, say in the simple case the Asset ID field value will contain the
original (legacy / import) data record key, then say we are processing a CSV
of relationships amongst asset IDs, building a Relation would be quite
simple:
[BuildRelation]
File = Input, File-Decl, $Arg, Input-File$
LoadQ = Parent, BMC:BMC_AssetBase, 'Asset ID' = "$Input, ID_Parent$"
LoadQ = Child, BMC:BMC_AssetBase, 'Asset ID' = "$Input, ID_Child$
Update = Update, BMC:BMC_Component, &
'GroupComponent.InstanceId' = &
"$Parent, InstanceId$" AND &
'PartComponent.InstanceId' = &
"$Child, InstanceId$"
In the above case, when a record will be created (or updated) in the
BMC_Component schema, the two AssetBase records are available for
assignments of values thereby allowing you to link through the GUID
(InstanceId or 179) fields and to specify the correct classes in the
Relation record.
Further, using Meta-Update, you can import data from a CSV selecting the
correct CLASS and target schemas on a record by record basis using data in
the CSV field set. You can also fill in hidden fields as required including
the class names for categorisation subclasses and so on. You can make
conditional assignments based on selected classes or based on import csv
field values.
You can also, as a result of a single CSV, update or create related sets of
records in different schemas.
Meta-Update produces an error log, an ID log of all actions (queries and
updates), optional full tracing including ARS client tracing), and a copy of
the CSV containing only those records that resulted in an error.
This process is being run heavily over and over with many records for an
international global company.
I do have a presentation on this usage of Meta-Update and will be willing to
email it off-line - and possibly deliver it remotely - to interested
parties.
Please email me off-line for further information.
Ben Chernys
Senior Software Architect
Software Tool House Inc.
Canada / Deutschland / Germany
Mobile: +49 (0162) 175 0956 GMT + 1
Email: mailto:[EMAIL PROTECTED]
Web: http://www.softwaretoolhouse.com
A free notepad for Diary fields:
http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm
An ARS integration, import, batch, and API scripting facility:
http://www.softwaretoolhouse.com/products/SthMupd
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of [EMAIL PROTECTED]
Sent: May 1, 2006 7:06 PM
To: arslist@ARSLIST.ORG
Subject: Re: Importing to CMDB w/ correct Relationships
Chris,
You may want to build a small app that consists of a form that contains all
the fields of the spreadsheet that you would import the spreadsheet into.
Providing the spreadsheet has information regarding the relationships
between assets, you could build workflow that would push the asset info to
it's proper class. Now, how to determine which class an asset goes into is
another story. It may be on the spreadsheet: that's the easiest way. Or
there may be some other way of determining that through workflow.
Once the asset records are built, run an escalation to build the
relationship records. If there are people relationships, they can be built
at this time as well.
Then at monthly intervals, you could just repeat the process.
Regards,
Thomas Worth
IT Prophets, LLC
732-674-4042
[EMAIL PROTECTED]
Original Message:
-----------------
From: Christopher Gillman [EMAIL PROTECTED]
Date: Mon, 1 May 2006 08:02:59 -0700
To: arslist@ARSLIST.ORG
Subject: Importing to CMDB w/ correct Relationships
Listers,
I'm trying to see if anyone has succesfully come up with a good way or
"defined process" to import monnthly data with various information (i.e.
memory modules, computer servers, etc.) into CMDB 1.1 Patch 2. The client
has a spreadsheet which contains information that is inputted by other
groups monthly, and then needs to be imported into Remedy's CMDB with the
correct relationships to corresponding asset classes. The client used to
be an ARS 4.5 customer, and upgraded to 6.3 w/ CMDB late last year. Is
there any easy way to take data from a csv imported into CMDB and get the
relationships set up correctly? Any info or "success stories" would be
greatly appreciated. Thanks
v/r
Chris
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
