The Administrator can import a large number of Assets from a Microsoft Excel sheet template, and activate or deactivate them. The Administrator can also do the asset movement in bulk using excel upload. The assets are moved based on the parameters available in the uploaded excel such as AssetID, Asset Condition, Destination Location, Destination Store, and Floor. The Audit trail for From Store and To Store is updated accordingly.
To Activate/Deactivate or Update Assets in Bulk:
- Select Asset > User > Manage Asset > Import > Custom Action.
- On the CUSTOM ACTION page, under the GENERAL tab, select the required options and upload the template for bulk activation/ deactivation/movement. For information about the fields under the GENERAL tab, see Field Description.
- Click SUBMIT. A table is displayed that lists the sheets of Asset Custom Action Template. Select the sheets to import the Assets.
Figure: CUSTOM ACTION page: GENERAL tab - Under the MAPPING tab, select the fields in Source and Destination sections. For information about the fields under the Mapping tab, see Field Description. Click NEXT.
Figure: CUSTOM ACTION page: MAPPING tab A table listing all the mapped values is displayed under PREVIEW tab. For information about the fields under the PREVIEW tab, see Field Description.
Figure: CUSTOM ACTION page: PREVIEW tabClick UPDATE ASSETS. The Assets are updated for the selected location, and deactivated/reactivated/moved as per the Action Type that you selected under GENERAL tab.
Field Description
The following table describes the fields on the CUSTOM ACTION page:
Field | Description |
|---|---|
GENERAL Tab | |
Tenant | Select the Tenant, for which, you want to activate or deactivate the Assets. |
Asset Type | Select the Asset Type from the list. |
Action Type | Select the action that you want to perform on the Assets. The available options are:
|
Source | Click the Upload icon to upload the Asset Custom Action Template sheet. Click SUBMIT. A table is displayed that lists the sheets of uploaded template. Select the sheet to upload Assets. |
MAPPING Tab | This tab displays the fields with its mapping result. Select the appropriate value in the Source and Destination sections. |
PREVIEW Tab | Displays all the mapped Assets. The fields displayed on this table depends on the fields mapped under the MAPPING tab. If you do not want to perform an action on a specific Asset, select the related check box in the Discard column. |
ACTIONS
This section explains all the icons displayed on the ACTIONS panel of the CUSTOM ACTION page.
DOWNLOAD TEMPLATE
Click DOWNLOAD TEMPLATE to download the Asset Custom Action Template.
UPDATE ASSETS
Click UPDATE ASSETS to upload the Assets to the selected location.