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.
- 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. - 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. - Click the Schedule Report tab.
A list of request IDs is displayed. - Click Refresh to refresh the list of request IDs.
- 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.
- 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. - Click Schedule and then select Upload.
- Browse and select the required file and upload it to the system.

