I just went through this same exercise and posed the same question to the list with a similar response. But I was able to get it working through trial and error and my intent is to create a full blown how-to that may or may not get included in the distribution.
In the meantime as a simple example, here are the things that you will need to do: 1. If you are using custom fields for your assets, create and enable them via the web interface. 2. Create your csv file. Here is a simple example of what I am using: Name,Description,Status,Type,Model,Serial Number,IP Address,Location,Rack Number myMachine1,Controller,in-use,Dell Server,R720,abc123,192.168.1.1,Building 1,1 myMachine2,Controller,in-use,Dell Server,R720,def456,192.168.1.2,Building 1,1 myMachine3,Controller,in-use,Dell Server,R720,ghi789,192.168.1.3,Building 1,1 3. Create a custom config file. (This is what I did as opposed to adding it to the RT_SiteConfig.pm file) Set( $AssetsImportUniqueCF, undef ); Set( %AssetsImportFieldMapping, 'id' => 'Name', 'Name' => 'Name', 'Catalog' => \'Storage Assets', 'Description' => 'Description', 'Status' => 'Status', 'CF.Type' => 'Type', 'CF.Model' => 'Model', 'CF.Serial Number' => 'Serial Number', 'CF.IP Address' => 'IP Address', 'CF.Location' => 'Location', 'CF.Rack Number' => 'Rack Number' 4. Running the script to populate the database: /opt/rt4/local/plugins/RT-Extension-Assets-Import-CSV/bin/rt-assets-import-csv --update ./test1.csv --debug --config config.test1 I added all the switches to see what's happening. I would suggest that you create a test RT instance to play with to get comfortable with the process. Hope this helps. ==== Joe Mervini Sandia National Laboratories High Performance Computing 505.844.6770 [email protected]<mailto:[email protected]> On Sep 16, 2014, at 4:43 AM, David Lane (IT Support) <[email protected]<mailto:[email protected]>> wrote: Hi guys, Nearly got this to work i've Installed the cpan module - and manually compiled so its now installed fine Added the plugin and configuration to the RT Siteconfig The distribution notes say i should run "SYNOPSIS rt-assets-import /path/to/assets.csv " HOW? It would be really helpful to create a work-through for this... Thanks for your time Dave -- David Lane Director GoodChoice.IT Ltd We reward successful referrals W: www.goodchoice.it<http://www.goodchoice.it/> E: [email protected]<mailto:[email protected]> T: 020 8099 5540 -- RT Training - Boston, September 9-10 http://bestpractical.com/training
-- RT Training - Boston, September 9-10 http://bestpractical.com/training
