JIRA CSV Import priorities

Question

I am uploading a CSV file that contains about 10-12 fields that are successfully mapped to JIRA fields. However, when I attempt to import priorities, I get the following error:

2018-03-07 10:00:40,878 ERROR - Error importing issue [externalId='11976', summary='Personal Lines Download']
com.atlassian.jira.plugins.importer.external.ExternalException: Unable to create or update issue: [externalId='11976', summary='Personal Lines Download']
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:931)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:797)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:414)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:26)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:15)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:458)
	at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:426)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:216)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.atlassian.jira.plugins.importer.imports.csv.ImportException: Priority [ Low ] is not in the project [ EMI ] Priority Schema.  Also Priority Schema couldn't be changed, because it's shared by more than one project.
	at com.atlassian.jira.plugins.importer.imports.importer.impl.PriorityUtils.preFilterPriority(PriorityUtils.java:60)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.ExternalUtils.convertExternalIssueToIssue(ExternalUtils.java:510)
	at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.createIssue(DefaultJiraDataImporter.java:908)
	... 11 more

In my CSV file that I'm attempting to import, I have a column named Priority. Each row has a value of 'Low'. From my understanding, each project has the standard JIRA priority schema (lowest, low, medium, high, highest).

Any thoughts on why this is not working? Any help would be greatly appreciated!

Jeff Abbott_7hw68u · Answer

Priorities are numbers 1 through N as defined in your default Priority Scheme.  The JIRA default is 1=Highest (assuming you are not using a different priority scheme). These schemes are used to map terms (Highest) to priority numbers (1). You have to be an administrator to manage the priority schemes.

Warning, be careful not to import bad priority values. They can be hard to remove from your scheme later.

unknown · Answer

As this line says:

Caused by: com.atlassian.jira.plugins.importer.imports.csv.ImportException: Priority [ Low ] is not in the project [ EMI ] Priority Schema.  Also Priority Schema couldn't be changed, because it's shared by more than one project.

Anyway, you can make the field priority optional in a test project if you need this upload, and see if it works or not.

Edward Greathouse · Answer

Hi Cristian,

This issue could be related to that issue. Both issues are occurring on the same JIRA instance. Would you like to wait to see if the resolution for the first issue resolves this issue before trying anything else? Also, I have the CSV configuration file as well as the CSV data file that caused this issue if you would like to see those.

Thanks!