Uploaded image for project: 'Xray for Jira'
  1. Xray for Jira
  2. XRAY-8218

Excel created CSV files with more than one column are "not importable"

    XporterXMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Xray DC V5.0.0, 6.0.0
    • 6.1.3
    • None
    • Xray 2022 S5, Xray 2022 S6
    • OK

    Description

      Description
      Any Excel-created CSV files using more than one column are triggering an error when importing into Xray.

      Pre-conditions
      The file is formatted using more than one column.
      Like this:

      Not like this:

      How to reproduce

      1. Enter the Dataset Dialog;
      2. Select the "Import" -> "CSV File" menu;
      3. Import the aforementioned CSV File, the appropriate "CSV Delimiter" and define UTF-8 in the "File Encoding":

      Actual result/Attachments
      The file is not imported, and the user sees an error:

      Expected result
      The file is correctly imported.

      Version

      • Xray v5.x and v6.x

      Attachments

        1. image-2021-12-27-11-46-34-656.png
          3 kB
          Francisco Silva [X]
        2. image-2021-12-27-11-47-05-433.png
          2 kB
          Francisco Silva [X]
        3. image-2021-12-27-11-56-24-685.png
          24 kB
          Francisco Silva [X]
        4. image-2021-12-27-11-56-58-933.png
          42 kB
          Francisco Silva [X]
        5. image-2021-12-27-12-00-13-740.png
          109 kB
          Francisco Silva [X]

        Activity

          People

            ipvm Isabel Moreira [X] (Inactive)
            fnsi Francisco Silva [X] (Inactive)
            Goncalo Lima, Pedro Rodrigues
            Votes:
            3 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 3 days, 1 hour, 19 minutes
                3d 1h 19m