Export objects

Exporting objects from Assets lets you integrate data into other systems for analysis or create backups. Objects are exported as a CSV file.

To export objects:

1. Go to Assets and select an object schema.

2. Select the object type.

   1. You can filter objects using filter search or advanced search.

3. Select the List view icon.

4. Select Bulk actions, then Edit objects in the dropdown.

5. A window will pop up:

   1. Configure the options for export (see below for more details).

   2. Select Export to create the CSV file.

Options for export

Delimiter

This specifies the separator for the values in the header and data records. You can use the default comma (,) or choose from: 

• semicolon (; )

• tab

Encoding

This denotes the encoding format that will be used for the data records in your CSV file. You can choose one of the following:

• UTF-8

• UTF-16

• ISO-8859-1

• ISO-8859-15

• Windows-1250

• Windows-1252

Format

This indicates whether the data stored in the CSV file should be Data consistent (unprocessed) or User friendly.

• If you want to import the data to Assets for data migration or recovery purposes, then the Data consistent option will help you to preserve the references and date formats appropriately.

• Alternatively, if you use the CSV file with a reporting tool like Power BI or open it in Microsoft Excel or Google Sheets then the User friendly option will display the data in a meaningful manner.

The tables below show what is stored in the CSV file for certain object types in both formats:

User friendly format

Data consistent format