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 your own 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:
- 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.
Asset Navigator with Export dropdown feature:
| Export Dropdown | Export CSV dialog | Delimiter options |
|
|
|
Sample exported file, viewed in Libre Office
Exporting Search Results to HTML
AIP (Assets and Inventory app) enables 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:
- A file called Assets <Time Stamp>.html will be created. Print this file using a browser.
| Export Dropdown | Export HTML dialog | |
|
|
Export options
| 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 |
Sample exported HTML file
It is possible to add any HTML tag to the template, i.e Company Logo/name.
