Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-5373

Import ignores first column type when CSV file contains BOM

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Minor - P4 Minor - P4
    • 1.31.0
    • Affects Version/s: 1.29.5
    • Component/s: Import/Export
    • None
    • Environment:
      Mac os 10.15.5
    • 2
    • Iteration Seoul, Iteration Versailles
    • Not Needed
    • None

      Problem Statement/Rationale

      When importing a csv file, the first column type setting(e.g. Number) gets ignored, and becomes a String anyways.

      Steps to Reproduce

      Import a CSV, select the first column as Number.

      Expected Results

      Get Number type

      Actual Results

      Gets String

       

        1. Schermafbeelding 2021-12-17 om 09.48.41.png
          Schermafbeelding 2021-12-17 om 09.48.41.png
          32 kB
        2. testimport.csv
          0.3 kB

            Assignee:
            alena.khineika@mongodb.com Alena Khineika
            Reporter:
            iliasaddab@gmail.com Ilias Addab
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: