Eliminate duplicate during import

[Tina Holmes]

I am trying to find a way to import a CSV file which will only create a new story, if there is not an existing story for that issue.

For example, if there is a value currently in the labels field that is also on the CVS file, a new story will not be created.

Thank you!

[Thomas Deiler]

Dear @Tina Holmes,

afaik you can't do with Jira (out-of-the-box). I also think (I didn't search on marketplace) that there will be any plugin that can do.

But this is what you an do as  a work-a-round:

• Export your current issues to a CSV file
• Eliminate all columns except the labels column and save as CSV (native text, no XLS)
• run Linux command: cat export.csv | uniq > new.csv
• Now you got all the labels (condensed) in one file (header is missing)
• open the import CSV in Excel and do this "column magic"
• eliminate lines with matches from new.csv
• save as CSV
• Import to Jira

So long

Thomas

[Tina Holmes]

Thank you Thomas.  That was what I thought but being a fairly new user I was hoping I was wrong!!

Tina.