Exporting data in CSV format from Jira cloud

Question

Hi

We are using jira cloud  for bug management, my requirement is i need to export data in CSV format, we need to export some issues along with screenshots  based on date, example , we need to export two  years of bug history, i dont see an option  Jira settings--->system--->import/export.

please guide me in migrating it.

Thanks

Saikrishna

Petter Gonçalves · Answer

Hello Sai,

Sorry, I have misread your question. I thought you were meaning Import when actually you were talking about the export feature.

The query you are exporting will return all the issues created, however, it will not export the Screenshots or any kind of attachments of your issues.

The Attachments can be exported using the option described in the link below:

- HOW TO EXPORT ATTACHMENTS FROM JIRA ONDEMAND

About the Export Excel CSV (current fields) that you mentioned, it will export all the fields you configured as a column in the Issue Navigator. If you want to export all your issue fields, you must use the option Export Excel csv (All Fields).

Sai Krishna_ucvcix · Answer

Hi

Thanks for update, I have followed by filtering using the below JQL query,

"project = WM AND issuetype in (Bug, Improvement, Task) AND created >= 2017-09-07 AND created <= 2018-10-15 order by created DESC"

I got the list of 1 year data , at the top of download button and Export Excel csv all fields , as attached per the screenshot.

All the data gets downloaded with the along with the screenshot urls, my question is this approach correct to export cloud data for specific project  in CSV?

And another question is  when i click Export Excel csv (current fields). all the data which is displayed in the ticket is not getting downloaded like, fixed version, component, screenshot url?

how can we get this data since those data is displayed in the ticket

Thanks

Saikrishna

Petter Gonçalves · Answer

Hello Sai,

To import attachments using CSV format, you must specify the URL of your attachment in an Attachments column within your CSV file. For example:

Assignee, Summary, Description, Attachment, Comment
Admin, "Issue demonstrating the CSV attachment import", "Please check the attached image below.", "https://jira-server:8080/secure/attachment/image-name.png", "01/01/2012 10:10;Admin; This comment works"
Admin, "CSV attachment import with timestamp,author and filename", "Please check the attached image below.", "01/01/2012 13:10;Admin;image.png;file://image-name.png", "01/01/2012 10:10;Admin; This comment works"

Note that URLs for attachments support the HTTP and HTTPS protocols and can be located anywhere that your Jira Cloud site can access.

For more information about it, you can check the documentation below:

- Attachment Import