[COMPASS-5763] While importing csv file there is no datatype Array to change but all others are available Created: 22/Apr/22  Updated: 29/Oct/23  Resolved: 08/May/23

Status: Closed
Project: Compass
Component/s: Import/Export
Affects Version/s: 1.31.2
Fix Version/s: 1.37.0

Type: Bug Priority: Major - P3
Reporter: Aakash Shrestha Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

macOS, Monterey - version 12.3.1


Attachments: PNG File Screen Shot 2022-04-22 at 9.21.41 PM.png    
Issue Links:
Related
related to COMPASS-6521 Support extended json in CSV fields w... Closed
Epic Link: COMPASS-5576
Documentation Changes: Not Needed

 Description   

Problem Statement/Rationale

 I want to import a CSV file and want to change my one column of CSV file to Array but I could not find the option Array to change after the upload, while editing the MongoDB document I can edit the field to Array individually but there is 1000+ document so changing every field to Array is a tedious task.

Steps to Reproduce

Import CSV file and try to change any column datatype into Array

Expected Results

I should be able to change any column datatype to Array

Actual Results

There is no Array option for a datatype to change

Additional Notes

Please update this bug or feature as soon as possible as it will get late for me to submit my academic project.



 Comments   
Comment by Maurizio Casimirri [ 10/Jun/22 ]

Unfortunately, we don't support arrays as types to import from CSV. I'm going to put this up for discussion in our next triage session, but I can't promise we will work on this immediately since we are planning a bigger effort to improve the import/export later in the year.

If you need something sooner I'd recommend either switching to JSON or try with mongoexport and mongoimport instead (https://www.mongodb.com/docs/database-tools/mongoimport/)

Generated at Wed Feb 07 22:40:44 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.