<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
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.
<div><br>
</div>
<div>In the meantime as a simple example, here are the things that you will need to do:</div>
<div><br>
</div>
<div>1. If you are using custom fields for your assets, create and enable them via the web interface.</div>
<div><br>
</div>
<div>2. Create your csv file. Here is a simple example of what I am using:</div>
<div><br>
</div>
<div>
<div>Name,Description,Status,Type,Model,Serial Number,IP Address,Location,Rack Number</div>
<div>myMachine1,Controller,in-use,Dell Server,R720,abc123,192.168.1.1,Building 1,1</div>
<div>
<div>myMachine2,Controller,in-use,Dell Server,R720,def456,192.168.1.2,Building 1,1</div>
</div>
<div>
<div>myMachine3,Controller,in-use,Dell Server,R720,ghi789,192.168.1.3,Building 1,1</div>
</div>
<div><br>
</div>
<div>3. Create a custom config file. (This is what I did as opposed to adding it to the RT_SiteConfig.pm file)</div>
<div><br>
</div>
<div>
<div>Set( $AssetsImportUniqueCF, undef );</div>
<div>Set( %AssetsImportFieldMapping,</div>
<div>'id' => 'Name',</div>
<div>'Name' => 'Name',</div>
<div>'Catalog' => \'Storage Assets',</div>
<div>'Description' => 'Description',</div>
<div>'Status' => 'Status',</div>
<div>'CF.Type' => 'Type',</div>
<div>'CF.Model' => 'Model',</div>
<div>'CF.Serial Number' => 'Serial Number',</div>
<div>'CF.IP Address' => 'IP Address',</div>
<div>'CF.Location' => 'Location',</div>
<div>'CF.Rack Number' => 'Rack Number'</div>
</div>
<div><br>
</div>
<div>4. Running the script to populate the database:</div>
<div><br>
</div>
<div>/opt/rt4/local/plugins/RT-Extension-Assets-Import-CSV/bin/rt-assets-import-csv --update ./test1.csv --debug --config config.test1</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Hope this helps.</div>
<div><br>
</div>
<div apple-content-edited="true"><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;">
<div>====</div>
<div><br>
</div>
<div>Joe Mervini</div>
<div>Sandia National Laboratories</div>
<div>High Performance Computing</div>
<div>505.844.6770</div>
<div><a href="mailto:jamervi@sandia.gov">jamervi@sandia.gov</a></div>
<div><br>
</div>
</span><br class="Apple-interchange-newline">
</div>
<br>
<div>
<div>On Sep 16, 2014, at 4:43 AM, David Lane (IT Support) <<a href="mailto:dave@goodchoice.it">dave@goodchoice.it</a>> wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div dir="ltr">
<div class="gmail_default" style="font-family:'trebuchet ms',sans-serif">Hi guys,</div>
<div class="gmail_default" style="font-family:'trebuchet ms',sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:'trebuchet ms',sans-serif">Nearly got this to work i've</div>
<div class="gmail_default" style="font-family:'trebuchet ms',sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:'trebuchet ms',sans-serif">Installed the cpan module - and manually compiled so its now installed fine</div>
<div class="gmail_default" style="font-family:'trebuchet ms',sans-serif">Added the plugin and configuration to the RT Siteconfig </div>
<div class="gmail_default" style="font-family:'trebuchet ms',sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:'trebuchet ms',sans-serif">The distribution notes say i should run </div>
<div class="gmail_default" style="font-family:'trebuchet ms',sans-serif"><br>
</div>
<div class="gmail_default" style="font-family:'trebuchet ms',sans-serif">
<div class="gmail_default">"SYNOPSIS</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">rt-assets-import /path/to/assets.csv</div>
<div class="gmail_default">"</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">HOW?</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">It would be really helpful to create a work-through for this... </div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">Thanks for your time</div>
<div class="gmail_default"><br>
</div>
<div class="gmail_default">Dave</div>
</div>
<div><br>
</div>
-- <br>
David Lane<br>
Director<br>
GoodChoice.IT Ltd<br>
<br>
We reward successful referrals<br>
<br>
W: <a href="http://www.goodchoice.it/" target="_blank">www.goodchoice.it</a> E: <a href="mailto:dave@goodchoice.it" target="_blank">
dave@goodchoice.it</a> T: 020 8099 5540 </div>
-- <br>
RT Training - Boston, September 9-10<br>
<a href="http://bestpractical.com/training">http://bestpractical.com/training</a></blockquote>
</div>
<br>
</div>
</body>
</html>