How to control export to CSV (current fields) fields

[Sharon Cohen-Ofir]

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

[Angela Sadul]

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.

[Lorenzo Petrone]

This did it for me! 👌

[Nika Allahverdi]

Thank you! 📌

[Bill Filler]

How do you navigate to this UI to set "My Defaults"? I am on the Sprint Reports -> View In Navigator page and attempting to "Export to CSV (my default)" and I want to change what my defaults are. But I can't find this in the UI. Please help!!

[Victor Wolff-EXT]

so helpful! thanks - you made my day :)
@Bill Filler I can select my defaults in the same menu as where I can select additional columns to be displayed in the filter.

[Sharon Cohen-Ofir]

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

[Mateja Jermanis]

Hi @Sharon Cohen-Ofir I dont have the filter option? mine just shows this:

Thus, i do not have the option to export to current fields. Anyone had the same problem? 

[Shelly Singh]

I dont have the option listed for 'Current Fields'  only All fields 

any solution on fixing/adding this? 

[Jeff Abbott]

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.

[Atiq Ahmed]

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,  

[Tim Graham]

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

But 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. 

[Tim Graham]

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!

[Tim Graham]

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

[Luiz Britto]

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

[Tim Graham]

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.

[Victor St_ Clair]

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? 

[Ollie Guan]

Hi @Sharon Cohen-Ofir,

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

[Nelson Loia Jr_]

Hi!

I have the same issue:  
1 - I already defined the columns I want in "My Default" option.
2 - But when I try to export the CSV comes with the columns defined in the "Filter" option.

How to fix it?   (if possible).

 

---

---

THX!.