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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
