Technical Question

[Super Diego]

I want to import a CSV file into a project that has the Field "Linked Work Items:

Linked Work Items

supports [AUTO-947]

Some of the new cases have two support items, like this one:

supports [AUTO-937, AUTO-944]

The problem is that when I do a validation before importing the file, I get these errors:

025-07-29 17:19:46,294 WARN - Issue link 'Relates' between 'autoid-3121375300206595944' and 'supports [AUTO-947]' cannot be created - at least one of the issues couldn't be found. (From the Log).

Map values
Your file statistics:
0 issue/s will be created correctly
179 issue/s will be created with warnings
0 issue/s will not be created due to errors
The validation process has found 100 warning/s

Issue link 'Support' between 'autoid--6637690284820449134' and 'supports [AUTO-947]' cannot be created - at least one of the issues couldn't be found.
Issue link 'Support' between 'autoid-6562370260331564290' and 'supports [AUTO-937, AUTO-944]' cannot be created - at least one of the issues couldn't be found.
Issue link 'Support' between 'autoid-7468139937752763311' and 'supports [AUTO-937]' cannot be created - at least one of the issues couldn't be found.
Issue link 'Support' between 'autoid--3559179491925006892' and 'supports [AUTO-932]' cannot be created - at least one of the issues couldn't be found.
Issue link 'Support' between 'autoid--3517187321780204575' and 'supports [AUTO-932]' cannot be created - at least one of the issues couldn't be found.

I know it has to do with the format in the CSV. How can I fix this?

[Trudy Claspill · Accepted solution]

Hello @Super Diego 

Can you provide an example of your import data that includes the headers, issue key(s) and data you provide for trying to create links between issues?

[Super Diego]

Under the D and E columns, I have tried different fields, like relates, support.

So far not luck.

Thanks 

[Trudy Claspill]

Can you show us an example of an issue where a link already exists like the ones you are trying to create? Specifically I would like to see the Linked Work Items section.

I suspect part of the problem is that you should only have an issue key as the data to import. "supports" should not be in the data.

There may be another problem though if in the Linked Work Items section you see the word "supports" as a header, like how "blocks", "implements" and "is blocked by" appear below.

The column header you use in the CSV has to match to the link type you want to create. If the Linked Work Items section is showing "supports" as the heading, then having the column named "blocks" may be the incorrect choice.

To ensure you have the correct name, can you show us the Link Types information available at:

https://yourBaseURL/secure/admin/ViewLinkTypes!default.jspa

Can you also show us the field mapping you are configuring when you import the CSV?

This KB on importing issue links is labeled as specific to Data Center, but the information is relevant to Cloud also to explain how linked issue imports are handled. You may find it useful.

https://support.atlassian.com/jira/kb/how-to-import-issue-links-from-a-csv-file-in-jira/

[Super Diego]

The Work Item should be"supports", but I tried that one and didn't work

[Trudy Claspill]

You tried that where? What was the symptom of "not working"?

Did you remove the "supports " text from the data you are importing, so that the data in the column is just the issue key rather than "supports <issueKey>"?

To ensure you get the correct name to use for the column header in the CSV, can you show us the Link Types information available at:

https://yourBaseURL/secure/admin/ViewLinkTypes!default.jspa

[Super Diego]

What do you mean where? I tried to import the CSV file with the example I sent you.

When I manage to run the import without issues, the "Linked work items" don't show on the ticket.

[Super Diego]

https://delfidiagnostics.atlassian.net/secure/admin/ViewLinkTypes!default.jspa

[Trudy Claspill]

First I want to address you last two replies.

What do you mean where? I tried to import the CSV file with the example I sent you.

You need to remove the text "supports" from the data you are importing where I highlighted it with red boxes. Only the key for the issue you want to link should be there.

When I asked you to show us the Link Types information I was requesting a screen show of what you see at that URL. Something like this:

Second, I need to ask a few questions to clarify your scenario.

Referencing the CSV sample you provided:

Before you execute the import do the issues to which you are trying to link already exist in Jira with the keys "AUTO-947" and "AUTO-937" and "AUTO-944"?

Are you trying to create two brand new issues, with the Summaries "Example 1" and "Example 2", and link them to the specified issues?

[Super Diego]

Thank you. I'll make changes to the file before trying again.

Are you trying to create two brand new issues, with the Summaries "Example 1" and "Example 2", and link them to the specified issues? Yes. and the specified issues already exist on the project. 

[Super Diego]

The links already exist.

I am just trying to create new issues and link them to other existing issues.

[Super Diego]

Hi, 

After removing the  [ ] and the text "support" from the cell, leaving just the support number, it worked!!

[Super Diego]

Thank you so much, Trudy.