forum

Home / DeveloperSection / Forums / Write a Node.js script to read data from a CSV file and store it in a MongoDB database.

Ask Question

Write a Node.js script to read data from a CSV file and store it in a MongoDB database.

Steilla Mitchel9426-Jul-2023

Write a Node.js script to read data from a CSV file and store it in a MongoDB database.

node.jsdatabase node js mongodb 
Updated on 27-Jul-2023
Steilla Mitchel

Steilla Mitchel

Follow
I completed my post-graduation in 2013 in the engineering field. Engineering is the application of science and math to solve problems. Engineers figure out how things work and find practical uses for scientific discoveries. Scientists and inventors often get the credit for innovations that advance the human condition, but it is engineers who are instrumental in making those innovations available to the world. I love pet animals such as dogs, cats, etc.

Can you answer this question?

Answer

1 Answers

Aryan Kumar

Aryan Kumar

27-Jul-2023

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.

MindStick Training

Liked By