Special Field Handling
User Fields
Fields like reporter, creator, assignee and other user field picker provide the Jira internal user name (which is mostly the email address, depending on the Jira setup). This is to all a unique identification of the user.
| Info |
|---|
On Jira Cloud the user´s email could be deactivated by company policies. In this case you will receive the Jira internal user ID, "abcdef00101234567890abcd", extend with the (not unique) users display name. Jira system admins can define if email addresses are shown: System > General configuration > User email visibility, turn to “Public”, “Masked” or “Show to logged in user” to retrieve/set user names via email. |
Linked Issues
Links between Jira issues (including link relation), to Confluence pages and to external URL (webpages) are supported.
With the field “Issue Links” you can maintain the link relation and the connected Jira issue key.
When you add in Excel only one side of the relation, Jira will automatically update the other issues link.
| Info |
|---|
After upload of link relations please ensure to update the excel sheet with most current data from Jira. Otherwise the update of the other side of the link may be missed in Excel and could cause removal of the relation again. |
Create links between new issues or between new and existing issues
Links between new Jira issues are created by using the Excel row numbers of the issues in the Issue Links column. To create links between new Jira issues and existing issues, you use the issue key of the existing issue instead of a row number. (If the existing issue is also in the worksheet, you can use either the row number or the issue key.) The following example shows how to create links of type “specified by” and “specifies” between two new issues and to create a link of type “test” between a third new issue and an existing issue. It is not required to define both ends of the relation, Jira will take care for the second part:
1 (Excel row) | Key | Project Key | Issue Type | Summary | Issue Links |
|---|
2 | SC | Functional Requirement | New functional requirement | specified by:3 |
3 | SC | System Requirement | New system requirement | specifies:2 |
4 |
| SC | Test Case | New test case | tests:SC-10 |
SandCastle Project/Test Cases
Comments
Comments of Jira issues listed as Excel comments. They can not be updated. Number of latest comments can be configured in the settings dialog.
Create comments
New comments can be created by entering a value in the column Comments.Sub-Task
The plugin supports sub-task load, upload and creation. The relation between a sub-task (Jira issue type) and a parent can be retrieved by the field “Sub-Task Parent Key”.
Creation and linking of Sub-Tasks
The plugin supports sub-task load, upload and creation. User can add sub-tasks to a new or existing parent issues using a new field "Sub-task Parent key".
Instructions to create and link Sub-task
Load the Jira project in excel with field type “Sub-Task Parent Key”
To create new sub-tasks (of sub-task issue type
, e.g. “Sub-task” (or similar, depend on your Jira coniguration)
Update the “Sub-Task Parent Key” for this issue
Upload the changes
The sub-task will be created on Jira and linked to the parent issue
Additional line reference feature:
The "Sub-task Parent Key" also accepts also the Excle line number instead of an Issue Key. If you want the parent of the sub-task to be the issue on line 4, then write "4" into the "Sub-Task Parent Key"for an existing parent issue, just fill up the “Sub-task Parent key” and upload. The “Sub-Task Parent Key” can also be filled with the Excel line number of the parent issue.
Limitations:
Changing the parent of a Sub-task is a feature only available through the Jira webpage, trying to do so through the plugin is not possible at the moment.
Creation of sub task (issue type) without a parent is not allowed by Jira.
Comments
Comments of Jira issues listed as Excel comments with author and timestamp. They can not be updated or deleted. Number of latest (downloaded) comments can be configured in the settings dialog.
To create new comments fill up the cell itself and upload the Excel sheet to Jira. Your comment will be added to the issue with your account details and timestamp.
Time Tracking
Fields for the time tracking are support. The values downloaded from Jira are given in seconds to allow calculation. For upload the configured time tracking default unit must be set to minutes.
Supported System and Custom Fields
Update process depend on user permission.
Field Name | Jira Data Center / Jira Cloud | Read | Write | Comment |
|---|---|---|---|---|
Standard Fields | ||||
Affected Versions | both |
|
| |
Component/s
| both |
|
| |
Created | both |
|
| |
both |
|
| ||
Description | both |
|
| |
Due Date | both |
|
| |
Fix Version | both |
|
| |
Issue Type * | both |
|
| mandatory |
Key * | both |
|
| mandatory for modification, leave blank for creation |
both |
|
| Unit: seconds | |
Priority | both |
|
| |
Project Name | both |
|
| |
Project Key * | both |
|
| mandatory |
both |
|
| Unit: seconds | |
both |
| | Special Jira update permission applies | |
Resolution | both |
|
| |
Resolution Date | both |
|
| |
Status | both |
|
| Tool tries to apply new workflow state depending on existing workflow transitions from current state. |
Summary * | both |
|
| mandatory |
both |
|
| Unit: seconds | |
Updated | both |
|
| |
Special Fields | ||||
both |
|
| Download comments into Excel note field including reporter and date. Excel cell value used for update only, will be cleared after upload. | |
Confluence Links | both |
|
| Download as markup text in the format “[Page title|URL]”. Upload as URL sufficient. |
both |
|
| With link relation. Upload supports Excel row numbers. | |
Parent | both |
|
| Replaces Sub-Task parent key. Upload supports Excel row number |
Requirement Path | both |
|
| easeRequirements path of all projects where issue is added to tree, multiline. |
Requirement Path (splitted) | ||||
Sub-Task Parent Key (depreciated) | Data Center |
|
| Upload supports Excel row number. Use Parent instead. |
Web Links | both |
|
| Download/Upload as “URL” or markup text as “[Alias|URL]” |
Custom Field Types | ||||
Checkboxes | both |
|
| |
Date Picker | both |
|
| |
Date Time Picker | both |
|
| |
Group Picker (multiple groups) | both |
|
| |
Group Picker (single group) | both |
|
| |
Labels | both |
|
| |
Number Field | both |
|
| |
Project Picker (single project) | both |
|
| |
Select List (cascading) | both |
|
| |
Select List (multiple choices) | Data Center |
|
| |
Cloud |
| |||
Select List (single choice) | both |
|
| |
Text Field (multi-line) | both |
|
| |
Text Field (single-line) | both |
|
| |
URL Field | both |
|
| |
User Picker (multiple users) | both |
|
| |
User Picker (single user) | both |
|
| |
Version Picker (multiple versions) | both |
|
| |
Jira Software Field Types | ||||
Epic Link | Data Center only |
|
| For Cloud use “Parent” field |
Epic Name | both |
|
| |
Epic Status | both |
|
| |
Epic Color | both |
|
| |
Flagged | Data Center |
|
| Removing of flag words in Data Center. |
Cloud |
| |||
Rank | both |
|
| Internal format of Jira, e.g. “0|i002bz:” |
Sprint | both |
|
| |
Story Points | both |
|
| |
