Approve a request with a comment

[Jason Michaud]

Is there any option to add the Comment field to the Approve Request screen when an approver pushes the Approve link and is redirected back to the Jira Customer Portal? This is part of the embedded Approval workflow within Jira.

I see the comment field when the Approver pushes decline they have the option to leave a comment. But what if we require the Approver to also leave a comment when we want them to approve a request?

[Dave Ahlers]

You can easily and automatically import Jira Cloud data directly into Excel 2016 by following these steps:

1. Create a filter view in Jira with all of your desired columns, save it, and make a note of the path.  Example: https://mycompany.atlassian.net/issues/?filter=11940

2. Change the path to https://mycompany.atlassian.net/sr/jira.issueviews:searchrequest-csv-current-fields/11940/SearchRequest-11940.csv

Note that going to this URL in your browser returns a CSV file.

3. Start Excel, and select Data menu, New query, From Other Sources, From Web

4. A dialog will appear asking you for the URL. Paste in your CSV URL from step 2, and click OK

5. You will be prompted with a permissions dialog.  Select Basic authentication, enter your Jira username and password, and click Connect.

6. After Excel connects, you will see a dialog with a preview of the table.  Click Load to load it into the current worksheet.

From this point forward, your Jira credentials will be cached, and you can update the query at any time by clicking Data/Refresh all.

[Daniel Stainton]

Can you do this for Jira Server????

[Daniel Stainton]

and please, no plug in suggestion, its not an option here

[Daniel Stainton]

CSV changes Hotlinks fieds from description to Jira ID, and uses UserID instead of full names

[Santhosh Kumar Arogyaswamy]

@Dave Ahlers this method is just downloading the csv info into system, even though you try with Excel-> Data -> From Web option. Does not import into existing worksheet and is not retaining the url. Any idea how to resolve this ?

[Maura Oei]

How did you change the path (Move from step 1 to step 2)?

[Midori]

Better Excel Plugin works in a different way, but it ultimately solves the same problem.

You can create an Excel template file, add a blank chart to it, connected to the data placeholders, then upload that to JIRA. After this, you can merge the template with the most recent issue data, and the result with the updated chart will be downloaded to your computer.

[Justin Leader]

https://marketplace.atlassian.com/plugins/pl.com.tt.jira.plugin.excel2jira