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 customized reports, graphs, and charts.

Table of Contents

To export search results to CSV (Microsoft Excel):

  1. Choose Assets > Asset Navigator.

  2. Refine your search, then choose the Export menu.

    Image RemovedImage Added
  3. Choose "Export CSV" from the dropdown menu.

  4. Select the delimiter, and click Download.

  5. 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

Image RemovedImage Added

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:

  1. Choose Assets > Asset Navigator.

  2. Refine your search, then choose the Export menu.

  3. Choose "Export HTML" from the dropdown menu.

  4. 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

  1. 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.

Image RemovedImage Added

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:

  1. Choose Assets > Asset Navigator.

  2. Refine your search, then choose the Export menu.

  3. Choose "Export for Cloud" from the dropdown menu.

  4. Select the delimiter, and click Download.

    Image Added
  5. The system will generate a cloud-compatible export file.

Panel
panelIconIdatlassian-warning
panelIcon:warning:
bgColor#F4F5F7

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.