Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Error exporting data to cvs

On June 16th, we upgraded to 8.13.7.  Yesterday, I've tried to execute a filter.  The filter has two fields and the search has a created date range.  From this search, I export to a CSV for current fields.  The first date range I exported, which has a range of six months, only the two fields, along with Issue ID, were in the spreadsheet.  I then changed the date range and searched again.  Only the two fields displayed on the web page.  Only the two fields showed as selected under Columns.  I export again.  This time, there were about ten different columns in the spreadsheet, columns that I did not check to select. 

Last night, I signed out of Google and then cleared my cache.  I rebooted the PC that evening.  Today, I tried exporting again and I had the same results: the first export had only two fields and the others have more.  I also tried exporting with Microsoft Edge and had the same results.

Filter page.pngSelect CSV.pngField display.png

 

 

1 answer

1 accepted

0 votes
Answer accepted

Hi @Monica Collins ,

Thanks for posting in community.

1. I hope the filter view is saved with column selected and while you change anything in the filter and refresh the page the selection remains with those selected columns .

2. Did you try to open the same with Google Sheets/ Microsoft Excel instead of using the Export option? Do you find the same result? 

Looking forward to hear from you.

Cheers

Suvradip

1.  No, my fields are not saved with the issue filter.  How do I go about doing that?

2. I don't understand this.  I have t perform the export first to get the data.  How can I open excel/sheets while the data is still displaying on the web page?

Before the update, this filter would work, even though the two fields are not saved to the filter.  Has anyone else reported this error?

Hi @Monica Collins ,

Thanks for your response. 

  1. While you select the custom columns in your filter, I meant you followed the steps here in defining a filter specific column order - https://confluence.atlassian.com/jirasoftwareserver0813/saving-your-search-as-a-filter-1027135332.html.
  2. Sorry, I think the earlier option would not be applicable for Jira Server and only specific to Jira Cloud. You can follow this article Exporting your search results section - https://confluence.atlassian.com/jirasoftwareserver0813/working-with-search-results-1027135393.html

I hope that helps. Please respond and accept the answer if it resolves your query else, respond and allow others to share input.

Cheers
Suvradip

I rebuilt my filter to save my two fields to the filter.

I am still getting the 2nd and subsequent exports built incorrectly, with too many columns.  I will open a ticket with support.

Thanks.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Trello

🏊‍♀️ Atlympic Event: Trello

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

62 views 0 6
Read article

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