Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When changes take place requiring you to edit data for multiple assets, the template is the best way to bring about the required updates.

What Updates Can Be Done via the Template

You can update existing assets, deactivate assets, and add new assets via the upload of the template with standard attributes. 

It should be noted that no assets can be deleted via the template. If the template you upload doesn’t contain records on assets that exist in Asset Manager, these assets will not be affected by the template upload.

General Workflow

Follow the 4 steps described below to update your asset data for assets en masse — without having to fill out an MS Excel template from scratch.

Section


Column
width45%

STEP 1

Apply the required filters to get a list of assets that you want to update.

Filtering assets on the assets listImage Modified


Column
width45%

STEP 2

Download the list of assets with standard attributes.

Downloading an MS Excel report on assets with standard attributesImage Modified



Section


Column
width45%

STEP 3

Make the required changes to asset data in the downloaded MS Excel file.

MS Excel report on assets with standard attributesImage Modified


Column
width45%

STEP 4

Upload the file into the system via the Imported Assets section.

Imported Assets section where you can upload the templateImage Modified



Even though the exported file contains more columns than required for the upload, there is no need to remove any columns. This is because the file can serve the two functions: 

  • It is a report that provides complete asset data.
  • It is a template that can be used to update multiple assets in bulk.

When you use the template with the second function in mind, all you need is to make the required updates, and reupload the file.

Live Search
spaceKeySCU
additionalpage excerpt
placeholderSearch our Knowledge Base
typepage

Panel
titleColor#ffffff
titleBGColor#5fa7d0
borderStylegroove
titleIn this Article

Table of Contents
maxLevel3
minLevel2
indent20px

Panel
titleColorwhite
titleBGColor#75a346
titleRelated Articles

Filter by label (Content by label)
showLabelsfalse
max8
showSpacefalse
sorttitle
cqllabel in ( "label" , "assettemplate" , "assetfilter" , "asset-filters" , "assetattributes" , "assetlist" ) and space = currentSpace ( )