Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Excel 365 Connector for Jira

Excel 365 Connector for Jira allows you to manage your Jira issues using MS Excel 365

Release Notes:

v2.8.0 (2022-11-22) New features and improvements:

  • Added fixes and improvements for Visible Fields Schema

  • Fixed problem with incorrect sorting of issues after refresh

  • Fixed issue with importing select List (cascading) custom field

  • Added Service Management field: Request Type (read-only)

v2.7.0 (2022-10-13) New features and improvements:

  • New feature - Visible Fields Schemas with custom selected fields

  • Logs are now possible to download from Home Page

  • Fixed sorting issues after refresh action

  • Last used filter can be seen after choosing different filter and selected again

v2.6.2 (2022-08-31) Minor bug fixing

  • Fixed issue with dropdown values on unmodifiable fields

  • Newly added field is now coloured correctly

  • Fixed problem with incorrect mapping of field Reporter

  • Log in - Fixed issue with multiple different timer values during verification

  • Minor improvements and fixes of user interface

v2.6.1 (2022-08-16) Minor bug fixing

  • Fixed bugs with exporting new issues with Time Tracking and Parent fields

  • Fixed problem with incorrect mapping of new issues with Epic type

  • Visible Fields List is now in alphabetical case-insensitive order

  • Expired Session error is no longer visible after renewed logging in

  • Minor improvements of user interface in Data Formatting Settings section

v2.6.0 (2022-08-02) Compatibility with Jira 9.x

  • Added compatibility with Jira 9.x

v2.5.0 (2022-07-28) Improvements

  • When user logs time, Start date is calculated from current user time (Customer Request)

  • Added ability to change date format in app settings (Customer Request)

  • Custom Fields - Support for new custom field: Select List (cascading)

  • Header is now visible even when scrolling down

  • Minor bug fixes

v2.4.0 (2022-07-06) Improvements

  • Added dropdowns support for fields: Priority, Issue Type, Fix Version

  • Added ability to disable dropdowns injection

  • Added ability for user to collect logs in file format

  • Fixed issue with cloning formatting in new column after add column operation

  • Fixed problem with metadata sorting

  • Minor fixes on the interface side

v2.3.0 (2022-04-20) Improvements

  • Custom Fields - Support for new custom field Project Picker

  • Create Issue - When creating new issue Excel will scroll down to new row

  • Export Issue - Fixed warning related to evaluation license

  • Getting started page (Jira Data Center / Server) for administrators

  • UI improvements

v2.2.0 (2022-02-23) Improvements

  • Custom Fields - Support for new custom field Group Picker (multi group)

  • Trial Limitations - Limit of issues to send has changed from 5 to 25

  • Standard Fields - Project and Issue Type fields are not case-sensitive now. Improved communication about errors in these fields.

  • Settings - Changes in settings are now auto-saved

v2.1.0 (2022-01-24) Improvements

  • Custom Fields - Support for new custom field: Version Picker (single version) and Group Picker (single group)

  • Templating - Field Issue Key now returns correct value instead of n/s

  • Expired Session (Jira Cloud) - Toast with information about expired session will not disappear also after clicking on toast, user will be logged out

  • Errors - Even better error handling

  • Read Only Mode - Now after fetching data from filter that returns no tasks, sheet will not be affected

  • Show/Hide Issue Fields - Fields key, project, summary, issue type are now visible

  • Minor UI/UX improvements

  • Minor bug fixes

v2.0.0 (2021-12-21) ​New User Interface

  • New User Interface

    Version 2.0.0 brings new user interface - we changed all views to standardize and simplify the app UI. We believe this will greatly improve user experience. Moreover, in each section you will find details about it’s usage and links to documentation (also refreshed). We’ve added better error handling, so now you can see all information in each view.

  • Feedback

    Please use our dedicated customer portal in case of any issues with new UI, improvements or new feature ideas: Support Portal

v1.9.0 (2021-08-04) Issue Structures

  • Sending issue structures – ability to design and send issue structure. Users can now create parent issues and sub-task that are connected to each other by temporary issue ID.

v1.8.1 (2021-07-15) Fetching users improvements

  • New option in settings allowing to run a live fetch of users, eg. if assignee was not visible on sheet, which resulted in validation error, now Excel 365 Connector will search for that user in Jira

v1.8.0 (2021-06-16) Performance improvement, global settings and login improvements

  • New, better approach for fetching, rendering and saving data - now Excel 365 Connector for Jira is quicker than before

  • User settings are saved as global settings in Excel - each time user create new document, setting will be the same

  • Logging into Jira Cloud is done automatically when the last obtained authorization did not expired

  • Improved persistent-state mechanism allows to store “remember me” data for Jira Server - user no longer need to have to enter data to the new workbook (new excel file)

  • Support for “Sprint” field (read only)

  • Minor bug fixing

v1.7.1 (2021-05-11) Time tracking improvements, Bug fixing

  • Time Tracking column

  • Fixed issue with duplicated last column on login to saved files

  • Fixed issue with worklog feature not available for non-admin users

  • Fetching issues in read-only mode - ability to import raw issue data from Jira and work with them without tracking changes.

  • Fields reordering improvement - now your new order of visible fields will be applied immediately after saving changes

  • Support for new field: epic link

v1.6.0 (2021-04-01) Columns reordering and improvements in Templating

Improvements:

  • "Fetch issue" and "Search issue" option in "Templating" feature - possibility to use issues independently of the main "Fetch issue" option for sheets

  • Added field IDs in visible fields setting - with this improvement you can be sure if you are using correct fields and it can speed up the templating

  • Visible fields reordering - with drag & drop easily change order of fields to rearrange the columns

  • Timestamp - detailed information when issues were pulled from Jira or when spreadsheet was refreshed

  • Improve "Undo" option in "Templating" - now it is possible to revert more than last change

Minor bug fixing

v1.5.0 (2021-03-22) Templating, More supported fields

New features:

  • Templating - new feature, allowing to insert variables into spreadsheet and fill it with specified issue data. It can be used for creating templates and fill it in real time (powered by Excel).

    Insert variables in your spreadsheet then select range (cells to be updated) and fill all selected variables with data from selected Jira issue.

  • Support to new fields: Sub Tasks, Linked Issues, Epic name

Bug fixing:

  • Minor bug fixing

v1.4.2 (2021-02-11) Support for security level field, minor improvements

Improvements:

  • support for security level field

  • changes in the default visible fields

  • minor improvements related to the login form

v1.4.1 (2021-01-13) Improvement, bug fixing

Improvement:

  • Added support for “Number” type field in Next-gen projects

Bug Fixing:

  • Characters encoding problem is resolved

  • Minor bug fixing

Info

Important notice: Within 1 month (starting Jan 21, 2021) app will be available on Data Center.


Expand
titlev1.4.0 (2020-12-18) Worklogs enabled

New features:

  • Possibility to add/edit worklogs by new tab

  • New tab "About EC365" - right now you can show all basic information about application

  • Support for 1 new custom field: url-field

  • New configurable option (settings tab): you can now decided about resizing columns during fetching issues

  • Refresh sheet - auto resizing has been disabled

Bug fixing:

  • Minor bug fixing

Expand
titlev1.3.0 (2020-10-23) OAuth 2.0 support, custom JQL, 7 new Custom Fields support, Parent Field support

New features:

  • OAuth 2.0 - new successful and fail view with more clarify information.

  • Release notes view - right now you can see all new changes in EC365 application.

  • Possibility to type your own JQL and save it on the Jira.

  • Possibility to get JQL from selected filter.

  • possibility to fetch issues based on typed JQL

  • Excel online - more stability improvements.

  • Jira server - whitelist checking during login process.

  • Support for 7 new standard fields: parent, resolution, resolution date, time estimate (temporary read-only), time oryginal (temporary read-only), time spent (temporary read-only), updated.

  • Support for parent field - right now you can create subtasks

Expand
titlev1.2.0 (2020-09-28) New custom fields supported

New features:

  • Split login view to server and cloud platform

  • Support for 2 new custom fields types: multiselect, checkboxes

Improvements:

  • New modals view

Expand
titlev1.1.0 (2020-09-01) Support for Custom Field types, introduced export feature, minor enhancements
  • Support for custom fields types: single user picker, radio button, number, date & date time, text field single & multiple lines

  • Option to remember Jira URL and Username - to speed up login process, this data will be stored on sheet in your saved files

  • Excel 365 Connector Export feature - available for Jira Server, allowing to export data from Jira filter (or search results)

Improvements:

  • Reorganized page filters

  • Moved elements a bit for better UX

  • Changes in Colors legend

  • minor UI/UX improvements

Expand
titlev1.0.0 (2020-08-19) First release of Excel 365 Connector for Jira!

This is first release of our brand new product - Excel 365 Connector!