JIRA2PM Help

Connection settings

Connection settings consist of 3 fields:

Username - username which you use in JIRA
Password - password for your account
Base URL - base url of your JIRA server. In case of cloud JIRA hosting it will look like this:https://example.atlassian.net/

After filling all fields, press connect to connect to JIRA. Button should be changed to the success message after connecting.

JQL Query - A query which you want to fetch. You can create it in JIRA and then copy to this field
Fields to Show - Fields which will be displayed in table
Custom Fields - Custom JIRA fields. Each custom field has fields for regular expression which allows more control over formatting. Displayed value will be the first regex result.
For example field which looks like com.atlassian.greenhopper.service.sprint.Sprint@[id=12,rapidViewId=12,state=ACTIVE,name=12 — Sprint 12,startDate=2012-12-12T12:12:12.121+12:12,endDate=2012-12-12T12:12:12.121+12:12,sequence=12] and with regular expression .*name=(.*)\,startDate.* will fetch sprint name and display just 12 — Sprint 12

Fields Displayed as Hyperlinks - selected fields will be displayed as hyperlinks to issues or JQL queries
Date Format - Format to display dates. Y - year, M - month, D - day, h - hour, m - minute, s - second
Estimation Unit - Unit in which estimations will be displayed
Sort by parents - Sort issues by epics and subtasks. Epics have additional formatting

Refresh every... - If this option has been selected - the add-on should check was the last row inserted in the table before the selected time interval. If it was, the old information will be updated

Send Request - Sends request to JIRA with selected options and inserts received data into active sheet
Clean Sheet and Send Request - Additionaly cleans sheet before inserting data from request
Send Request and Insert Data into New Sheet - Inserts data from request to newly created sheet

Convert to JIRA Link - Converts selected keys in sheet to link for JIRA with these keys