Thanks so much for that Worked perfectly - I owe you a beer!
Please try and get this included in the docs! Dave On Tue, Sep 16, 2014 at 5:11 PM, Mervini, Joseph A <jame...@sandia.gov> wrote: > 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 > jame...@sandia.gov > > > > On Sep 16, 2014, at 4:43 AM, David Lane (IT Support) <d...@goodchoice.it> > 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 E: d...@goodchoice.it T: 020 8099 5540 > -- > RT Training - Boston, September 9-10 > http://bestpractical.com/training > > > -- David Lane Director GoodChoice.IT Ltd We reward successful referrals W: www.goodchoice.it E: d...@goodchoice.it T: 020 8099 5540
-- RT Training - Boston, September 9-10 http://bestpractical.com/training