Advanced Export – Documentation

ADVANCED EXPORT

Export any standard or custom field

Select any of the standard or custom Jira fields to export. Save as Excel XLSX, CSV or raw JSON files.

Export historical changes
to field values

Optionally export all the changes to the values of selected fields as separate rows.

Save named export configurations

Easily save and load export configurations. Control configuration's permissions to share with coworkers.

Shadow
Slider

More about advanced export

What is Advanced Export

With Advanced Export for JIRA you can easily export issues (including history of changes) for further analysis in a spreadsheet or other tools.

As far as we know this is the only add-on that allows for export of history of changes for JIRA issues. Simply select what standard JIRA fields of custom fields you’re interested in and download exported CSV or Excel XLSX file. The file will contain additional row for every change of any of the selected fields.

example

Let’s assume there’s a JIRA project with 2 custom fields: Ice Cream Flavor and Reason. Issues in this project track current preferences for ice cream. Owner of one of the issues started with Vanilla ice cream and a reason of Safe Choice. He then changed the fields to Chocolate and Adventurous, followed by Strawberry and Why Not.

All these changes can be found in issue history panel in JIRA, however analysis would become cumbersome if we had tens or hundreds of issues with many changes for each.

With Advanced Export add-on you can export CSV file which would look similar to the below (assuming we’re exporting fields Created, Ice Cream Flavor, Reason, Assignee):

KeyAs Of DateChanged FieldsCreatedIce Cream FlavorReasonAssignee
1 ISSUE-1 05/23/2020 05/01/2020 Strawberry Why Not Tomek
2 ISSUE-1 05/15/2020 Ice Cream Flavor, Reason 05/01/2019 Strawberry Why not Tomek
3 ISSUE-1 05/10/2019 Ice Cream Flavor, Reason 05/01/2019 Chocolate Adventurous Tomek
4 ISSUE-1 05/01/2019 05/01/2019 Vanilla Safe Choice Tomek

Columns KeyAs Of Date and Changed Fields are always added by the report.

  • Row 1: current values of fields. Changed Fields is empty as there were no changes on the day the report was generated.
  • Rows 2-3: rows representing snapshots of values of fields on the dates changes occurred. Changed Fields show which fields were amended.
  • Row 4: initial state of the issue as it was created

Note, that values in columns Created and Assignee remained constant.

Advanced Export Usage

Use Advanced Export icon on any Search issues screen as seen below:

Select fields that you want to export, and choose whether history should be exported as well (this will produce extra rows for each change of the issue, as described above).

Note, that Preview shows actual data from the first issues being exported. It changes as you select fields to export and change settings.

Ready to use Advanced Export?

Get started with a trial for your business

Support

Send us an email: support@kanbanalytics.com

SNG Technologies Ltd. aims to respond within 24 hours to new support requests and provide an update at least every 48 hours for existing support requests, although we frequently respond much faster. With clients working across many different time zones, we try to prioritise our support requests, so that we can provide the best level of support for all our customers across several continents.

Frequently asked questions

| 403 – Forbidden; 414 – URI too long errors

One of these errors occur when you try to export more than around 1000 items when accessing the app from Export/Advanced Export dropdown menu. This is legacy method of using this app and is not recommended anymore.

Please use Advanced Export icon from Search issues screen as described above.

Data security and privacy statement

This app doesn’t store any data related to users, issues or any other information from JIRA instance it’s installed on. All the computations are performed in the browser. No data from JIRA is transmitted to the server at any time.

The plugin uses Google Analytics to track usage statistics.

© 2020 SNG Technologies Ltd. All rights reserved.