Prerequisites

You will need the latest Microsoft Visual Studio for Office Runtime (VSTO 4.0) from Microsoft installed on your PC. It can be downloaded directly from Microsoft here.

Installation

Latest Installer: R4J_Excel_4.1.0-651-combined.msi 
Release notes: Excel Addin 4.1

BETA-Version: R4J_Excel_4.1.7-692-combined.msi
- Fixed performance problem at upload to Jira if issues nested in R4J tree structure

Quick Start

The add-in will add a new ribbon tab, "JIRA", to your Excel interface.

If the new ribbon tab is not visible, please follow these steps.

Connection Settings

Before working with your issues, the connection to JIRA must be configured first. To do so, select the option Settings and enter your JIRA URL, username and password. With Save as... you can setup connections to different Jira servers.

Options:

• Jira API Token: Alternative option to connect to Jira via Personal access token (after Jira 8.14)

• Remember me: stores your password encrypted in a save location

• Show changed values as Excel comments: Shows found differences (of Check button) as comment content.

• Show Issue Key column as hyperlink: Enables Issue Key to hyperlink into Jira instance

• Write Debug Logs: Store send and received messages in log file, to analyze communication issues. Mouse over to retrieve location of log file.

• Maximum number of comments per issues: Number of latest comments downloaded from Jira when using the "Comments" field, 0 (zero) retrieves all comments

Afterwards, you can extract issues with the Load Data option and upload them with the Upload Data option. See the user guide.

Logfile

To easier identify issues in the communication and data quality, the Excel Plugin can create logfile on demand:

• Enable "Write Debug Logs" in the instance settings

• Get the file "excel-log.txt" from "%appdata%\ease solutions\Office to Jira Integration" folder

• "excel-log.txt.*" are older files, up to five files stored.