Eliminate duplicate during import

Question

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!

Tina Holmes · Answer

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

Tina.

Thomas Deiler_db00h3 · Answer

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