CSV import into JIRA fails

[Cyril Michy]

Hello all,

I'm currently failed to import data from my previous bug tracker.

I reduce my CSV file at the minimum stage to ensure having a correct and well formatted CSV, but it still not working… 

Below is the CSV I had written to find my issue:

Summary, Description
"Ticket1", "Des1"
"Ticket2", "Des2"

But each try I made guides me to the same log:

2020-02-06 21:44:18,615 INFO - Import started by admin using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2020-02-06 21:44:18,861 INFO - ------------------------------
2020-02-06 21:44:18,861 INFO - Importing: Users
2020-02-06 21:44:18,861 INFO - ------------------------------
2020-02-06 21:44:18,861 INFO - Only new items will be imported
2020-02-06 21:44:18,864 INFO - 0 users associated with import. All of them imported as inactive, this can be changed after import in User Access step.
2020-02-06 21:44:18,864 INFO - ------------------------------
2020-02-06 21:44:18,864 INFO - Finished Importing : Users
2020-02-06 21:44:18,864 INFO - ------------------------------
2020-02-06 21:44:18,864 INFO - 0 users successfully created.
2020-02-06 21:44:18,867 INFO - Retrieving projects...
2020-02-06 21:44:18,882 INFO - Project ExternalProject{id='null', key='BDT', externalName='null', name='Base de test', type='null', template='null'} exists and found correctly.
2020-02-06 21:44:18,889 INFO - ------------------------------
2020-02-06 21:44:18,889 INFO - Importing: Versions
2020-02-06 21:44:18,889 INFO - ------------------------------
2020-02-06 21:44:18,889 INFO - Only new items will be imported
2020-02-06 21:44:18,889 INFO - ------------------------------
2020-02-06 21:44:18,889 INFO - Finished Importing : Versions
2020-02-06 21:44:18,889 INFO - ------------------------------
2020-02-06 21:44:18,889 INFO - ------------------------------
2020-02-06 21:44:18,889 INFO - Importing: Components
2020-02-06 21:44:18,889 INFO - ------------------------------
2020-02-06 21:44:18,889 INFO - Only new items will be imported
2020-02-06 21:44:18,889 INFO - ------------------------------
2020-02-06 21:44:18,889 INFO - Finished Importing : Components
2020-02-06 21:44:18,889 INFO - ------------------------------
2020-02-06 21:44:18,895 INFO - Retrieving custom fields...
2020-02-06 21:44:18,902 INFO - ------------------------------
2020-02-06 21:44:18,902 INFO - Importing: Issues
2020-02-06 21:44:18,902 INFO - ------------------------------
2020-02-06 21:44:18,902 INFO - Only new items will be imported
2020-02-06 21:44:18,916 INFO - Importing issue: [externalId='autoid--4345693853745060360', summary='Ticket1']
2020-02-06 21:44:18,952 ERROR - Error importing issue [externalId='autoid--4345693853745060360', summary='Ticket1']: Unable to create issue: Ticket1
2020-02-06 21:44:18,959 INFO - Importing issue: [externalId='autoid-4918512775106674054', summary='Ticket2']
2020-02-06 21:44:18,973 ERROR - Error importing issue [externalId='autoid-4918512775106674054', summary='Ticket2']: Unable to create issue: Ticket2
2020-02-06 21:44:18,980 INFO - 0 out of 2 issues successfully created
2020-02-06 21:44:18,983 INFO - ------------------------------
2020-02-06 21:44:18,983 INFO - Finished Importing : Issues
2020-02-06 21:44:18,983 INFO - ------------------------------
2020-02-06 21:44:18,986 INFO - ------------------------------
2020-02-06 21:44:18,986 INFO - Importing: Issue Links & Subtasks
2020-02-06 21:44:18,986 INFO - ------------------------------
2020-02-06 21:44:18,986 INFO - Only new items will be imported
2020-02-06 21:44:18,990 INFO - ------------------------------
2020-02-06 21:44:18,990 INFO - Finished Importing : Issue Links & Subtasks
2020-02-06 21:44:18,990 INFO - ------------------------------

I currently don't understand why it fails.

As a complement information: I am french but I take attention to convert my CSV file in UTF8 even if the example above does not contain any special character.

Is anybody have already had a similar issue?

Thanks in advance for your support.

[Cyril Michy · Accepted solution]

That's confirmed! My issue was coming from some mandatory fields required by my workflow that was not defined in my CSV...

Rookie mistake!

Thanks for your time anyway.
Regards.

[Hernan Halabi - Elite IT Consulting Group]

Hello @Cyril Michy are you running the import from the admin interface or as a standard user? I suppose that you have create permissions on that project, correct? What if you add the issue type information as well? In the past even though documentation doesn't say it's required, not adding the issue type caused us trouble, wouldn't hurt to try.

[Cyril Michy]

Hello @Hernan Halabi - Elite IT Consulting Group , thanks for your quick answer.

I use the admin interface to import those data.

I have maked another try by adding the issue type by it failed also.

Then I tried to import my CSV in another project with default scheme regarding permissions and it works. I guess I have got something wrong in my permissions so I am gonna dig deeper this way and will come back to writ my results in the post.

Thanks!

[Cyril Michy]

Unfortunately, this issue doesn't provide from autorisations. I have contacted JIRA support who told me that this blocage is coming from my Workflow and the validators that I've created. I have specified some mandatory fields at some specific steps and because those fields are not in my CSV, my import fails.

I will add my feedback once tested.