MongoDB Compass导入含嵌套数组JSON报错，求解决方法及Python简易方案

问题说明 #

你提供的JSON结构如下：

{"A": [  {"above average": "more than average, esp. in amount, age, height, weight etc."},   {"absolutely necessary": "totally or completely necessary"},  ],"G":[  {"get back together": "to become a couple or a group again after being apart"},   {"get better": "to improve"},   {"get better (at)": "to improve in skill or ability"},  ]}

使用MongoDB Compass的「import file」功能导入时，出现错误：Operation passed in cannot be an Array。

Compass导入的解决方法 #

报错原因是MongoDB Compass导入的是集合中的独立文档，而你当前的JSON是一个包含数组的单个大对象，不符合导入要求。需要把JSON转换成JSON Lines格式（每个文档单独一行），具体修改方式如下：

将原结构拆分为多条独立的文档，每条文档包含分类、短语和释义：

{"category": "A", "phrase": "above average", "definition": "more than average, esp. in amount, age, height, weight etc."}
{"category": "A", "phrase": "absolutely necessary", "definition": "totally or completely necessary"}
{"category": "G", "phrase": "get back together", "definition": "to become a couple or a group again after being apart"}
{"category": "G", "phrase": "get better", "definition": "to improve"}
{"category": "G", "phrase": "get better (at)", "definition": "to improve in skill or ability"}

修改后，在Compass导入时选择「JSON Lines」格式，即可正常导入。

Python替代实现方式 #

如果不想手动修改JSON，可以用Python脚本批量导入，步骤如下：

1. 安装依赖库：

pip install pymongo

2. 编写导入脚本（替换your_file.json为你的文件路径）：

import json
from pymongo import MongoClient

# 连接本地MongoDB服务
client = MongoClient('mongodb://localhost:27017/')
# 选择目标数据库和集合
db = client['phrase_dictionary']
collection = db['english_phrases']

# 读取原JSON文件
with open('your_file.json', 'r', encoding='utf-8') as f:
    raw_data = json.load(f)

# 转换数据结构为MongoDB可接受的文档格式
insert_docs = []
for category, phrase_items in raw_data.items():
    for item in phrase_items:
        # 遍历每个短语-释义对
        for phrase, definition in item.items():
            insert_docs.append({
                'category': category,
                'phrase': phrase,
                'definition': definition
            })

# 批量插入数据
if insert_docs:
    result = collection.insert_many(insert_docs)
    print(f"成功插入{len(result.inserted_ids)}条短语数据")
else:
    print("未找到可导入的数据")

运行脚本后，数据会直接插入到指定的MongoDB集合中。

内容的提问来源于stack exchange，提问作者Jake