Traceback (most recent call last): File "E:\Anaconda Projects\Mongo Projects\SDR Tool\csvtojson.py", line 16, in <module> jsonString = json.dumps(jsonArray, indent=1, separators=(",", ":")) File "C:\Users\Predator\anaconda3\lib\json\__init__.py", line 234, in dumps return cls( File "C:\Users\Predator\anaconda3\lib\json\encoder.py", line 201, in encode chunks = list(chunks) MemoryError
import csv import json from pymongo import MongoClient url = "mongodb://localhost:27017" client = MongoClient(url) db = client.Office customer = db.Customer jsonArray = [] with open("Names.txt", "r") as csv_file: csv_reader = csv.DictReader(csv_file, dialect='excel', delimiter='|', quoting=csv.QUOTE_NONE) for row in csv_reader: jsonArray.append(row) jsonString = json.dumps(jsonArray, indent=1, separators=(",", ":")) jsonfile = json.loads(jsonString) customer.insert_many(jsonfile)
customer.insert_many(jsonString)
jsonString
jsonfile
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)