I saw transactional spreadsheets for asset, but not to load CI's, just to manage the relationships. Am I missing something?
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Davin Lindner-Green Sent: Tuesday, April 01, 2014 12:33 PM To: [email protected] Subject: Re: Remedy 7.6: Bulk Loading of elements of Asset Management. Hello Salvo, You should start with the Data Management Tool ("DMT") which is included in ITSM 7.6.4. Look for the documentation called "Data Management Guide.pdf" for a description. DMT can load foundation data (companies, categories, people, etc) and is often used for that, but it can also load "Transactional" data by which is meant thing like Assets or CI's. This is the type of data load you probably need. The basic way it works is you load the data into an Excel spreadsheet (you must use the template included in the DMT client). This is transformed in Excel to a CSV. The CSV is then loaded to a set of staging forms in Remedy, where the administrator can promote that data from the staging form to the actual ITSM form. Data validation and error reporting are done all along the way. Because of this validation (and the fact that the DMT spreadsheets already have all the columns you need) you will save time using DMT as compared to creating your own spreadsheet import. The DMT is probably already installed on your server, you will also need to install the DMT client (spreadsheets and scripts to load CSVs) on an admin workstation which also has Microsoft Office. It may already be on your server, look for Program Files\BMC Software\DataManagementClient folder. Hope that gets you started in the right direction! Thanks, Davin Lindner-Green On Apr 1, 2014, at 1:58 AM, [email protected] <[email protected]> wrote: > Hi all, we work with AR Server 7.6.0.4 SP5 and ITSM 7.6.04 SP4. > We are using for the first time Asset Management and we need to load > for our organization, a large number of elements like cash desk, > printers and so on (more or less 10000 elements). > Is there a way (for example Using Spreadsheets) to make a bulk loading > on Remedy of these Asset elements? > Are there any documents around that offers a guide on what should be > the values/columns used and what forms should it be imported to? > Thanks in advance. > Best Regards. > Salvo > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
