Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-46365

New line in CSV external import in JIRA doesn't work

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Medium
    • None
    • 6.4.11, 7.0.0-OD-08, 7.1.0-OD-05, 7.2.0, 8.21.1, Archived Jira Cloud, 7.8.0, 8.2.3, 8.5.4
    • Jira Importers Plugin

    Description

      NOTE: This bug report is for JIRA Server. Using JIRA Cloud? See the corresponding bug report.

      Summary

      The documentation for New line in CSV external import in JIRA doesn't work

      Steps to Reproduce

      1. Create and save a CSV file as per the documentation Importing Data From CSV
        Summary, Description, Status
        "Login fails", "This is on
        a new line", Open
        
      1. Do a CSV import in JIRA using the External Import in JIRA

      Expected Results

      Issue created to have multiple line in it's Description field.

      Actual Results

      Imported issue is in one line rather than multiple lines.

      "Login fails", "This is ona new line", Open
      

      Workaround #1

      On the Map fields screen, map your incoming field to the appropriate Jira field, but do not tick the Map field value checkbox. Ticking this box takes you to a screen where your browser will strip out your extra formatting.

      Depending on the formatting of your data and the field it's importing into, you may also want to wrap your incoming comment in {noformat} tags.

      Workaround #2

      It is possible to create newlines by using:

      \\ 

      at the beginning of each line as per the example below:

      Summary,Type,Description,Status
      "next csv new line test","Bug","Atlassian
      \\ Testing Issue
      \\ Acceptance Criteria
      \\ - Line 1
      \\ - Line 2
      \\ - Line 3
      \\ - Line 4",To Do
      

      However, this workaround creates another issue with the exported field as mentioned in this bug ticket: JRA-46364

      Attachments

        1. Problem1.png
          Problem1.png
          254 kB
        2. Workaround1.png
          Workaround1.png
          78 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              nghanis Nithiyaa Ghanis (Inactive)
              Votes:
              85 Vote for this issue
              Watchers:
              74 Start watching this issue

              Dates

                Created:
                Updated: