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: [email protected] 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
