Brian, I did just down load AIE, but I thought that I could only get data from another database. I didn't realize I could pull in data from a flat file too.
And I was already putting the data into my SandBox dataset. Thanks for the info. Lou Sent from my Verizon Wireless Blackberry ----- Original Message ----- From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG> To: arslist@ARSLIST.ORG <arslist@ARSLIST.ORG> Sent: Fri Jun 20 15:28:47 2008 Subject: Re: Trying to Load Assets into CMDB/Asset Inventory Another option is the Atrium Integration Engine. It allows you to map directly into CMDB classes as well as normal AR forms. It will map from flat files or other databases. I'm pulling asset data from SQL Server into Remedy. I would caution you however, the AIE is incredibly temperamental. But when it works it's really easy. I have found it a good idea to create a staging dataset from the CMDB console, and then setup a reconciliation job to move the data it into your production dataset. This allows you to import from multiple data sources and configure precedences. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Friday, June 20, 2008 12:13 PM To: arslist@ARSLIST.ORG Subject: Re: Trying to Load Assets into CMDB/Asset Inventory Hi Claire, I thought about importing directly into the AST form first but I get a little paranoid moving any data directly from a spreadsheet to a system form I like to stage it to make sure that all the data is clean. Also I was hoping to automate this process for when we receive new equipment and for inventory moves. Importing works great for the first load but I don't think it will work well in the long run when I just need update and asset. How do you update your asset locations changes and such? Thank you, Lou -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Friday, June 20, 2008 2:58 PM To: arslist@ARSLIST.ORG Subject: Re: Trying to Load Assets into CMDB/Asset Inventory I import them directly to the AST:ComputerSystem. it does the push to the other forms all on it's own. I make sure I set several of the hidden/background fields and it works well. I did about 34K assets this way! -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis Sent: Friday, June 20, 2008 1:51 PM To: arslist@ARSLIST.ORG Subject: Re: Trying to Load Assets into CMDB/Asset Inventory We loaded our assets into the system. It isn't easy but first import into the BMC_CORE:BMC-BaseElement Form and then export out into an arx file each Class ID - So you may have BMC_CORE:BMC-Equipment, ComputerSystem etc. Then you import each individual one into corresponding form - example Equipment goes into the BMC_CORE:BMC_Equipment_ form and Printer go into the BMC:CORE_BMC_Printer_ and BMC:CORE_BMC_HardwareSystemComponent_ Form. Use the Update Existing Record when importing into this form. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Louis Cobuccio Sent: Friday, June 20, 2008 1:38 PM To: arslist@ARSLIST.ORG Subject: Trying to Load Assets into CMDB/Asset Inventory Hi List, I am hoping someone can help me out. I am in the process of trying to load our Server Assets into Remedy Asset Inventory and into the CMDB. We are running CMDB v 2.0 and our AR apps are v 7.0.1 patch 006, on Windows 2003 Server and MS SQL 2005. I have a csv file listing out our server assets; I've loaded the data from the csv into a custom form via the Remedy Import Tool. I've then created a Filter to "Push" the data from the custom form into the AST:ComputerSystem form. I am receiving the following error message when the Filter fires: The Product Categorization Tiers, Product Name and Manufacturer combination is not valid. Please use the menus provided for these fields to select this information. (ARERR 44901) I did create the Categorization Tiers, Product Name and Manufacturer fields on the custom form as Character fields and I am trying to "Push" the data from these fields to the corresponding fields on AST:ComputerSystem. I am using the same Name Values for the above fields in the custom form that are being used on the AST:ComputerSystem form. So I thought that this should work fine. If I am reading the error right, I guess I should have created selection fields instead of character ones on the custom form and use the same Name Values for each field. But I would have to think there must be an easier way of getting this data into the system. I noticed that the same fields in question are character fields on the BMC.Core:BMC_ComputerSystem - Join form. Should I have the Filter "Push" to this form instead of the AST:ComputerSystem form? If I do "Push" to the BMC form will I see the data in the AST form once the Reconciliation Engine runs? I've also recently downloaded the AIE product, should I be using that instead of the Import Tool & Filter process? Any suggestions will be very helpful. Thank you, Lou ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"