CSV IMPORT ERROR

[Richard Griffiths]

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

[Rambabu Patina _Appfire_]

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.

[Richard Griffiths]

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

[Rambabu Patina _Appfire_]

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

[Richard Griffiths]

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: 

[Rambabu Patina _Appfire_]

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

[Richard Griffiths]

plug in is

You are using version 1001.0.0-SNAPSHOT.

[Milan Chheda [INFOSYSTA]]

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

[Milan Chheda [INFOSYSTA]]

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

[Rambabu Patina _Appfire_]

@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.

[Richard Griffiths]

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. 

[Rambabu Patina _Appfire_]

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

[Milan Chheda [INFOSYSTA]]

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

[Richard Griffiths]

This is how i have the custom issue type configured.

[Rambabu Patina _Appfire_]

@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.

[Richard Griffiths]

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

[Milan Chheda [INFOSYSTA]]

Is the custom field configured as Number field or Text?

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

[Richard Griffiths]

custom field is configured as a Text

[Milan Chheda [INFOSYSTA]]

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

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

[Richard Griffiths]

That does not appear to work either. Same error messgae