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

Can I identify issues that were imported with a CSV file?

A staff member who is no longer here imported a bunch of issues into JIRA from several CSV files and didn't do it quite right.  I can search for the issues in small groups looking for unique fields, but is there a field that identifies an issue as one that was imported?  I hope for a query that looks something like:

Project = TRKS AND component = DSN AND imported = TRUE  (or many external identifier is NOT EMPTY)

 

Thanks for any help.

1 answer

1 accepted

0 votes
Answer accepted
Jack Community Leader Sep 23, 2019

Not by default. When I have done this in the past I would always use bulk update and add a label, e.g. "imported". I also have created a custom field to include the previous systems issue-id. Maybe that was done?

Exactly. I always add a label or update a field to uniquely identify bulk imported issues. Combining it with Date range it is much easier to delete them or do something with them if needed.

Jack Community Leader Sep 23, 2019

sort of painful but here is a thought...

Assuming you have access to the original system:

  • query the old system to find some trace of the first and last issues imported, e.g. the summary field
  • search Jira to see if you can find the first and the last which would give you the two issue keys that could be used to identify the full set ...maybe

Thank you all for your help.  Yes, the original staffer did not add a label though going forward, I think I will do that!  I can probably work my way through the uploads to find the top and bottoms as suggested by Jack.  I was just thinking MAYBE there was some hidden system field I could use.  Ah well.  If that's the worst thing that ever happens to me, I'm in great shape.

 

Thanks.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

Jira Cloud for Google Sheets: Automatically Refresh Your Data!

Remember that time you realized it was possible to refresh your Jira data in Google sheets with just one click? What if we told you that you can now get the latest data with no clicks at all?! Zero! ...

7,364 views 33 29
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