Hi Chris, I built a little app that basically uses the native unique identifier to create the relationships. What I mean by the native unique identifier is whatever the tool that is furnishing the information uses. That identifier is stored as the Asset ID. I have a relationship builder form that takes the unique identifiers for each side of the relationship, does a query against the specified form, returns the CMDB unique identifier and then pushes out to the appropriate relationship table.
Hope this makes sense. Not a real fancy solution but it seems to work and is really simple. Jack -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Gillman Sent: Monday, May 01, 2006 8:03 AM 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
