Imports ASSET

To support an initial upload of multiple new Assets a file import is available using the standard C-TMS Import Maintenance functionality:

The following fields can be specified:

• ACTION - optional - 'A'dd or 'M'odify. If not provided, and the asset is not found, will default to adding, else modifying. If adding, the asset must not exist, if modifying, the asset must exist.
• ASSET_ID - required
• OWNER
• ASSET_TYPE - required when adding - must exist as a DU type marked as reusable in the system.
• ORIGIN
• CURRENT_LOCATION - required when adding - must exist as a valid location in the system.
• ROUTE
• STATUS - required - must be a valid status in the system.
• COMMENTS

Any data that does not conform to the specified format will be rejected, any errors will be reported in the results file which can be displayed on completion of the import process.

Duplicate assets will not be inserted if an asset already exists; this will be considered an update.

The standard Import screen is used to initiate the upload of the file:

When a valid asset is created/updated an associated record will be created in the Asset Audit History table to record the details of the creation or amendment.

Further configuration:

Parameter	Description	Level
UPPERCASE_ASSET_ID	Asset id to be stored in upper case	SYSTEM