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

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

0 votes

Hi @Sharon Cohen-Ofir,

 

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

CSV.png

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? 

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 @Support @Support should take a look at this, and reach back out to us.

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,  

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.

0 votes

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

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