[rt-users] Assigning HeldBy users during Asset Import

mkyser mkyser at albion.edu
Fri Sep 12 13:15:19 EDT 2014


Hi All

I have been playing around with RT for the last few weeks now and am trying
to import assets from an inventory I exported to a CSV file.  The assets
successfully import but I am unable to fill the HeldBy field for any assets,
seeing the following warning when running the import ;

'Role name HeldBy must be single-value for column Username, skipping'

My current configuration is RT 4.27 with RT-Authen-ExternalAuth-0.21,
Extension-LDAPImport-0.35, Extension-Assets-1.01 and
Extension-Assets-Import-CSV-1.3.  I have connected the ExternalAuth to my
local AD and successfully imported all the domain users as unprivileged
users.  I am able to assign any of these users to the HeldBy role under the
People tab of an Asset.

Here is the snippet from RT_SiteConfig.pm for the field mapping I am using;

Set( $AssetsImportUniqueCF, 'Key Number' );
Set( %AssetsImportFieldMapping,
    'Catalog'              	=> \'Keys',
    'Name'		    	=> 'KeyNumber',
    'Description'          	=> 'EmployeeName',
    'Status'               	=> \'in-use',
    'HeldBy' 		=> 'Username',
    'CF.Department'    	=> 'Department',
    'CF.Issue Date'      	=> 'Issued',
    'CF.Username'  	=> 'Username',
    'CF.Issued To'	=> 'EmployeeName',
    'CF.Key Level'    	=> 'KeyLevel',
    'CF.Key Way'      	=> 'Keyway',
    'CF.Key Number'   	=> 'KeyNumber',
    'CF.Other Info'	=> 'Username',
); 

Is there something I am missing or is this function not available?

In a related test, I am not able to assign a HeldBy user using the Bulk
Update feature either.

Thanks for any insight or solution to this.



--
View this message in context: http://requesttracker.8502.n7.nabble.com/Assigning-HeldBy-users-during-Asset-Import-tp58502.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.



More information about the rt-users mailing list