Unable to import csv file to JIRA project

[Ксения Луканова]

Unable to import csv file to JIRA project. Please explain me what`s wrong

I had this error:

Error importing issue ExternalIssue{externalId=autoid-3403488133502377422, summary=null, issueType=null}

and this is an error log:

2019-02-05 11:41:21,406 INFO - Import started by DKX6TNC using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2019-02-05 11:41:21,493 INFO - ------------------------------
2019-02-05 11:41:21,493 INFO - Importing: Users
2019-02-05 11:41:21,493 INFO - ------------------------------
2019-02-05 11:41:21,493 INFO - Only new items will be imported
2019-02-05 11:41:21,511 INFO - 0 users associated with import. 0 new users were created and imported as active.
2019-02-05 11:41:21,511 INFO - ------------------------------
2019-02-05 11:41:21,511 INFO - Finished Importing : Users
2019-02-05 11:41:21,511 INFO - ------------------------------
2019-02-05 11:41:21,511 INFO - 0 users successfully created.
2019-02-05 11:41:21,511 INFO - Retrieving projects...
2019-02-05 11:41:21,513 INFO - Project ExternalProject{id=null, externalName=null, name=null, key=DMD, url=null, lead=null, description=null, projectCategoryName=null, avatarUrl=null, assigneeType=null, versionCount=0, componentCount=0, issueCount=0} already exists. Not imported
2019-02-05 11:41:21,513 INFO - ------------------------------
2019-02-05 11:41:21,513 INFO - Importing: Versions
2019-02-05 11:41:21,513 INFO - ------------------------------
2019-02-05 11:41:21,513 INFO - Only new items will be imported
2019-02-05 11:41:21,513 INFO - ------------------------------
2019-02-05 11:41:21,513 INFO - Finished Importing : Versions
2019-02-05 11:41:21,513 INFO - ------------------------------
2019-02-05 11:41:21,513 INFO - ------------------------------
2019-02-05 11:41:21,513 INFO - Importing: Components
2019-02-05 11:41:21,513 INFO - ------------------------------
2019-02-05 11:41:21,513 INFO - Only new items will be imported
2019-02-05 11:41:21,514 INFO - ------------------------------
2019-02-05 11:41:21,514 INFO - Finished Importing : Components
2019-02-05 11:41:21,514 INFO - ------------------------------
2019-02-05 11:41:21,514 INFO - Retrieving custom fields...
2019-02-05 11:41:21,514 INFO - ------------------------------
2019-02-05 11:41:21,514 INFO - Importing: Issues
2019-02-05 11:41:21,514 INFO - ------------------------------
2019-02-05 11:41:21,514 INFO - Only new items will be imported
2019-02-05 11:41:21,545 INFO - Importing issue: ExternalIssue{externalId=autoid-3403488133502377422, summary=null, issueType=null}
2019-02-05 11:41:21,583 ERROR - Error importing issue ExternalIssue{externalId=autoid-3403488133502377422, summary=null, issueType=null}
com.atlassian.jira.plugins.importer.external.ExternalException: Unable to create or update issue: ExternalIssue{externalId=autoid-3403488133502377422, summary=null, issueType=null}
 at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:903)
 at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:764)
 at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:390)
 at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26)
 at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15)
 at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:527)
 at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:490)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:253)
 at java.lang.Thread.run(Thread.java:745)
Caused by: com.atlassian.jira.plugins.importer.imports.csv.ImportException: Blank summary detected. Such issue cannot be imported
 at com.atlassian.jira.plugins.importer.imports.importer.impl.ExternalUtils.convertExternalIssueToIssue(ExternalUtils.java:481)
 at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:880)
 ... 11 more
2019-02-05 11:41:21,618 INFO - 1 issues successfully created
2019-02-05 11:41:21,618 INFO - ------------------------------
2019-02-05 11:41:21,618 INFO - Finished Importing : Issues
2019-02-05 11:41:21,618 INFO - ------------------------------
2019-02-05 11:41:21,639 INFO - ------------------------------
2019-02-05 11:41:21,639 INFO - Importing: Issue Links & Subtasks
2019-02-05 11:41:21,639 INFO - ------------------------------
2019-02-05 11:41:21,639 INFO - Only new items will be imported
2019-02-05 11:41:21,685 INFO - ------------------------------
2019-02-05 11:41:21,685 INFO - Finished Importing : Issue Links & Subtasks
2019-02-05 11:41:21,685 INFO - ------------------------------
2019-02-05 11:41:21,686 INFO - No issues need to be reindexed.

[Alexey Matveev]

Hello,

You ve got a line in your file with empty summary. The summary field must not be empty

[Ксения Луканова]

Can you explain me, please, what I`m doing wrong..

This is my csv file:

Test Description,Summary,Test Type,Issue Type,DemandID,Manual Test Steps
"""Заявка отправлена в Банк - AML проверка на стороне POS не пройдена"",""Заявка отправлена в Банк - AML проверка на стороне POS не пройдена"",“Manual”,Test,RAFR.017,[ { """"index"""": 0, """"step"""": """"Войти в систему POS под ролью сотрудника ДЦ"""", """"data"""": """"Сотрудник ДЦ"""", """"result"""": """"Произведен вход в POS"""" }, { """"index"""": 1, """"step"""": """"Выбрать вкладку ""Заявки на кредит"""""", """"data"""": """"Сотрудник ДЦ"""", """"result"""": """"Открыта ЭФ вкладки ""Заявки на кредит"""""" }, { """"index"""": 2, """"step"""": """"Используя фильтры выбрать и открыть на редактирование заявку из предусловия"""", """"data"""": """"Сотрудник ДЦ"""", """"result"""": """"Заявка открыта, все данные заполнены"""" }, { """"index"""": 3, """"step"""": """"На открытой заявке нажать кнопку ""Отправить в Банк"""""", """"data"""": """"Сотрудник ДЦ"""", """"result"""": """"Проверка AML на стороне POS не пройдена, появляется сообщение о недействительности паспорта. Заявка не уходит в DIasoft Front, статус заявки не меняется"""" } ]"

and on the photo how I map fields

[Alexey Matveev]

It looks like something is wrong with your encoding. In what encoding is your text file? You should provide the correct encoding on the first page of the csv import. It is UTF8 by default. but maybe you have cp1251.

If you have the Notepad++, you should open this file in this software. then you convert to UTF8, then save. 

Then when importing the csv file, make sure that you chose UTF8 in the first page.

[Ксения Луканова]

I did that, but it didn`t help( I`m in desperation, Xray wrote that summary=null and IssueType=null. Have you ever import csv in Jira? Maybe you can give me an example. I will be really thankful for it, because I try for a week and can`t do that

[Alexey Matveev]

You can go to Issue Navigator in your instance and export to csv file all fields. Then you can import this file.

[Ксения Луканова]

Xray export csv, which can`t read.. 

Maybe it`s because I have 1.12 Xray version

[Tom Cheung]

Here's the issue I see:

Error importing issue ExternalIssue{externalId=autoid-3403488133502377422, summary=null, issueType=null}

Blank summary detected. Such issue cannot be imported

Is the summary blank in CSV file you're importing? JIRA won't let you import without a summary column and values in said column. 

[Ксения Луканова]

Can you explain me, please, what I`m doing wrong..

This is my csv file:

Test Description,Summary,Test Type,Issue Type,DemandID,Manual Test Steps
"""Заявка отправлена в Банк - AML проверка на стороне POS не пройдена"",""Заявка отправлена в Банк - AML проверка на стороне POS не пройдена"",“Manual”,Test,RAFR.017,[ { """"index"""": 0, """"step"""": """"Войти в систему POS под ролью сотрудника ДЦ"""", """"data"""": """"Сотрудник ДЦ"""", """"result"""": """"Произведен вход в POS"""" }, { """"index"""": 1, """"step"""": """"Выбрать вкладку ""Заявки на кредит"""""", """"data"""": """"Сотрудник ДЦ"""", """"result"""": """"Открыта ЭФ вкладки ""Заявки на кредит"""""" }, { """"index"""": 2, """"step"""": """"Используя фильтры выбрать и открыть на редактирование заявку из предусловия"""", """"data"""": """"Сотрудник ДЦ"""", """"result"""": """"Заявка открыта, все данные заполнены"""" }, { """"index"""": 3, """"step"""": """"На открытой заявке нажать кнопку ""Отправить в Банк"""""", """"data"""": """"Сотрудник ДЦ"""", """"result"""": """"Проверка AML на стороне POS не пройдена, появляется сообщение о недействительности паспорта. Заявка не уходит в DIasoft Front, статус заявки не меняется"""" } ]"

and on the photo how I map fields