-
Type: Bug
-
Resolution: Gone away
-
Priority: Minor - P4
-
Affects Version/s: 1.24.1
-
Component/s: Import/Export
-
None
-
3
-
Not Needed
Problem Description
.json file having below document,
```
{
"data": {
"plans":
{ "1": "14", "2": "20", "3": "40" }}
}
```
When we import this file in specific collection by selecting JSON import, It converts object in to array of strings, like below:
```
{ "plans": [null, "14", "20", "40"] }```
Steps to Reproduce
Open Compass > Connect DB > Select Collection / Create Collection > Click on Add Data button > Select Import File > Popup will open > Select File > Select input file type as JSON > Click on Import button
Expected Results
```
{
"data": {
"plans":
{ "1": "14", "2": "20", "3": "40" }}
}
```
Actual Results
```
{ "plans": [null, "14", "20", "40"] }```
Additional Notes
When i import this with `mongoimport` command in mongo shell it is working perfectly,
```
> mongoimport --db dbName --collection collectionName <fileName.json
```
- is related to
-
COMPASS-4418 Compass has no good way to import array fields from CSV
- Closed
- related to
-
COMPASS-5076 Importing a document with mixed numeric and string keys causes the object to be converted to array when numeric keys are first in the list of keys
- Closed