Cannot Import Status using Status Name in CSV

XMLWordPrintable

    • 6.02
    • 10
    • Severity 3 - Minor
    • 2

      Steps to reproduce

      1. 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
        
      2. go to Administration -> System -> External System Import -> Import from CSV
      3. 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.:

      1. go to Administration -> Issues -> Statuses
      2. hover the mouse onto the Edit link of the Status to be mapped
      3. 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;
      4. 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

      1. uninstall JIM from Manage add-ons
      2. download [^jira-importers-plugin-6.2.8.jar]
      3. use Upload add-on from Manage add-ons to upload the file manually
      4. reindex JIRA
        -> Status can be mapped using Status Name e.g. Open now

            Assignee:
            Unassigned
            Reporter:
            Anonymous
            Votes:
            11 Vote for this issue
            Watchers:
            12 Start watching this issue

              Created:
              Updated: