nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

CSV IMPORT ERROR

Richard Griffiths_3rgtaz

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

Accepted answers

All comments

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.

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_3rgtaz

custom field is configured as a Text

Richard Griffiths_3rgtaz

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.

Milan Chheda [INFOSYSTA]

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

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

Richard Griffiths_3rgtaz

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:

Richard Griffiths_3rgtaz

That does not appear to work either. Same error messgae

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

csv

jira

import