Showing 0 issue imported when trying to import data from csv file

[Naren Singh]

Hi,

I am trying to bulk uploading the Jira issue via CSV import. I tried couple of time but always getting

Imported 1 project and 0 issues successfully even i am seeing all parameters ( User, Importing issues etc ) green while uploading is in progress.

Am i missing any setting ? Please suggest

Here's the log file

2017-11-25 04:12:27,353 INFO - Import started by admin using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2017-11-25 04:12:27,682 INFO - ------------------------------
2017-11-25 04:12:27,682 INFO - Importing: Users
2017-11-25 04:12:27,682 INFO - ------------------------------
2017-11-25 04:12:27,682 INFO - Only new items will be imported
2017-11-25 04:12:27,685 INFO - 0 users associated with import. All of them imported as inactive, this can be changed after import in User Access step.
2017-11-25 04:12:27,685 INFO - ------------------------------
2017-11-25 04:12:27,685 INFO - Finished Importing : Users
2017-11-25 04:12:27,685 INFO - ------------------------------
2017-11-25 04:12:27,685 INFO - 0 users successfully created.
2017-11-25 04:12:27,687 INFO - Retrieving projects...
2017-11-25 04:12:27,696 INFO - Project ExternalProject{id='null', key='SI', externalName='null', name='Embershot', type='software', template='null'} exists and found correctly.
2017-11-25 04:12:27,714 INFO - ------------------------------
2017-11-25 04:12:27,714 INFO - Importing: Versions
2017-11-25 04:12:27,714 INFO - ------------------------------
2017-11-25 04:12:27,714 INFO - Only new items will be imported
2017-11-25 04:12:27,714 INFO - ------------------------------
2017-11-25 04:12:27,714 INFO - Finished Importing : Versions
2017-11-25 04:12:27,714 INFO - ------------------------------
2017-11-25 04:12:27,714 INFO - ------------------------------
2017-11-25 04:12:27,714 INFO - Importing: Components
2017-11-25 04:12:27,714 INFO - ------------------------------
2017-11-25 04:12:27,714 INFO - Only new items will be imported
2017-11-25 04:12:27,714 INFO - ------------------------------
2017-11-25 04:12:27,714 INFO - Finished Importing : Components
2017-11-25 04:12:27,714 INFO - ------------------------------
2017-11-25 04:12:27,718 INFO - Retrieving custom fields...
2017-11-25 04:12:27,722 INFO - ------------------------------
2017-11-25 04:12:27,722 INFO - Importing: Issues
2017-11-25 04:12:27,722 INFO - ------------------------------
2017-11-25 04:12:27,722 INFO - Only new items will be imported
2017-11-25 04:12:27,931 INFO - Importing issue: [externalId='XXXXX', summary='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"]
2017-11-25 04:12:49,455 INFO - 0 out of 1000 issues successfully created
2017-11-25 04:12:49,458 INFO - ------------------------------
2017-11-25 04:12:49,458 INFO - Finished Importing : Issues
2017-11-25 04:12:49,458 INFO - ------------------------------
2017-11-25 04:12:49,641 INFO - ------------------------------
2017-11-25 04:12:49,641 INFO - Importing: Issue Links & Subtasks
2017-11-25 04:12:49,641 INFO - ------------------------------
2017-11-25 04:12:49,641 INFO - Only new items will be imported
2017-11-25 04:12:49,641 INFO - ------------------------------
2017-11-25 04:12:49,641 INFO - Finished Importing : Issue Links & Subtasks
2017-11-25 04:12:49,641 INFO - ------------------------------

[Nic Brough -Adaptavist-]

My guess is that you already have issues in the project, with identical summaries to the issues you are trying to import.  The CSV importer tries to stop you importing duplicates.

[Naren Singh]

Thanks. But I can’t see any imported issue in JIRA. I tried searching with ticket number but can’t see any tickets. 

Do I need to change any setting to view these tickets.

[Nic Brough -Adaptavist-]

I didn't say you should look for that.  Look at the summaries.

[Naren Singh]

I did limited import with only 30 identical issue but still getting same.

[Nic Brough -Adaptavist-]

Could you look at the summaries of the issues you have in the project already?