This documentation is for Insight for Jira Cloud only.



Exporting objects provides you a way to feed your data in any other system and do subsequent data analysis. You can also take occasional backups using this feature.

In order to export objects, you can either be in the Insight Administrator, Insight Manager, Insight Developer or even the Insight User role. Follow the steps below.

  1. Click on in the left sidebar of your Jira cloud instance. If you have the alternate navigation in use, you will see this option on the horizontal menu.
  2. Under Insight, click Object Schemas and select the object schema whose objects you want to export.
  3. Click on your preferred Object type.
  4. On the far right, click on the  icon and select the option of Export objects as shown below.

  5. A pop up will be displayed informing you about the objects being exported. It will also ask you to configure few settings for the export to get completed as shown below. The options are described below.

  6. After you configure all options, click on the Export button. The objects will now be exported to a file in CSV format and will be downloaded on your instance.


The CSV file will contain the header record which is a comma separated (default separator is comma) string of all the names of the attributes for your exported object type. The subsequent rows are the data records for each of those attributes.

Export objects is a bulk feature available on all object types.





Configurable options for export

The table below describes the options that you can set for your export.

OptionDescription
Delimiter

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

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

In case you import the data to Insight for data migration or recovery purposes, then Data consistent option will help you to preserve the references and date formats appropriately.

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

Following is a quick reference of what is stored in the CSV file for certain object types in both formats:

User friendly format
Attribute type                              Stored value                                                                                                                                     
Referenced ObjectThe label of the value
UserThe display name of the user
StatusThe name of the value
Date, DateTimeThe value of the date in a format that is set in Jira
TextareaOnly the plain text value. All the HTML tags in the value will be removed.
Data consistent format
Attribute type                                           Stored value                                                                                                                                                         
Referenced ObjectThe Key of the value
UserThe account id of the user
StatusThe Id of the value
Date, DateTimeThe value of the date in a unix timestamp
TextareaThe entire HTML markup value