Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,729
Community Members
 
Community Events
165
Community Groups

How to control export to CSV (current fields) fields

IT seems to ignore the on-screen fields and just export whatever he wants.. .

7 answers

I found the solution... trivial actually.... export is using the field selected in the filter tab rather than the fields that are displayed (columns --> Filter tab on the top right hand side , see below screenshot

 

jira.png

Actually, for mine, I need to set Columns to "My defaults" (NOT Filter) -- whatever is selected under "My Defaults" appears in the exported file. Doesn't matter what I have in the Filter option.

image.png

This did it for me! 👌

The same issue is described last year on this page:
https://community.atlassian.com/t5/Jira-Software-questions/Filter-export-returns-incorrect-fields/qaq-p/1146158 

I have to set the default column view to "Filter" and leave it there for the account I use to download the issues.

Hi, i faced similar issues and then started importing csv files using Power query filter for Excel. still time to time i need to visit and tweak query steps, however it is much less painful then fixing manually fixing spreadsheet each time.

Cheers,  

I have the same issue. I'm displaying columns based on the 'Filter' view

2020-01-03_1715.pngBut no matter how I export; CSV (current fields), Excel (current fields), or even the Open in Google Sheets - It's pulling the columns from the 'My defaults' section. 

2020-01-03_1721.png

I was able to resolve by clearing my browser cache. I cleared the last 4 weeks on Chrome. Did the trick for me. Hope it works for you too!

I must adjust my above work-around. It turns out that manually adjusting the JQL is what is breaking the column sync. If I just run the filter as-is, then the columns export correctly. Still a #bug though

Like Joscha Göllner likes this

This work-around is not working for me. Do you have other ideas? 

sorry Luiz, nothing beyond the typical default troubleshooting. The issue hasn't recurred for me in a while. I suggest getting the filter the way that you want it, saving (or saving as), closing out the window, clearing cache, re-opening, and trying the newly saved (or new filter) I do think there's a bug here and one of the many instances of @Support @Ryan Robert @Support should take a look at this, and reach back out to us.

Hi.  Am am selecting columns in the columns tab, and choosing CSV (Current Fields) AND YET, the exported CSV file still has many more columns than the 5 I have selected for display.   I want the export to match the display.  How can I control that? 

0 votes
Ollie Guan Community Leader Jul 02, 2018

Hi @Sharon Cohen-Ofir,

 

When you choose to export the current field, the result still export all the fields?

CSV.png

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