Unexplained error when importing CSV into Jira Cloud

[Rebecca Low]

I'm trying to import issues into Jira Cloud using the CSV importer. I'm using this CSV:

Product,Issue Type,#,Reporter,Description,Summary,Status,Created,Updated
Dashboard,Feature,123,xxxx,"Do not show the preview button","Hide the preview button",Open,"10/15/2018 7:40","10/15/2018 7:56"

I got this error message:

2018-10-24 23:34:08,530 INFO - Import started by admin using com.atlassian.jira.plugins.importer.imports.csv.CsvDataBean
2018-10-24 23:34:08,733 INFO - ------------------------------
2018-10-24 23:34:08,733 INFO - Importing: Users
2018-10-24 23:34:08,733 INFO - ------------------------------
2018-10-24 23:34:08,733 INFO - Only new items will be imported
2018-10-24 23:34:14,651 INFO - Imported user xxxx (xxxx) as an inactive
2018-10-24 23:34:14,658 INFO - 1 users associated with import. All of them imported as inactive, this can be changed after import in User Access step.
2018-10-24 23:34:14,658 INFO - ------------------------------
2018-10-24 23:34:14,658 INFO - Finished Importing : Users
2018-10-24 23:34:14,658 INFO - ------------------------------
2018-10-24 23:34:14,658 INFO - 1 users successfully created.
2018-10-24 23:34:14,660 INFO - Retrieving projects...
2018-10-24 23:34:14,672 INFO - Project ExternalProject{id='null', key='PLAT', externalName='null', name='Platform', type='null', template='null'} exists and found correctly.
2018-10-24 23:34:14,676 INFO - ------------------------------
2018-10-24 23:34:14,676 INFO - Importing: Versions
2018-10-24 23:34:14,676 INFO - ------------------------------
2018-10-24 23:34:14,676 INFO - Only new items will be imported
2018-10-24 23:34:14,676 INFO - ------------------------------
2018-10-24 23:34:14,676 INFO - Finished Importing : Versions
2018-10-24 23:34:14,676 INFO - ------------------------------
2018-10-24 23:34:14,676 INFO - ------------------------------
2018-10-24 23:34:14,676 INFO - Importing: Components
2018-10-24 23:34:14,676 INFO - ------------------------------
2018-10-24 23:34:14,676 INFO - Only new items will be imported
2018-10-24 23:34:14,676 INFO - ------------------------------
2018-10-24 23:34:14,676 INFO - Finished Importing : Components
2018-10-24 23:34:14,676 INFO - ------------------------------
2018-10-24 23:34:14,681 INFO - Retrieving custom fields...
2018-10-24 23:34:14,694 INFO - ------------------------------
2018-10-24 23:34:14,694 INFO - Importing: Issues
2018-10-24 23:34:14,694 INFO - ------------------------------
2018-10-24 23:34:14,694 INFO - Only new items will be imported
2018-10-24 23:34:14,717 INFO - Importing issue: [externalId='autoid-2100597901712294166', summary='Hide the preview button']
2018-10-24 23:34:14,747 INFO - ------------------------------
2018-10-24 23:34:14,747 INFO - Finished Importing : Issues
2018-10-24 23:34:14,747 INFO - ------------------------------
2018-10-24 23:34:14,747 ERROR - Unexpected failure occurred. Importer will stop immediately. Data may be in an unstable state:

Nothing appears after "Data may be in an unstable state:" so I have no idea what the issue is. Any thoughts?

Thanks in advance!

[Petter Gonçalves]

Hello Rebecca,

I believe that the error you are facing is being caused by the custom field # that you added to your CSV file.

# is also a character on JIRA import, so if you indeed have a custom field with this name you can import it by using Custom field (#):

Product,Issue Type,Custom field (#),Reporter,Description,Summary,Status,Created, Updated
Dashboard,Feature,123,xxxx,"Do not show the preview button","Hide the preview button",Open,"10/15/2018 7:40","10/15/2018 7:56"

Please, let me know if it works for you.