Error importing as CSV file containing user story title, acceptance criteria etc.

Ed Pm

Can anyone help please what could be the cause why I'm not successful with the upload of CSV file. See error below. 

2019-01-25 01:16:27,602 INFO - Import started by admin using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2019-01-25 01:16:28,037 INFO - ------------------------------
2019-01-25 01:16:28,037 INFO - Importing: Users
2019-01-25 01:16:28,037 INFO - ------------------------------
2019-01-25 01:16:28,037 INFO - Only new items will be imported
2019-01-25 01:16:28,040 INFO - 0 users associated with import. All of them imported as inactive, this can be changed after import in User Access step.
2019-01-25 01:16:28,040 INFO - ------------------------------
2019-01-25 01:16:28,040 INFO - Finished Importing : Users
2019-01-25 01:16:28,040 INFO - ------------------------------
2019-01-25 01:16:28,041 INFO - 0 users successfully created.
2019-01-25 01:16:28,043 INFO - Retrieving projects...
2019-01-25 01:16:28,054 INFO - Project ExternalProject{id='null', key='PM', externalName='null', name='Project Magellan', type='null', template='null'} exists and found correctly.
2019-01-25 01:16:28,057 INFO - ------------------------------
2019-01-25 01:16:28,057 INFO - Importing: Versions
2019-01-25 01:16:28,057 INFO - ------------------------------
2019-01-25 01:16:28,057 INFO - Only new items will be imported
2019-01-25 01:16:28,057 INFO - ------------------------------
2019-01-25 01:16:28,057 INFO - Finished Importing : Versions
2019-01-25 01:16:28,057 INFO - ------------------------------
2019-01-25 01:16:28,057 INFO - ------------------------------
2019-01-25 01:16:28,057 INFO - Importing: Components
2019-01-25 01:16:28,057 INFO - ------------------------------
2019-01-25 01:16:28,057 INFO - Only new items will be imported
2019-01-25 01:16:28,057 INFO - ------------------------------
2019-01-25 01:16:28,057 INFO - Finished Importing : Components
2019-01-25 01:16:28,057 INFO - ------------------------------
2019-01-25 01:16:28,062 INFO - Retrieving custom fields...
2019-01-25 01:16:28,067 INFO - ------------------------------
2019-01-25 01:16:28,067 INFO - Importing: Issues
2019-01-25 01:16:28,067 INFO - ------------------------------
2019-01-25 01:16:28,067 INFO - Only new items will be imported
2019-01-25 01:16:28,075 INFO - Importing issue: [externalId='autoid--5703556233309961782', summary='US01 As a Reservation Consultant, I want to be able to create a booking so that record of customers will be captured in the system']
2019-01-25 01:16:28,258 INFO - ------------------------------
2019-01-25 01:16:28,258 INFO - Finished Importing : Issues
2019-01-25 01:16:28,258 INFO - ------------------------------
2019-01-25 01:16:28,259 ERROR - Unexpected failure occurred. Importer will stop immediately. Data may be in an unstable state: 

 

Petter Gonçalves

Hello Ed Pm,

Welcome to Atlassian Community!

This general error can be caused by several possible syntax errors, so we would need to take a look in your CSV file to better troubleshoot it.

That been said, please provide us with the following information so we can help you:

1 - Add the CSV file you are trying to import - Please, erase all your personal data from it before

2 - Have you exported this CSV file from other application or you have manually build it from scratch?

3 - Try to export one of your issues with the same fields that you are trying to import. Then, compare both CSV files to ensure it is properly configured.

Additionally, you can check the following documentation for reference:

Importing Data from CSV

We will be waiting for your answer.