Skip to content

Web Application - Admin User Manuals

Uploading Assets in Bulk

4 min readUpdated

The procedure to upload assets in bulk involves two steps:

Downloading Asset Data Reports

To upload assets in bulk, you need to first download the asset data report. Then you can make the necessary additions/modifications and upload assets to the system.

To download an asset data report, you need to first schedule the download on the Asset page under the Asset tab and then download the report from the Schedule Report tab.

  1. In the Main Menu, under the ADMIN OPTIONS, in the Asset Management subsection, click Asset.
    ‎The Asset page with the Asset tab open by default is displayed.
  2. Click Schedule and then select Download.
    A Request ID for Asset Data Report Download is generated, and the report is available for download under the Schedule Report tab.
  3. Click the Schedule Report tab. 
    A list of request IDs is displayed.
  4. Click Refresh to refresh the list of request IDs.
  5. Under the Download Link column for your request ID, click Download.
    ‎The asset data report is downloaded in Excel format and contains detailed information for each asset along with some metadata that can be used to add additional information about any asset spread across the following sheets. The Assets sheet in the report displays the following information:

Column

Description

Id

Displays the system generated ID of the asset.

Name

Displays the name of the asset.

Active

Displays whether the asset is active or not.

Feedback

Displays whether the option to raise a service request for this asset is enabled or not.

Asset Category

Displays the asset category to which the asset belongs.

Specification

Displays the specification associated with the asset.

Metadata

Displays link to the specific metadata value for the asset in the corresponding metadata sheet.

 

Groups

Displays the group(s) associated with the asset.

Tags

Displays the tag(s) associated with the asset.

Service Groups

Displays the service groups associated with the asset.

Status

Displays the status of the asset.

Condition

Displays the condition of the asset.

Maintenance Templates

Displays the maintenance template assigned to the asset.

Assigned To

Displays the name of the user who has been assigned the asset for use.

Serial No

Displays the serial number of the asset.

Assigned To Employee Id

Displays the email ID of the user who is allocated the asset for use.

Assigned To

Displays the name of the user to whom the asset is allocated (Assignee filed in the maintenance template).

Purchased Date

Displays the date on which the asset was purchased.

Warranty End Date

Displays the date on which the warranty for the asset expires.

DLP Capture Date

Displays the date until which any defects identified must be addressed by the contractor or vendor at no additional cost.

UID

Displays the unique ID assigned to the asset.

Currency

Displays the currency used to purchase the asset.

Cost

Displays the cost of the asset.

Campus

Displays the campus where the asset is installed.

Building

Displays the building where the asset is installed.

Floor

Displays the floor where the asset is installed.

Hvac Zone

Displays the HVAC zone associated with the asset.

Light Zone

Displays the light zone associated with the asset.

Access Device

Displays the access device associated with the asset.

AHU

Displays the AHU associated with the asset.

Energy Meter

Displays the energy meter associated with the asset.

Water Meter

Displays the water meter associated with the asset.

PAC

Displays the PAC associated with the asset.

UPS

Displays the UPS associated with the asset.

Breaker

Displays the breaker associated with the asset.

Desk

Displays the desk associated with the asset.

Room

Displays the room associated with the asset.

Area

Displays the area associated with the asset.

Uploading Asset Data Reports

This feature allows users to efficiently perform bulk operations on asset data. It is particularly useful in scenarios where small updates need to be made across multiple assets simultaneously. Additionally, this functionality supports the bulk addition of assets, making it easier to onboard large volumes of data at once, without the need to manually create or update each asset individually.

  1. In the Main Menu, under the ADMIN OPTIONS, in the Asset Management subsection, click Asset.
    ‎The Asset page with the Asset tab open by default is displayed.
  2. Click Schedule and then select Upload.
  3. Browse and select the required file and upload it to the system.
Was this page helpful?