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

Import : FileTransferHandler silently throws an HTTP 400 when importing .xml files

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 10.111.0
    • 10.107.4
    • Import|Export
    • 12
    • Severity 3 - Minor
    • No

      Issue Summary

      The POST call to FileTransferHandler silently throws an HTTP 400 error when importing files with a .xml extension.

      Steps to Reproduce

      1. Prepare the import file as usual
      2. Save it with the .xml extension – e.g. import.xml
      3. Browse to the Import your backlog using Excel page, then click the Browse button
      4. Select the import.xml file in the local file system
      • Notice the loading bar animation gets red, very briefly, then vanishes. No work items are displayed (all work item counts are zeroed)

      Expected Results

      • The system accepts xml file without errors.

      Actual Results

      • An HTTP 400 error is thrown in the background
      2022-06-17 23:07:13 172.22.16.138 POST /Handlers/FileTransferHandler.ashx - 443 661683 172.22.18.236 Mozilla/5.0+(Macintosh;+Intel+Mac+OS+X+10_15_7)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/102.0.5005.115+Safari/537.36 https://instance.jiraalign.com/ImportObjects?FirstTime=True&Programs=196 400 0 0 375
      • The loading bar animation very briefly displays red, then vanish. No other visual cue or message toaster is presented to the user, informing about the POST call error.

      Workaround

      • In the operating system, rename the import file from import.xml to file.xls

      XML files are typically produced by MacOS users. This is mentioned in Help Center article 10X: Import Objects Via Excel Overview

      For Mac OS users only, when you save the file to import your items back to the system, save the file as a .xml (Excel 2004 XML spreadsheet) file. Then, locate the updated file in your file directory and manually change its extension to .xls. This will format the file so that Jira Align can import it.

            97abbabfa9ae Chase Nielson
            rcortez@atlassian.com Rodrigo Cortez
            Votes:
            6 Vote for this issue
            Watchers:
            13 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 40m
                40m