Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-3737

Import Failure produces wrong error message

XMLWordPrintable

      Issue Summary

      An import failure is producing an error message of "invalid file format, please use XML Spreadsheet 2003"

      However, investigation shows that the import failure is due to a malformed carriage return.
      Error message is misleading and resulted in a lot of wasted time trying to fix the file format.

      Steps to Reproduce

      1. Specific text required - detailed in comments
      2. In FeaturesGrid
      3. More Actions
      4. Import Features
      5. ImportObjects.asp click on Download Template
      6. Edit Template
      7. In Description, enter specific text which includes an invisible malformed carriage return
      8. Save template
      9. In Jira Align Choose the Program
      10. Click on Browse
      11. Select the saved template
      12. Import appears to work, see green line for importing

      Expected Results

       Error message that is more descriptive to what prevented the import.
      Ideal would be to reference the specific cell that has the error.

      Actual Results

      "Invalid file format, please use XML Spreadsheet 2003"

      Workaround

      • Remove the malformed content

      How do identify the malformed content?

      • Launch Chrome or Mozilla
      • Drag & drop the import file onto the browser window or tab
        Chrome Mozilla
        Mozilla will tell you at which line/char position the misleading character is found

        1. image-2021-10-29-17-01-39-198.png
          image-2021-10-29-17-01-39-198.png
          14 kB
        2. ImportObjectsTemplate.xls
          126 kB
        3. malformed character.png
          malformed character.png
          17 kB
        4. screenshot-1.png
          screenshot-1.png
          49 kB
        5. screenshot-2.png
          screenshot-2.png
          84 kB

              dfuller@atlassian.com Don Fuller
              81fb6d9e7236 Heidi Hendry (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: