Assetas support

Data Export

There are multiple pathways to export your data out of Assetas. Data may be exported in different formats based on the type of data. 

Exporting reports | Exporting documents | Exporting JSON files for configuration records | Exporting locations and units of measure | Related topics

Icon Light 500px.png
Assetas support
  1. Locate your desired report.

  2. Select the "Run this report" button under the Actions menu.  

  3. Populate any arguments required by the report and select "Refresh Report".

  4. Once the report looks as expected, select the "Export the report" button at the top right, across from the report name.

  5. Select one of the following export types.  The exported file will be generated after selection.

    1. Excel:  Export the report as an Excel (xlsx) file.

    2. PDF: Export the report as a PDF file.

    3. Copy: Copy the report data to the clipboard as a tab-separated table.

    4. CSV: Export the report as a comma-separated value (csv) file.

    5. JSON: Export the report as a JavaScript Object Notation (json) file.

Exporting reports
 
  1. Locate your desired document.

  2. To the right of the document, under the Actions menu, you may download the document in its original format.

Exporting documents
 
  • Reports (see the Exporting Reports section above)

  • Form Types

  • Dashboard Templates

  • Manufacturers and Models

  • Report Categories

  • Statuses of Assets, Contacts, Documents, and Tasks

  • Types of Asset Associations, Assets, Contacts, Documents, Roles, Tasks, and Telemetry

  • Scheduled Jobs

  • Workflows

To export the JSON file for a Configuration menu record:

  1. Locate your desired record.

  2. To the right of the record, under the Actions menu, you may download the JSON file for the record.

Exporting JSON files for configuration records

Within one account of Assetas, a user can export a JSON file that can be imported into another account using the Data Import tool.
 

This tool is intended for users to import files exactly as exported; Assetas does not support importing adjusted exported JSON files. Please note that the system will not import or update data for exported “system-defined” records.

The following records types are available for exporting as a JSON file for import into another account:

 
  1. Expand "Configuration" in the sidebar navigation.

  2. Expand the "Lists & Types" menu under "Configuration".

  3. Locate your desired list.

    • Expand the "Locations" section​ for the Locations lists which includes countries, U.S. counties, states/provinces, and time zones.

    • Select "Units of Measure" for that data.

  4. Select the "Export the list" button at the top right, across from the list name.

  5. Select one of the following export types.  The exported file will be generated after selection.

    1. Excel:  Export the list as an Excel (xlsx) file.

    2. PDF: Export the list as a PDF file.

    3. Copy: Copy the list data to the clipboard as a tab-separated table.

    4. CSV: Export the list as a comma-separated value (csv) file.

Exporting locations and units of measure