Exporting Search Results to CSV (Microsoft Excel)
AIP (Assets and Inventory app) enables you to easily export your asset search results from the Asset Navigator to Microsoft Excel. This can be a useful way to format data and create customized reports, graphs, and charts.
To export search results to CSV (Microsoft Excel):
Choose Assets > Asset Navigator.
Refine your search, then choose the Export menu.
Choose "Export CSV" from the dropdown menu.
Select the delimiter, and click Download.
A file called Assets <Time Stamp>.csv will be created. Edit this file using Microsoft Excel Or Libre Office and/or save it as required.
Sample exported file, viewed in Libre Office
Exporting Search Results to HTML
AIP allows you to easily export your asset search results from the Asset Navigator to HTML with pre-defined export templates. This can be a useful way to print custom documents with assets, i.e., having an employee's signature to check out assets.
To export search results to HTML:
Choose Assets > Asset Navigator.
Refine your search, then choose the Export menu.
Choose "Export HTML" from the dropdown menu.
Name the template, select the export style, and optionally, complete user selection. Click Download.
Template | HTML template (See Template Settings for template configuration) |
Export Style | Grid view: Excel style list view Individual assets view: Each asset will be displayed one by one. |
User | Select an User if the template has User variables, i.e user name |
Include linked issues | Linked issues will be printed when this option is checked |
A file called Assets <Time Stamp>.html will be created. Print this file using a browser.
Sample exported HTML file
It is possible to add any HTML tag to the template, i.e Company Logo/name.
Export to Cloud
This provides a guide on migrating assets from on-premise to the cloud. Users can now seamlessly transfer their assets by utilizing the "Export for Cloud" feature, eliminating the need for manual formatting tasks such as adjusting headers and organizing data.
Prerequisites
Before initiating the migration process, ensure the following prerequisites are met:
Access to the on-premise asset repository.
Permission to export assets.
Properly configured cloud environment.
To export for Cloud:
Choose Assets > Asset Navigator.
Refine your search, then choose the Export menu.
Choose "Export for Cloud" from the dropdown menu.
Select the delimiter, and click Download.
The system will generate a cloud-compatible export file.
For successful on-premise to cloud import, it is crucial that the asset types and attributes are pre-configured in the cloud environment. If the required asset types and attributes already exist in the cloud, users can directly proceed with the import process.