Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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):

  1. Choose Assets > Asset Navigator.
  2. Refine your search, then choose the Export menu.
  3. Choose "Export CSV" from the dropdown menu:
  4. 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:

Asset Navigator and Export dropdown



Export DropdownExport CSV dialogDelimiter 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:

  1. Choose Assets > Asset Navigator.
  2. Refine your search, then choose the Export menu.
  3. Choose "Export HTML" from the dropdown menu:
  4. A file called Assets <Time Stamp>.html will be created. Print this file using a browser.


Export DropdownExport HTML dialog

Image Modified

Image Modified



Export options

TemplateHTML
template 
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.

UserSelect an User if the template has User variables, i.e user name
Include linked issuesLinked 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.

Table of Contents