Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

Home Forums Write a Node.js script to read data from a CSV file and store it in a MongoDB database. – MindStick
Ask Question

1 Answers

Aryan Kumar
Aryan Kumar 27 Jul 2023
Report Abuse

Sure, here is a Node.js script to read data from a CSV file and store it in a MongoDB database:

JavaScript

const csv = require("csv");
const mongodb = require("mongodb");

const client = new mongodb.MongoClient("mongodb://localhost:27017");

client.connect((err) => {
  if (err) {
    console.error(err);
    process.exit(1);
  }

  const db = client.db("mydb");
  const collection = db.collection("mycollection");

  const csvData = csv.parseFile("data.csv");

  csvData.forEach((row) => {
    const document = {
      name: row[0],
      age: row[1],
      address: row[2],
    };

    collection.insertOne(document, (err, result) => {
      if (err) {
        console.error(err);
      } else {
        console.log("Document inserted: ", result);
      }
    });
  });

  client.close();
});

This script first imports the csv and mongodb modules. Then, it creates a new MongoDB client and connects to the database.

Next, the script opens the CSV file and parses it into an array of objects. Each object in the array represents a row in the CSV file.

Finally, the script iterates through the array of objects and inserts each object into the MongoDB collection.

To run this script, you can save it as a file called read_csv.js and then run it from the command line:

node read_csv.js

This will read the data from the CSV file and store it in the MongoDB database. You can then query the database to view the data.

advertising
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md