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

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

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 1.28.4
    • 1.28.1
    • Compass, Import/Export
    • None
    • platform: macOS Big sur 11.4
      compass version: 1.28.1
    • 3
    • Not Needed
    • Iteration Johannesburg

    Description

      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

      Attachments

        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

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: