As I did an import via CSV to create links between story and test, I deleted the story

Question

I did an import to add links (relates) between a story and test cases

I used the following import file :

issue key,summary,link1,link2,link3
PGTV-8834,,PGTV-14296,PGTV-14297,PGTV-14295

All seems OK as I have a look at import log

2020-01-15 14:42:31,703 INFO - Importing: Issues
2020-01-15 14:42:31,703 INFO - ------------------------------
2020-01-15 14:42:31,703 INFO - Only new items will be imported
2020-01-15 14:42:31,825 INFO - Importing issue: [externalId='autoid-3641929320064624598', summary='null']
2020-01-15 14:42:32,005 INFO - 0 out of 1 issues successfully created
2020-01-15 14:42:32,008 INFO - ------------------------------
2020-01-15 14:42:32,008 INFO - Finished Importing : Issues
2020-01-15 14:42:32,008 INFO - ------------------------------
2020-01-15 14:42:32,050 INFO - ------------------------------
2020-01-15 14:42:32,050 INFO - Importing: Issue Links & Subtasks
2020-01-15 14:42:32,050 INFO - ------------------------------
2020-01-15 14:42:32,050 INFO - Only new items will be imported
2020-01-15 14:42:32,057 INFO - Linking 'PGTV-8834' and 'PGTV-14295' as Relates
2020-01-15 14:42:32,108 INFO - Created link 'Relates' between PGTV-8834 and PGTV-14295
2020-01-15 14:42:32,123 INFO - Linking 'PGTV-8834' and 'PGTV-14297' as Relates
2020-01-15 14:42:32,176 INFO - Created link 'Relates' between PGTV-8834 and PGTV-14297
2020-01-15 14:42:32,182 INFO - Linking 'PGTV-8834' and 'PGTV-14296' as Relates
2020-01-15 14:42:32,231 INFO - Created link 'Relates' between PGTV-8834 and PGTV-14296
2020-01-15 14:42:32,235 INFO - ------------------------------
2020-01-15 14:42:32,235 INFO - Finished Importing : Issue Links & Subtasks
2020-01-15 14:42:32,235 INFO - ------------------------------

But as I did a check in my project the story have disappeard

Do someone have an idea why?

Thank you for your help

Petter Gonçalves · Answer

Hello @guillaume_mangin

Thank you for the information.

About this statement:

I try with a summary field completed for the story but with the same results

Does that mean that when you tried to perform the same steps with a new test issue and filling the summary field, that issue also disappeared from your Jira site?

About this statement:

In the history of the test issue, the update of the link by import is logged but inactive (as update done manually is active) and I could no more find the user story

I must confess that I did not fully understand your statement here. Since you were able to check the history of the test Story, it means that it did not disappear right after the import. Is that correct? Which time did the Story disappear from your site?

In order to better understand and further investigate the problem, please do the following steps and provide us with the results:

1 - Create a new issue and try to link them through CSV again, filling the summary field. Also, make sure you are using the external system import under Jira Settings > System, as described in the section "Sample 2: Importing links to existing issues" on the documentation below:

- Import issue links

2 - Provide us with the CSV file you uploaded, together with the following information:

- The issue that disappeared

- If the Story issue didn't disappear, provide us with a screenshot of the results you got, describing exactly what did not happen how you expected

Let us know if this information helps.

guillaume_mangin · Answer

Hello

I did several tentatives of import

I try with a summary field completed for the story but with the same results

The import file included :

issue id of story, summary of story, issue id of the tests to link

If I did the link manually there is no problem

In the history of the test issue, the update of the link by import is logged but inactive (as update done manually is active) and I could no more find the user story

Thanks for your help

Petter Gonçalves · Answer

Hello @guillaume_mangin

Thank you for reaching out.

Per your description, I believe you had an existing story and test cases in your Jira site that you wanted to link through CSV, however, once you uploaded the CSV file it seems to have deleted the existing Story. Is that correct?

Although I'm not sure of what could be deleted the issue, I believe the reason for the error you are facing is that you are importing a summary with no value in Jira. As you can see in the documentation below, at least one of the selected fields must contain data for the Summary field:

Importing data from CSV

That being said, can you please search for the PGTV-8834 in the issue navigator and check if you are able to find it?

Then, try to perform the same steps but adding value to the Summary field.