How to select what fields to export issues to in JIRA?

When I export issues to csv in JIRA, with current fields, none of the project's custom fields is there and when i export to csv (all fields), all fields that are not even in the screens associated with the project shows up and it's hard to get through the data. Any help will be much appreciated.

3 answers

1 accepted

2 votes
Answer accepted

Hi @Jyot Dawar ,

 

in order to have a field exported using 'current fields' option, you have to display that field on the screen by configuring columns.

 

When you can see the custom field column on the screen it will be in the exported csv regardless you have there values or not.

 

 

Regards,

  Jakub.

Configuring columns in the board configuration? Not sure if i am understanding you correctly. Can you explain it again?

I was describing how to export issues from the search issues view.

 

Screenshot from 2019-03-12 13-40-45_mod.png

 

Are you trying to export issues directly from the board?

Tom Lister Community Champion Mar 12, 2019

Hi

That's a cloud display yes?

For server, the empty columns aren't exported - at least not on our 7.11 server

Maybe server/c;loud differences?

@Tom ListerYes, this is  Jira Cloud. And Jira Cloud will export custom fields even with no values. The only requirement is to add such field to displayed columns.

 

@Jyot DawarWhat Jira do you use?

I'm using JIRA server, i'm not getting any of the custom fields for the project when extracting with current fields. And with all fields, i'm getting all the fields that are not associated with the project and those columns are empty. Also i'm exporting from search view as well, but i don't the columns as you have shown. I am running JIRA version 7.12.0

Hi @Jyot Dawar ,

 

I checked that on the Jira Server version 7.13.1 and it works in exactly the same way as on Jira Cloud.

 

I can see the columns button in exactly the same place.

 

Screenshot from 2019-03-13 09-57-27.png

I don't see it on 7.12.0

2019-03-13 16_05_27-[CC-458] P37974357 - Jira.png

@Jyot DawarCan you switch to list view?

Like 1 person likes this

@Jakub Sławiński  Ok, i see it now, thanks!

0 votes
Ollie Guan Community Champion Mar 12, 2019

Hi @Jyot Dawar ,

If this custom field is only displayed in a particular IssueType, try to limit the scope of the query, add for example "IssueType = Story", then use export issues to csv in JIRA, with current fields.

i have limited the query to the project of the issue type and it is still the same. 

Tom Lister Community Champion Mar 12, 2019

Hi @Jyot Dawar 

if the custom fields aren’t populated for the issues they won’t appear in the current fields extract

There are fields that are populated that don't show in the csv extract 

Tom Lister Community Champion Mar 12, 2019

Ok

The columns are in different sections

Your default

Filter Columns

System Defaults

Check which you setting. Try the filter defaults

I'm using JIRA version 7.12.0. And i don't know where that is in the search view

0 votes
Tom Lister Community Champion Mar 12, 2019

Hi @Jyot Dawar 

Custom fields don’t exist for an issue until they have values. Check if your issues have values. All fields as it says. 

 depending on what you want to use your extract for, the current fields is producing valid data as far as jira is concerned.

can you set values in your custom fields?

current fields only show one custom field and a couple of system fields. And all fields shows all system fields and custom fields from all projects that don't have values. And i just want the system fields and custom fields in the screen from the specific project and issue type to show in the csv file.

Tom Lister Community Champion Mar 12, 2019

I understand but Jira doesn't export fields with no values at all to current filelds csv export. If you just set one value in one issue, the column will be added.

Just asking - why do you need an empty column exported?

Well it does, and i don't need the empty columns exported

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Feb 26, 2019 in Jira Software

How to prevent the propagation of unused project schemes, workflows & screens in Jira software

Atlassian ranks project attributes as the third most important factor impacting performance in the category of data. It’s not surprising, since project attributes are precisely the rules used to ma...

628 views 0 7
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you