-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Medium
-
None
-
Affects Version/s: 6.2, 6.3, 7.0.11, 7.0.12
-
Component/s: Jira Importers Plugin
-
6.02
-
10
-
Severity 3 - Minor
-
2
Steps to reproduce
- create a simple CSV file, using Open for Status mapping:
Key,Summary,Issue Type,Status,Priority,Created,Description CSV-1,CSV Test,Bug,Open,Critical,5/11/2015 14:50,Import this plz - go to Administration -> System -> External System Import -> Import from CSV
- import this file and map all the fields properly (no need to map field values)
Expected behavior
Fields are mapped properly and issue is imported
Actual behavior
Status cannot be mapped and issue is not imported:
-> [^failure.txt]
Caused by: com.atlassian.jira.plugins.importer.external.ExternalException: Cannot find status with id 'Open'.
"ID is required but Name is found"
Workaround 1
Use Status ID instead of Name in CSV e.g.:
- go to Administration -> Issues -> Statuses
- hover the mouse onto the Edit link of the Status to be mapped
- notice the Status ID in the status bar of the browser e.g. for Open it's 1
alternatively, all Status IDs can be searched from JIRA database:
SELECT pname, id FROM issuestatus;
- replace Open with 1 in the CSV file and import it
-> [^success.txt]
Workaround 2
Downgrade JIRA Importers Plugin (JIM) to 6.2.8 (compatible with JIRA 6.2 -> 6.3.15 only)
JIM-1391 is not available in JIM 6.2.8
- uninstall JIM from Manage add-ons
- download [^jira-importers-plugin-6.2.8.jar]
- use Upload add-on from Manage add-ons to upload the file manually
- reindex JIRA
-> Status can be mapped using Status Name e.g. Open now