nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Why is 'Jira for Excel' returning duplicate rows?

Mark Ericson_kyidwo

When I use the 'Jira for Excel' add-in I sometimes get duplicate rows in my target sheet. Even when I clear everything in the sheet before reloading data from Jira, the plugin returns duplicate rows.

It isn't just random duplicate rows; when there are duplicates, it is consistently the complete results appended consecutively in the sheet.

An additional oddity is that the results are sometimes correct, and it is one result, but sometimes it is two complete sets and even four complete sets of the results.

Accepted answers

All comments

Brant Schroeder

@Mark Ericson I would suggest submitting an support ticket to the vendor of the app https://marketplace.atlassian.com/apps/1221301/jira-cloud-for-excel-official?tab=support&hosting=cloud

Mark Ericson_kyidwo

The vendor of "Jira for Excel" is Atlassian.

Brant Schroeder

@Mark Ericson If you are just using the delivered product then it is not an add in. Can you share some steps and screenshots of what you are doing when this issue occurs?

Mark Ericson_kyidwo

It is an Excel add-in provided by Atlassian. I click refresh and sometimes I get one copy of the results, in the sheet, sometimes two copies, and sometimes four copies. When I get multiple copies I get a new header and all the rows each time.

Screenshot 2023-09-04 at 9.28.02 PM.png

Diana Valencia

I've noticed it happens to me only when I have the Updated field as part of my columns. Maybe it's showing a register for every time the issue is updated?

Dale Jordaan

I have to exactly the same issue. You can literally divide values by half and get the correct answer.

I have tried all of the above. I also used a new sheet altogether. After a few refreshes it happened again to the new sheet. Now I have to start from scratch every time and change pivot table sources etc

Very frustrating

Mark Ericson_kyidwo

@Diana Valencia I see the same behavior even when I remove the Updated field.

Mark Ericson_kyidwo

Yes, it is very time-consuming for me to set up the set of fields and order of fields when starting with a fresh workbook. And then, as you mentioned, fix up the formula and pivot table references for the data for the new sheet.

MobilityStream

Both exporter add-ons "Jira Cloud for Excel" and "Jira Cloud for Google Sheets" have known issues and have been put into de-facto maintenance mode by Atlassian. If you are looking for something more reliable and are open for a marketplace app, you can try our Excel Online integration which works both for Excel Desktop as well as Excel Online. It doesn’t have any issues with duplicated rows. Also, it scales to a large number of Jira issues and supports real-time, schedule, and manual exports.

Kind regards,

The Mobility Team

unknown

I encountered the same problems with my sheets to Google sheets connector. I noticed that in the connector plug-in window, I had previously selected quite a few fields (around 30) and this issue keeps happening. I then tried reducing the number to a few key columns (around 19) and this issue doesn't recur. YMMW but I thought you might want to check this and see if this addresses the issue until a more permanent fix is provided by the plug-in providers.

Norah Medlin

I am also encountering this issue with https://workspace.google.com/marketplace/app/jira_cloud_for_sheets/1065669263016

joseluis.bonilla

Hello, it happend the same to me until I found that I was adding "Comment.Updated" instead of "Updated". I changed it and the duplicated rows dissapeared.

I hope I have helped you.

Dale Jordaan

Thanks - What i do now is I whack sheet 1 so it's empty, then select A1 and refresh. Seems to work

Jasmine Anderson

Same for me, this is super aggravating

Ersa Aditya Hasdianto

I also experience the same thing. Despite excluding the 'Updated' field or select less than 10 fields, the issue still occurs. My workaround is using Google Sheet feature 'Data Cleanup' to remove duplicates.

This issue needs to be resolved, some people using 'Jira Cloud for Sheets' extension to do some analysis.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud