Skip to main content

Asset Import

AdamRMS supports the bulk import of assets from a CSV file. This is an instance-level feature, accessible to instance admins with the ASSETS:IMPORT permission.

A template is available with the correct CSV headings, which can be downloaded from within the Import Assets page in AdamRMS.

To import assets, navigate to Assets → Import Assets in the sidebar and upload your completed CSV file.

The columns of the CSV file are as follows:

ColumnDescriptionRequired
assetTypes_nameAsset Type NameYes
assetTypes_descriptionAsset Type DescriptionNo
assetTypes_productLinkLink to product pageNo
assetTypes_massAsset Type MassNo
assetTypes_dayRateHire cost per dayYes
assetTypes_weekRateHire cost per weekYes
assetTypes_valueAsset Type Purchase ValueYes
assetCategories_nameAsset Category Name (must match an existing category in this instance)Yes
manufacturers_nameManufacturer NameYes
assets_tagThe Unique ID/Tag associated with the assetYes
assets_notesNo
assets_storageLocationThe ID of the default location for the assetNo
assets_dayRateOverride the Asset Type Day Rate for this assetNo
assets_WeekRateOverride the Asset Type Week Rate for this assetNo
assets_valueOverride the Asset Type Value for this assetNo
assets_massOverride the Asset Type Mass for this assetNo
assetType_definableFieldsName_1Name of the first Asset Type definable fieldNo
assetType_definableFieldsName_2As aboveNo
assetType_definableFieldsName_3As aboveNo
assetType_definableFieldsName_4As aboveNo
assetType_definableFieldsName_5As aboveNo
assetType_definableFieldsName_6As aboveNo
assetType_definableFieldsName_7As aboveNo
assetType_definableFieldsName_8As aboveNo
assetType_definableFieldsName_9As aboveNo
assetType_definableFieldsName_10As aboveNo
asset_definableFields_1Value for the first Asset Type definable fieldYes, if field name given
asset_definableFields_2As aboveYes, if field name given
asset_definableFields_3As aboveYes, if field name given
asset_definableFields_4As aboveYes, if field name given
asset_definableFields_5As aboveYes, if field name given
asset_definableFields_6As aboveYes, if field name given
asset_definableFields_7As aboveYes, if field name given
asset_definableFields_8As aboveYes, if field name given
asset_definableFields_9As aboveYes, if field name given
asset_definableFields_10As aboveYes, if field name given
Instance Permissions Required

ASSETS:IMPORT (requires ASSETS:CREATE, ASSETS:ASSET_TYPES:CREATE, ASSETS:MANUFACTURERS:CREATE)