Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Need help with mysterious CSV import errors/warnings

I have been helping a team with CSV imports and I am getting errors and warnings like:

  • Destination issue not found
  • Component lead null not found
  • Commenter named null not found. Creating issue with currently logged in user instead

The first one, destination issue not found - no idea of what that refers to.

The second error makes sense is the Component error, since that's where the log shows that error.  The documentation says absolutely nothing about importing a lead, or how to do it - so.... how can that be fixed in a CSV import?

According to https://jira.atlassian.com/browse/JRACLOUD-64520 this isn't going to be fixed, so if that's the case why is Jira complaining??

Same for commenter - how do you specify a commenter in the CSV?

2021-05-25 20:30:50,132 INFO - ------------------------------
2021-05-25 20:30:50,132 INFO - Importing: Components
2021-05-25 20:30:50,132 INFO - ------------------------------
2021-05-25 20:30:50,132 INFO - Only new items will be imported
2021-05-25 20:30:50,134 INFO - Importing component (redacted)
2021-05-25 20:30:50,135 WARN - Component lead null not found
2021-05-25 20:30:50,755 INFO - ------------------------------
2021-05-25 20:30:50,755 INFO - Finished Importing : Components
2021-05-25 20:30:50,755 INFO - ------------------------------

 

1 answer

1 accepted

2 votes
Answer accepted

Hello @Rob Horan 

Are you using the import option found on the Advanced Filters screen or under the administration settings?

Concerning "Destination issue not found", are you trying to create new issues through your import or update existing issues? Are you mapping some column to the Issue ID field during the import?

Concerning "Component lead null not found", using CSV to import Component values for the project does not currently support importing Component Lead information for the component. As that is only a warning message it should not be disrupting your import process.

To import the author of a comment, you provide all the information for a single comment information in one column, in this type of format:

"<date>;<comment Author username>;<comment text>"

"01/01/2012 10:10;Admin; This comment works"

 Examples are shown in this document:

https://support.atlassian.com/jira-cloud-administration/docs/import-data-from-a-csv-file/

Thank you - this is an external system import (since status needs to be mapped) and there were sub-task to parent task mappings that took place, but there were no detailed errors in the log - the only thing that appeared was that vague "Destination issue not found" in the UI.  There was truly NOTHING in the log that identified the problematic row in the CSV or anything that could help diagnose this.

As for the rest, that Component Lead warning is not appropriate IMHO.  If its not possible to map component lead then this should be an information statement that new components were mapped with no component lead, not a warning, which implies the user made a mistake.

If you would like to open a change request with Atlassian to change the messages that appear in the import log, you should contact Atlassian Support directly at 

https://support.atlassian.com/contact/#/

I agree that the log is not crystal clear in its messaging.

For the "destination issue not found" issue, I don't think I can help you debug that more without access to the input file and the log file.

Like Rob Horan likes this

Well... see the problem is there are issues like  https://jira.atlassian.com/browse/JRACLOUD-64520 where the problem is known and reported and the issue is closed as something that will never be fixed...

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

212 views 6 7
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