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"
