It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

I am not able to import issues from Jira into excel.

I use 'Get Data' -> 'From Other sources' -> 'from Web' option in Excel. I give the below URL

"https://acsjira.honeywell.com/sr/jira.issueviews:searchrequest-csv-current-fields/158751/SearchRequest-158751.csv" 

to get defect/issue data from Jira. But what I get is html script. I googled and found a suggestion to append '?' at the end of the URL. By doing this, I am prompted to key-in Jira login id and password. I choose the option to use my Windows login credentials. When I click on 'Ok' button, nothing happens. And if I click on 'load' option, I see hour glass and then the request times out. How to resolve? 

 

2 answers

Hi @sarvotham.chenji 

Are you trying to import issues to jira from excel?

Please find the  document 

https://confluence.atlassian.com/display/JIRA062/Importing+Data+from+CSV

No, I am trying to import from Jira to Excel, not from Excel to Jira

It's Export 

Go to issue navigator, Create a jql query and there in the corner you can see view menu item and there select excel(all fields) option to export all issues to excel

Ganesh, I request you to read my problem statement again. I know how to write a JQL query and I also know about the export option using which one can export. What I am not able to get working is, from within Excel 2016, I use 'get data' from 'Web' option where I give the URL. But excel fails to get data from Jira

0 votes

There is something not set up correctly in your Excel importer.  Check the user credentials and that the network is connecting ok.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you