RT-Extension-Assets-Import-CSV - RT Assets Import from CSV
This version of RT::Extension::Assets::Import::CSV requires RT 4.4, as that version of RT has Assets built in.
If you're running RT 4.2 with the Assets extension, you should seek an older version of this extension; specifically, version 1.4.
perl Makefile.PL
make
make install
May need root permissions
Add this line:
Plugin('RT::Extension::Assets::Import::CSV');
See "CONFIGURATION", below, for the remainder of the required configuration.
bin/rt-assets-import-csv
See bin/rt-assets-import-csv --help for more information.
bin/rt-assets-import-csv --help
The following configuration would be used to import a three-column CSV of assets, where the column titled serviceTag is unique:
serviceTag
Set( $AssetsImportUniqueCF, 'Service Tag' ); Set( %AssetsImportFieldMapping, 'Name' => 'description', 'CF.Service Tag' => 'serviceTag', 'CF.Location' => 'building', 'CF.Serial #' => 'serialNo', );
If you want to set an RT column or custom field to a static value for all imported assets, precede the "CSV field name" (right hand side of the mapping) with a slash, like so:
Set( $AssetsImportUniqueCF, 'Service Tag' ); Set( %AssetsImportFieldMapping, 'Name' => 'description', 'Catalog' => \'Hardware', 'CF.Service Tag' => 'serviceTag', 'CF.Location' => 'building', 'CF.Serial #' => 'serialNo', );
Every imported asset will now be added to the Hardware catalog in RT. This feature is particularly useful for setting the asset catalog, but may also be useful when importing assets from CSV sources you don't control (and don't want to modify each time).
You may also compute values during import, by passing a subroutine reference as the value in the %AssetsImportFieldMapping. This subroutine will be called with a hash reference of the parsed CSV row.
%AssetsImportFieldMapping
Set( $AssetsImportUniqueCF, 'Service Tag' ); Set( %AssetsImportFieldMapping, 'Name' => 'description', 'CF.Service Tag' => 'serviceTag', 'CF.Location' => 'building', 'CF.Weight' => sub { $_[0]->{"Weight (kg)"} || "(unknown)" }, );
Using computed columns may cause false-positive "unused column" warnings; these can be ignored.
If you are already using a numeric identifier to uniquely track your assets, and wish RT to take over handling of that identifier, you can choose to leave $AssetsImportUniqueCF unset, and assign to id in the %AssetsImportFieldMapping:
$AssetsImportUniqueCF
id
Set( %AssetsImportFieldMapping, 'id' => 'serviceTag', 'Name' => 'description', 'CF.Service Tag' => 'serviceTag', 'CF.Serial #' => 'serialNo', );
This requires that, after the import, RT becomes the generator of all asset ids. Otherwise, asset id conflicts may occur.
Best Practical Solutions, LLC <modules@bestpractical.com>
All bugs should be reported via email to
L<bug-RT-Extension-Assets-Import-CSV@rt.cpan.org|mailto:bug-RT-Extension-Assets-Import-CSV@rt.cpan.org>
or via the web at
L<rt.cpan.org|http://rt.cpan.org/Public/Dist/Display.html?Name=RT-Extension-Assets-Import-CSV>.
This extension is Copyright (C) 2014-2016 Best Practical Solutions, LLC.
This is free software, licensed under:
The GNU General Public License, Version 2, June 1991
To install RT::Extension::Assets::Import::CSV, copy and paste the appropriate command in to your terminal.
cpanm
cpanm RT::Extension::Assets::Import::CSV
CPAN shell
perl -MCPAN -e shell install RT::Extension::Assets::Import::CSV
For more information on module installation, please visit the detailed CPAN module installation guide.