Need help with mysterious CSV import errors/warnings

[Rob Horan]

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 - ------------------------------

[Trudy Claspill · Accepted solution]

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/

[Rob Horan]

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.

[Trudy Claspill]

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.

[Rob Horan]

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...

[Nicole Griffin]

Hello, wondering if the solution to the comment author issue above was resolved? I have tried the exact format above and while the date and comment are imported properly, it does not import the author and so defaults to me as the commenter for all. Very much need the commenter to import properly, if anyone has alternative solutions or reasons this is failing.

Have tried replacing user name (firstname.lastname) with email on an off chance - no luck.

Thanks!

[Ari Raatikainen]

I have also tried to get the author to work but no luck.
Has anyone succeed in this?

[Luqman Jamil]

I am also trying this but  i am getting the error : Commenter named null not found. Creating issue with currently logged in user instead 
using the same format which is mentioned above 

[Trudy Claspill]

Have you tried including the user's Atlassian Cloud Account ID in the place for Comment Author? The Account ID is a hexidecimal hash. You can find it by using the Teams menu option, then Search, and search for the user. When you open the details for the user their Account ID will display as part of the URL for the page.

[Luqman Jamil]

yes I tried that Aswell but i am getting same error.  

this is how i am designing my comment body text. 

05/FEB/25 11:20 AM;5ccc50b43d242775a94351;This is a test comment.

[Luqman Jamil]

Is this correct format?

[Trudy Claspill]

@Luqman Jamil 

Yes. That format works for me when using the old import functionality from the Administrator > System > External System Import page in Jira Cloud.

Does the ID you supplied correspond to a valid Atlassian Cloud User that has permission to add comments to the issues in the project where you are importing the issues.

[Luqman Jamil]

yes, the ACCOUNT ID i provided is the System Administrator Account ID and they are active user in the project as well. and they are the administrator of the project as well.   @Trudy Claspill

[Trudy Claspill]

I don't have an explanation for why it would work for me but not for you. I can't look directly at your instance nor lookup a record for a user that is not part of my instance.

I recommend that you open a support case directly with Atlassian.