In this page

Version History

VersionDateNotes
3.2.002/10/2017Support for Zephyr.Release Notes & Upgrade GuideDownload
3.1.008/09/2017Compatibility release for JIRA 7.5.Release Notes & Upgrade GuideDownload
3.0.001/08/2017Major performance improvements. "Performance Tuning" page.Release Notes & Upgrade GuideDownload
2.6.021/06/2017Support for nFeed.Release Notes & Upgrade GuideDownload
2.5.016/05/2017Support for the Insight asset management add-on.Release Notes & Upgrade GuideDownload
2.4.126/04/2017Important bugfix: Excel rendering randomly fails with classloading exceptions.Release Notes & Upgrade GuideDownload
2.4.003/03/2017Performance improvements. Zero-config templates. New "repeating fields" templates. New calculated field type: "Excel parent key".Release Notes & Upgrade GuideDownload
2.3.005/01/2017Compatibility release for JIRA 7.3.Release Notes & Upgrade GuideDownload
2.2.016/12/2016Excel view visibility. UI integration with JIRA Agile, JIRA Service Desk and Tempo. "Link" cell type.Release Notes & Upgrade GuideDownload
2.1.029/08/2016Compatibility release for JIRA 7.2.Release Notes & Upgrade GuideDownload
2.0.007/06/2016Groovy editor, support for Visual Basic macros, date conversion, user exports.Release Notes & Upgrade GuideDownload
1.3.011/01/2016JIRA Data Center support, added support for older JIRA versions, MIME type and automation improvements.Download
1.2.016/11/2015Compatibility release for JIRA 7. Calculated fields with or without custom fields.Release Notes & Upgrade GuideDownload
1.1.011/09/2015Powerful field value formatting and calculated fields. Support for JIRA Agile, JIRA Service Desk and Tempo.Release Notes & Upgrade GuideDownload
1.0.018/11/2014Stable version with commercial support.Release Notes & Upgrade GuideDownload

Release Notes

3.2.0

Support for Zephyr

Zephyr is the most popular test management solution for the JIRA platform. From this Better Excel Plugin version, you can export Zephyr tests, test steps, test executions and test step results to Excel. Four templates are provided out of the box that solve the most typical Excel exporting and reporting use cases (and as always, can be customized!):

  1. Export the currently selected fields plus test steps (from the Issue Navigator to Excel)
  2. Export the currently selected fields plus test executions
  3. Export the currently selected fields plus test executions including detailed step results
  4. Zephyr report with various tables and charts (test results per version / cycle / tester, execution history over time, defects per test / execution, etc.)

See some sample exports from Zephyr and learn more about this integration.

Improvements
  • Default titles and default filenames are generated according to a slightly revised logic: "issue key" (for single issues), "search request name" (for saved filters with a name), "Excel view name (JIRA title)" in this order of precedence.
Bugfixes
  • Fixed: character encoding in Tempo worklog comments (that use international characters) may break when exporting from JIRA instances hosted on Windows
  • Fixed: "Reporter" column is empty when exporting with the created-vs-resolved-report.xlsx or insight-report.xlsx templates
Upgrading from 3.1.0

Several Excel templates and script files were introduced or updated in this release. You can take advantage of all the enhancements by executing the following steps.

Steps:

  1. Upgrade the plugin JAR as usual, through the Universal Plugin Manager.
  2. Download the ZIP that contains the latest template files: jira-better-excel-plugin-3.2.0-templates.zip, and extract it.
  3. Login to JIRA as administrator, go to AdministrationAdd-Ons Excel Templates (under Excel Views).
  4. Upload the following files from the directory where the ZIP was extracted:
    1. created-vs-resolved-report.xlsx
    2. insight-report.xlsx
    3. issue-navigator-with-zephyr-test-executions.xlsx
    4. issue-navigator-with-zephyr-test-step-results.xlsx
    5. issue-navigator-with-zephyr-test-steps.xlsx
    6. tempo-tool.groovy
    7. zephyr-report.xlsx
    8. zephyr-tool.groovy
  5. Create the new Excel views that render the new templates:
    1. To create a new export option in the Export dropdown, go to Excel Views (in the left-side bar) and click Add a new view.
    2. Enter "Zephyr Executions (Curr. f.)" as name, check the Issue Navigator context option (at least), select the template file issue-navigator-with-zephyr-test-executions.xlsx and click submit. If you are not using Zephyr at all or don't want to activate the Zephyr related Excel views for now, then do not select any of the contexts. (It is possible to create views without any context selected, making them invisible for now, but also making it super-easy to activate them later.)
    3. The Excel view you created in the previous step will export the currently visible columns in Issue Navigator plus the test executions details added in the right. If you need an additional view which exports all issue fields plus the test executions (to a super-wide spreadsheet), then create another view with the same template, but with the name "Zephyr Executions (All f.)". (Note: if the view name contains the word "all", then all columns will be exported.)
  6. Repeat the previous step also with the following templates:
    1. issue-navigator-with-zephyr-test-step-results.xlsx (view name: "Zephyr Step Results (C. f.)" for current fields or "Zephyr Step Results (All f.)" for all fields)
    2. issue-navigator-with-zephyr-test-steps.xlsx (view name: "Zephyr Test Steps (Curr. f.)" for current fields or "Zephyr Test Steps (All f.)" for all fields)
    3. zephyr-report.xlsx (view name: "Zephyr (Excel)")
  7. If during the previous steps you haven't selected any context for any of the Zephyr related Excel views (i.e. you don't want to use the Zephyr integration at all), then you can skip this step. Otherwise, you need to configure the Zephyr API access: just see this guide.
  8. Enjoy!

3.1.0

Compatibility release for the JIRA 7.5 line.

Upgrading from 3.0.0

Just update your plugin using UPM (the plugin manager built in to JIRA), that's all.

3.0.0

Major performance improvements

This release focuses on performance.

While working on this, we ran hundreds and hundreds of profiling sessions to find the performance bottlenecks that make the export process long (CPU) and consume unjustified amount of resources (memory). We reworked the resource intensive and memory hungry operations in the add-on code and in the default templates. This results in faster and more stable Excel exports from this release.

OK, but how much faster? This is difficult to tell how much improvement you will see in your environment compared to previous versions, as it depends on many different factors. Primarily factors are the template complexity (general logic, embedded iterations, etc.), data size (number of issues, number of dynamic columns, etc.) and data variance (which affects auto-sizing). The overall improvement can be anything between negligible (for small under-a-second tables) to 500% (for large tables).

To enjoy the improvements:

  1. Upgrade the default templates and scripts (see the upgrade guide below)
  2. Review your own templates and scripts using our new "Performance Tuning" guide in case you want to improve those now or in the future (see next section)
New "Performance Tuning" page

Not only we improved the add-on and the default templates for better performance, we also compiled a page about what to do and what to avoid when developing custom templates for large scale of data. We will keep improving the Performance tuning page with our future findings, as well.

New "Getting Started" page

We added a "getting started" page to the add-on to save some reading for first time evaluators. As it may be useful even for more experienced users, it can also be visited via the link at AdministrationAdd-OnsGetting Started (under Excel Views).

Improvements
  • New tag parameter <mt:autosize whiteSpace="3.5"> can specify the cell padding to avoid "######" cells and unwanted text wrapping (both caused by narrow columns).
  • New tag parameters <mt:autosize columnLimit="15" rowLimit="5"> can drastically speed up auto-sizing by limiting the cell region to test for optimal column width and optimal row height.
  • New tag parameter <jt:forEach copyColumnWidthsRight="false"t> makes it faster to render horizontal iterations.
  • Blank cell coloring helps to verify if your templates are clean and tidy.
  • Cell-level logging can generate super-detailed logs for trouble-shooting (you will rarely need it, but it's there now).
Upgrading from 2.6.0

We made major updates on the Excel templates and the Groovy scripts. You can take advantage of all the performance improvements by precisely executing the following steps.

Steps:

  1. Upgrade the plugin JAR as usual, through the Universal Plugin Manager.
  2. Download the ZIP that contains the latest template files: jira-better-excel-plugin-3.0.0-templates.zip, and extract it.
  3. Login to JIRA as administrator, go to AdministrationAdd-Ons Excel Templates (under Excel Views).
  4. Upload each file (both .xlsx and .groovy files) one by one from the directory where the ZIP was extracted.
  5. Enjoy!

2.6.0

Support for nFeed (by Valiantys)

The nFeed add-on integrates external data sources (SQL databases, LDAP, Active Directory, REST APIs, Salesforce, CSV files, etc.) to JIRA. From this version, Better Excel Plugin is tightly integrated with nFeed, allowing you to export all nFeed custom fields to Excel. More than data export, you can easily implement custom reporting and Business Intelligence on nFeed data.

See some sample exports from nFeed and learn more about this integration.

Upgrading from 2.5.0

One script file was updated in this release. You can take advantage of all the enhancements by executing the following steps.

Steps:

  1. Upgrade the plugin JAR as usual, through the Universal Plugin Manager.
  2. Download the ZIP that contains the latest template files: jira-better-excel-plugin-2.6.0-templates.zip, and extract it.
  3. Login to JIRA as administrator, go to AdministrationAdd-Ons Excel Templates (under Excel Views).
  4. Upload the field-helper-tool.groovy file from the directory where the ZIP was extracted.
  5. Enjoy!

2.5.0

Support for the Insight asset management add-on (by Riada)

Insight is the leading asset management add-on for JIRA, that allows implementing CMDB, CRM, HR, ITSM or ITIL functionality on the JIRA platform. From this release, Better Excel Plugin is tightly integrated with Insight, allowing you to export all Insight custom fields with the desired granularity (object keys, names, and attributes) to Excel. More than data export, you can easily implement custom reporting and Business Intelligence on Insight data.

See some sample exports from Insight and learn more about this integration.

Bugfixes
  • Fixed: Long issue keys like "VERYLONGPROJECTKEY-123" cannot be exported from agile boards (because of being shortened to "VERYLONG...-123")
Upgrading from 2.4.1

One script file was updated, plus one new Excel template and one new script were introduced in this release. You can take advantage of all the enhancements by executing the following steps.

Steps:

  1. Upgrade the plugin JAR as usual, through the Universal Plugin Manager.
  2. Download the ZIP that contains the latest template files: jira-better-excel-plugin-2.5.0-templates.zip, and extract it.
  3. Login to JIRA as administrator, go to AdministrationAdd-Ons Excel Templates (under Excel Views).
  4. Upload the following files from the directory where the ZIP was extracted:
    1. field-helper-tool.groovy
    2. insight-report.xlsx
    3. insight-tool.groovy
  5. If you want to activate the Insight report template, then also:
    1. To create the new export option in the Export dropdown, go to Excel Views (in the left-side bar) and click Add a new view.
    2. Enter "Insight (Excel)" as name, check the Issue Navigator context option (at least), select the template file insight-report.xlsx and click submit.
    3. Configure the custom field ID in insight-report.xlsx. See this guide.
  6. Enjoy!

2.4.1

This version fixes the problem of the Excel rendering randomly failing with mysterious classloading related exceptions: NoClassDefFoundError: ZipPackagePropertiesMarshaller and ExceptionInInitializerError (caused by ClassCastException: PackagePropertiesMarshaller).

Root cause: when using the Better Excel Plugin in an automation context, Automation Lite uses its own classloader to eagerly load and initialize an XML related class.

Fix: although the problem is not in the Better Excel Plugin side, we managed to develop a fix for this.

Upgrading from 2.4.0

Just update your plugin using UPM (the plugin manager built in to JIRA), that's all.

2.4.0

This release comes with a large number of useful improvements, that include both popular feature requests and important bugfixes.

Performance improvements for spreadsheets with many columns

We made dynamic columns rendering faster, which primarily improves the performance the "issue-navigator*.xlsx" templates. Depending on the number of columns, the difference can be negligible (for 8 columns), significant (30-100% faster for 15 columns) or radical (up to 300-400% faster for hundreds of columns). Overall, the "wider" your spreadsheet, the bigger the difference.

Zero-config templates

We introduced convenience methods to the field-helper.groovy script that allows getting custom field values by the custom field name. We also updated the templates that rely on custom fields like "Account" (Tempo), "Sprint" (JIRA Agile), "Time to resolution" (JIRA Service Desk) to access those by name. The advantage is that these will work immediately, without requiring you to correctly set the custom field IDs prior to using the template.

Learn more about the new convenience methods in the Excel template customization tutorial.

New "repeating fields" templates

The repeating field version of the issue-navigator-with-worklogs.xlsx and issue-navigator-with-tempo-worklogs.xlsx templates are now available. Those help to transfer data directly from the Issue Navigator to external systems.

Learn more about the repeating field mode among the super-useful recipes.

New calculated field type: "Excel parent key"

This new calculated field can show the parent key for sub-tasks, either as plain text or as link.

Learn more about "Excel parent key" in the calculated fields section.

Improvements
Bugfixes
  • Fixed: Created, Updated, Resolution Date, Date Time Picker type custom fields and the datetime-valued calculated fields (Excel first comment date and Excel last comment date) ignore the timezone of the current user (note: Due Date and Date Picker type custom fields export pure dates (no time part and no timezones!) to be compatible with JIRA)
  • Fixed: XLSM and XLS format export files are served with the XLSX files' MIME type, confusing Internet Explorer
  • Fixed: tempo-tool.groovy is using blank base URL, therefore cannot connect to the Tempo worklog servlet
  • Fixed: Formulas containing "<" cannot be parsed (workaround was: flip the formula and use ">")
  • Fixed: The created-vs-resolved-report.xlsx and worklog-report.xlsx templates use the TEXT() function produce month names, but the format string works reliably in English Excel versions only
  • Fixed: The workflow-report.groovy script should generate a time metric also for the last (current) status of each issue
Also: Excel Automation Plugin 2.1.0 released!

We hope you are already using the Excel Automation Plugin, our free add-on that allows integrating the Better Excel Plugin to automatic business processes. If you are, then remember to upgrade your Excel Automation Plugin to 2.1.0, its latest version released the same day as Better Excel Plugin 2.4.0. (We developed these two releases in parallel, make sure you leverage their integration!)

If you are not using that yet, make sure to give this a try! It will save you from lots of boring manual work by creating and distributing Excel reports automagically!

Learn more about the improvements in the Excel Automation Plugin 2.1.0 release notes.

Upgrading from 2.3.0

Several template and script files were updated in this release. You can take advantage of all the enhancements by executing the following steps.

Steps:

  1. Upgrade the plugin JAR as usual, through the Universal Plugin Manager.
  2. Download the ZIP that contains the latest template files: jira-better-excel-plugin-2.4.0-templates.zip, and extract it.
  3. Login to JIRA as administrator, go to AdministrationAdd-Ons Excel Templates (under Excel Views).
  4. Upload the following files from the directory where the ZIP was extracted:
    1. basic-issue-list-template.xlsx
    2. created-vs-resolved-report.xlsx
    3. field-helper-tool.groovy
    4. issue-navigator-with-comments.xlsx
    5. issue-navigator-with-history.xlsx
    6. issue-navigator-with-repeating-tempo-worklogs.xlsx
    7. issue-navigator-with-repeating-worklogs.xlsx
    8. issue-navigator-with-tempo-worklogs.xlsx
    9. issue-navigator-with-worklogs.xlsx
    10. issue-navigator.groovy
    11. jira-agile-report.xlsx
    12. jira-service-desk-report.xlsx
    13. tempo-report.xlsx
    14. tempo-tool.groovy
    15. workflow-report.groovy
    16. worklog-report.xlsx
  5. Enjoy!

2.3.0

Compatibility release for JIRA 7.3.

Upgrading from 2.2.0

Just update your plugin using UPM (the plugin manager built in to JIRA), that's all.

2.2.0

This version enables to configure visibility rules for the Excel views, to show or hide them dynamically for user, groups and issues. Also, Better Excel Plugin now seamlessly integrates with the user interface of the most widely used JIRA plugins: JIRA Agile, JIRA Service Desk and Tempo. As for the templates, it generates hyperlinks for the Issue key and Summary columns, and it standardizes on using the 1900 date system.

View visibility

You can set up smart conditions for the Excel views. The availability of each view can be restricted to:

  • Certain groups
  • Certain users
  • Issues that match a given JQL expression (e.g. only display the "Timesheet (Excel)" export type for Task type closed issues)
User interface integration with JIRA Agile, JIRA Service Desk and Tempo

You can now export Excel spreadsheets directly from:

  • JIRA Agile: backlog and Scrum/Kanban board views
  • JIRA Service Desk: ticket queues
  • Tempo: timesheet, calendar, report and list views
Support for view contexts

Previous Better Excel Plugin versions used the concept of view types. From this version, we allow more fine-grained control over which screen in the UI a view should be available in:

You can set any combination of these so-called view contexts for each Excel view. Combining this with the optional restrictions (limit each view to certain users, to certain user groups, to certain issues), you can flexibly configure all your Export menus.

When you upgrade to this add-on version, your views will be migrated to the most intuitive contexts (see the table below). You may want to review those settings after the migration.

View type View contexts
Single issue only Single Issue View
Multiple issues only Issue Navigator
JIRA Agile Backlog
JIRA Agile Board
JIRA Service Desk
Tempo Timesheet
Single and Multiple issues Single Issue View
Issue Navigator
JIRA Agile Backlog
JIRA Agile Board
JIRA Service Desk
Tempo Timesheet
Disabled none

The new cell type called "link" was introduced to turn cells into clickable hyperlinks.

Having this new mechanism, we changed the cell type of the Issue key and Summary columns from plain text into links, when exported from the Issue Navigator. If you prefer the old non-link representation for some reason, you can return to that by modifying two configuration parameters in field-helper.groovy.

See this recipe for more information about exporting hyperlinks.

All default templates use the 1900 date system

The following template files were updated to use the 1900 date system in Excel:

  1. issue-navigator.xlsx
  2. issue-navigator-with-comments.xlsx
  3. issue-navigator-with-history.xlsx
  4. issue-navigator-with-tempo-worklogs.xlsx
  5. issue-navigator-with-worklogs.xlsx
  6. jira-service-desk-report.xlsx

(All other templates were already using the 1900 date system.)

Please note that templates using the 1904 date system were (and still are) working correctly, but you may face difficulties when copying data from 1904 based spreadsheets to 1900 based spreadsheets and vice versa. We decided to consistently use the 1900 date system in all our templates, as it offers better compatibility with spreadsheet tools.

Bugfixes
  • Fixed: Excel API (and Excel Automation for JIRA) always generates files with the ".xlsx" extension even if the template is ".xls" or ".xlsm" type
  • Fixed: "All fields" type exports at single issues export only a subset of the fields
Upgrading from 2.1.0

Several template files were updated in this release. You can take advantage of all the enhancements by executing the following steps.

Steps:

  1. Upgrade the plugin JAR as usual, through the Universal Plugin Manager.
  2. Download the ZIP that contains the latest template files: jira-better-excel-plugin-2.2.0-templates.zip, and extract it.
  3. Login to JIRA as administrator, go to AdministrationAdd-Ons Excel Templates (under Excel Views).
  4. Upload the following files from the directory where the ZIP was extracted:
    1. basic-issue-list-template.xlsx
    2. field-helper-tool.groovy
    3. issue-navigator.groovy
    4. issue-navigator-with-comments.xlsx
    5. issue-navigator-with-history.xlsx
    6. issue-navigator-with-tempo-worklogs.xlsx
    7. issue-navigator-with-worklogs.xlsx
    8. issue-navigator.xlsx
    9. jira-service-desk-report.xlsx
  5. Lean back and have a chocolate.

Two final notes about the upgrade:

  1. If you are also using our super-awesome PDF View Plugin, we suggest to upgrade that to the 5.6.0 version (or newer) for best interoperability. That add-on and the Better Excel Plugin are using shared Export menus, and these two versions give you the best experience.
  2. You may eventually see a LinkageError written the JIRA log when running Excel automations after the upgrade. See this troubleshooting item for the easy fix.

2.1.0

This version is simply a compatibility release for the JIRA 7.2 line.

Upgrading from 2.0.0

Just update your plugin using UPM (the plugin manager built in to JIRA), that's all.

Upgrading to this version is necessary if you want to use the plugin with JIRA 7.2.

2.0.0

This release introduces several new features and minor enhancements, that significantly improve the overall experience of creating Excel reports from JIRA. The primary driving force behind these improvements was the feedback we received from the user community during the last couple of months. (We take your requests seriously, so keep them coming!)

Built-in Groovy editor

A web-based Groovy editor was introduced, to ease making changes in the Groovy scripts that are executed during exports.

Support for Visual Basic macros and macro-enabled workbooks

Utilize VBA code to enhance your Excel exports with dynamic behavior (format, update, post-process content) and interactions (ex: display alerts).

Learn more in the Visual Basic macros tutorial.

Auto-conversion for all date type fields

All date type system fields (creation date, resolution date, etc.) and custom fields (date picker, date time picker) are automatically transformed to Excel's date representation (sequential serial numbers).
If you used Excel formulas for this conversion with previous add-on versions, don't forget to check the corresponding part of the upgrade guide.

User export

Use the new export option (disabled by default) to export all user account information from JIRA to Excel, for every sort of maintenance and analysis purporses.

Learn more in the exporting JIRA users to Excel tutorial.

View names in the "Export" drop-down in any language

View names can now contain alphanumeric characters from any language, from German to Japanese. This was previously limited to the English characters only. Finally, you can offer native language experience for your team.

Additional improvements
  • User-friendly warning message when trying to export more issues than the limit (1000, by default), instead of the non-intuitive "403 error" screen JIRA offers by default
  • Correct file extension and MIME type returned for any XLSX, XLSM and XLS template (Internet Explorer will not get confused when facing inconsistent MIME types and file extensions anymore)
  • <mt:autosize> tag can resize rows only, columns only or both, giving you more flexibility in automatic layout optimization
  • Support for the "creator" field
  • Guide for users running non-English versions of Excel covers the differences between localized Excel versions in the context of the Better Excel Plugin (a must-read for anyone running one of those!)
Upgrading from 1.3.0 (and from 1.2.0)

A new template was introduced to enable exporting user account information, and some existing templates and scripts were improved, too. You can take advantage of these enhancements by executing the following steps.

Steps:

  1. Upgrade the plugin JAR as usual, through the Universal Plugin Manager.
  2. Download the ZIP that contains the latest template files: jira-better-excel-plugin-2.0.0-templates.zip, and extract it.
  3. Login to JIRA as administrator, go to AdministrationAdd-Ons Excel Templates (under Excel Views).
  4. Upload the following files from the directory where the ZIP was extracted:
    1. field-helper-tool.groovy
    2. user-export.xlsx
    3. user-export.groovy
    4. workflow-report.xlsx
    5. workflow-report.groovy
  5. To create the corresponding options in the Export dropdowns, go to Excel Views (in the left-side bar) and click Add a new view:
    1. Enter "Users (Excel)" as name, choose the desired type, select the template file user-export.xlsx and click submit.
  6. Go to Issue Navigator, open the Export menu and click the view created in the previous step for testing.
  7. When developing custom Excel templates in previous add-on versions, date and date-time values required formulas to convert the Java time representation to Excel's time representation. From 2.0.0 this will be automatically done for you by the fieldHelper tool, without using formulas. Therefore, when updating to 2.0.0, you should search and rewrite those formulas in your existing templates, following the instructions below. If you don't have any custom templates, you can skip this step.
    1. Check all your custom templates for expressions similar to this:
      ${fieldHelper.getFieldValue(issue, "customfield_10280")/1000.0/86400.0+25569}
    2. Check also for the null-tolerant version of that expression:
      ${fieldHelper.getFieldValue(issue, "customfield_10280") ? fieldHelper.getFieldValue(issue, "customfield_10280")/1000.0/86400.0+25569 : ""}
    3. Remove the formula part, and simplify that simply to:
      ${fieldHelper.getFieldValue(issue, "customfield_10280")
  8. Lean back and grab a cup of coffee.

1.2.0

This version is a compatibility release for the JIRA 7 line, also maintaining compatibility with the JIRA 6 line. The only functional change is that calculated fields can now be used without creating the corresponding "placeholder custom fields" (it was required in previous versions).

Calculated fields with or without custom fields

From this version, calculated fields can be used without the need to create a matching JIRA custom field. Calculated fields are entirely virtual, not necessarily appearing in the JIRA configuration, only in the Groovy script that implements them.

Note that you still need to create a JIRA custom field for the calculated field, if you want to export that from Issue Navigator. In that context the column represented by the custom field is required for visibility and positioning of the calculated field.

Upgrading from 1.1.0

Only one Groovy script file has been updated for JIRA 7.

Steps:

  1. Upgrade the plugin JAR as usual, through the Universal Plugin Manager.
  2. Download the ZIP that contains the latest template files: jira-better-excel-plugin-1.2.0-templates.zip, and extract it.
  3. Login to JIRA as administrator, go to AdministrationAdd-Ons Excel Templates (under Excel Views).
  4. Upload the file field-helper-tool.groovy from the directory where the ZIP was extracted.
  5. Have some chocolate.

Known and harmless issue: RuntimeException with XlsViewComparator

During the upgrade the following exception may appear in your JIRA log: java.lang.RuntimeException: com/midori/jira/plugin/betterexcel/model/XlsViewComparator.

You can safely ignore this. This is caused by a timing problem during the installation, but it has zero effect after being displayed only once, right after the plugin version upgrade.

1.1.0

This version focuses on bringing more data and better data from JIRA to your Excel reports.

Powerful field value formatting

Transform the JIRA values to the their best representation in Excel. "Best" can mean different things in different use cases, but this tool will be your best friend in general when briding between JIRA fields and Excel cells.

Learn more in the user manual.

Calculated fields

Export fields, which are dynamically calculated during the export, to Excel. These can, for instance, return the issue's last comment, combine the value from multiple fields, connect to an external API, or do any custom computation.

Learn more in the user manual.

Support for JIRA Agile, JIRA Service Desk and Tempo

Export all data from these popular JIRA add-ons to Excel, and create powerful reports from your sprints, user stories, tickets (Service Desk managed issues) and Tempo worklogs.

See the Integrations page for details.

Upgrading from 1.0.0

Several new templates were introduced, and some existing resources were improved, too. You can take advantage of these enhancements by executing the following steps.

Steps:

  1. Upgrade the plugin JAR as usual, through the Universal Plugin Manager.
  2. Download the ZIP that contains the latest template files: jira-better-excel-plugin-1.1.0-templates.zip, and extract it.
  3. Login to JIRA as administrator, go to AdministrationAdd-Ons Excel Templates (under Excel Views).
  4. Upload the following files from the directory where the ZIP was extracted:
    1. basic-issue-list-template.xlsx
    2. field-helper-tool.groovy
    3. issue-navigator.groovy
    4. issue-navigator.xlsx
    5. issue-navigator-with-comments.xlsx
    6. issue-navigator-with-history.xlsx
    7. issue-navigator-with-tempo-worklogs.xlsx
    8. issue-navigator-with-worklogs.xlsx
    9. jira-agile-report.xlsx
    10. jira-service-desk-report.xlsx
    11. tempo-report.xlsx
    12. tempo-tool.groovy
  5. To create the corresponding options in the Export dropdowns, go to Excel Views (in the left-side bar) and click Add a new view:
    1. Enter "Comments (All fields)" as name, select the type "All", select the template issue-navigator-with-comments.xlsx, and submit.
    2. Similarly, create "Comments (Current fields)" with the type "Multiple issues only" and issue-navigator-with-comments.xlsx.
    3. Create "Worklogs (All fields)" with the type "All" and issue-navigator-with-worklogs.xlsx.
    4. Create "Worklogs (Current fields)" with the type "Multiple issues only" and issue-navigator-with-worklogs.xlsx.
    5. Create "Tempo Worklogs (All fields)" with the type "Disabled" (or "All" if you are using Tempo) and issue-navigator-with-tempo-worklogs.xlsx.
    6. Create "Tempo Worklogs (Current f.)" with the type "Disabled" (or "Multiple issues only" if you are using Tempo) and issue-navigator-with-tempo-worklogs.xlsx.
    7. Create "History (All fields)" with the type "All" and issue-navigator-with-history.xlsx.
    8. Create "History (Current fields)" with the type "Multiple issues only" and issue-navigator-with-history.xlsx.
    9. Create "JIRA Agile (Excel)" with the type "Disabled" (or "Multiple issues only" if you are using JIRA Agile) and jira-agile-report.xlsx.
    10. Create "JIRA Service Desk (Excel)" with the type "Disabled" (or "Multiple issues only" if you are using JIRA Service Desk) and jira-service-desk-report.xlsx.
    11. Create "Tempo (Excel)" with the type "Disabled" (or "Multiple issues only" if you are using Tempo) and tempo-report.xlsx.
    12. Create "Basic Export (Excel)" with the type "Disabled" and basic-issue-list-template.xlsx.
  6. Go to Issue Navigator, open the Export menu and click each of the views created in the previous step for testing.
  7. Have some chocolate.

Upgrading to this version is necessary if you want more precise export of JIRA custom fields, plus export of JIRA Agile-, JIRA Service Desk- and Tempo data.

1.0.0

After so many months in beta status, we are happy to announce that Better Excel Plugin for JIRA is now ready for production use. Starting from this version, Midori offers its usual commercial support also for this product.