Hi,

 

I am attempting to import as CSV file. I have mapped the filed from CSV to my JIRA project but every time i run the import i get the following issue.

 

External System Import - Jira Unexpected failure occurred. Importer will stop immediately. Data may be in an unstable state:

 

I have tried a simple CSV file before importing the whole data-set and i get the same issue.

 

The  data is as follows

Issue Type,TIPQA Number, Summary
PQ,PQ12345,TEST 12345

 

Mapped to 

Issue Type ----> issuetype

Summary------>summary

TIPQA Number-----> TIPQA (Custom Field)

 

I have a issue  custom issue type called PQ

with a custom field TIPQA Number

 

What am i doing wrong?

Please Help

2 answers

Is the custom field configured as Number field or Text?

From your CSV, it seems Text (PQ12345), but kindly check and confirm.

custom field is configured as a Text

In that case, even TIPQA Number should be in quotes:

Issue Type,TIPQA Number, Summary
PQ,"PQ12345","TEST 12345"

That does not appear to work either. Same error messgae

Hi @Richard Griffiths,

Seems the data is not formed well in the csv file. Please make sure your summary data should use double quotes as like below:

 

Issue Type,TIPQA Number, Summary
PQ,PQ12345,"TEST 12345"

And also please make sure you are mapping the 'TIPQA Number' to a right field. For more details you can see the documentation for Preparing your CSV file.

Thanks,
Ram.

I have added double quotes but still get the failure message.

@Richard Griffiths Can you post us what is the exact error message you are getting from csv import log.

Error log

2018-09-10 09:59:02,626 INFO - Import started by admin using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean 2018-09-10 09:59:02,961 INFO - ------------------------------ 2018-09-10 09:59:02,961 INFO - Importing: Users 2018-09-10 09:59:02,961 INFO - ------------------------------ 2018-09-10 09:59:02,961 INFO - Only new items will be imported 2018-09-10 09:59:02,964 INFO - 0 users associated with import. All of them imported as inactive, this can be changed after import in User Access step. 2018-09-10 09:59:02,964 INFO - ------------------------------ 2018-09-10 09:59:02,964 INFO - Finished Importing : Users 2018-09-10 09:59:02,964 INFO - ------------------------------ 2018-09-10 09:59:02,964 INFO - 0 users successfully created. 2018-09-10 09:59:02,967 INFO - Retrieving projects... 2018-09-10 09:59:02,977 INFO - Project ExternalProject{id='null', key='NEW', externalName='null', name='Demo Corrective Action Tracker', type='null', template='null'} exists and found correctly. 2018-09-10 09:59:02,980 INFO - ------------------------------ 2018-09-10 09:59:02,980 INFO - Importing: Versions 2018-09-10 09:59:02,980 INFO - ------------------------------ 2018-09-10 09:59:02,980 INFO - Only new items will be imported 2018-09-10 09:59:02,980 INFO - ------------------------------ 2018-09-10 09:59:02,980 INFO - Finished Importing : Versions 2018-09-10 09:59:02,980 INFO - ------------------------------ 2018-09-10 09:59:02,980 INFO - ------------------------------ 2018-09-10 09:59:02,980 INFO - Importing: Components 2018-09-10 09:59:02,980 INFO - ------------------------------ 2018-09-10 09:59:02,980 INFO - Only new items will be imported 2018-09-10 09:59:02,980 INFO - ------------------------------ 2018-09-10 09:59:02,980 INFO - Finished Importing : Components 2018-09-10 09:59:02,980 INFO - ------------------------------ 2018-09-10 09:59:02,988 INFO - Retrieving custom fields... 2018-09-10 09:59:03,000 INFO - ------------------------------ 2018-09-10 09:59:03,000 INFO - Importing: Issues 2018-09-10 09:59:03,000 INFO - ------------------------------ 2018-09-10 09:59:03,000 INFO - Only new items will be imported 2018-09-10 09:59:03,009 INFO - Importing issue: [externalId='autoid-1017226751989332981', summary='TEST 12345'] 2018-09-10 09:59:03,020 INFO - ------------------------------ 2018-09-10 09:59:03,020 INFO - Finished Importing : Issues 2018-09-10 09:59:03,020 INFO - ------------------------------ 2018-09-10 09:59:03,020 ERROR - Unexpected failure occurred. Importer will stop immediately. Data may be in an unstable state:

I have tried with same csv file and could able to import it. BTW what is the Jira importers plugin version?

plug in is

 

You are using version 1001.0.0-SNAPSHOT.

Even I am able to import is successfully. @Richard Griffiths, please share your JIRA version and JIRA Importers plugin version.

Version is written on the bottom of the External System Import page. I am using version 8.0.15.

@Richard Griffiths The version you have provided is not a valid version for Jira Importers plugin. If you are the jira administrator you can check the Jira Importers plugin version by go to Manage Add-ons --> Choose System add-ons --> Search for 'jira-importers-plugin' --> Expand and see the version.

Upgrading Jira Importers plugin to the latest available version may fix the issue.

Ok i have found somthing out.

 

If i remove the custom field i get a successful import.

 

However the issue is coming up as a "STORY" and not as my custom issue "PQ". Maybe this is the issue. 

@Richard Griffiths if the PQ issue type does exist in your jira and configured with your project then it should work.

  1. PQ issue type should be associated with the Project for which you are importing
  2. Associate custom field 'TIPQA Number' with PQ issue type
  3. This custom field should be added on the create issue screen of PQ issue type

image.png

This is how i have the custom issue type configured.

@Richard Griffiths Here the custom field name appearing as TIPQA_ID, Thus you should map from 'TIPQA Number' --> TIPQA_ID on csv import mapping page.

OK i have it working now.

Removed the story type issue and it imports correctly.

Added additional issues and they import correctly

 

Thanks for the help

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 16, 2018 in Jira

Looking for anyone who made the switch to Data Center

The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...

1,260 views 17 10
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you