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 < [email protected]> wrote: > ** > > Hi Kali,**** > > ** ** > > Why not using the AIE?**** > > ** ** > > Francois**** > > ** ** > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Michael Burton > *Sent:* Monday, June 27, 2011 6:25 PM > *To:* [email protected] > *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: [email protected] > Subject: Re: Creating bulk assets - Remedy 7.6.03 > To: [email protected] > > ** **** > > 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: > [email protected]] *On Behalf Of *Michael Burton > *Sent:* Monday, 27 June 2011 6:49 PM > *To:* [email protected] > *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: [email protected] > Subject: Creating bulk assets - Remedy 7.6.03 > To: [email protected] > > ** **** > > 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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
