KanbanalyticsKanbanalytics
← All Docs
Advanced Export (Atlassian)

Exporting data

You can access the export screen in 2 ways:

  • from the Advanced issue search screen (Filters -> Advanced issue search) by clicking Advanced export icon in the upper right part of the screen
  • from the Dashboard (Apps -> Advanced Export), but clicking on "Create export" or any existing export configurations

Options

Advanced Export view
  • Export issues: JQL to filter issues to export. You can use any Jira issue filter you have defined earlier by clicking From filter.
  • Fields to export: A set of fields to add as report columns. Some custom fields may not be known to the app, in which case you'll see a warning. You can still add them, but they will be presented as plain text.
  • History export: If checked, the app will export all the changes made to the issues in separate rows. It will also add 4 extra columns:
    • As Of Date - the date of the change or current date for the row containing values as of now
    • Changed Fields - the list of fields that were changed at that date
    • Change Author - the user who made the change
    • Time In This State - the time the issue spent in the current status
  • Date/Time Format: you can select one of the predefined formats
  • Time Difference: format of the time difference between 2 dates (used for example for Time In This State column)
  • CSV Separator: only used for CSV export, ignored for other formats
Note

All the dates will be presented in the time zone of the Jira instance, not the time zone of your browser/computer. You'll see information about it in case your browser time zone differes from the Jira instance time zone.

If, for example, your Jira instance is set up to use America/New York time zone, and you are in Europe/London, the dates will be presented in America/New York timezone and will be shifted by 5 hours.

Live preview

The preview is generated in the browser as you change options or add/remove fields or modify JQL. It shows first several issues that match the JQL. It's useful to quickly check if the export is configured correctly and data you need is presented correctly.

Saved configurations

You can save or load export configurations using the top menu on the export page.

Save/load configurations

Saved configurations contain all the options and selected columns.

Save As dialog

Limitations

There's no limit of how many issues or fields you can export. Reports are generated in the browser, so exporting large amount of issues can take a while.

There are 2 solutions for that:

  • Export less issues: use JQL to filter issues to manageable amount
  • Schedule export: you can schedule export to run in the background and send you an email with the results.

Data format

Comments

Comments are exported by default in a single text column.

  • comments are sorted latest to oldest
  • format of each comment is: “AUTHOR, DATE, COMMENT_BODY"
  • column with comments is enclosed with quotes for CSV output (quotes inside comments are escaped with double quotes)
  • comments are separated with: new line - pipe symbol (“|”) - new line (“\n|\n”)

Example output:

Key,Comment
SSP-28,"Tomasz Kustrzynski, 2024-02-23T10:11:49-05:00:
another comment with “some quotes”, ""different quotes"" and an emoji 😀 
|
Tomasz Kustrzynski, 2024-02-23T09:01:51-05:00:
another comment
|
Tomasz Kustrzynski, 2024-02-23T09:01:47-05:00:
first comment"