HI Kali, AIE is definitly the way to go when loading Assets into the CMDB from a .csv. You can select a 'Data Exchange Type' of "CI", this will allow you to select the CMDB Class you want to import into, (such as Computer System). You then specify the path to your .csv. Then it is easy to set up your mappings, you have a screen with the Class attributes on one side, and the csv columns on the other side. Just select one from eac side and add.
Look for the AIE User Guide and Admin Guide on the BMC Site. .ron On Thu, Jun 30, 2011 at 2:16 AM, Kali Obsum <kali.ob...@macquarie.com>wrote: > ** ** > Hi All, > > Is there any documentation on how to load assets through AIE? Is it in the > BMC docs/guides? > > Regards, > Kali > > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *JD Hood > *Sent:* Tuesday, 28 June 2011 3:02 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Creating bulk assets - Remedy 7.6.03 > > ** I was wondering the same... Perhaps AIE was too easy and just wasn't > challenging enough? > > JDHood > > > On Mon, Jun 27, 2011 at 1:25 PM, Francois Seegers < > franco...@blueturtle.co.za> wrote: > >> ** >> >> Hi Kali,**** >> >> **** >> >> Why not using the AIE?**** >> >> **** >> >> Francois**** >> >> **** >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Michael Burton >> *Sent:* Monday, June 27, 2011 6:25 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Creating bulk assets - Remedy 7.6.03**** >> >> **** >> >> ** **** >> >> Hi, >> >> You need to do one import per form type. >> >> As for mandatory fields, first of all, manually create an entry on the >> form, and see which ones it demands (not many), then you'll need the data >> set id I mentioned below. >> >> Thanks >> >> - >> Mike >> **** >> ------------------------------ >> >> Date: Mon, 27 Jun 2011 20:04:57 +0800 >> From: kali.ob...@macquarie.com >> Subject: Re: Creating bulk assets - Remedy 7.6.03 >> To: arslist@ARSLIST.ORG >> >> ** **** >> >> Hi Mike,**** >> >> **** >> >> Thanks! So I just need to import in 1 form? For example, if I want to >> create a Computer System asset, I just need to import to the >> AST:ComputerSystem form?**** >> >> **** >> >> Also, how do I know which fields are mandatory and which ones will be >> automatically generated? (e.g. Should I just leave the Reconciliation ID and >> Instance Id fields blank?)**** >> >> **** >> >> Regards,**** >> >> Kali**** >> >> **** >> >> **** >> ------------------------------ >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Michael Burton >> *Sent:* Monday, 27 June 2011 6:49 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: Creating bulk assets - Remedy 7.6.03**** >> >> ** **** >> >> Hi Kali, >> >> I've done quite a few of these. The best method I've found to use is: >> >> 1) Create/Open the CSV and sanitise the data. >> 2) Open the ComputerSystem form in the user tool and work out which column >> on the CSV you want to go in to which field on the CS form. I then write the >> name of the field in a new row at the top of the sheet and work my way >> across the sheet. >> 3) If your not sure on the field names - open Dev Studio and cross check >> the field names with the actual name. I then write this in a further row at >> the top of the sheet. >> 4) Once finished I delete the unused column names, and then map in to the >> Data Import tool. >> >> Once you've done it a few times, you can get quite proficient at it !! >> >> You'll also need to include some mandatory fields as well such as status >> and data set ID. >> >> Regards >> >> - >> Mike >> >> >> **** >> ------------------------------ >> >> Date: Mon, 27 Jun 2011 13:50:50 +0800 >> From: kali.ob...@macquarie.com >> Subject: Creating bulk assets - Remedy 7.6.03 >> To: arslist@ARSLIST.ORG >> >> ** **** >> >> Hi,**** >> >> **** >> >> Has anyone tried to create bulk assets (Computer System, Database) using >> the Remedy 7 Data Import Tool. If yes, are there any documents around that >> offers a guide on what should be the values/columns used in the csv file and >> what forms should it be imported to?**** >> >> **** >> >> Thanks!**** >> >> **** >> >> Regards,**** >> >> Kali**** >> >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ NOTICE >> The information contained in this email is confidential. If you are not >> the intended recipient, you must not disclose or use the information in this >> email in any way. If you received it in error, please tell us immediately by >> return email and delete the document. We do not guarantee the integrity of >> any e-mails or attached files and are not responsible for any changes made >> to them by any other person. >> >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_**** >> >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ **** >> >> ------------------------------ >> Blue Turtle Technologies (Pty) Limited | Reg. no.: 2003/002610/07 | Tel: +27 >> (0)11 206 5600 | Fax: +27 (0)11 206 5606 | http://www.blueturtle.co.za >> Midridge Office Estate, International Business Gateway, cnr New Road & >> Sixth Street, Midrand, 1685 | P O Box 31331, Kyalami, 1684 >> >> DISCLAIMER: This email and any files transmitted with it are confidential >> and are intended solely for the use of the individual or entity to whom they >> are addressed. This communication represents the originator's personal views >> and opinions, which do not necessarily reflect those of Blue Turtle >> Technologies (Pty) Ltd. If you are not the original recipient or the person >> responsible for delivering the email to the intended recipient, be advised >> that you have received this email in error, and that any use, dissemination, >> forwarding, printing, or copying of this email is strictly prohibited. If >> you received this email in error, please immediately notify the sender. >> Thank you. >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
