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

The specified type is invalid when importing data into the collection from csv file

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 1.28.4
    • Affects Version/s: 1.28.1
    • Component/s: Compass, Import/Export
    • Labels:
      None
    • Environment:
      platform: macOS Big sur 11.4
      compass version: 1.28.1
    • 3
    • Not Needed
    • Iteration Johannesburg

      Problem Statement/Rationale

      The specified type is invalid when importing data into the collection from csv file.
      No matter what type I change to, the data type of all fields is still string.
      Another problem is that I cannot select a certain Field check box.

      I guess this is because the first line of the csv is in Chinese, because there is no such problem after changing them to English.

      Steps to Reproduce

      You can refer to my screenshot and cvs file in the attachment to reproduce this problem

      note: The csv file is in utf-8 encoding format

        1. en-header.csv
          0.1 kB
        2. en-import.png
          en-import.png
          115 kB
        3. en-result.png
          en-result.png
          71 kB
        4. zh-header.csv
          0.1 kB
        5. zh-import.png
          zh-import.png
          117 kB
        6. zh-result.png
          zh-result.png
          69 kB

            Assignee:
            leroux.bodenstein@mongodb.com Le Roux Bodenstein
            Reporter:
            wcmolin@gmail.com Molin Wang
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: